View All Posts



Extended Events

Anatomy of a Select

Change Font XEvent Profiler Processing Order – Part 1

SSMS Options – Part 1

SSMS Options – Part 2

Where are the events for Extended Events stored in the system tables

Create Database Event, When does it fire?

Database Restore and Extended Events

SELECT – Part 2

FROM – Part 3

JOINS – Part 4

  Searching for Events  
  Capture the Deadlock Graph  
  Max Dispatch Latency GROUP BY\HAVING – Part 5


Options Greyed Out

WHERE – Part 6


Extended Events and Execution Plans

Using Extended Events to Capture Failed Logins

SSMS Extended Events Filters

File Rollover and Max Size File Target Options


Azure DB

Azure Architecture

Azure Performance

Create an Azure SQL Database

Move Existing DB to Azure SQL DB

Query Editor for Azure SQL Database

Azure Data DTUs

Azure Storage Explorer Lease

Add a Dashboard to the Azure Portal

Azure SQL Database Connections works in SSMS but not with Azure Data Factory Connection

Azure Budgets

How to create a Metrics Report

Read Extended Events Files in Azure Storage Account


SQL Agent


Live Query Execution Plans Missing Job Step Type Get Statistics Info
MDOP vs Cost Threshold for Parallelism   Did the System Create the Stats
Trace Flags: Global vs Session   Optimize for Ad Hoc Workloads
sp_helptext   dm_os_performance_counters and PIVOT
Disabled Database user?    

Azure SQL DB and @@version

Deadlock Detection Interval

Check for Pending Restart

Is a Restart needed Due to Server Property Changes



General Topics


I am waiting…… Lessons Learned about Blogging Operand Type Clash: Error 206
Table Variable and ROLLBACK    

Pivot and Column Names