Dynamic UNPIVOT Reporting on Cardinality.

Today I was diving into some extremely wide tables, I wanted to take a quick look at things like “How many unique values does this table have in every column?”. This can be super useful if you have a spreadsheet of results or a schema without effective normalization and you want to determine which rows […]

Postgres Plugin Support Added in Azure Data Studio!!

I know I have been writing a lot about ADS recently, but this is even bigger than the Notebook announcement. A Postgres plugin has been announced in the insider release of ADS, and it just works! If the term Postgres is unfamiliar – PostgreSQL is one of the preeminent open source database solutions and is […]

Update: T-SQL Notebooks in Azure Data Studio

It’s only been ten days since my first post about ADS Notebooks, and the team has already pushed out some super useful updates. Now launching an Azure Data Studio Notebook now is almost instantaneous. You are not prompted to install the other kernels unless you select them. When reopening a file, you no longer are […]

T-SQL Notebooks in Azure Data Studio

Update: This blog post is already out of date due to the hard work of the ADS team! Check my Azure Data Studio Notebook Update for more details of why you can skip my warnings about your internet connection. I have been waiting for word about the new Notebook functionality in Azure Data Studio, and […]

How long did that last PowerShell command take?

Today Thomas Rayner’s post on Get-History reminded me of a one liner I use to calculate time spent on the last command.

  You can select any property from the output and get just the TotalSeconds, but I like this simple output for when I have to leave some work in progress and I […]