December, 2008
Create a Job-Scheduling Advisor
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.
SQL Server Magazine
|
January, 2008
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.
SQL Server Magazine
|
May, 2007
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 Magazine
|
April, 2007
Sqlcmd
Sqlcmd performs functions similar to the older Osql tool, but with subtle differences.
SQL Server Magazine
|
April, 2007
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.
SQL Server Magazine
|
August, 2006
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.
SQL Server Magazine
|
December, 2005
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.
SQL Server Magazine
|
July, 2004
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.
SQL Server Magazine
|
October, 2001
Redeploy Your Favorite Classic Games
Does your favorite game run only on Atari? Use software emulation programs so you can run your old favorites on your new PC.
Windows IT Pro
|
August, 2001
PhatWare NetProfile 2000
Configure, save, and apply multiple network profiles.
Windows IT Pro
|
August, 2001
SpaceMaXX SRM 1.2
Search and destroy wasted storage space.
Windows IT Pro
|
May, 2001
Chariot 4.0
Predict performance of network applications.
Windows IT Pro
|
April, 2001
WinWhatWhere Investigator 3.0
Monitor a user's every move.
Windows IT Pro
|
March, 2001
MDX Builder 2.0
MDX Builder 2.0 from BiSense helps expert MDX developers sidestep annoying logic and syntax errors.
SQL Server Magazine
|
February, 2001
Ecora Application Server
A hardware and Web application solution for documenting your servers in minutes.
Windows IT Pro
|
February, 2001
Enterprise Security Reporter 1.75
Find out about software that gathers, stores, and analyzes your network's security information.
Windows IT Pro
|
November, 2000
Total Control 2.5
Lightspeed Systems' Total Control 2.5 provides almost every conceivable means of monitoring and controlling IP traffic.
Windows IT Pro
|
September, 2000
SQL Compare 1.14
You can use SQL Compare to find differences in databases rather than scanning code line by line.
SQL Server Magazine
|