WHAT’S IN THIS CHAPTER
- Organizing Code with Solutions and Projects
- Learning and Implementing Policy-Based Management
- Creating Custom Change Management Solutions Using DDL Triggers
- Standardizing Deployments Using Scripting Solutions
The challenges faced by database administrators have changed drastically since the early days of SQL Server. Laws such as Health Insurance Portability and Accountability Act (HIPAA) and Sarbanes-Oxley Act (SOX) have made a DBA’s job much more structured because of their compliance requirements. These compliance laws require that administrators pass strict audits that require the administrator to answer questions such as “When was the last time a database was backed up?” or “Who has access to these tables in production?” The rise in popularity of quick development methodologies such as Agile and Rapid Application Development (RAD) bring their own challenges because now changes are occurring in your environments faster than ever before, making management of objects and versions a challenge to keep up with. With these challenges, Microsoft has evolved its products with features to help administrators ease these pains. Because of these new laws and methodologies, change management has become an issue that all DBAs need to pay close attention to.
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, to help manage ...