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

Heading Back to SQL Bits

I’m honored to be selected to speak at SQL Bits 2017 this April in Telford. This is my favorite SQL...

JSON Support Is The Best New Developer Feature in SQL 2016 — Part 4: Performance Comparisons

This is the fourth article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON,...

Managing Bad Data

In the last post in my ongoing series about ETL best practices, I discussed the importance of error handling in ETL...