Exam Prep 70-463: Variables and Parameters

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...

Join me for Dashboards in a Day

Seats are limited – act fast!

This week I will be hosting two free events at the Microsoft Office in Alpharetta, GA...

Tales of a DBA fed up with NOLOCK. Part 2

Feb 16, 2015

Dear Diary,

A few weeks back I introduced HAL002 to a database managed by some annoying devs. They were...

T-SQL EXCEPT and INTERSECT

T-SQL EXCEPT and INTERSECT
Both T-SQL EXCEPT and INTERSECT are set based operators that combine multiple query results back in the same...

“sp_helptext“ – Useful command to view detail TIP #85

 
It might be already known to you but I thought for sharing because I frequently use this command and it...

SQL Saturday NYC Update #4

SQL Saturday NYC is going full steam ahead and we have finalized our 2 Precons for Friday May 29th.  Before...

SQL Saturday NYC Update #4

SQL Saturday NYC is going full steam ahead and we have finalized our 2 Precons for Friday May 29th.  Before...

A Critical SQL Server 2014 Cumulative Update

If you are running SQL Server 2014, please read the following:
Memory leak occurs when you run DBCC CHECKDB against a...

A Critical SQL Server 2014 Cumulative Update

If you are running SQL Server 2014, please read the following:
Memory leak occurs when you run DBCC CHECKDB against a...

Friday Followup For February 20, 2015

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