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 5
Improving Query Performance
Content Locked
Section 1
Tables
This video will explain what a row store index is and how this helps performance and data integrity and how it relates to Primary Keys and Foreign Keys. - Understand what Row Store Index means - Learn about Indexes and their performance. - Understand Index Decision Guidelines.