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

SQL in the City Prep

I’m at the Redgate Software offices this week. I come over to visit the company, my boss and our department,...