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
|