SQL Server 2017 Administration Inside Out



Bookstore > Books > SQL Server 2017 Administration Inside Out

Price$39.99 - $47.26
Rating
AuthorsWilliam Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
PublisherMicrosoft Press
Published2018
Pages704
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101509305211
ISBN-139781509305216
EBook Hardcover Paperback

Dive into SQL Server 2017 administration - and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Server experts offer a complete tour of DBA capabilities available in SQL Server 2017 Database Engine, SQL Server Data Tools, SQL Server Management Studio, and via PowerShell. Discover how experts tackle today's essential tasks - and challenge yourself to new levels of mastery.

Install, customize, and use SQL Server 2017's key administration and development tools; Manage memory, storage, clustering, virtualization, and other components; Architect and implement database infrastructure, including IaaS, Azure SQL, and hybrid cloud configurations; Provision SQL Server and Azure SQL databases; Secure SQL Server via encryption, row-level security, and data masking; Safeguard Azure SQL databases using platform threat protection, firewalling, and auditing; Establish SQL Server IaaS network security groups and user-defined routes; Administer SQL Server user security and permissions; Efficiently design tables using keys, data types, columns, partitioning, and views; Utilize BLOBs and external, temporal, and memory-optimized tables; Master powerful optimization techniques involving concurrency, indexing, parallelism, and execution plans; Plan, deploy, and perform disaster recovery in traditional, cloud, and hybrid environments; Intermediate-to-advanced level SQL Server database administrator, architect, developer, or performance tuning expert; Basic understanding of database administration procedures.





4 5 4

Similar Books


Microsoft SQL Server 2017 on Linux

Microsoft SQL Server 2017 on Linux

by Benjamin Nevarez

This comprehensive guide shows, step-by-step, how to set up, configure, and administer SQL Server 2017 on Linux for high performance and high availability. Written by a SQL Server expert and respected author, Microsoft SQL Server 2017 on Linux teaches valuable Linux skills to Windows-based SQL Server professionals. You will get clear cove...

Price:  $29.93  |  Publisher:  McGraw-Hill  |  Release:  2018

Getting Started with SQL Server 2014 Administration

Getting Started with SQL Server 2014 Administration

by Gethyn Ellis

The release of SQL Server 2014 has brought with it some great new features and enhancements that database administrators can use to make their database servers faster, highly available, and protected from disaster. As the lines between on-premise and on-cloud based solutions become even more blurred, enterprise database applications such ...

Price:  $16.99  |  Publisher:  Packt Publishing  |  Release:  2014

Hands-On Data Science with SQL Server 2017

Hands-On Data Science with SQL Server 2017

by Marek Chmel, Vladimir Muzny

SQL Server is a relational database management system that enables you to cover end-to-end data science processes using various inbuilt services and features.Hands-On Data Science with SQL Server 2017 starts with an overview of data science with SQL to understand the core tasks in data science. You will learn intermediate-to-advanced leve...

Price:  $44.99  |  Publisher:  Packt Publishing  |  Release:  2018

Pro SQL Server 2012 Administration, 2nd Edition

Pro SQL Server 2012 Administration, 2nd Edition

by Ken Simmons, Sylvester Carstarphen

Pro SQL Server 2012 Administration is a one-stop source for all the knowledge you'll need to professionally manage a database under Microsoft SQL Server 2012. SQL Server administration is a complex field requiring an unusually broad and well-rounded skill set. A good database administrator must be part system administrator, part database ...

Price:  $30.00  |  Publisher:  Apress  |  Release:  2012

SQL Server 2017 Query Performance Tuning

SQL Server 2017 Query Performance Tuning

by Grant Fritchey

Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.This book covers ...

Price:  $44.98  |  Publisher:  Apress  |  Release:  2018

Microsoft SQL Server 2008 R2 Administration Cookbook

Microsoft SQL Server 2008 R2 Administration Cookbook

by Satya Shyam K Jayanty

Provides Advanced Administration techniques for SQL Server 2008 R2 as a book. Covers the essential Manageability, Programmability, and Security features. Emphasizes important High Availability features and implementation. Explains how to maintain and manage the SQL Server data platform effectively....

Price:  $32.99  |  Publisher:  Packt Publishing  |  Release:  2011

Expert SQL Server Transactions and Locking

Expert SQL Server Transactions and Locking

by Dmitri Korotkevitch

Master SQL Server's Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurrency issues in the systems you develop.SQ...

Price:  $24.47  |  Publisher:  Apress  |  Release:  2018

Learning SQL Server Reporting Services 2012

Learning SQL Server Reporting Services 2012

by Jayaram Krishnaswamy

In the present day information-centric world we live in, the success of an enterprise depends enormously on how its information is generated, handled, and disseminated. With ample screenshots and over 65 hands-on exercises, this book will guide you effortlessly through creating cutting edge reports using SQL Server Reporting Services 2012...

Price:  $32.99  |  Publisher:  Packt Publishing  |  Release:  2013