Professional Microsoft SQL Server 2014 Administration - Product Image

Professional Microsoft SQL Server 2014 Administration

  • ID: 2708367
  • Book
  • 936 Pages
  • John Wiley and Sons Ltd
1 of 4

Best practices for administering SQL Server 2014, from Microsoft MVPs

This comprehensive guide teaches the skills needed to successfully administer SQL Server, including change management, security, performance tuning, monitoring, and backups. Written by the leading authorities on Microsoft SQL Server, this book will help you master the latest features of the 2014 release, including greater integration of cloud and on–premises management using SQL Server Management Studio, enhanced performance optimization, new cardinality estimator, and new features for AlwaysOn availability groups. This comprehensive guide will help you improve the efficiency, scalability, and performance of the SQL Server environment so more can be done in less time.

Professional Microsoft SQL Server 2014 Administration:

  • Provides an overview of SQL Azure and new features for AlwaysOn availability groups
  • Explains In–Memory OLTP and buffer pool extensions for SSDs and performance optimizations for 2014
  • Details the new cardinality estimator (Query Optimizer) in SQL 2014
  • Discusses the separation of duties and important regulatory requirements for security roles
  • Provides real–world case examples and solutions

Programmer Forums

Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.

Code Downloads

Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.

Read More

Find articles, e–books, sample chapters, and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.

READ MORE
Note: Product cover images may vary from those shown
2 of 4

INTRODUCTION xxxvii

CHAPTER 1: SQL SERVER 2014 ARCHITECTURE 1

CHAPTER 2: INSTALLING SQL SERVER 2014 BEST PRACTICES 23

CHAPTER 3: UPGRADING SQL SERVER 2014 BEST PRACTICES 57

CHAPTER 4: MANAGING AND TROUBLESHOOTING THE DATABASE ENGINE 79

CHAPTER 5: AUTOMATING SQL SERVER 113

CHAPTER 6: SERVICE BROKER IN SQL SERVER 2014 155

CHAPTER 7: SQL SERVER CLR INTEGRATION 185

CHAPTER 8: SECURING THE DATABASE INSTANCE 199

CHAPTER 9: IN–MEMORY OLTP 215

CHAPTER 10: CONFIGURING THE SERVER FOR OPTIMAL PERFORMANCE 247

CHAPTER 11: OPTIMIZING SQL SERVER 2014 281

CHAPTER 12: MONITORING YOUR SQL SERVER 325

CHAPTER 13: PERFORMANCE TUNING T–SQL 391

CHAPTER 14: INDEXING YOUR DATABASE 425

CHAPTER 15: REPLICATION 449

CHAPTER 16: CLUSTERING SQL SERVER 2014 491

CHAPTER 17: BACKUP AND RECOVERY 535

CHAPTER 18: SQL SERVER 2014 LOG SHIPPING 593

CHAPTER 19: DATABASE MIRRORING 629

CHAPTER 20: INTEGRATION SERVICES ADMINISTRATION AND PERFORMANCE TUNING 667

CHAPTER 21: ANALYSIS SERVICES ADMINISTRATION AND PERFORMANCE TUNING 701

CHAPTER 22: SQL SERVER REPORTING SERVICES ADMINISTRATION 725

CHAPTER 23: SQL SERVER 2014 SHAREPOINT 2013 INTEGRATION 763

CHAPTER 24: SQL DATABASE ADMINISTRATION AND CONFIGURATION 789

CHAPTER 25: ALWAYSON AVAILABILITY GROUPS 813

INDEX 849

Note: Product cover images may vary from those shown
3 of 4

Loading
LOADING...

4 of 4

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 SQLServerCentral.com and JumpStartTV.com

Wrox Professional guides are planned and written by working programmers to meet the real–world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Note: Product cover images may vary from those shown
5 of 4
Note: Product cover images may vary from those shown
Adroll
adroll