Archive for the ‘Automating SQL Server Management with WMI’ Category

Automating SQL Server Management with WMI (part 5)

In this article, I will continue with the topic of performing common SQL server maintenance tasks using Windows Management Instrumentation. In the part 4 of the series, I described methods that allow rebuilding indexes and updating statistics on the table level. These operations can take a considerable amount of processing power and time, in the […]

Automating SQL Server Management with WMI (part 4)

This fourth article in "SQL Server management with WMI" series provides examples of using WMI in common maintenance tasks, such as truncating the database transaction logs, or updating statistics and rebuilding indexes on database tables. Truncating the database transaction logs removes the inactive portion (containing transactions committed to the database). This typically happens as the […]

Automating SQL Server Management with WMI (Part 3)

In the first article of this series, I presented a few simple scripts for automating the most basic SQL Server administrative tasks, such as starting and stopping a SQL Server service and login management (changing passwords and determining mappings between server logins and database users). The second article covered methods dealing mostly with SQL Server […]

Automating SQL Server Management with WMI (Part 2)

In the first article of this series, I presented a few simple scripts automating the most basic SQL Server administrative tasks, such as starting and stopping a SQL Server service and login management (changing passwords and determining mappings between server logins and database users). In this article, we will cover methods dealing mostly with SQL […]

Automating SQL Server Management with WMI (Part 1)

Windows Management Instrumentation is becoming one of the prevalent management technologies in Windows environments. Although it is primarily known among Windows server and desktop administrators, its tremendous versatility encompasses other management areas as well. The goal of this series of articles is to demonstrate the use of WMI in SQL Server management. The architecture of […]

Powered by WordPress | Compare Cell Phone Plans at iCellPhonePlans.com | Thanks to Cheap Palm Pixi, Bromoney and Wordpress Themes