O'Reilly logo

Professional Microsoft® SQL Server® 2008 Administration by Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required