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

T-SQL Tech

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

T

Latest stories

You can now access the SQL Server Diagnostic Book remotely!

Good news everyone, thanks to the Azure Data Studio August 2020 update you can now access the SQL Server Diagnostic Book without having to download the book from my Github. Remote Jupyter Books have been added to ADS, now you just need to click “Add Remote Jupyter Book” in the Notebooks blade and insert my GitHub repository URL, like so: Be sure to click the “Search”...

How to lose hundreds of thousands of dollars by using functions in SQL Server

Ahh, functions, the greatest tool at a programmer’s disposal, they make code reusable and easy to read, they’ve been essential since the first function call was made in the last century… Unfortunately for the developers out there, when working for SQL Server, especially when tuning for performance, you need to get everything you knew about programming and throw it out of the...

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: I’m sure you know that PowerBI tabular models are 100% the same as SSAS tabular models, hence you can use SSMS to connect to a PowerBI Tabular model as if it was SSAS (because it is), to do whatever you...

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. I’m sure that you used the the “Generate Scripts” feature in SSMS quite a few times, you could generate the code for schema and/or data for any (or...

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. 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)

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

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

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

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

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...

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