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

  • Invite for #TSQL2sday #59 – My Hero!
  • Using Encryption To Protect Your Data From Alien Abduction
  • Building (for…

Read more

0 comments, 94 reads

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

Friday Followup For October 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

  • Invite for #TSQL2sday #59 – My Hero!
  • Using Encryption To Protect Your Data From Alien Abduction
  • Building (for…

Read more

0 comments, 98 reads

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

Invite for #TSQL2sday #59 – My Hero!

It is T-SQL Tuesday again, for the 59th month in a row. Next month marks FIVE YEARS of T-SQL Tuesday, introduced by Adam Machanic (B|T) way back in 2009.

I’m hosting this month, but the topic actually comes from Wendy Pastrick (B|T).… Read more

14 comments, 4,060 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 8 October 2014

Friday Followup For October 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

  • Cheating DBCC To Fix Index Corruption
  • Don’t Get Slimed By Bad Parameter Sniffing
  • Building (for FREE) a Virtual…

Read more

0 comments, 107 reads

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

Friday Followup For September 26, 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

  • Don’t Get Slimed By Bad Parameter Sniffing
  • Building (for FREE) a Virtual Server for SQL Demos
  • Presto Chango

Read more

0 comments, 81 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 26 September 2014

Presto Chango

About six months ago, I wrote a post reviewing a book titled The Phoenix Project. In that post, I compared the events in the book to my experiences in my role as a production DBA. I also shared some ideas that I gained from the book to help improve… Read more

9 comments, 88 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 25 September 2014

Friday Followup For September 19, 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

  • Don’t Get Slimed By Bad Parameter Sniffing
  • Building (for FREE) a Virtual Server for SQL Demos
  • Cheating DBCC…

Read more

0 comments, 112 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 19 September 2014

Friday Followup For September 12, 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

  • Don’t Get Slimed By Bad Parameter Sniffing
  • Automated Source Control: A Librarian For Your Database Objects, Part 1

Read more

0 comments, 105 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 12 September 2014

Friday Followup For September 5, 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

  • Automated Source Control: A Librarian For Your Database Objects, Part 1
  • Automated Source Control: A Librarian For Your…

Read more

0 comments, 107 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 5 September 2014

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

  • Don’t Get Slimed By Bad Parameter Sniffing
  • Cheating DBCC To Fix Index Corruption
  • Automated Source Control: A Librarian…

Read more

0 comments, 159 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 29 August 2014

Automated Source Control: A Librarian For Your Database Objects, Part 3

As I mentioned earlier, we use Perforce as our source control package, so all of the scripts presented here are written for Perforce.  I’ll try to clearly explain, in terms of source control, the functional parts of the script, so that you can easily transfer this to your own… Read more

0 comments, 6,176 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 27 August 2014

Automated Source Control: A Librarian For Your Database Objects, Part 2

I assume that by now you’ve tried the script from Part 1, and have seen how easy it is to script out your database objects using Powershell.  The resulting scripts are the standard DDL scripts that you can generate from Management Studio, and for most of us, are just… Read more

0 comments, 6,215 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 25 August 2014

Friday Followup For August 22, 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

  • Cheating DBCC To Fix Index Corruption
  • Don’t Get Slimed By Bad Parameter Sniffing
  • Do You Need A Log…

Read more

0 comments, 116 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 22 August 2014

Automated Source Control: A Librarian For Your Database Objects, Part 1

One of the biggest headaches in most development groups that do any sort of SQL Server work is that of source control.  There are some commercial products that attempt to solve this headache, and from what I understand, some of them do a pretty decent job.  The only one that… Read more

0 comments, 463 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 21 August 2014

Friday Followup For August 15, 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?
  • Cheating DBCC To Fix Index Corruption
  • Don’t Get Slimed By Bad…

Read more

0 comments, 230 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 15 August 2014

Speaking In Kansas City At #SQLSatKC

On Saturday, September 13th, I’ll be presenting my 10 Ways To Abuse T-SQL session in Kansas City. If you haven’t seen this one before, here’s your chance! This is always a fun one, and always draws good feedback, even when I run out of time – which happens every single… Read more

0 comments, 91 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 11 August 2014

Friday Followup For August 8, 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?
  • Don’t Get Slimed By Bad Parameter Sniffing
  • What Are Your Servers…

Read more

0 comments, 109 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 8 August 2014

Friday Followup For August 1, 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

  • What Are Your Servers Doing While You’re Sleeping?
  • Cheating DBCC To Fix Index Corruption
  • Don’t Get Slimed By…

Read more

0 comments, 126 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 1 August 2014

Friday Followup For July 25, 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

  • Don’t Get Slimed By Bad Parameter Sniffing
  • Which One’s Better?
  • Cheating DBCC To Fix Index Corruption
  • Building (for…

Read more

0 comments, 110 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 25 July 2014

Friday Followup For July 18, 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

  • Which One’s Better?
  • Don’t Get Slimed By Bad Parameter Sniffing
  • Cheating DBCC To Fix Index Corruption
  • Building (for…

Read more

0 comments, 120 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 18 July 2014

Older posts