Chapter 2. SQL Server Administration

SQL Server's management tools have always been strong. Some would say they are the best in the relational database market. We would agree, but we would add that they are the best by a long way. This is good news for us because as DBAs and developers, we spend a lot of time using them. The more we get done and the better we do it, the happier our bosses will be.

While SQL Server's early tools were comparatively basic and un-integrated, the latest administration tools are exceptionally powerful; indeed there is little separation now between development and administration tools, arguably the way it should be.

In addition to this, the features that the tools can now administer have been vastly extended in SQL Server ...

Get What's New in SQL Server 2012 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.