This blog is part of the blog series named SQL Server Monitoring. Purpose To list status of backups. Sources This feature queries the MSDB tables dbo.backupmediafamily and dbo.backupset which returns…
Category: <span>Power BI Desktop</span>
This blog is part of the blog series named SQL Server Monitoring. Purpose To show the Always On performance over time. Sources This feature queries the DMV sys.dm_os_performance_counters which returns…
This blog is part of the blog series named SQL Server Monitoring. Purpose To get a quick overview of the Always On configuration. Sources This feature queries the 7 DMV’s…
This blog is part of the blog series named SQL Server Monitoring. Purpose To get a baseline of the SQL agent jobs and their executions over time, how long time…
This blog is part of the blog series named SQL Server Monitoring. Purpose To list agent jobs and their schedules. Sources This feature queries the MSDB tables dbo.sysjobs, dbo.sysjobschedules and…
Are you aware of Visual Level Filters (VLF) in Power BI Desktop? I was not until I saw this video by Patrick from GuyInACube (YouTube – Twitter). VLF’s are amazing…