Professional Microsoft SQL Server 2014 Administration

This book is a how-to guide for experienced DBAs.   The book will be loaded with unique tips, tricks and workarounds for handling the most difficult SQL Server admin issues, inlcuding:       Managing and monitoring SQL Server       Automating administration       Security       Change management       Performance tuning       Scaling and replication       Clustering       Backup and recovery   Overall, the 2014 edition will be about 40% new and revised;  the following new features will be covered in depth in this edition: SQL Azure New Features for AlwaysOn Availability Groups In-Memory OLTP Buffer Pool Extensions for SSDs and Performance Optimizations for 2014 New Cardinality Estimator (Query Optimizer) in SQL 2014 Separation of Duties Security Roles Greater Integration of Cloud and on Premises Management using SSMS Smart Backup and Backup to the Cloud The authors also plan to cover related tools that DBAs will find useful---for example, Visual Studio Team System for Database Professionals to show DBAs how to perform change management.  The book's companion website will provide all of the sample code in the book, plus useful utilities for automating various administrative tasks.