Today, we are going to look into one of the commonly faced issues in the field of Data Engineering i.e. slow running queries in the production environment. I encountered this issue in production where the queries were running over 13 hours whereas initially used to take 22-25 mins. Use case: One weekend, we saw the…
We have seen how to clone the Synapse Dedicated SQL pool using the GUI in our blog https://techdiw.com/cloning-restoration-dedicated-sql-pool-formerly-sql-dw-in-synapse/. We can perform the same action using the PowerShell and make it more generic where it can be used for the Automation and can reuse the code to clone from any source to any target within the…
Today we are going to discuss on how to clone any lower environment dedicated SQL pool with the upper environment dedicated SQL pool or vice versa within a subscription. There could be the situation if you have lower environments which does not get refreshed every day, but you must clone them with the PROD…
