Posts tagged "sql-server"

Finding queries with cross schema joins

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

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