Chapter 10. Change Management
The challenges faced by database administrators have changed drastically since the early days of SQL Server. Laws like Health Insurance Portability and Accountability Act (HIPAA) and Sarbanes-Oxley have made a DBA's job much more structured because of their compliance requirements. In this chapter, you learn how to create projects for your SQL scripts and how to integrate those into Visual Source Safe, Microsoft's source control management system. You also learn how to monitor for unauthorized changes by using Policy-Based Management and how to script database management actions using PowerShell.
Get Professional Microsoft® SQL Server® 2008 Administration 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.
