Professional Microsoft SQL Server 2014 Administration - Brossura

Jorgensen, Adam; Ball, Bradley; Wort, Steven; Loforte, Ross; Knight, Brian

Brossura

ISBN 10: 1118859138 ISBN 13: 9781118859131

Casa editrice: Wrox Pr Inc, 2014

Riassunto

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.

Su questo libro

Informazioni sull?autore

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.

Dalla quarta di copertina

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.

Dal risvolto di copertina interno

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.

Dettagli dell?edizione

• Editore: Wrox Pr Inc
• Data di pubblicazione: 2014
• Lingua: Inglese
• ISBN 10: 1118859138
• ISBN 13: 9781118859131
• Rilegatura: Copertina flessibile
• Numero edizione: 1
• Numero di pagine: 892
• Contatto del produttore: non disponibile
• Persona responsabile: non disponibile