Skip to content
October 6, 2025
Newsletter
Random News
Techdiw

Techdiw

  • Home
  • Azure
  • Python
  • About Us
  • Home
  • Azure
  • Python
  • About Us

Category Collection

  • Home
  • Dedicated SQL Pool

Tag: Dedicated SQL Pool

  • Azure

Query Optimization In Synapse Dedicated SQL Pool

Diwakar KumarJune 21, 2024June 21, 202408 mins

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…

Read More
  • Azure

Restore Synapse Dedicated SQL Pool Using PowerShell

diwakar.kumar@techdiw.comMarch 11, 2023January 2, 202406 mins

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…

Read More
  • Azure

Cloning/Restoration Dedicated SQL Pool (formerly SQL DW) in Synapse

diwakar.kumar@techdiw.comFebruary 15, 2023December 25, 202308 mins

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…

Read More

Recent Posts

  • Query Optimization In Synapse Dedicated SQL Pool
  • Automating Workflows: Triggering Logic Apps from Synapse with Python
  • Managing Synapse Triggers with PowerShell in DevOps
  • A Deep Dive into FileDataLakeClient in Azure Synapse Analytics
  • Resolving Production Self-Hosted Integration Runtime Version Mismatch Issue

Archives

  • June 2024
  • May 2024
  • January 2024
  • September 2023
  • July 2023
  • May 2023
  • March 2023
  • February 2023
  • January 2023

Categories

  • Azure
  • DevOps
  • Python
  • Uncategorized

About Us

Hey Tech Enthusiasts! Welcome to TechDiw, the ultimate hub for learning new
technologies and conquering tech challenges. Born in 2023, Here we share the knowledge which will help others to come out of the mud of technical challenges.

Our Location

Address:
Ranchi, Jharkhand

Social
Follow us via: Facebook, Instagram & Youtube
support@techdiw.com

Quick Links

  • Home
  • About Us
  • Azure
  • Python
TechDiw | Developed by Impulse Web Solution Powered By BlazeThemes.
  • Login
  • Register
Forgot Password?
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.