Professional Microsoft SQL Server 2012 Administration

INTRODUCTION

SQL SERVER 2012 REPRESENTS A SIZABLE jump forward in scalability, performance, and usability for the DBA, developer, and business intelligence (BI) developer. It is no longer unheard of to have 40-terabyte databases running on a SQL Server. SQL Server administration used to just be the job of a database administrator (DBA), but as SQL Server proliferates throughout smaller companies, many developers have begun to act as administrators and BI developers as well. In addition, some of the new features in SQL Server are more developer-centric, and poor configuration of these features can result in poor performance. SQL Server now enables all roles through significantly improved data tools experiences, better security integration, and drastic improvements in data integration, administration, availability, and usability. Professional Microsoft SQL Server2012 Administration is a comprehensive, tutorial-based book to get you over the learning curve of how to configure and administer SQL Server 2012.

WHO THIS BOOK IS FOR

Whether you’re an administrator or developer using SQL Server, you can’t avoid wearing a DBA hat at some point. Developers often have SQL Server on their own workstations and must provide guidance to the administrator about how they’d like the production configured. Oftentimes, they’re responsible for creating the database tables and indexes. Administrators or DBAs support the production servers and often inherit the database from the developer.

This book ...