SQL Server 2019 Administration Inside Out
|Price||$53.99 - $67.16
|Authors||Randolph West, Melody Zacharias, William Assaf, Sven Aelterman, Louis Davidson, Joseph D'Antoni|
|Format||Paper book / ebook (PDF)|
Dive into SQL Server 2019 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 2019 in any production environment: on-premises, cloud, or hybrid. Six experts thoroughly tour DBA capabilities available in SQL Server 2019 Database Engine, SQL Server Data Tools, SQL Server Management Studio, PowerShell, and Azure Portal. You'll find extensive new coverage of Azure SQL, big data clusters, PolyBase, data protection, automation, and more. Discover how experts tackle today's essential tasks - and challenge yourself to new levels of mastery.
Explore SQL Server 2019's toolset, including the improved SQL Server Management Studio, Azure Data Studio, and Configuration Manager; Design, implement, manage, and govern on-premises, hybrid, or Azure database infrastructures; Install and configure SQL Server on Windows and Linux; Master modern maintenance and monitoring with extended events, Resource Governor, and the SQL Assessment API; Automate tasks with maintenance plans, PowerShell, Policy-Based Management, and more; Plan and manage data recovery, including hybrid backup/restore, Azure SQL Database recovery, and geo-replication; Use availability groups for high availability and disaster recovery; Protect data with Transparent Data Encryption, Always Encrypted, new Certificate Management capabilities, and other advances; Optimize databases with SQL Server 2019's advanced performance and indexing features; Provision and operate Azure SQL Database and its managed instances; Move SQL Server workloads to Azure: planning, testing, migration, and post-migration.
by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
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 Serve...
Price: $34.23 | Publisher: Microsoft Press | 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 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: $59.99 | Publisher: Apress | Release: 2012
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.23 | Publisher: Apress | Release: 2018
by Lisa Bohm
Breathe new life into older applications by refactoring T-SQL queries and code using modern techniques. This book shows you how to significantly improve the performance of older applications by finding common anti-patterns in T-SQL code, then rewriting those anti-patterns using new functionality that is supported in current versions of SQ...
Price: $23.99 | Publisher: Apress | Release: 2020
by Elizabeth Noble
Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book provides the help you need in writing T-SQL that performs fast and is easy to maintain. You also will learn how to implement version control, testing, and deployment strategies. Hands-...
Price: $24.62 | Publisher: Apress | Release: 2020
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