By: Phil Woubshet In part 1 of this series, we implemented a solution within the Azure Portal to copy multiple tables from an on-premise SQL Server database to Azure Synapse Analytics (formerly Azure SQL Data Warehouse). Today’s exercise will be to...
By: Phil Woubshet This exercise will demonstrate how to copy multiple tables from an on-premise SQL Server database to Azure SQL Data Warehouse. We will use a metadata table that contains the schema/table names to drive the copy process from source to...
By: Mason Prewett We’ve written many blog articles about PowerShell and how incredibly useful the Microsoft framework can be, and this article is another example. PowerShell is a great tool for performing long running tasks. A common strategy used to...
By: Austin Gainey Did you know you can utilize Microsoft PowerApps to customize out of the box SharePoint Online forms, which can then be used to take down corrupt secret government projects, destroy cars with telekinesis, and cut through the fabric of...
By: Andy Kim Introduction The SELECT…INTO statement is an excellent tool to have in your arsenal if you’re a SQL developer. The SELECT…INTO statement: Creates a target table for you automatically, eliminating the need to manually create a table....
By: Matt Wisor PowerShell to the Rescue Carrying out server maintenance on a regular basis can be challenging, especially if users are working in the application being serviced. Applying a Visual Studio update, for example, may corrupt the application if...
