September 2010
Intermediate to advanced
1704 pages
111h 8m
English
A new feature added to SQL Server 2008 Scheduling and Notification is the capability to execute PowerShell scripts. PowerShell is a command-line scripting language that allows administrators to achieve greater control and productivity. SQL Server 2008 comes with several PowerShell snap-ins that give you access to a variety of SQL Server objects. Scripts that are written to access these objects can be run from SQL Server jobs using the new PowerShell job type. You can find a more detailed discussion of PowerShell’s capabilities in the next chapter, “Administering SQL Server 2008 with PowerShell.”
Policy-Based Management is another new feature in SQL Server 2008. This feature does not fall directly under ...
Read now
Unlock full access