Superfast Broadband – can be a drawn out slow and frustrating process

I’m writing this blog post to simply to vent some frustration. I live in Wales’ third largest city, Newport and...

A quick hint – evaluating 2 tables in one IF BEGIN END block

Have you ever wanted to evaluate 2 tables in one IF BEGIN END block, I firstly wrote this:-

Which always evaluated...

Blocked processes: Quick Tips

Sometimes activity monitor just isn't fast enough. Maybe it's not telling you what a specific query is doing. Below is...

How To Get The TableDiff Utility

Tablediff is a command line utility that comes with SQL Server to compare the data and schema in two tables...

Myths and Misconceptions about Hekaton

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Over the...

Power Query Preview November Update

As I mentioned in my previous post (see Power BI first impressions), Power Query is a great new tool and Microsoft...

Presentation Update: Change Data Capture (CDC) Made Easy With SSIS 2012

Come get your learn on with Pragmatic Works and myself! In January I’ll be dropping some knowledge about change data...

SQL Server Quickie #8 – Hash Indexes

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...

T-SQL Tuesday #49: Topic is … Wait for It …

Have you been waiting to hear about this month’s T-SQL Tuesday topic? Here’s the announcement, right here and right now....

Webcast Today: Surviving The First Week As The New DBA

Today at 3 pm EST I’m presenting Surviving The First Week As The New DBA. Some of the topics I’m...