View All Posts

 

SSMS

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

GROUP BY\HAVING – Part 5

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

 

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

Administration

SQL Agent

Performance

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?   Collecting Execution Plans

Azure SQL DB and @@version

Deadlock Detection Interval

Check for Pending Restart

Is a Restart needed Due to Server Property Changes

Auto Delete Jobs

   

TSQL

General Topics

Errors

I am waiting…… Lessons Learned about Blogging Operand Type Clash: Error 206
Table Variable and ROLLBACK    
UNION vs UNION ALL    
DISTINCT and XML    

Pivot and Column Names

DEADLOCK_PRIORITY

   

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