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

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

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

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

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

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

PASS Virtual Chapter Events : December 2013

Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...

PASS Virtual Chapter Events : December 2013

 
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...

PASS SQL Saturday Events : December 2013

PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...