SQL Server 2017 Administration Inside Out
|Price||$39.99 - $47.26
|Authors||William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt|
|Format||Paper book / ebook (PDF)|
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
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
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
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
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: $15.15 | Publisher: Apress | Release: 2012
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
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
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
by Edward Pollack
Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the changing landscape of analytics and database administration. Code examples have been updated with new system objects and functions to impro...
Price: $30.40 | Publisher: Apress | Release: 2019