All Posts

SQL Server Management Studio Github Copilot activity

Finding queries with cross schema joins

Is my stats updated on my Azure SQL DB Failover Group?

SQL/KQL Linter tool

Catch risky query patterns before they hit production. The new SQL & KQL Linter analyzes your queries in-browser and flags performance and safety issu...

SQL/KQL formatter tool

A free browser-based formatter for T-SQL, KQL, and five other SQL dialects. Your queries never leave your machine.

Log Analytics Audit - Failed logins

Find write queries

Audit for write operations on an Azure database

Find possible duplicate indexes

Want to locate possible duplicate / redundant indexes?

Get index size and usage

Had a question about the usage of some indexes. Ended up with this script to document my findings.

Azure bug

DTU count, determines if user can access VIEW SERVER PERFORMANCE STATE through role

Space used by table

Sometimes we just need a simple list of space used for some tables

Quick database information

Get the basic information about the current database