How to Be a Ninja - Troubleshooting SQL Performance

Offered By: PASS Data Community Summit via YouTube

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Dive into advanced SQL performance troubleshooting techniques in this comprehensive 59-minute conference talk from PASS Data Community Summit. Learn how to become a "ninja" at diagnosing and resolving SQL performance issues, covering topics such as capital expenditure vs operational expenditure, storage tips, best practices, and backup strategies. Explore crucial concepts like instant file initialization and block pages in memory, while gaining insights into cheat sheets and practical results. Perfect for data professionals seeking to enhance their SQL troubleshooting skills and optimize database performance.

Syllabus

Introduction
Questions
Sponsors
Passim
Data Professional
Agenda
Capital Expenditure vs Operational Expenditure
Cheat Sheet
Storage Tips
Best Practices
Results
Backups
Instant File initialization
Block pages in memory
Summary

Taught by

PASS Data Community Summit

Related Courses

Doing More with Less - The Challenges Ahead for Every Data Professional
PASS Data Community Summit via YouTube Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube Transform Your Data Estate
PASS Data Community Summit via YouTube Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube