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

sp_BackupDatabases v1.2

I just posted a new version of sp_BackupDatabases. The biggest change is that the procedure now creates one-time SQL Agent jobs to perform its tasks, instead of running dynamic SQL statements. This makes the process much more resilient when it comes to handling errors – one failed backup can’t… Read more

2 comments, 141 reads

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

What’s In My Utility Belt? Issue #1

Welcome to the first issue of what I hope will become a monthly series called “What’s In My Utility Belt?”. The intent is to share with you some of the top free SQL tools, Windows utilities, Internet tools, and even some paid software that I find indispensable in my role… Read more

0 comments, 104 reads

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

SQL Query Formatting – Putting Lipstick On A Pig

“Psssst….”

“Hey buddy! Yeah, you there in the propeller hat. You’re a SQL nerd, right? Can you help me tune this query? Sorry for the formatting, I generated this with my pointy-clicky development tool, and you know the kind of crap they generate. Anyway, I need you to review this… Read more

1 comments, 134 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 24 October 2013

No, Simple Mode Doesn’t Disable The Transaction Log

If you’ve spent any time with me in person, trading war stories, you’ve likely heard my rant about the consultant who suggested using the Simple recovery model for our production databases because “it’s faster”. If not, ask me about it sometime.

He’s not alone, unfortunately. There is a common misconception… Read more

3 comments, 807 reads

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

One-stop Shopping for Backups

First, let me say that yes, I’m aware of Ola Hallengren’s excellent set of maintenance scripts, including those for doing backups. Truly awesome stuff – but not exactly what I wanted in a backup solution. What I’ve built is not meant to improve upon, replace, or in any way… Read more

0 comments, 72 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 5 October 2013

New Blog Series – Origins

I’ve been struggling for months to bring this blog back to life. I’d love to produce content dedicated to the latest bells and whistles in SQL Server, but I don’t have the time to dedicate to keeping up with everything new. After lots of contemplation and some guidance from other… Read more

0 comments, 68 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 2 October 2013

Using A Non-correlated Subquery To Avoid DISTINCT

Nobody wants duplicate data. It’s messy, wastes space, and looks really bad on a report – I get that. What I don’t get is why so many people (developers, I’m lookin’ at you) think DISTINCT is the only way to avoid it. I’ve even run into folks who use DISTINCT… Read more

6 comments, 140 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 2 October 2013