Friday Followup For December 6, 2013

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

Presentation Update: New BI Features in SharePoint 2013

It’s time for another free webinar!!
Whether you like it or not SharePoint is here to stay! With every release of...

Junior DBAs - Where to start?

I personally would start with your local user groups. Getting to know people and networking may be your best bet...

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

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