Copy from On-Prem to Azure SQL with Azure Data Factory ­čô║

In this short video, I demonstrate how to copy data or multiple tables from an on-prem SQL Server, through a self-hosted run-time integration to Azure SQL DB Hyperscale and/or Azure SQL Data Warehouse with Azure Data Factory. Plus, how to automate tasks like Resuming or Pausing your Azure SQL Data Warehouse before or after your… Continue reading Copy from On-Prem to Azure SQL with Azure Data Factory ­čô║

Hurdles of Encryption – Refresh X from Y

In short, sys.dm_database_encryption_keys allowed to see the encryption state and I found the system was in progress of decrypting the database. The hurdle originated while trying to restore encrypted database backups generated by Prod svr(s) to Dev svr(s). The lower env needed the Prod keys to decrypt the Prod backup files. While trying to restore… Continue reading Hurdles of Encryption – Refresh X from Y

Batching SQL Scripts to Automate Deployments (with .bat/cmd)

With this technique, you don't have to buy anything or spend time installing fancy stuff. Just write some commands, copy/paste and save as .bat or cmd. [Not discrediting any other implementation, just sharing┬ámy experience with a simple method]. When you end up┬árunning the batch I recommend doing it on the target server, not your workstation… Continue reading Batching SQL Scripts to Automate Deployments (with .bat/cmd)