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 5
Nonclustered Columnstore Indexes
You will learn how to create a nonclustered columnstore index. - Open a new query window in SSMS - Execute the sample script v5.5 - View the properties of each index