Seeking SQL Server Secrets

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!

Explore hidden features and undocumented commands in SQL Server through this comprehensive conference talk from PASS Data Community Summit. Discover favorite undocumented features and learn techniques for uncovering more SQL Server secrets. Delve into topics such as undocumented trace flags, DVCC usage, page dumps, DBCC commands, secret functions, and undocumented procedures. Gain insights into enabling trace flags, understanding DVCC, and utilizing various undocumented tools to enhance your SQL Server knowledge and capabilities.

Syllabus

Introduction
Agenda
Undocumented
Trace Flags
Enable Trace Flags
Trace Flags and DVCC
DVCC
How do I know
DVCC Usage
DVCCC Page
Page Dump
DBCC Commands
Stored Procedures
Secret Functions
undocumented commands
undocumented procedures

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