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

CategoryGeneral

The SQL Server Diagnostic Book is now on the Azure Data Studio Marketplace!

T

Great News Everyone!As detailed in my previous article, you can now create extensions containing SQL (note)books and publish them on the Azure Data Studio Marketplace!How do I know? Because I did it 🧐 How to install it As you see in the gif above, the process is super fast: Be sure to be on Azure Data Studio version 1.22.0 (September 2020) or laterSearch for “SQL Server Diagnostic” in...

How to ship SQL Jupyter Notebooks and Books directly to Azure Data Studio by creating an extension in the Marketplace

H

The recently released Extension Generator for Azure Data Studio has opened up yet another way to ship Notebooks and Books to ADS allowing you to easily author your extensions. In my previous post I’ve detailed how you can now access a Book remotely, now, if you want the book to be actually installed in your ADS instance, you can install it as an extension! Follow this link for the SQL...

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

H

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. However, these weeks of quarantine showed that IT it’s a critical part for the success of the emergency reaction and to be able to continue providing services, here are some examples: Remote Working Allowing people to continue to work...

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.

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