9 тысяч подписчиков
177 видео
Query Writing: Peak Year - Setup and Problem
Course: Tuning a Stored Procedure - Finding the Slow Query with Query Store
Setting Up Free Blocking Alerts and Deadlock Monitoring (Dear SQL DBA Episode 17)
SSMS Shortcuts - Pinning and Custom Keyboard Shortcuts
Altering an INT Column to a BIGINT (Dear SQL DBA Episode 11)
Dear SQL DBA: Everything I Never Wanted to Know About Collation
SSMS Shortcuts - XEvents Wizard Secrets
Course: Tuning a Stored Procedure - Finding the Slow Query with the Plan Cache
SSMS Shortcuts - Welcome
SSMS Shortcuts - IntelliSense
Rita the Raccoon Writes SQL
SSMS Shortcuts - Execution Plans
A Dynamic SQLChallenge: Solution
SSMS Shortcuts - Stupid Pet Tricks
SSMS Shortcuts - Session Management
Dear SQL DBA - Down Tools Week 2020
SQLChallenge: DDL Triggers - Solution
SSMS Shortcuts - Thanks for Watching
Query Writing: Peak Year - Sample Solution
Course: Tuning a Stored Procedure - The Problem
Freyja the Corgi’s Notes for Learning SQL
Dear SQL DBA: What's Up With Tech Interviewing in 2023?
SQLChallenge: Event Notifications - Setup
SQLChallenge: DDL Triggers - Challenge
Dear SQL DBA: Advice for Technical Leaders with Alex Robson
SSMS Shortcuts - Object Explorer Details
Be careful out there
Data Careers: DBA, DBRE, and Data Engineer
A Dynamic SQLChallenge: Setup and Problem
SSMS Shortcuts - Diagnosis for Stack Dumps
Jer and Kendar Explore Optimized Locking
SQLChallenge: Event Notifications - Solution
The Manager's Guide to Git Training for DBAs
Course: Tuning a Stored Procedure - Tuning the Slow Query
Auto-Tuning: What Automatic Plan Correction Does and How to Enable It
Love and Hate for SSMS (Dear SQL DBA Episode 51)
Collect and Baseline Wait Statistics (Dear SQL DBA Episode 14)
SQLChallenge: Event Notifications - Challenge
Why do We Have Repeatable Read and Serializable Isolation Levels?
Dynamic SQL
Developer Seeks DBA Career (Dear SQL DBA Episode 13)
Why Table Partitioning Doesn't Speed Up Query Performance
Awkward Unicorn Explains Database Normalization
3 Things that Shouldn't be Normal in Database Development
Interview Advice from the SQL Server Community (links to posts in description!)
How Developers and DBAs Collaborate in a DevOps World
Should I Automate Windows Updates against SQL Server? (Dear SQL DBA Episode 10)
Will the Cloud Eat My DBA Job? (Dear SQL DBA Episode 31)
A common error with NOLOCK
Running SQL Server in a Docker Container on a Mac
