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.
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.
About the Author
Steve Jones has been working with SQL Server since 1991. He has worked with all versions of SQL Server as a developer and DBA, in a variety of industries and companies. Over the last 25 years, he been greatly pleased with the enhancements and growth of the platform; he feels SQL Server is an outstanding database platform that is suited to a wide variety of needs and situations.
In 2001, Steve founded SQLServerCentral with Brian Knight, Andy Warren, and three other partners. In 2002, Steve left his job with PeopleSoft to manage SQLServerCentral as a full-time editor, publisher, and writer. Andy, Brian, and Steve continued to manage and grow SQLServerCentral until 2007 when it was sold to Redgate Software along with Database Weekly (then Database Daily). At that time Steve went on to work for Redgate and has continued his work with SQLServerCentral and Red Gate as a writer and speaker.
Steve regularly presents at SQL Saturday conferences and other technical events on career and technical topics, and enjoys meeting and interacting with the SQL Server community. He has been a presenter at //build/, the PASS Summit, Dev/IT Connections, VSLive, SQL Bits, SQL Intersection, and many user groups in the US.
Steve is a graduate of the University of Virginia. He has been awarded the title of Microsoft Data Platform MVP from 2008–2017 for his many contributions to the SQL Server community. Steve holds an MCSE from NT 4.0, an MSITPro in SQL Server, and numerous other MCP certifications in SQL Server.
This video shows the hardware and software requirements for installing and running SQL Server. Security requirements for services accounts are also covered.
This video will show how the viewer can install SQL Server using the GUI-based setup program.
This video will show how you can install SQL Server using the command-line setup program.
This video will show how you can upgrade SQL Server.
This video will describe the security model for SQL Server and how this protects the databases on the instance.
Learn what a server login is and how to create one along with the options available.
You will learn about the various built-in server rolls inside SQL Server.
You will learn how to create and manage user-defined server roles and assign logins to them.
You will learn what a database user is and how this relates to logins. You will also learn to create one and test it.
You will learn the types of database roles, what privileges each has, and how to add users.
You will look at the user-defined database roles, how to create them, and add users to each of them.
You will look at how to manage object level permissions and assign them to a user or role.
This video will explain what a user database is and how to create one.
You will learn how to create a user database and set options.
You will learn how to create and alter FileGroups for user databases.
You will learn how to alter options for user databases.
You will learn how to manage the size of files for user databases.
You will learn how to create a view.
You will learn how to create, alter, and execute stored procedures.
You will understand the two types of user-defined functions.
You will learn how to create an assembly and then create a user-defined function.
You will add a file group and file for In-Memory OLTP and create a memory-optimized table.
You will create non-durable memory-optimized tables and stored procedures.
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.
You will learn how to create a clustered index.
You will learn how to create a nonclustered index.
You will learn how to create a clustered columnstore index.
You will learn how to create a nonclustered columnstore index.
You will learn how to create an indexed view.
Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.
With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.
From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.
Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.