http://www.sqlmag.com/authors/author/author/5622333/rss/5622333en-USFri, 25 May 2012 08:17:29 GMTFri, 25 May 2012 08:17:29 GMThttp://www.sqlmag.com/article/task-scheduling/use-ssis-to-access-wmi-data-on-multiple-serversUsing SSIS’s WMI Data Reader task, you can collect a lot of useful information about the hardware and software installed on your servers.]]>Gabriela NanauThu, 10 Sep 2009 00:00:00 GMThttp://www.sqlmag.com/article/task-scheduling/use-ssis-to-access-wmi-data-on-multiple-servershttp://www.sqlmag.com/article/task-scheduling/using-a-variable-to-store-the-wmi-data-reader-task-s-outputIn 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.]]>Gabriela NanauThu, 10 Sep 2009 00:00:00 GMThttp://www.sqlmag.com/article/task-scheduling/using-a-variable-to-store-the-wmi-data-reader-task-s-outputhttp://www.sqlmag.com/article/tsql3/improving-the-index_evaluation_usp-stored-procedureSome 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.]]>Gabriela NanauThu, 04 Jun 2009 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/improving-the-index_evaluation_usp-stored-procedure