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 2
Login and User Security
Content Locked
Section 3
Built-in Server Roles
You will learn about the various built-in server rolls inside SQL Server. - Go into the Server Roles folder,right click on setupadmin, and then select Properties - Add a member and confirm the log-in that needs to be added - Learn about the rights and privileges of various server roles