Maintenance

You can now access the SQL Server Diagnostic Book remotely!

UPDATE: This is now somewhat deprecated, because you can install the Book as an extension, without having to type anything, as detailed here .

Read More

How to use Grafana (on docker) to monitor your SQL Server (eventually on docker too) - feat. InfluxDB and Telegraf

In this container-centric era to complement my SQL Server instance on docker (previous articles here ) I’ve looked over containerized monitoring solutions, and chose Grafana as my first candidate; spoiler: everything is simple once you’ve figured out how this stuff works, which can be not trivial for a Windows Guy (like me)

Read More

A PowerBI Report for SQL Server Agent Jobs

As my “community service” this month, I’ve worked on this neat (I hope!

Read More

Creating a Perfmon and Filestats reports in PowerBI [Part 2]

In this previous post I detailed the structure of the objects to be created to create a live report in PowerBI to analyze Perfmon and Filestats data (which in my case was already being gathered but not used by the FirstRespondersKit tool); Let’s get to the PowerBI stuff.

Read More

Revisiting the classics: Minimizing the Impact of DBCC CHECKDB (by Aaron Bertrand) in 2018

SQL Server has a long history, it has been around since the ‘90, more than 20 years have passed, which is a VERY long time as far as the IT world goes; Especially now that Microsoft has stepped up the release schedule for SQL Server (releases are now scheduled yearly) I thought that maybe it’s a good time to go back and revisit the classic articles and recommendations by the Gurus of the SQL Scene to see if those are stil valid.

Read More