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.

Friday Followup For January 17, 2014

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

  • Do You Need A Log Recovery Tool?
  • Sometimes It’s A Dirty Job – #TSQL2sDAY #50
  • That Awkward Moment…

Read more

0 comments, 123 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 17 January 2014

Sometimes It’s A Dirty Job – #TSQL2sDAY #50

Sometimes being a DBA really stinks. You try to follow best practices in everything you do. You’re not shrinking databases on a daily basis. You’re not using the auto-close option on your databases. You know you’re not supposed to flush the procedure cache on a live server. Sometimes though, in… Read more

0 comments, 140 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 14 January 2014

Friday Followup For January 10, 2014

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, 100 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 10 January 2014

That Awkward Moment When I Started Channeling Brent Ozar

If you read my end-of-year post (you did, right?), you’ll recall that I mentioned that 2013 was a tough year for me. I’ve (the whole team actually) been stressed, unhappy, and just generally miserable in my job. At one point I was looking for a way out. Things are getting… Read more

10 comments, 142 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 9 January 2014

Friday Followup For January 3, 2014

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

  • Building The Redneck Treadmill Desk
  • Kissing 2013 Goodbye
  • Don’t Bring a Tank to a Prison Fight – #TSQL2SDAY…

Read more

0 comments, 96 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 3 January 2014

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, 192 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, 112 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, 112 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, 104 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, 130 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, 84 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,576 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

1 comments, 297 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, 100 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, 121 reads

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

What’s In My Utility Belt? Issue #2

Wow, can you believe it’s been a month already since I posted the first issue of “What’s In My Utility Belt?”? Time flies when you’re having fun. Or when you’re really busy. A lot has happened since that first issue – I became, once again, a Rockstar Blogger, I… Read more

0 comments, 173 reads

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

Friday Followup For November 29, 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

  • Automated Permissions Auditing With Powershell and T-SQL: Part 1
  • 20 Abuses: Procedurally Going In Circles
  • Do You Need…

Read more

0 comments, 131 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 29 November 2013

What Are Your Servers Doing While You’re Sleeping?

Well, do you know? You’re the DBA, the guy in charge, the guy who gets pounced on first thing in the morning with complaints of “my report took FOREVER to run last night, why?”, or “customers are saying the web site was really slow at 3:00am this morning, why?”. You’re… Read more

5 comments, 218 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 25 November 2013

Friday Followup For November 22, 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, 96 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 22 November 2013

What Happens In Vegas…

…stays in Vegas, except when it comes to chocolate. After walking more than 1500 miles over the past 9 months, 30 of those in Las Vegas last week, I’ve earned a treat. What’s this have to do with SQL Server? Absolutely nothing…

That doesn’t mean it’s not relevant to this… Read more

2 comments, 107 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 21 November 2013

Newer posts

Older posts