ISJSON() restriction in T-SQL 2016

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

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

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

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

PowerShell – Install PowerShell

Recently got a question regarding PowerShell installation hence this post took an existence.
How to Install PowerShell various versions
http://technet.microsoft.com/en-us/library/hh847837.aspx
http://social.technet.microsoft.com/wiki/contents/articles/21016.how-to-install-windows-powershell-4-0.aspx
Can we have...

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

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

Why use a Date Dimension Table in a Data Warehouse

In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you...

SQL Server Admin Best Practices with DMV's at SQLSaturday Pensacola 2016

Great attendance and awesome questions from my 1130AM session on "SQL Server Admin Best Practices with DMV's". As promised, all...

Deletes Ignore Check Constraints

I know it sounds a bit odd but DELETE statements really do ignore table constraints. Running the code below in...