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.

05 August 2008
05 August 2008

SQL Server eBook Download – SQL Server Tacklebox

The SQL Server Tacklebox contains a collection of practical tools and techniques to automate and standardize SQL Server installation, document and report on servers, migrate data and manage data growth, troubleshoot performance issues, receive notifications of impending issues, secure access servers and fight off the data corruption.… Read more
05 June 2008
05 June 2008

Using SSIS to monitor SQL Server Databases

52
Rodney Landrum is a DBA who manages over eighty SQL Servers. It is a job that requires a great deal of ingenuity. He needed a way of knowing if there were signs of trouble anywhere in his servers. Here he describes how the use of SSIS saved him a great deal of time in getting a monitoring system in place and working… Read more
52
05 May 2008
05 May 2008

SQL Saturday Thoughts and SQL Alphabet

0
With gas prices here in the panhandle of Florida where I comfortably reside soaring to over $3.60 per gallon, I knew I would spend at least $110 toting myself and my beautiful fiancee from Pensacola to Jacksonville, host city of the most recent SQL Saturday event this past weekend. Another $89.00 per night for 2 … Read more
0
01 October 2007
01 October 2007

Diagnosis….More Diagnostics.

0
Sometimes in my career as a DBA I feel like a doctor. Actually, this started before my stint as DBA…way back in my help desk days. Someone on the other end of the phone begins to impart their symptoms and like an ER intern, I listen intently to every detail. Often, like most good practioners, … Read more
0
21 June 2007
21 June 2007

SQL Server and The Holy Grail

0
That title should garner some comments, I suspect, or if not then the following questions should: Does there exist a way to provide real-time – or a close proximity thereof – replication from a SQL production database to a reporting database with the following rquirements: 1.) No source shema changes (even assuming that the source DB does … Read more
0
18 April 2007
18 April 2007

Too Much HR, Not Enough Guts and Glory

0
At some point in a DBA’s career, assuming he or she has had the mettle to withstand the onslaught of mediocrity and ineptness in its various forms (I may qualify this bold statement in a future post), there comes a time when said DBA is asked to manage other DBAs.  This “management” includes mentoring, coaching, training, … Read more
0
09 April 2007
09 April 2007

sp_helptext squared

0
As I sat at my desk, like most days, pondering what a partial database restore truly is in regards to object-level restores and filegroups and noting that though this sentence will go on longer than I intended I will not finish it prior to finishing the initial thought, my phone rang and the question came … Read more
0
28 March 2007
28 March 2007

Kill or Be Shamed

0
Every tidbit of knowledge gleaned over years of working with a product comes at a price and that price is sometimes shame at not having known such slacious info beforehand. So it is with shame I admit that today I learned something I suspect I should have known. I run the risk of criticism of my … Read more
0