The SQL Diagnostic Notebook: Update 2
Just a quick note, the SQL Diagnostic Book has been updated, here is the changelog:
Read MoreHow 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 MoreThe 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 MoreWhy RDP'ing into a SQL machine is a bad idea
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).
Read MorePresenting at SQL Saturday
I’ll be presenting my session on “How to use PowerBi as a Free monitoring tool” this Saturday in Parma.
Read MoreUse SQL Server on Docker for Windows, the easy way
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.
Read MoreSlides and materials for my session "How to use PowerBI as a Monitoring Tool" @ GroupBy.org
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!
Read MoreWhy identity values can jump by the 1000's ? Is it normal?
It must have happened you at least once to find identity columns with values that from one row to the next one jump by 1000’s rows, of course without having anyone deleting the rows in between, how this occurs?
Read More