Find possible duplicate indexes
Want to locate possible duplicate / redundant indexes?
Insights and expertise on the Microsoft Data Platform stack: Azure Data Services, SQL Server, Power BI, and enterprise data solutions.
Want to locate possible duplicate / redundant indexes?
Had a question about the usage of some indexes. Ended up with this script to document my findings.
DTU count, determines if user can access VIEW SERVER PERFORMANCE STATE through role
Sometimes we just need a simple list of space used for some tables
A PowerShell CLI tool that scans your .sql files for destructive, risky, and security-sensitive comm...
A PowerShell script for automating daily Azure Privileged Identity Management (PIM) role activations...
Deep-diving into the Microsoft Data Platform stack — from SQL Server internals and performance tuning to Azure Data Services, Power BI, and enterprise data architecture.
Practical insights, release tracking, and real-world solutions for data professionals working with Microsoft technologies.
5
Articles
430
Releases Tracked
2
Projects