O'Reilly logo

Pro SQL Server 2012 Administration by Sylvester Carstarphen, Ken Simmons

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

PART 3

Administering Microsoft SQL Server 2012

C H A P T E R  6

Multi-Server Administration

With the number of database servers increasing and the tolerance for errors decreasing in today’s organizations, it is has become necessary to define and maintain database standards across the enterprise. One of the problems in the past has been making sure those standards are being followed. As a DBA, you would have to go out to each server and run queries using system tables to ensure that each server was in compliance. Luckily, you can now use Policy-Based Management to ensure that your standards are being followed. In addition, by using central management servers, you can use a single server as an access point to all the servers in the organization. ...

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