An adventure on SQL Server performance and features

Blog

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

Slides and materials for my session “How to use PowerBI as a Monitoring Tool” @ GroupBy.org

S

Good news everybody!As you may know if you follow me on Linkedin , I’ve been selected as one of the GroupBy Speakers for the last GroupBy session for 2019! My session will be: How to use PowerBI as a free monitoring tool (including 5 free reports for SQL Server) (session abstract here) I’ve already published the session slides and materials for you to follow along, you can find them...

An adventure on SQL Server performance and features

Emanuele Meazzo

My Social Profiles

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