Professional Microsoft SQL Server 2014 Administration

More about the book

Take advantage of the opportunities presented by SQL Server 2014, which introduces significant changes for database administrators. This update enhances support for large-scale enterprise databases and offers a competitive pricing advantage, leading to broader industry adoption. Key features include new backup and recovery tools, AlwaysOn enhancements, and improved cloud capabilities. Innovations such as in-memory OLTP, Buffer Pool Extensions for SSDs, and a new Cardinality Estimator can enhance functionality and streamline workflows, but understanding their full potential is crucial. This comprehensive guide equips you to navigate the new environment effectively. The authors, a renowned team in the SQL Server community, provide insights to help you improve management and monitoring, enhance security, and upgrade performance tuning, scaling, replication, and clustering. You'll discover new options for backup and recovery, along with a companion website offering sample code, automation utilities, and valuable tips and tricks. Stop letting administrative challenges hinder your work. This resource serves as your roadmap to mastering the update, enabling you to create effective solutions and take control of your database management tasks.