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 April 4, 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

  • The Phoenix Project: a DBA rises from the ashes
  • Automated Permissions Auditing With Powershell and T-SQL: Part 1

Read more

0 comments, 109 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 4 April 2014

Friday Followup For March 28, 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
  • Automated Permissions Auditing With Powershell and T-SQL: Part 1
  • Building The Redneck…

Read more

0 comments, 98 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 28 March 2014

Friday Followup For March 21, 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
  • Do You Need A Log Recovery Tool?
  • The Phoenix Project: a DBA…

Read more

0 comments, 135 reads

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

Speaking In Madison At #sqlSatMadison

In just under 2 weeks I’ll be speaking at my first SQL Saturday of 2014. On Saturday, March 29th, I’m on deck in Madison at 9:00am to give my 10 Ways To Abuse T-SQL presentation. Earlier this year I gave a variation of this presentation for Dell – close, but… Read more

0 comments, 89 reads

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

Friday Followup For March 14, 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

  • The Phoenix Project: a DBA rises from the ashes
  • Do You Need A Log Recovery Tool?
  • Cheating DBCC…

Read more

0 comments, 132 reads

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

The Phoenix Project: a DBA rises from the ashes

About a year ago, fellow blogger Thomas LaRock recommended the book The Phoenix Project, claiming that “every business leader and IT professional should read this book”. Since I’m an IT professional (no jokes, please), and I’m supposed to be leading a team, that means me. He also uses the… Read more

1 comments, 1,419 reads

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

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

  • Dell Webinar: 10 Ways To Abuse T-SQL
  • Don’t Get Slimed By Bad Parameter Sniffing
  • Winning From Within: a…

Read more

0 comments, 135 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 7 March 2014

Dell Webinar: 10 Ways To Abuse T-SQL

I’m a bit late getting this posted, so to the two of you waiting to see it, I apologize. Back on February 6th, almost a month ago already, I presented my “10 Ways To Abuse T-SQL” session for Dell. Due to my inability to watch the clock, those 10 ways… Read more

0 comments, 1,388 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 2 March 2014

Friday Followup For February 28, 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
  • Do You Need A Log Recovery Tool?
  • Automated Permissions Auditing With Powershell…

Read more

0 comments, 140 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 28 February 2014

Friday Followup For February 21, 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
  • Building (for FREE) a Virtual Server for SQL Demos
  • Automated Permissions Auditing…

Read more

0 comments, 127 reads

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

Friday Followup For February 14, 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

  • Winning From Within: a book review and a new attitude
  • Cheating DBCC To Fix Index Corruption
  • If You’re…

Read more

0 comments, 139 reads

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

Winning From Within: a book review and a new attitude

See that guy there? He’s not winning. This picture was taken in July of 2013, and at that exact moment, that guy was not winning that race. He was also not winning at work. He was not winning as a leader, a mentor, a manager, or anything else in his… Read more

1 comments, 138 reads

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

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

  • If You’re Not Doing Anything….
  • Do You Need A Log Recovery Tool?
  • Cheating DBCC To Fix Index Corruption

Read more

0 comments, 110 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 7 February 2014

Friday Followup For January 31, 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

  • If You’re Not Doing Anything….
  • Do You Need A Log Recovery Tool?
  • What Are Your Servers Doing While…

Read more

0 comments, 143 reads

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

If You’re Not Doing Anything….

Hey… Pssst… Yeah, you there on the couch. Listen, if you’re not doing anything around lunchtime on February 6th, I have a suggestion for you.

Displaying a startling lack of good judgement, Dell Software has decided to put me in front of a virtual audience to present my “10 Ways… Read more

0 comments, 159 reads

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

Friday Followup For January 24, 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?
  • Thaw, Rinse, Repeat – #SQLPlunge
  • Sometimes It’s A Dirty Job –…

Read more

0 comments, 130 reads

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

Thaw, Rinse, Repeat – #SQLPlunge

Three years ago in March of 2011, on a whim, I jumped into a hole in a frozen lake into ice-cold water wearing pajamas and boxer shorts. I was a one-man team, a shriveled army of one. I had a blast, and made a short little video to show just… Read more

2 comments, 134 reads

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

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, 149 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, 168 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, 128 reads

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

Newer posts

Older posts