Rodney Landrum

Rodney Landrum went to school to be a poet and a writer. And then he graduated so that dream was crushed. He followed another path, which was to become a professional in the fun filled world of Information Technology. He has worked as a systems engineer, UNIX and network admin, data analyst, client services director and finally as a database administrator. The old hankering to put words on paper, while paper still existed, got the best of him and in 2000 he began writing technical articles, some creative and humorous, some quite the opposite. In 2010 he wrote SQL Server Tacklebox, a title his editor disdained, but a book closest to the true creative potential he sought; he still yearns to do a full book without a single screen shot, which he accomplished in 2019 with his first novel, Chronicles of Shameus He currently works from his castle office in Pensacola, FL as a senior DBA consultant for Ntirety, a division of Hostway/Hosting.

03 January 2013
03 January 2013

2013 and the Impossible Challenge

1
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 … Read more
1
08 September 2012
08 September 2012

Disaster Recovery Discovery

1
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 … Read more
1
27 August 2010
27 August 2010

SQL Alphabet and Friday Nights

0
So, it is Friday night in Lake Mary, Florida, our new home. I get off work at 3:30 on Friday and after a soothing cold Hazed and Confused IPA from our new favorite watering hole, it is time to play some SQL Alphabet. If you have ever been the unwitting participant at a SQL Saturday or … Read more
0
14 April 2010
14 April 2010

Consolidating SQL Server Error Logs from Multiple Instances Using SSIS

39
SQL Server hides a lot of very useful information in its error log files. Unfortunately, the process of hunting through all these logs, file-by-file, server-by-server, can cause a problem. Rodney Landrum offers a solution which will allow you to pull error log records from multiple servers into a central database, for analysis and reporting with T-SQL.… Read more
39
21 January 2010
21 January 2010

Managing Data Growth in SQL Server

'Help, my database ate my disk drives!'. Many DBAs spend most of their time dealing with variations of the problem of database processes consuming too much disk space. This happens because of errors such as incorrect configurations for recovery models, data growth for large objects and queries that overtax TempDB resources. Rodney describes, with some feeling, the errors that can lead to this sort of crisis for the working DBA, and their solution.… Read more
24 November 2009
24 November 2009

Eating SQL Server Installations for Breakfast

Here you will find wholesome SQL Server installations on the menu, complete with Express, Continental and Deluxe breakfast choices, depending on your application's appetite. This is the article where your new SQL Server installation is completely yours, having not as yet been turned over to the general populace of developers or users. Enjoy it while you can: From the SQL Server Tacklebox … Read more
04 August 2009
04 August 2009

SQL Server Tacklebox Free eBook

As a DBA, how well-prepared are you to tackle issues such as backup failure due to lack of disk space, or locking and blocking that is preventing critical business processes from running, or data corruption due to a power failure in the disk subsystem? If you have any hesitation in your answers to these questions, then Rodney Landrum's SQL Server Tacklebox is a must-read.… Read more
31 July 2009
31 July 2009

The DBA as Detective: Troubleshooting Locking and Blocking

In this article, taken from Chapter 5 of his great new book, SQL Server Tacklebox, Rodney describes in his own unique style how he, as a working DBA, goes about troubleshooting problem queries, and investigating various types of locking and blocking problems. In the process, he  passes on valuable tips learned from practical, and sometimes stressful, experience.… Read more
15 July 2009
15 July 2009

SQL Server Tacklebox

Inside the SQL Server Tacklebox you'll find day-to-day tools, scripts and techniques to automate and standardize SQL Server installation, document and report on your servers, migrate data and manage data growth, troubleshoot performance issues, receive notifications of impending issues, secure access to your servers and fight off the data corruption monster… Read more
08 December 2008
08 December 2008

The Holy Scrolling NO WAY Gold Nugget (Script Data) SSMS 2008

0
Tonight, I set about blogging about something I thought was interesting, funny and marginally useful (IFmU)…or wait…funny, useful and marginally interesting (FUmI). Part of the blog post I had envisioned would be to create a database, it’s objects and data to reproduce the FUmI that I wanted to impart. However…as I was creating said database I stumbled … Read more
0
08 December 2008
08 December 2008

Keywords, Brackets, Identifiers and Ridiculous.

0
One of my DBAs recently reported to me that our indexing job was failing because a database included in the re-indexing code was actually named after a T-SQL keyword. I think I actually guffawed, not because it was impossible, but just because this “actually” happened. So, being inquisitive, I took this whole idea that a database … Read more
0