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…

PASS Summit 2017

Today was another good day at work. Since returning from summit, I spent a rigorous amount of time developing slides & demos to share what I learned, attempting to deliver on my pact with my CIO and Director. Well, that came true today in full-circle & the feedback was amazing! Recording: Slides: This is a…