September, 2009
Use SSIS to Access WMI Data on Multiple Servers
Using SSIS's WMI Data Reader task, you can collect a lot of useful information about the hardware and software installed on your servers.
SQL Server Magazine
|
September, 2009
Using a Variable to Store the WMI Data Reader Task's Output
In an SSIS package, you can use a WMI Data Reader task to obtain WMI data from servers. Here's what you need to do to store the task's output in a variable.
SQL Server Magazine
|
June, 2009
Improving the Index_Evaluation_USP Stored Procedure
Some refinements to Index_Evaluation_USP make this T-SQL stored procedure more effective and easier to use to identify tables without indexes, indexes that aren't being used, and indexes that aren't being used efficiently.
SQL Server Magazine
|