Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

RealSQLGuy - Helping You To Become A SQL Hero

My real name is Tracy McKibben. I’ve been working with database products for over 20 years, starting with FoxBase running on Xenix. Over the years, I’ve worked with all flavors of FoxPro, some Clipper and dBase, and starting somewhere around 1995, SQL Server. I’ve even dabbled with Oracle, though I’ve tried to block out all memories of that experience. At present, I’m the Senior SQL Server DBA and the DBA Team Supervisor for Pearson VUE. All opinions expressed on this site are my own and do not reflect the opinions of Pearson VUE.

Archives: December 2013

Kissing 2013 Goodbye

The end of the year is here, which means it’s time to look back and review my goals and reflect on the highlights and lowlights of the year. I can’t say that I’m sorry to see this year come to an end. 2013 was a tough, ugly year. Tension between… Read more

0 comments, 223 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 30 December 2013

Friday Followup For December 27, 2013

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

Read more

0 comments, 135 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 27 December 2013

The Night Before Upgrade

I originally wrote this in December 2011. It’s been one of my most popular posts, so reposting it has become a Christmas tradition. Enjoy!


‘Twas the night before upgrade of the serving device
Not an admin was sleeping, the men nor their mice
The cables were strung to the appropriate…
Read more

0 comments, 137 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 23 December 2013

Friday Followup For December 20, 2013

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

Read more

0 comments, 133 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 20 December 2013

I’m Board

No, really, I’m board. It will be officially announced today, but as of December 11th, I’m the new Director of Program Development for PASSMN, the Minnesota chapter of the Professional Association for SQL Server. What does this mean exactly? Well, here’s my new job description:

The Director of Program Development…

Read more

2 comments, 155 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 17 December 2013

Friday Followup For December 13, 2013

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • So, This Happened Today…
  • Automated Permissions Auditing With Powershell and T-SQL: Part 1
  • Using A Non-correlated Subquery To…

Read more

0 comments, 107 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 13 December 2013

Don’t Bring a Tank to a Prison Fight – #TSQL2SDAY #49

A couple of weeks ago I gave you some scripts to collect wait stats from your SQL Server instance over time. Assuming that you downloaded those scripts and started using them right away, you now have two weeks worth of wait stats data collected. Do you know what to do… Read more

6 comments, 1,653 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 10 December 2013

Don’t Get Slimed By Bad Parameter Sniffing

Listen! Do you smell something? Are you suffering from random, unexplained slowdowns? Users complaining about queries that sometimes run fast, sometimes slow, for no obvious reason? Maybe it’s gremlins, or maybe your server is haunted, but more likely it’s just bad parameter sniffing. Before you call in the Ghostbusters, let’s… Read more

3 comments, 383 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 9 December 2013

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 not doing any real work anyway.

Posts That Were Popular This Week

  • So, This Happened Today…
  • Automated Permissions Auditing With Powershell and T-SQL: Part 1
  • Do You Need A Log…

Read more

0 comments, 125 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 6 December 2013

So, This Happened Today…

It started like any other Monday following a long holiday weekend. Hundreds of emails to filter through, a new client launch (after a holiday weekend? Really?), and a pager that somehow survived the weekend without being tossed into a lake. It ended with one of my heroes buying me a… Read more

0 comments, 149 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 3 December 2013