SQL Compare 12 Beta

The Beta is out. I’ve been waiting for this, and was glad to see Carly’s post on the product. I’ve...

Congrats to MSSQLTips on 10 Years!

MSSQLTips has posted about their 10 years as a resource to the SQL Server community. It’s where I do the...

Elastic Query in Azure SQL Database and Views

The question came up, how do the constructs necessary for Elastic Query within Azure SQL Database affect your ability to...

Painting with PowerShell SQL Server Administration

This blog post is just a quick follow from my presentation last week for the SQL PASS PowerShell Virtual Chapter.

Here...

I need help with DBCC

Many years ago during an interview I was asked to “Name the top 7 DBCC commands that you use.” I...

Broadening Horizons: From DBA to Data Science #2 Math Fundamentals

In the previous article in this blog series I told you my plans of expending my horizons towards the Data...

ISJSON() restriction in SQL Server 2016 and not in SQL Server 2017

You should have a database on SQL Server 2016 instance with an In-Memory file group so that you can create tables with the MEMORY_OPTIMIZED option set to ON. Like...

ISJSON() restriction in SQL Server 2016 and not in SQL Server 2017

You should have a database on SQL Server 2016 instance with an In-Memory file group so that you can create tables with the MEMORY_OPTIMIZED option set to ON. Like...

SQL Server 2016 RTM – Is Anyone Still Waiting for the First Service Pack?

Well most of the SQL Server news last week focused around the launch of SQL Server 2016. SQL Server RTM...

ISJSON() restriction in SQL Server 2016 and not in SQL Server 2017

You should have a database on SQL Server 2016 instance with an In-Memory file group so that you can create...