Dec 3, 2019 | How To, Microsoft Azure, SQL Server, Technical Information
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...
Sep 11, 2019 | How To, Microsoft, PowerShell, Technical Information
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...
Aug 27, 2019 | How To, Microsoft, Microsoft PowerApps, SharePoint, Technical Information
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...
Aug 6, 2019 | How To, SQL Server, Technical Information
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....
Jul 18, 2019 | How To, PowerShell, System Administration, Technical Information
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...
Jul 8, 2019 | Data Security, How To, Microsoft Power BI, Technical Information
By: Matt Wollner What is Row Level Security (RLS) in Power BI? Row Level Security (RLS) can be setup in Power BI to restrict data access based on the logged in. For example, perhaps you have multiple sales teams and you want each team to see sales data...
