Estimated Costs of All Queries

One question constantly comes up; What should the Cost Threshold for Parallelism be? The default value of 5 is pretty...

How to sign a SQL Server CLR Assembly in Visual Studio 2015

It took me quite a while to figure out how to sign a SQL Server CLR Assembly (like a CLR...

Read Statistics Histogram using DMV

DMV: sys.dm_db_stats_histogram (object_id, stats_id) 
For a long time, the DBCC SHOW_STATISTICS command was the only way to get information about statistics....

Reminder – SQL Saturday Chicago Precon

I just wanted to remind everyone that the SQL Saturday in Chicago is coming up, and that both Adam Machanic...

Remotely Administering the Docker Engine on Windows Server 2016

Continuing on my series in working with Docker on Windows, I noticed that I always open up a remote powershell...

SQL Code Guard 2.9 released

Nothing special - just signed with renewed code sign certificate, small fixes, etc
Have fun!

Wait a minute! Almost forgot.
More great news coming...

SSMS Presenter Mode

SQL Server Management Studio (SSMS) release candidate 17.0 RC2 works side-by-side with generally available releases (16.x), but it is not...

What’s a DACPAC and a BACPAC?

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

What’s in my backup file?

Restoring a backup file is pretty easy right?
RESTORE DATABASE [Test] FROM DISK = 'C:\backups\backup.bak';Ok, but what if more than one database...

Giving a Security Webinar on Thursday

On Thursday, February 23rd at 3 PM EST I’m giving a webinar on designing a successful database security model with...