Emanuele Meazzo - That guy

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

General , Powershell

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!

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.

Quick Tip: How to find the address of the PowerBI local tabular instance

Powerbi , Powershell

Super quick tip, I’ve seen this done via CMD or DaxStudio, but not via PowerShell (probably because I haven’t searched so much since I’ve done it myself), but here we are:

How to update a SQL Server container on Docker for Windows (spoiler - there is a catch)

General , Powershell , Tipstricks

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.

Use SQL Server on Docker for Windows, the easy way

General , Powershell

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.

Creating a Report and distributed Alerts for PowerBI Scheduled Refreshes in your organization (starring Powershell, PowerBi & Microsoft Flow)

Powerbi , Powershell

The Issue If you ever tried to manage a PowerBI Tenant, you may have come across this problem:

SQL Notebooks: On the right track to enhance Data Analysis on SQL Server

General , Powershell

Since about a couple of versions ago, Azure Data Studio introduced Jupyter Notebooks support for SQL Server (and with SQL Server 2019 “Big Data Clusters” on the horizon, it was about time)

Quickly move data between instances for testing using only PowerShell

Powershell , Tipstricks

Quick tip, how many times did a dev ask you to move the PROD/QA data to DEV to test a feature?

Load data directly in SQL Server from a xlsx file, without OLEDB or Excel, using Powershell

Powershell , Tipstricks

I don’t know you, but people from other BU are old fashioned guys that do everything by hand, and then send you an Excel file to “put this data in the database” or “find info related to this codes”.