Oct 30, 2020 | GitHub, How To, Microsoft
By: Matt Wollner Our Branch-Based GitHub Workflow Now that Microsoft has acquired GitHub, our team here at Key2 Consulting is starting the transition from Team Foundation Server (TFS) to GitHub for our database source control. If you are...
Jun 4, 2020 | How To, Microsoft Excel
By: Andy Kim When it comes to analyzing data, Microsoft Excel spreadsheets have always been a great tool to do so, and they will continue to be commonly used amongst data analysts for the foreseeable future. Have you ever found yourself performing...
May 7, 2020 | How To, Microsoft, Microsoft Power Automate
By: Austin Gainey Before I get into the details of Power Automate’s capabilities, it is my genuine hope that you and your family/friends are healthy and safe as we navigate our way through the COVID-19 pandemic. A huge thank you and appreciation to...
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...
