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 …
PowerShell
- Home /
- Categories /
- PowerShell
Small PowerShell scripts that saved me hours: moving data between instances, reading Extended Events files, and getting data out of Excel and Oracle without installing half a server.
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 …
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 …
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 …
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 …
The Issue If you ever tried to manage a PowerBI Tenant, you may have come across this problem: A part the PowerBI success comes from the ability for BI people …
Since about a couple of versions ago, Azure Data Studio introduced Jupyter Notebooks support for SQL Server (and with SQL Server 2019 “Big Data …
Quick tip, how many times did a dev ask you to move the PROD/QA data to DEV to test a feature? Of course, not the whole DB, which would be too easy via a …
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 …