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.