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...

SQLSaturday Iowa City is this weekend!

If you’re within driving distance of Iowa City, IA, I’d love to see you at SQLSaturday Iowa City this weekend!...

Monday Morning SQL Break – June 6, 2016

It’s Monday time for this week’s Monday Morning SQL Break.  A chance to catch up on links I’ve shared and...

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...