This is the code repository for SQL Server 2019 Administrator's Guide, published by Packt.
A definitive guide for DBAs to implement, monitor, and maintain enterprise database solutions
SQL Server is one of the most popular relational database management systems developed by Microsoft. This second edition of the SQL Server Administrator's Guide will not only teach you how to administer an enterprise database, but also help you become proficient at managing and keeping the database available, secure, and stable.
This book covers the following exciting features:
- Discover SQL Server 2019’s new features and how to implement them
- Fix performance issues by optimizing queries and making use of indexes
- Design and use an optimal database management strategy
- Combine SQL Server 2019 with Azure and manage your solution using various automation techniques
- Implement efficient backup and recovery techniques in line with security policies
If you feel this book is for you, get your copy today!
All of the code is organized into folders. For example, Chapter02.
The code will look like the following:
use [AdventureWorks]
exec sp_replicationdboption @dbname = N'AdventureWorks',
@optname = N'publish',
@value = N'true' GO
Following is what you need for this book: This book is for database administrators, database developers, and anyone who wants to administer large and multiple databases single-handedly using Microsoft's SQL Server 2019. Basic awareness of database concepts and experience with previous SQL Server versions is required.
With the following software and hardware list you can run all code files present in the book (Chapter 1-15).
| Chapter | Software required | OS required |
|---|---|---|
| 1 | SQL Server 2019 | Windows, Mac OS X, and Linux (Any) |
We also provide a PDF file that has color images of the screenshots/diagrams used in this book. Click here to download it.
- Introducing Microsoft SQL Server 2019 [Packt] [Amazon]
- Mastering Azure Machine Learning [Packt] [Amazon]
Marek Chmel is a senior cloud solutions architect at Microsoft for data and artificial intelligence, a speaker, and a trainer with more than 15 years' experience. He's a frequent conference speaker, focusing on SQL Server, Azure, and security topics. He has been a Data Platform MVP since 2012. He has earned numerous certifications, including MCSE: Data Management and Analytics, Azure Architect, Data Engineer and Data Scientist Associate, EC Council Certified Ethical Hacker, and several eLearnSecurity certifications. Marek earned his MSc degree in Business and Informatics from Nottingham Trent University. He started his career as a trainer for Microsoft courses and later worked as principal sharepoint administrator and principal database administrator.
Vladimír Mužný has been a freelance developer and consultant since 1997. He has been a Data Platform MVP since 2017, and he has earned certifications such as MCSE: Data Management and Analytics and MCT. His first steps with SQL Server were done on version 6.5, and from that time on, he has worked with all following versions of SQL Server. Now Vladimir teaches Microsoft database courses, participates in SQL Server adoption at various companies, and collaborates on projects for production tracking and migrations.
Click here if you have any feedback or suggestions.