O'Reilly logo

Professional Microsoft SQL Server 2012 Administration by Ross LoForte, Steven Wort, Adam Jorgensen, 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 9

Change Management

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 ...

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