Co-Authored by: Mindy Curnutt Conquer SQL Server 2017 administration—from the inside out Dive into SQL Server 2017 administration—and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds—all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, […]
sql
My Article at IT Pro Today – Azure Cosmos DB vs. SQL Server
I am pleased to announce I’m writing a series of articles for IT Pro Today. Below is a excerpt from the first in the series. In this article I’m comparing Azure Cosmos DB against SQL server and how that affects or will affect DBAs and our profession as a whole. You can read the entire article […]
Restoring a SQL Backup from Azure Blob Storage
I struggled through this exercise and thought I would pass along what I have learned along the way. Basically, I have a Windows Server in Azure with SQL Server installed on it. I want to take a native SQL backup and restore it to the SQL Server in Azure. Sounds like it shouldn’t be that […]
Do You Want to Build a Snowman?
I’ll be teaching a session on Spatial Data coming up this weekend at SQL Saturday, Washington DC. In the recent past, at the end of my presentation we have a little fun and use spatial methods to render a drawing of Hillary and Donald using only T-SQL. Honestly, I’m getting rather tired of that story, […]
Using Powershell to set Roles & Features required for MDS
This is my 3rd go-around installing MDS on SQL Server. I’ve been playing with it on each of the new SQL 2016 RC builds. Today I’m once again standing it up. Hey, practice makes perfect! One of the first things that needs to happen in order to get MDS up and running is that the […]