How to read data from Oracle Database via PowerShell without using ODBC or installing Oracle Client (and import it to SQL Server too)
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!
Read MoreHow to update a SQL Server container on Docker for Windows (spoiler - there is a catch)
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.
Read MoreCreating a Report and distributed Alerts for PowerBI Scheduled Refreshes in your organization (starring Powershell, PowerBi & Microsoft Flow)
The Issue If you ever tried to manage a PowerBI Tenant, you may have come across this problem:
Read MoreQuickly move data between instances for testing using only PowerShell
Quick tip, how many times did a dev ask you to move the PROD/QA data to DEV to test a feature?
Read MoreLoad data directly in SQL Server from a xlsx file, without OLEDB or Excel, using Powershell
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”.
Read More