Dec 5, 2019 | Business Intelligence, How To, Microsoft Power BI
By: Mike Pierre-Louis Have you ever been in a situation at work where you need to review a really complicated report but are extremely pressed for time? I know I have, and my guess is just about everyone reading this blog post has experienced a similar...
Dec 3, 2019 | Azure, How To, 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...
Oct 8, 2019 | Business Intelligence, Data Encryption, Data Security, How To
By: Paul Schuliger What is Column Level Security? Column level security (CLS) is a useful tool for limiting access to specific data elements (or database columns) through data obfuscation. Data obfuscation masks the underlying data elements to avoid...
Sep 20, 2019 | Data Security, How To, SQL Server, Web Applications, Web Development
By: Phillip Sharpless Security, as part of many projects, is all too often an afterthought. The standing up of a new system or the development of a new project can be quite rapid and dynamic. Not pausing during this process to think about security as an...
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...
