Subscribe to Windows IT Pro

Rodney Landrum

Rodney Landrum has been working with SQL Server technologies for longer than he can remember. (He turned 40 in May 2009, so his memory is going.) He regularly writes about many SQL Server technologies, including SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS). He is the author of three books on SSRS and a regular contributor to SQL Server Pro. He also sporadically blogs about SQL Server and his plethora of geek tattoos on Simple-Talk.com. His day job finds him overseeing the health and well-being of a large SQL Server infrastructure in Pensacola, Florida. Rodney is a SQL Server MVP.
Email: rodneylandrum@hotmail.com

My Latest Content
My Latest Comments



Author Articles

DBA Repository 2010

By Rodney Landrum, 06/22/2010

Responding to DBAs' requests and suggestions, the DBA Repository has been updated with resiliency for offline servers, support for SQL Server 2008, and parallel processing for ...

Create a Job-Scheduling Advisor

By Rodney Landrum, 12/23/2008

Use this Gantt-chart–style overlay report, based on SQL Server Reporting Services 2008 and an enhancement to the Data Repository solution, to find the best times to run SQL Server ...

Use SSRS and SSIS to Create a DBA Repository

By Rodney Landrum, 01/25/2008

This update to the original DBA Repository solution adds support for SQL Server 2005, support for SQL Server authenticated domains, support for server location, information for ...

SQL Server Reporting Services

By Rodney Landrum, 05/23/2007

SQL Server Reporting Services (SSRS) lets you use repository data to create customized reports about job status, database backup status, and server details.

SQL Server Integration Services

By Rodney Landrum, 04/19/2007

Create an SSIS package that connects to all your SQL Server machines, pulls information into a central repository database, and feeds the combined data to a report.

Sqlcmd

By Rodney Landrum, 04/19/2007

Sqlcmd performs functions similar to the older Osql tool, but with subtle differences.

Win the Lottery on Your Way to Analysis Services 2005 Mastery

By Rodney Landrum, 08/23/2006

Here's how to build a lottery prediction Analysis Services project and become disgustingly wealthy. In the process, you'll get a powerful BI education.

Reporting Services and Multivalued Parameters

By Rodney Landrum, 12/20/2005

SQL Server 2005 Reporting Services makes it easy to use multivalued parameters in embedded queries, but using these parameters in stored procedures requires a little more effort.

Pushing the Parameters

By Rodney Landrum, 07/20/2004

SQL Server 2000 Reporting Services lets you use parameters and expressions minimal programming to customize reports and give users the functionality they need.

Redeploy Your Favorite Classic Games

By Rodney Landrum, 10/05/2001

Does your favorite game run only on Atari? Use software emulation programs so you can run your old favorites on your new PC.

SpaceMaXX SRM 1.2

By Rodney Landrum, 08/14/2001

Search and destroy wasted storage space.

PhatWare NetProfile 2000

By Rodney Landrum, 08/14/2001

Configure, save, and apply multiple network profiles.

Chariot 4.0

By Rodney Landrum, 05/16/2001

Predict performance of network applications.

WinWhatWhere Investigator 3.0

By Rodney Landrum, 04/18/2001

Monitor a user's every move.

MDX Builder 2.0

By Rodney Landrum, 03/21/2001

MDX Builder 2.0 from BiSense helps expert MDX developers sidestep annoying logic and syntax errors.

Enterprise Security Reporter 1.75

By Rodney Landrum, 02/28/2001

Find out about software that gathers, stores, and analyzes your network's security information.

Ecora Application Server

By Rodney Landrum, 02/28/2001

A hardware and Web application solution for documenting your servers in minutes.

Total Control 2.5

By Rodney Landrum, 11/20/2000

Lightspeed Systems' Total Control 2.5 provides almost every conceivable means of monitoring and controlling IP traffic.

SQL Compare 1.14

By Rodney Landrum, 09/21/2000

You can use SQL Compare to find differences in databases rather than scanning code line by line.



Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.