Pro SQL Server 2012 Practices is an anthology of writings on practices and techniques you should become familiar with on the way to becoming a top-notch database administrator (DBA) or database programmer. The authors have deep insight, and they want to share. The book covers a very wide array of topics, such as what makes for a well-performing design, how to choose database server hardware, indexing, tuning, tools to help you build your database, techniques for managing replication, compliance, backups, high availability, and more.

Working as a SQL Server professional is daunting and exhilarating at the same time. It’s daunting due to the immense amount of “mechanics” that one must learn simply to run and program against a SQL ...

Get Pro SQL Server 2012 Practices now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.