Professional SQL Server 2014 Administration

  • 14h 30m
  • Adam Jorgensen, Bradley Ball, Brian Knight, Ross LoForte, Steven Wort
  • John Wiley & Sons (US)
  • 2014

Learn to take advantage of the opportunities offered by SQL Server 2014

Microsoft's SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here on out. The update's enhanced support of large-scale enterprise databases and significant price advantage mean that SQL Server 2014 will become even more widely adopted across the industry. The update includes new backup and recovery tools, new AlwaysOn features, and enhanced cloud capabilities. In-memory OLTP, Buffer Pool Extensions for SSDs, and a new Cardinality Estimator can improve functionality and smooth out the workflow, but only if you understand their full capabilities. Professional Microsoft SQL Server 2014 is your comprehensive guide to working with the new environment. Authors Adam Jorgensen, Bradley Ball, Ross LoForte, Steven Wort, and Brian Knight are the dream team of the SQL Server community, and they put their expertise to work guiding you through the changes.

  • Improve oversight with better management and monitoring
  • Protect your work with enhanced security features
  • Upgrade performance tuning, scaling, replication, and clustering
  • Learn new options for backup and recovery

Professional Microsoft SQL Server 2014 includes a companion website with sample code and efficient automation utilities, plus a host of tips, tricks, and workarounds that will make your job as a DBA or database architect much easier. Stop getting frustrated with administrative issues and start taking control. Professional Microsoft SQL Server 2014 is your roadmap to mastering the update and creating solutions that work.

About the Authors

Adam Jorgensen is the President of Pragmatic Works and the Executive Vice President of PASS with more than 15 years’ experience.

Bradley Ball is a MCITP 2005, 2008, and 2012 MCSE DBA with more than a decade of experience who is currently the Data Platform Management Lead with Pragmatic Works specializing in Data Platform solutions.

Steven Wort has been working with SQL Server since 1993, who joined Microsoft in 2000, and now works as an Architect in the CRM Service Engineering team.

Ross LoForte is a Technology Architect at the Microsoft Technology Center Chicago focused on Microsoft SQL Server solutions, with more than 20 years of business development, project management, and SQL experience.

Brian Knight is the founder of Pragmatic Works and co-founder of and

In this Book

  • Introduction
  • SQL Server 2014 Architecture
  • Installing SQL Server 2014 Best Practices
  • Upgrading SQL Server 2014 Best Practices
  • Managing and Troubleshooting the Database Engine
  • Automating SQL Server
  • Service Broker in SQL Server 2014
  • SQL Server CLR Integration
  • Securing the Database Instance
  • In-Memory OLTP
  • Configuring the Server for Optimal Performance
  • Optimizing SQL Server 2014
  • Monitoring Your SQL Server
  • Performance Tuning T-SQL
  • Indexing Your Database
  • Replication
  • Clustering SQL Server 2014
  • Backup and Recovery
  • SQL Server 2014 Log Shipping
  • Database Mirroring
  • Integration Services Administration and Performance Tuning
  • Analysis Services Administration and Performance Tuning
  • SQL Server Reporting Services Administration
  • SQL Server 2014 SharePoint 2013 Integration
  • SQL Database Administration and Configuration
  • AlwaysOn Availability Groups