Expert Insights

blog

SQL Server


Exploring SQL Server Metrics in Power BI

This blog is aimed at IT/Database folks to show you how you can leverage Power BI when analyzing databases and environments for problem areas or performance issues. This exercise presents an alternative to rows and rows of data, and gives some tools/ideas to create a quick report and make it repeatable across environments when analyzing SQL Server metrics.      

Seth Bauer by Seth Bauer

Comparing Extended Events in SQL Server and Azure SQL Database

An exciting new feature of Azure SQL Database is the implementation of Extended Events (XEvents). I use XEvents in SQL Server to track information about many things – query performance, deadlocks, Availability Group status, and more. Until October, they were missing from SQL Database, but they are now in preview!

Kim Claditis by Kim Claditis