Click here to monitor SSC

Rodney Landrum


Rodney Landrum

Crime Scene Investigation: SQL Server

14 comments

“The packages are running slower in Prod than they are in Dev” My week began with this simple declaration from one of our lead BI developers, quickly followed by an emailed spreadsheet demonstrating that, over 5 executions, an extensive ETL process was running average 630 seconds faster on Dev than on Prod. The situation needed […]

7 November 2013 3:29 pm by
Rodney Landrum

4 Future Inventions We Will Wonder How We Lived Without

0 comments

I have always wanted to be a Science Fiction writer. I am enthralled by the invention and imagination of writers such as Douglas Adams and Robert Heinlen. One day I will transmogrify my technical writing into something much more prosaic, and produce a novel of my own. Much like in my day job, as a […]

26 September 2013 2:51 pm by
Rodney Landrum

DEF CON SQL

0 comments

On Saturday July 27 2013, 10:37 AM EST, I was sitting with a small clan of DBAs at the SQL Saturday in Cocoa Beach, Florida (you know, the place where actual rocket scientists live and work). A colleague had a serious issue with his laptop, on which was critical information for the event. Somehow, inexplicably, […]

12 August 2013 8:14 pm by
Rodney Landrum

Dear Microsoft Access: I Love You

21 comments

Five weeks ago, I was on a phone call talking about problems our users were having with an MS Access application. Up until this point in my career, I had successfully fended off “database” questions or issues in MS Access because I was not an MS Access expert. Now though, on this call, put together […]

28 March 2013 10:55 am by
Rodney Landrum

From DBA to Data Professional and back again

13 comments

One of my periodic tasks in the department I lead, “IT Data Services”, is to produce summary reports on the current state of my team’s projects, as well as statistics on our SQL Server infrastructure. For efficiency, I normally just write a quick query to pull the data from my DBA repository database, throw the […]

31 January 2013 5:04 pm by
Rodney Landrum

2013 and the Impossible Challenge

14 comments

I am consistently amazed when I read on twitter the exploits of DBAs who compete in marathons, endure triathlons, or simply run every single day. For me: impossible. The furthest I have ever run in one go was 3 miles. I was 9 years old, barefoot, and being chased by a Doberman. Older now, and […]

3 January 2013 6:23 pm by
Rodney Landrum

Disaster Recovery Discovery

0 comments

Last weekend I joined several of my IT staff on a mission to perform a DR test in our remote CoLo center in a large South East city of the US. Can I be more obtuse? The goal was simple for me as the sole DBA in a throng of Windows, Storage, Network and SAN […]

8 September 2012 1:53 pm by
Rodney Landrum

High Jinks, Hi Jacks, Exceptional DBA Awards and PASS

2 comments

The countdown to PASS has counted down.  The day after tomorrow I will board a plane, like many others, on my way for the 4th year in a row to SQL PASS Summit.  The anticipation has been excruciating but luckily I have this little thing called a day job as a DBA that has kept […]

7 October 2011 5:58 am by
Rodney Landrum

Denali-runner: Do DBAs dream of readable replicas?

6 comments

Several years ago, I sat attentively in my new boss’ office, as he described a constant and painful thorn in the side of our company. The problem was with one particular highly visible and critical OLTP system that was now firmly rooted in production; it was being beaten up, badly. It was a large database, […]

21 July 2011 2:50 pm by
Rodney Landrum

Going to the Score Cards – Exceptional DBA Awards 2011

0 comments

This year marks my 4th year as a judge for the Exceptional DBA Awards, founded by Red Gate in 2008 to “recognize the essential but often overlooked contributions of DBAs, the unsung heroes of the IT community.” As a professional DBA myself I have been honored to participate as a judge. It is not an […]

16 June 2011 1:51 am by
Older posts