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 authorsalso 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.