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. He currently works from his castle office in Pensacola, FL as a senior DBA consultant for Ntirety, a division of Hosting.

17 January 2018
17 January 2018

Ready Player Tattoo

2
3
I am sitting in my hotel room in Nashville getting ready for #SQLSatNash as I write this. I know there are a lot of #SQLFamily here at this and I look forward to seeing them again.  It is snowing outside. This is perfect weather for a Florida boy to contemplate his life and pen a … Read more
2
3
14 February 2017
14 February 2017

Scaling out SSRS on SQL Server Standard Edition

The ability to scale out SSRS, so that multiple report server instances can access a single report server database, is an Enterprise Edition-only feature. So when Rodney Landrum was tasked with implementing a scale-out solution, with failover, for SSRS on SQL Server Standard Edition, it required some creative thinking. This article describes his solution, its merits and drawbacks.… Read more
09 February 2015
09 February 2015

Upside Down Sizing

0
0
At one point late last week I had a 4 bedroom house in the happiest place on earth, Orlando, Florida. It was a nice two story home, with a swimming pool and game room, new appliances and two large oak trees out front and a fertile rose bush whose yellow roses bloomed 40 or more … Read more
0
0
23 January 2015
23 January 2015

The Target of Your Defection

0
0
I was a bit nervous this morning. I had been tasked with adding two SQL instances back into a master/target (MSX/TSX) relationship so that they would receive updated job code that had a new DFS share backup maintenance plans. Why was I nervous? Well, nervous might not be the right word. I was challenged because … Read more
0
0
11 October 2014
11 October 2014

Wonder Twins at PASS Summit 2014

0
0
It is Saturday afternoon in Orlando and as I type this, my wife, Karla, is in St Louis attending SQL Saturday #333. I have just finished my HoneyDo list and have been thinking about the upcoming PASS Summit 2014 in Seattle and all of the great memories there. I could tell you about the time … Read more
0
0
07 November 2013
07 November 2013

Crime Scene Investigation: SQL Server

0
0
“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 … Read more
0
0
26 September 2013
26 September 2013

SSRS Reports as a Data Source in Excel 2013

DBAs are expected to know how to administer the technologies that are available with and peripheral to SQL Server. To properly administer them, it certainly helps to understand the technology from the point of view of the user. By using an existing SSRS report as a data feed for Excel, Rodney Landrum explains how these users can now take advantage of development efforts in new ways.… Read more
12 August 2013
12 August 2013

DEF CON SQL

0
0
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, … Read more
0
0
28 March 2013
28 March 2013

Dear Microsoft Access: I Love You

0
0
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 … Read more
0
0
03 January 2013
03 January 2013

2013 and the Impossible Challenge

0
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
0
1