http://www.windowsitpro.com/authors/author/author/5035567/rss/5035567en-USSun, 27 May 2012 03:29:58 GMTSun, 27 May 2012 03:29:58 GMThttp://www.windowsitpro.com/article/sql-server/dba-repository-2010
By Rodney Landrum
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 faster execution.]]>Rodney LandrumTue, 22 Jun 2010 00:01:00 GMThttp://www.windowsitpro.com/article/sql-server/dba-repository-2010http://www.windowsitpro.com/article/reporting2/create-a-job-scheduling-advisor
By Rodney Landrum
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 Agent jobs.]]>Rodney LandrumTue, 23 Dec 2008 00:00:00 GMThttp://www.windowsitpro.com/article/reporting2/create-a-job-scheduling-advisorhttp://www.windowsitpro.com/article/sql-server-integration-services-ssis/use-ssrs-and-ssis-to-create-a-dba-repository
By Rodney Landrum
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 reports and ad-hoc queries, and an enhanced SQL Server Agent job schedule.]]>Rodney LandrumFri, 25 Jan 2008 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-integration-services-ssis/use-ssrs-and-ssis-to-create-a-dba-repositoryhttp://www.windowsitpro.com/article/business-intelligence-development-studio-bids/sql-server-reporting-services
By Rodney Landrum
SQL Server Reporting Services (SSRS) lets you use repository data to create customized reports about job status, database backup status, and server details.]]>Rodney LandrumWed, 23 May 2007 00:00:00 GMThttp://www.windowsitpro.com/article/business-intelligence-development-studio-bids/sql-server-reporting-serviceshttp://www.windowsitpro.com/article/task-scheduling/sql-server-integration-services
By Rodney Landrum
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.]]>Rodney LandrumThu, 19 Apr 2007 00:00:00 GMThttp://www.windowsitpro.com/article/task-scheduling/sql-server-integration-serviceshttp://www.windowsitpro.com/article/sql-server-integration-services-ssis/sqlcmd
By Rodney Landrum
Sqlcmd performs functions similar to the older Osql tool, but with subtle differences.]]>Rodney LandrumThu, 19 Apr 2007 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-integration-services-ssis/sqlcmdhttp://www.windowsitpro.com/article/sql-server/win-the-lottery-on-your-way-to-analysis-services-2005-mastery
By Rodney Landrum
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.]]>Rodney LandrumWed, 23 Aug 2006 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server/win-the-lottery-on-your-way-to-analysis-services-2005-masteryhttp://www.windowsitpro.com/article/tsql3/reporting-services-and-multivalued-parameters
By Rodney Landrum
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.]]>Rodney LandrumTue, 20 Dec 2005 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/reporting-services-and-multivalued-parametershttp://www.windowsitpro.com/article/reporting2/pushing-the-parameters
By Rodney Landrum
SQL Server 2000 Reporting Services lets you use parameters and expressions minimal programming to customize reports and give users the functionality they need.]]>Rodney LandrumTue, 20 Jul 2004 00:00:00 GMThttp://www.windowsitpro.com/article/reporting2/pushing-the-parametershttp://www.windowsitpro.com/article/video-games/redeploy-your-favorite-classic-games
By Rodney Landrum
Does your favorite game run only on Atari? Use software emulation programs so you can run your old favorites on your new PC.]]>Rodney LandrumFri, 05 Oct 2001 00:00:00 GMThttp://www.windowsitpro.com/article/video-games/redeploy-your-favorite-classic-gameshttp://www.windowsitpro.com/article/storage-management/spacemaxx-srm-1-2
By Rodney Landrum
Search and destroy wasted storage space.]]>Rodney LandrumTue, 14 Aug 2001 00:00:00 GMThttp://www.windowsitpro.com/article/storage-management/spacemaxx-srm-1-2http://www.windowsitpro.com/article/remote-computing/phatware-netprofile-2000
By Rodney Landrum
Configure, save, and apply multiple network profiles.]]>Rodney LandrumTue, 14 Aug 2001 00:00:00 GMThttp://www.windowsitpro.com/article/remote-computing/phatware-netprofile-2000http://www.windowsitpro.com/article/performance/chariot-4-0
By Rodney Landrum
Predict performance of network applications.]]>Rodney LandrumWed, 16 May 2001 00:00:00 GMThttp://www.windowsitpro.com/article/performance/chariot-4-0http://www.windowsitpro.com/article/user-management-and-profiles/winwhatwhere-investigator-3-0
By Rodney Landrum
Monitor a user’s every move.]]>Rodney LandrumWed, 18 Apr 2001 00:00:00 GMThttp://www.windowsitpro.com/article/user-management-and-profiles/winwhatwhere-investigator-3-0http://www.windowsitpro.com/article/database-development/mdx-builder-2-0
By Rodney Landrum
MDX Builder 2.0 from BiSense helps expert MDX developers sidestep annoying logic and syntax errors.]]>Rodney LandrumWed, 21 Mar 2001 00:00:00 GMThttp://www.windowsitpro.com/article/database-development/mdx-builder-2-0http://www.windowsitpro.com/article/auditing/enterprise-security-reporter-1-75
By Rodney Landrum
Find out about software that gathers, stores, and analyzes your network’s security information. ]]>Rodney LandrumWed, 28 Feb 2001 00:00:00 GMThttp://www.windowsitpro.com/article/auditing/enterprise-security-reporter-1-75http://www.windowsitpro.com/article/product-review/ecora-application-server
By Rodney Landrum
A hardware and Web application solution for documenting your servers in minutes.]]>Rodney LandrumWed, 28 Feb 2001 00:00:00 GMThttp://www.windowsitpro.com/article/product-review/ecora-application-serverhttp://www.windowsitpro.com/article/ip-addressing/total-control-2-5
By Rodney Landrum
Lightspeed Systems’ Total Control 2.5 provides almost every conceivable means of monitoring and controlling IP traffic.]]>Rodney LandrumMon, 20 Nov 2000 00:00:00 GMThttp://www.windowsitpro.com/article/ip-addressing/total-control-2-5http://www.windowsitpro.com/article/scripting/sql-compare-1-14
By Rodney Landrum
You can use SQL Compare to find differences in databases rather than scanning code line by line.]]>Rodney LandrumThu, 21 Sep 2000 00:00:00 GMThttp://www.windowsitpro.com/article/scripting/sql-compare-1-14