A service from Red Gate
Home SQL .NET SysAdmin Opinion Blogs Forums Books
Sign in  | Join  | Help
Authors  >  Rodney Landrum

Rodney Landrum Rodney Landrum
Rodney Landrum has been architecting solutions for SQL Server for over 10 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He has authored three books on Reporting Services including his most recent 2008 edition for Apress. He is a regular contributor to SQL Server magazine and Simple-talk.com, where he blogs on about things like spiders, beer, somnambulance and SQL. His three recent articles in SQL Server magazine on building a DBA repository with SSIS and SSRS have been well received and implemented widely by DBAs around the world. Rodney also speaks regularly on SQL topics at such events as SQL Saturday and the Pensacola SQL Server Users Group. His day job finds him overseeing the health and well being of over 100 SQL Servers as manager of database administration in Pensacola, Florida.
Managing Data Growth in SQL Server
by Rodney Landrum | 21 January 2010 |  2 comments |
'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... Read more...
Eating SQL Server Installations for Breakfast
by Rodney Landrum | 24 November 2009 |
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... Read more...
Finding Data Corruption
by Rodney Landrum | 29 September 2009 |  7 comments |
In this article, taken from Chapter 8 of his new book, SQL Server Tacklebox, Rodney describes how a working DBA goes about troubleshooting data corruption. He demonstrates the tools and scripts required to seek out and fix data corruption in a timely manner, and so... Read more...
SQL Server Tacklebox Free eBook
by Rodney Landrum | 04 August 2009 |  2 comments |
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... Read more...
The DBA as Detective: Troubleshooting Locking and Blocking
by Rodney Landrum | 31 July 2009 |  15 comments |
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... Read more...
SQL Server Tacklebox
by Rodney Landrum | 15 July 2009 |  2 comments |
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... Read more...
The DBA Script Thumb
by Rodney Landrum | 10 November 2008 |  31 comments |
Like many DBAs, Rodney has squirrelled away a large number of routines that he uses almost daily to check on his servers and databases. Of this large collection he chooses five that he wouldn't want to be without. and there is something for everyone in this DBA's... Read more...
SQL Server eBook Download - SQL Server Tacklebox
by Rodney Landrum | 05 August 2008 |  4 comments |
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... Read more...
Using SSIS to monitor SQL Server Databases
by Rodney Landrum | 05 June 2008 |  18 comments |
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... Read more...
Doing Eighty Things at Once
by Rodney Landrum | 25 January 2008 |  3 comments |
Rodney Landrum is a SQL Server DBA for a large company, with at least eighty SQL Servers to look after. He is now a great fan of SQL Multiscript and explains why ... Read more...
Changing Service Credentials
by Rodney Landrum | 05 September 2007 |  5 comments |
One day, you may need to change those service credentials under which your SQL Server services normally run. If you have a number of servers, then you'll really want to read about Rodney's solution. Read more...
Temporarily Changing an Unknown Password of the sa Account
by Rodney Landrum | 10 July 2007 |  21 comments |
You are asked for the sa password for a SQL Server in order to perform a software upgrade. You, the DBA, don't know the password and it's not documented. Rodney Landrum provides a way out of this dilemma, demonstrating two techniques for temporarily changing the... Read more...
Over 150,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.

Join Simple Talk


Privacy policy | Terms and conditions | ©2005-2010 Red Gate Software
About | Site map | Become an author | Newsletters | Contact us