Zip Files in SSIS

Of the very many things SQL Server Integration Services does well, one of its shortcomings is that it does not...

Presenting with SQL Server Management Studio

Short one this week as it’s the usual madness on the lead up to Xmas!
One of the cool things that...

Reminder – Geek Sync Today!

Today (December 14, 2016) at 12 PM Eastern I’m giving a webinar on preparing for your SQL Server farm for the...

SQL Server & Containers – Part Three

This post follows on from Part Two in which we created a custom docker image. We’ll now look at pushing...

SSIS Package Validation in the Catalog

Built into the SQL Server Integration Services catalog is the ability to run a validation without actually executing the package....

This Week in Data – Episode 16 (Top 5 Reasons You Need a Data Warehouse)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...

What is HTAP?

I have been seeing the term “HTAP” mentioned a lot recently, and I thought I would briefly explain the term....

DBA Myths: You can only restore one differential backup

Ok, I know I’m hosting T-SQL Tuesday this month but I still had post I wanted to share.

 
The basic steps...

Don’t blink you might READPAST it

Following on from my previous post on NOLOCK (https://blobeater.blog/2016/12/09/nolock/) I want to talk about another hint called READPAST. This hint tells...

Don’t trust Invoke-SqlCmd and error results

Don’t trust Invoke-SqlCmd and error results
I love to call Invoke-sqlcmd from powershell but one must beware of the risk of...