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

Geek Sync Tomorrow: Surviving the Holidays with SQL Server

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

Nintendo NES Classic Edition giveaway! #SQLFamily

I’ve managed to get my hands on a Nintendo NES Classic and I’m going to give it away. The details...

Power BI Custom Visuals Class (Module 29 – Dial Gauge)

In this module you will learn how to use the Dial Gauge Power BI Custom Visual.  While the usefulness of...