SQL Database DevOps (2 of 2)

How to automatically refresh a QA sql database from Prod by leveraging Azure DevOps and/or GitHub.

Power BI Fest 2019🎊

This year we're having the first ever Power BI Fest in South Florida and I was lucky to have been invited to speak at the event. I will be giving 2 talks in the morning. More info and registration around the event can be found on the event's website https://powerbifest.com/home/presenters. Space is very limited. Sessions…

Copy from On-Prem to Azure SQL with Azure Data Factory 📺

PASS Insights 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…

SQLCMD variables for input SQL file

In short, this is an example of how you do it. Set a couple of variables, use -v parameter sqlcmdVariable="%batVariable%". The following contains more details on how to use SQLCMD variables for an input SQL file. Note, I am not advising you to you use this as your routine backup method. If you're looking for…

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…

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…

How to create a DacPac

Over coffee with friends we got talking about dacpacs and other stuff. Later, Friend1 still had questions over skype about how to install it and such. I replied but he was gone. So I figured, I better send him some instructions and screenshots by email. From: Fleitas, Hiram Sent: Tuesday, January 10, 2017 5:52 PM…