SQL Server Administration and Maintenance

SQH02 Windows PowerShell Jumpstart for the SQL Server DBA


8:00am - 9:15am

Level: Introductory to Intermediate

Edwin Sarmiento

Managing Director


Windows PowerShell is becoming the scripting language of choice for managing Microsoft servers and workstations. And while T-SQL is still the scripting language for DBAs to administer and manage SQL Server, there are tons of stuff that can be easily done with Windows PowerShell.

In this session, learn Windows PowerShell from the ground up and how you can use it with SQL Server Management Objects (SMO) to administer and manage a SQL Server instance.

You will learn:

  • The basics of Windows PowerShell
  • How to manage SQL Server using Windows PowerShell
  • How to automate operational SQL Server administrative tasks using Windows PowerShell scripting