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

PoorSQL Formatter for SSMS

Azure Data Studio Connections and SSMS

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


WHERE – Part 6

  Searching for Events  
  Capture the Deadlock Graph  
  Max Dispatch Latency  


Options Greyed Out



Extended Events and Execution Plans

Using Extended Events to Capture Failed Logins

SSMS Extended Events Filters

File Rollover and Max Size File Target Options




Server Assessment

SSRS: Action to URL or Report


Assessment Reports

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?

Backup History and Information

Investigative Reports:  Global Table Already Exists Error


Collecting Execution Plans

Why look for Plan Guides?

What is the Data Type Precedence order and how is it used for Implicit Converts?

Azure SQL DB and @@version

Deadlock Detection Interval

Check for Pending Restart

Is a Restart needed Due to Server Property Changes

Auto Delete Jobs

SYS.DM_EXEC_SESSIONS and System Processes

A Faster Alternative to sp_helpdb



General Topics


I am waiting…… Lessons Learned about Blogging Operand Type Clash: Error 206
Table Variable and ROLLBACK 100th Blog Post and Time another Lessons Learned Post  

Pivot and Column Names


T-SQL Formatting – My Thoughts

Ambiguous Column Name when only using one table



Azure Data Studo

Introduction to Azure Data Studio

Azure Data Studio – The Explain Button

Agent Job management Using Azure Data Studio

ADS: SentryOne Plan Explorer Extension

ADS: SSMS Keymap

ADS: Search Extensions

ADS: Server Reports

ADS: Change Tab Color

ADS: Creating Server Groups

ADS: PoorSQL Extension

ADS: Keyboard Shortcuts

ADS: SQL Server Profiler Extension

ADS: Auto Close

ADS:  Why doesn’t the App ask to save file

ADS: Process Explorer

ADS: Query History Extension

ADS: Outdated Extensions

ADS:  Did I Save My Changes

ADS: Schema Compare

ADS: Notebook Text Formatting

ADS: Simple Data Scripter

ADS: Number on the Explorer Icon

ADS: Settings Editor

ADS: Demo Mode Extension

ADS: Database Snapshot Creator

ADS: TSQL Checker

ADS: Provide Feedback

Azure Data Studio Connections and SSMS










Mapping Database User to Login

Find Failed Logins using SQL Log

Find Failed Logins Using SQL Server Audit

Find Failed Logins Using Extended Events


Auditors are at your Desk…Now what?

Job Failures

Backup History

SysAdmin Members