Book Image

Getting Started with SQL Server 2016 Administration [Video]

By : Steve Jones
Book Image

Getting Started with SQL Server 2016 Administration [Video]

By: Steve Jones

Overview of this book

<p>SQL Server DBAs enable efficient administration of its SQL Server solution to get breakthrough performance and top-notch security. This video will teach you basic as well as advanced administration tasks for handling, managing, and monitoring your SQL Server 2016 efficiently. After setting up and configuring your virtual machine for SQL Server 2016, you will implement various techniques to improve query performance, create indexes, and perform activity monitoring. You will learn how to secure your SQL Server solution by implementing various authentication techniques. Finally, you'll ensure your database is always available and ready for any catastrophe.</p> <p>This comprehensive tutorial is packed with real-world examples and tips to solve the trickiest of challenges. By the end of this course, you will have a solid foundation in all SQL Server administration concepts and will be able to implement them in a production environment.</p> <h1>Style and Approach</h1> <p>This video is a step-by-step guide to help you understand and master the administration aspects of SQL Server 2016, with examples and use-cases wherever required. Every topic is explained in a clear, easy–to-understand manner.</p>
Table of Contents (5 chapters)
Chapter 3
Databases
Content Locked
Section 4
Database Options
You will learn how to alter options for user databases. - Open the Database folder in SSMS - Right click on a database and select Properties - Change some settings on various panes and click on Script