SQL Server Magazine

Use SSRS and SSIS to Create a DBA Repository

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.

Use SSRS and SSIS to Create a DBA Repository

SQL Server Reporting Services

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

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

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

Win the Lottery on Your Way to Analysis Services 2005 Mastery

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

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

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

MDX Builder 2.0

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

SQL Compare 1.14

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