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.

What you’ll learn

• Configure a smooth-running, database environment.
• Put in place backup & recovery solutions that work.
• Ensure security and the safety of your data.
• Create high-availability through AlwaysOn and mirroring.
• Automate using PowerShell and Policy-Based Management.
• Monitor operations and troubleshoot performance problems.

Who this book is for

SQL Server 2012 DBA Recipes is for database administrators who who want to quickly learn to setup and implement effective and proven solutions without reading through a lengthy manual or spending days in training or lengthy searching of the internet. Readers who learn by example will especially appreciate the problem/solution format. All readers will appreciate the clear and accurate examples that help get the day's job done with aplomb.