Blog Posts

How to programmatically read from SQL Server extended events files (*.xel) with PowerShell

• Powershell

I love extended events, and if you’re still using SQL profiler, go feel ashamed and come back only when you’ve stopped using it.

Slides for "How to use the Cloud for data and actually save money"

• General

On my GitHub you can find the slides for my presentation @ Data Saturdays 001 in Pordenone

How to configure a Linked Server to a modern version of Oracle in SQL Server

• General

It definitely was his plan, all along Following an Oracle migration to a new version (19c on AWS RDS), I had to update the related linked server in a SQL Instance, upgrading the Oracle Client to the latest version.

SQL Server Diagnostic Notebook Updated

• General

Good news everyone! As always, I’ve updated the SQL Server Diagnostic Notebook to include the latest updates to the source scripts

There's a Bug with Extended Events creation in SQL Server Management Studio 18.7: what it is and a workaround

• Tipstricks

UPDATE 2: The bug was fixed in SSMS 18.8 UPDATE: The bug still isn’t fixed in SSMS 18.

Presenting @ DataWeekender the SQL Server Diagnostic Book

I’ve bored you with my SQL Server Diagnostic Book for long enough, now I’ll bore even more people @ DataWeekender , where I’m doing a lightening talk about it, showing people what it is and how to install/use it.

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

• General , Tipstricks

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.

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

• General

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!

You can now access the SQL Server Diagnostic Book remotely!

• Maintenance , Performance

UPDATE: This is now somewhat deprecated, because you can install the Book as an extension, without having to type anything, as detailed here .

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

• Datawarehouse , Performance , Troubleshooting

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…