You’re a systems administrator or developer who’s been stuck in charge of the SQL Server. You have a couple of production SQL Servers, no high availability or disaster recovery, and around 100GB of data or less on each server.
You’ve never been to a “real” SQL Server training class, and you’ve been Googling your way through problems alright, but you’re starting to realize that this SQL Server thing is kinda complicated.
Let’s get you up to speed, quickly, with the most important things to learn before they catch you by surprise and ruin your day. No theory here, only the real deal production stuff, pronto.
Aulas do Curso
(17 vídeos)
0 de 17 aulas concluídas
0%
Progresso salvo somente neste navegador.
0
Backups 1: 3 Common Strategies
Want to get better at fixing slow queries? My 2027 Live Class Season Pass is $995 (normally $4,395), with live classes a…
1
DBA Fundamentals: Backups 2: Restores
Want to get better at fixing slow queries? My 2027 Live Class Season Pass is $995 (normally $4,395), with live classes a…
2
DBA Fundamentals - Backups 3 - Setting Up Maintenance Plans
Want to get better at fixing slow queries? My 2027 Live Class Season Pass is $995 (normally $4,395), with live classes a…
3
DBA Fundamentals - Backups 4: Setting Up Ola Hallengren's Scripts for Backups
Want to get better at fixing slow queries? My 2027 Live Class Season Pass is $995 (normally $4,395), with live classes a…
4
DBA Fundamentals - Backups 5 Restore With Standby
How to restore transaction logs using the Standby syntax and how that can help you in emergencies, where you need to rec…
5
DBA Fundamentals Configuration sp configure
For the most part, you can next-next-next your way through SQL Server's setup and it'll work well enough for most shops.…
6
DBA Fundamentals Configuring TempDB
Want to get better at fixing slow queries? My 2027 Live Class Season Pass is $995 (normally $4,395), with live classes a…
7
DBA Fundamentals: Configuration: Database Mail
Want to get better at fixing slow queries? My 2027 Live Class Season Pass is $995 (normally $4,395), with live classes a…
8
DBA Fundamentals: Configuration: Remote DAC
Set up and use and enable the Remote DAC. The beauty of the Remote DAC is that if for some reason you can't remote in, y…
9
DBA Fundamentals: Configuration: Lock Pages in Memory (LPIM)
To talk about lock pages in memory, you have to talk about paging. You have to talk about disk and memory too. If there …
10
DBA Fundamentals: Configuration: Instant File Initialization (IFI)
Usually when data file grows or when you create a new file for it or whatever else, SQL will have to zero out the disk t…
11
DBA Fundamentals: Configuration: Anti Virus
If you run anti-virus on a SQL Server, it's not enough to configure it to ignore MDF and LDF files.
12
DBA Fundamentals: Maintenance: Agent Jobs
SQL Server started long ago, and that's why it has its own backups, emails, event logging, OS abstraction layer, and sec…
13
DBA Fundamentals: Corruption: Checking for Corruption
Want to get better at fixing slow queries? My 2027 Live Class Season Pass is $995 (normally $4,395), with live classes a…
14
DBA Fundamentals: Corruption: DBCC CHECKDB for VLDBs
"All they know is that a database has exploded" the news reporter will say grimly, staring into the camera while a ticke…
15
DBA Fundamentals: Maintenance: Shrinking Files
Want to get better at fixing slow queries? My 2027 Live Class Season Pass is $995 (normally $4,395), with live classes a…
16
DBA Fundamentals: Patching SQL Server
You'll learn how patches changed starting with SQL Server 2017, what's inside a cumulative update, how to pick which pat…