View All Posts

 

SSMS

Extended Events

Anatomy of a Select

Change Font XEvent Profiler Processing Order – Part 1
SSMS Options – Part 1 Where are the events for Extended Events stored in the system tables SELECT – Part 2
SSMS Options – Part 2   FROM – Part 3
    JOINS – Part 4
    GROUP BY\HAVING – Part 5

 

 

WHERE – Part 6

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

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?    
Azure SQL DB and @@version    

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