SQL Server 2012 DBA Recipes

SQL Server 2012 DBA Recipes is chock-full of task-oriented examples for database administrators faced with more tasks on their to-do lists than fit into a day's work. Examples are couched in Apress’ popular, problem/solution format, and cover the gamut from small-business to enterprise database environments. You’re provided with effective and proven solutions to accomplish just about any DBA task that you may encounter during your daily work. You can feel confident taking the reliable solutions that are demonstrated in this book and applying them in your own working or testing environment.

The solutions in SQL Server 2012 DBA Recipes have been built and tested using the most current SQL Server 2012 software. Robust coverage is given to important new features such as SQL Server AlwaysOn. You also get solid-coverage of DBA-amplification features such as Policy-Based Management and PowerShell that serve as long levers by which you can move the world, or at least do more in less time, and with less effort. SQL Server 2012 DBA Recipes is the perfect lever by which you can extend your productivity as a DBA. Archimedes would be proud.

Covers the latest release, including new features such as SQL Server AlwaysOn and FileStream.

Shows the use of performance-amplifying tools such as PowerShell and Policy-Based Management.

Aids in removing the burden of mundane tasks, enabling you to focus on the more interesting, proactive side of database administration.