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

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

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

 

SSRS

Security

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

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?

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

   

TSQL

General Topics

Errors

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  
UNION vs UNION ALL    
DISTINCT and XML    

Pivot and Column Names

DEADLOCK_PRIORITY

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

 

 

 

 

 

 

 

 

Security

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