Is the list of servers you manage growing and growing? Are you starting to wonder if there is a more efficient way to manage your SQL Server instances than T-SQL and SSMS? In this session we will give you an introduction to PowerShell with a focus on SQL Server. In this session, we will cover the basics towards configuring and using PowerShell. We will also cover the basic syntax of PowerShell that will help you get started in the right direction. Finally, we will conclude the session with some examples that could make your SQL Admin life a lot easier.
Click to Download Demo Scripts
Tools
Links
- Windows PowerShell Tutorial
- Getting Started with PowerShell 3.0
- How I use PowerShell to collect Performance Counter data
- A Cheat Sheet for All the *{_(%#$] PowerShell Punctuation (Jes Borland)
- PowerShell Week at SQL University – Post 0
- PowerShell Week at SQL University – Post 1
- PowerShell Week at SQL University – Post 2
- PowerShell Week at SQL University – Post 3: Providers, PSDrive