Blog Posts

Quick Tip: How to find the address of the PowerBI local tabular instance

Super quick tip, I’ve seen this done via CMD or DaxStudio, but not via PowerShell (probably because I haven’t searched so much since I’ve done it myself), but here we are:

Read More

You can now script your database objects as a Notebook using SQL Server Management Studio 18.5+

Great News Everyone! Microsoft just dropped SSMS 18.5 after almost 5 long months without any updates; this new release fixes a lot of bugs and introduces a few new features, above them all I’m now showing you the following.

Read More

How IT helped the world during the CoronaVirus Pandemic, and how it can continue to help

The 2020 global coronavirus pandemic has shown how Health, Food, and Logistics are essential services to allow the integrity of a nation in a time of need.

Read More

A Self-deployable TICK Stack for ingesting data, monitoring and alerting for any service (including SQL Server)

Oh boy, this is a spinoff of my previous post on “How To Use Grafana (On Docker) To Monitor Your Sql Server (Eventually On Docker Too) – Feat.

Read More

A PowerBI Report for the COVID19 Emergency in Italy

As you may know, I’m from Italy; at the moment we’re experiencing the most difficult medical emergency in our history due to the new coronavirus.

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

The SQL Diagnostic Notebook: Update 2

Just a quick note, the SQL Diagnostic Book has been updated, here is the changelog:

Read More

Should you put all your eggs in one basket? Thinking about Database eggs and Cloud baskets

I had a conversation recently that started a train of thoughts related to database, cloud providers, and risk.

Read More

How to update a SQL Server container on Docker for Windows (spoiler - there is a catch)

With the 1st CU for SQL 2019 released just yesterday, and Microsoft updating the docker image right away, the only natural response for me was to update the docker instance that I showed you how to deploy a few months back.

Read More

The SQL Diagnostic (jupyter) Book

Welcome to 2020! I wanted to start this year by giving to all my fellow consultants another way to troubleshoot our beloved SQL Servers; I’ve already talked about diagnostic notebooks in the past, and now, since Azure Data Studio has implemented the feature, I wanted to group them into a Diagnostic Book.

Read More
Tags