Why Use PowerShell?
In today's business world it's important to get as much done in as little time as possible. The most successful people find ways to automate every repetitive task for which they're responsible. Consistency is important when automating tasks so that every administrator on the team is equally capable of stepping in to help other team members when necessary.
Microsoft has designated PowerShell as part of its common engineering criteria (CEC) for all server products. This means that an administrator who's responsible for Exchange or Active Directory probably has spent time learning PowerShell, and scripts written to manage SQL Server using PowerShell can be understood by administrators without specific SQL Server knowledge. Companies can run more efficiently with this common scripting language, and administrators with skills in PowerShell are more valuable to their companies.
- Single Module for SQL Server
- A new Module for SSAS
- Ability to browse SSIS & Extended Events
Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
