Essential SQL Server Administration Tips (Hands-On Guides)

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to the Course!

Lecture 2: How Can this Course Help You?

Chapter 2: SQL Server Maintenance

Lecture 1: Section Overview

Lecture 2: How to Patch a Standalone SQL Server Instance

Lecture 3: How to Patch a SQL Server Failover Cluster Instance

Lecture 4: The Maximum Number of Concurrent Connections Setting in SQL Server

Lecture 5: Searching for Keywords in SQL Server Agent Jobs

Lecture 6: The SQL Server Browser Service and UDP Port 1434

Lecture 7: Getting the Disk Usage Statistics for all Tables in a Database

Lecture 8: Handling Disk Space Issues During Heavy Index Rebuild Operations

Lecture 9: How to Add a Database to a SQL Server Availability Group Using T-SQL

Lecture 10: Migrating to a Contained Database in SQL Server

Lecture 11: Modelling Database Creation with the Model System Database in SQL Server

Lecture 12: Compatibility Levels Supported by Different SQL Server Versions

Lecture 13: Backup Compression in SQL Server

Lecture 14: Transferring Ownership of All Database Objects Back to DBO

Lecture 15: Section Recap

Chapter 3: SQL Server Performance

Lecture 1: Section Overview

Lecture 2: The Importance of Database Indexes

Lecture 3: Index Maintenance Scripts

Lecture 4: The TempDB System Database in SQL Server

Lecture 5: tempdb growth

Lecture 6: Introducing In-Memory Optimization in SQL Server

Lecture 7: In-Memory Optimization in SQL Server: A Simple Experiment

Lecture 8: Getting the RAM Usage per Database in SQL Server

Lecture 9: Getting the CPU Usage per Database in SQL Server

Lecture 10: Locking and Blocking in SQL Server

Lecture 11: Section Recap

Chapter 4: SQL Server Security

Lecture 1: Section Overview

Lecture 2: Why You Need to Secure Your SQL Server Instances

Lecture 3: Transparent Data Encryption (TDE) in SQL Server

Lecture 4: 10+1 Facts About SQL Server Transparent Data Encryption

Lecture 5: Encrypting a SQL Server Database Backup

Lecture 6: SQL Server Support for TLS 1.2

Lecture 7: How to Enable SSL Certificate-Based Encryption on a Standalone SQL Server

Lecture 8: How to Enable SSL Certificate-Based Encryption on a SQL Server Failover Cluster

Lecture 9: The SELECT ALL USER SECURABLES Permission in SQL Server

Lecture 10: Dynamic Data Masking in SQL Server 2016 or Later

Lecture 11: The “Public” Database Role in SQL Server

Lecture 12: SQL Server Row Level Security by Example

Lecture 13: Should Windows “Built-InAdministrators” Group be SQL Server SysAdmins?

Lecture 14: How to Rename Logins in SQL Server

Lecture 15: Handling Orphaned Users in SQL Server

Lecture 16: Section Recap

Chapter 5: SQL Server Integration

Lecture 1: Section Overview

Lecture 2: Using Proxy Accounts in SQL Server Agent Jobs

Lecture 3: Using Unicode in SQL Server

Lecture 4: UTF-8 Support in SQL Server 2019 and later

Lecture 5: How to Create a Simple Linked Server Between SQL Server Instances

Lecture 6: What are SQL Server Machine Learning Services?

Lecture 7: How to Install SQL Server Machine Learning Services

Lecture 8: Section Recap

Chapter 6: SQL Server Error Handling

Lecture 1: Section Overview

Lecture 2: Resolving the Error Message: Rule “KB2919355 Installation” failed

Lecture 3: Error converting data type varchar to float

Lecture 4: Database […] cannot be upgraded because it is read-only or has read-only files

Lecture 5: Could not load file or assembly ‘Microsoft.SqlServer.Smo, Version=10.0.0.0, …

Lecture 6: A connection was successfully established with the server, but then an error…

Lecture 7: The SELECT permission was denied on the object ‘extended_properties’, database..

Lecture 8: ORDER BY items must appear in the select list if SELECT DISTINCT is specified

Lecture 9: A network-related or instance-specific error occurred while establishing a …

Lecture 10: There is no SQL Server Failover Cluster Available to Join

Lecture 11: An error occurred within the report server database. This may be due…

Lecture 12: Operating System Error 170 (Requested Resource is in use)

Lecture 13: Cannot Connect to WMI Provider (SQL Server Configuration Manager)

Lecture 14: The Multi-Part Identifier Could not be Bound

Lecture 15: Argument data type ntext is invalid for argument 1 of left function

Lecture 16: String or binary data would be truncated

Lecture 17: Microsoft SSIS Service failed to start. Configuration system failed to…

Lecture 18: Section Recap

Chapter 7: Special Topics (Updated)

Lecture 1: Section Overview

Lecture 2: Where are Temporary Tables Stored in SQL Server?

Lecture 3: How to Suppress the “N Row(s) Affected” Output Message in SQL Server

Lecture 4: Accessing Reporting Services Using a Fully Qualified Domain Name

Lecture 5: How to Enable Stretch Database in SQL Server

Lecture 6: Running Queries and Scripting to T-SQL

Lecture 7: Methods of Importing and Exporting Data in SQL Server

Lecture 8: How to Write to a Flat File Using SQL in SQL Server

Lecture 9: How to Read from a Flat File Using SQL in SQL Server

Lecture 10: How to Install SQL Server on CentOS Linux

Lecture 11: How to Connect to SQL Server from a C++ Program

Lecture 12: SQL Server Installation and Setup Best Practices

Lecture 13: Frequently Asked Questions about SQL Server Transparent Data Encryption (TDE)

Lecture 14: Finding the Version of a SQL Server Instance

Lecture 15: Useful T-SQL Tips for SQL Server Professionals

Lecture 16: Benefits of Database Stored Procedures

Lecture 17: Using T-SQL Snippets in SSMS

Lecture 18: T-SQL Script for Retrieving SQL Server's Version Name