It's just Emanuele showing you what you can do in the Microsoft Data Platform

CategoryGeneral

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

A

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. Influxdb And Telegraf” , which is a nice solution, but I wanted to create something that’s even more easy to deploy, more configurable and without the need of actually knowing influxSQL or learning the influxDB Telegraf schema; for these...

A PowerBI Report for the COVID19 Emergency in Italy

A

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. As the official data from the Italian Government came out, I’ve created a PowerBi report in order to track the current status of the virus. ITA: Questo report è creato usando i dati ufficiali della protezione civile, si aggiorna ogni...

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

H

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) Note: I’m focusing on SQL Server as always but as you...

The SQL Diagnostic Notebook: Update 2

T

Just a quick note, the SQL Diagnostic Book has been updated, here is the changelog: Updated FirstResponder’s Kit and Glen Berry’s ScriptsAdded SQL Assessment API NotebooksAdded sp_whoisactive installation and basic documentation notebooksAdded sp_pressure_detector as a Notebook That’s it! As always, to use it just download the folder of the Book from my GitHub (here is...

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

S

I had a conversation recently that started a train of thoughts related to database, cloud providers, and risk.Should we treat DBs like investments and diversify investing in the best suit for a specific need, or try to keep everything in the same ecosystem? Stock market DBs When your IT stack is diversified, the risk is lowered as you don’t rely on any specific omnipotent provider that can...

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

H

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. The theory In theory, a docker container can’t be really “updated”, they’re meant to be stateless machines that you spin up and down responding to...

The SQL Diagnostic (jupyter) Book

T

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.

Why RDP'ing into a SQL machine is a bad idea

W

Guys, you should stop doing this, there are reasons if it’s not recommended to log into the SQL Server Machine via RDP as opposed to using a client on your PC (or another machine). PS: These recommendations are valid for any DMBS, not only SQL Server You’re stealing resources from SQL Server Probably you’re logging into your server because there is a problem, do you really want...

Presenting at SQL Saturday

P

I’ll be presenting my session on “How to use PowerBi as a Free monitoring tool” this Saturday in Parma.

Here you can check the session schedule, there are a lot of interesting sessions; moreover, the event is totally free, if you are in the area and you like data it can’t be missed!

Check out the event page here

Use SQL Server on Docker for Windows, the easy way

U

I wanted to install and test SQL Server 2019 on a new machine, without the hassle to create a VM from scratch, since I had none of my resources from this new place, that’s when I remembered about Docker and how Microsoft is slowing reaching feature parity for SQL on LInux , moreover, I didn’t need any of the unsupported stuff, so. I didn’t find a straightforward guide that said...

It's just Emanuele showing you what you can do in the Microsoft Data Platform

Emanuele Meazzo

My Social Profiles

If you're interested in following me around in the social world, here are some URLs for you

Find Us

Address
123 Main Street
London EC1 4UK

Hours
Monday—Friday: 9:00AM–5:00PM
Saturday & Sunday: 11:00AM–3:00PM

About This Site

This may be a good place to introduce yourself and your site or include some credits.