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

Blog

How to fix “Connect Timeout” and/or “Cannot open server xxx requested by the login” when connecting to Azure SQL Managed Instance in redirect mode

By Emanuele Meazzo
In Troubleshooting
May 14, 2022
2 Min read
H

Here is something that will save you lots of time and headaches when trying to connect to Azure SQL Managed Instances, especially from onprem servers or from other clouds; I had to repeat this multiple times to multiple actors, so I know it will happen to someone else too. In most cases, “Connect Timeout” and/or “Cannot open server xxx requested by the login; Login failed”...

Read onRead later1 comment

How to fix direct Query authentication delegation issues with Power Bi Report Server with Edge and Chrome

By Emanuele Meazzo
In PowerBI, Troubleshooting
July 12, 2021
3 Min read
H

With the end of the IE support for Power Bi (and in general tbh), companies are scrambling finally to move their users from the legacy browser to modern ones; it was about time if you ask me. However, there’s an edge case where using anything but IE is not as straightforward as it could be; in my case Power Bi RS worked fine for any report in any browser, except with direct query reports...

Read onRead later1 comment

How to read data from Oracle Database via PowerShell without using ODBC or installing Oracle Client (and import it to SQL Server too)

By Emanuele Meazzo
In General, powershell
April 13, 2021
6 Min read
H

If you read my previous article on how to configure a Linked server to Oracle , you know that I feel like someone is plotting to keep the topic of how to get our precious data outside of the Oracle ecosystem as obscure as possible out of the oracle circle Fear not! I’m here to get you all the info in order to get data from Oracle Database via Powershell, in a native high-performance way...

Read onRead later4 comments

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

By Emanuele Meazzo
In powershell
March 17, 2021
4 Min read
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...

Read onRead later1 comment

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

By Emanuele Meazzo
In General
January 7, 2021
5 Min read
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...

Read onRead later6 comments

SQL Server Diagnostic Notebook Updated

By Emanuele Meazzo
In General
December 18, 2020
1 Min read
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)

Read onRead later2 comments

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

By Emanuele Meazzo
In Tips&Tricks
October 26, 2020
1 Min read
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...

Read onRead later1 comment

Presenting @ DataWeekender the SQL Server Diagnostic Book

By Emanuele Meazzo
In Uncategorized
October 17, 2020
1 Min read
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

Read onRead laterAdd comment

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

By Emanuele Meazzo
In General
September 22, 2020
2 Min read
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...

Read onRead laterAdd comment
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