T-SQL Tuesday #85 – Backup & Recovery

Shout out to Kenneth Fisher (b|t) for hosting this month's #tsql2sday. This month is about backup and recovery and here...

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

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

T-SQL Tuesday #85–Cross Version Restores

It’s T-SQL Tuesday time, and this month Ken Fisher hosts. His topic is backups, and while I’m sure there will...

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

Using ReadyRoll to Automate Database Migrations

I like ReadyRoll, and this week at SQL in the City 2017, I get to show some of the product...

SSIS Data Taps

One of my favorite testing features of SSIS is also one of the most underutilized. SSIS data taps were introduced...

T-SQL Tuesday 85 - Backup & Recovery

Shout out to Kenneth Fisher (b|t) for hosting this month's #tsql2sday. This month is about backup and recovery and here...

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