December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
SQL Server Management Objects
SQL Server Management Objects (SMO) are a very useful tool for advanced users and developers when dealing with the automation of SQL Server 2005, 2008, and 2012. A lot of the features within SQL Server (core engine, agent, mail, and so on) are packaged into easy-to-access .NET libraries that can be accessed from PowerShell.
Most of the functionality provided by the new PowerShell support in SQL Server 2008 and SQL Server 2012 is based on SMO.
As for SQL Server 2005, PowerShell can still be used to administer this version via SMO. The only difference is that the relevant assemblies must be loaded manually.