Why would you never use SSIS Fast Load…?

We all know that if you want SQL Server to push data into a table then you want to batch the...

DLM Automation–Making a Database Connection

One of the things I’ve been wanting to do is dig more into the command line automation cmdlets from the...

Enabling Cortana for dbareports PowerBi

Last week at the Birmingham user group I gave a presentation about PowerShell and SQL Server

It was a very packed...

Parallel Powershell for Running SQL

This is just a quick look. I plan on diving into this in the future more, as I'm still working...

Parallel Powershell for Running SQL

This is just a quick look. I plan on diving into this in the future more, as I'm still working...

Persisting DBCC output data

Most of the DBCC commands return their results as textual output, even if you have SSMS configured to return result...

SQL Server & Containers – Part One

Containers are a hot topic at the moment, there seems to be a new article about them on Hacker News...

SQL Server 2016 Service Pack 1 – What’s New

With the release of the most epic Service Pack 1 for SQL Server 2016, the biggest attention of everyone should...

SQL Server 2016 Service Pack 1 Changes Everything

Earlier today, Microsoft announced the release of Service Pack 1 (SP1) for SQL Server 2016. Pay close attention to this...

SQL Server 2016 SP1 – Programmability Surface for everyone!

This is the most important blog post about SQL Server that I have ever written. As far as I am...