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

Blog

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

H

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.Now that you’re familiar with extended events, one of the common destinations for the tracked information are Extended Event Files, where simply put the events are saved to while they happen. *.XEL files are easy to work with in SSMS, just double click...

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

H

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. Doing so, I’ve come to the conclusion that Oracle purposely makes everything as obscure and overly complicated as possibile, in order to sell support. All the reference articles...

SQL Server Diagnostic Notebook Updated

S

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

No new addition this time around, just updates; but I’m always open to suggestions

The easiest way to access and use it is through the Azure Data Studio Marketplace (or downloading the vsix extension directly from GitHub)

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

T

UPDATE 2: The bug was fixed in SSMS 18.8UPDATE: The bug still isn’t fixed in SSMS 18.7.1 Oh boy, what I found; I haven’t seen anybody else reporting on it, yet, so here I am.Fortunately, the bug is not breaking, as I’ve found a workaround, but still. Repro Open the “New Session…” GUI for extended events in SSMSGive it a name, it’s not importantAdd an...

Presenting @ DataWeekender the SQL Server Diagnostic Book

P

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.

You can download the Slides from the slides HereMy latest post on the Diagnostic book is HereHow to Create a Book Extension for ADS Here

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

T

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!How do I know? Because I did it 🧐 How to install it As you see in the gif above, the process is super fast: Be sure to be on Azure Data Studio version 1.22.0 (September 2020) or laterSearch for “SQL Server Diagnostic” in...

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

H

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. In my previous post I’ve detailed how you can now access a Book remotely, now, if you want the book to be actually installed in your ADS instance, you can install it as an extension! Follow this link for the SQL...

You can now access the SQL Server Diagnostic Book remotely!

Y

UPDATE: This is now somewhat deprecated, because you can install the Book as an extension, without having to type anything, as detailed here. 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...

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

H

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

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