Aug 21, 2018 | Data Warehousing, Key2 Stories, Microsoft, PowerShell, SQL Server, SSIS, Tech Tips, Technical Information
By: Ken Adams Introduction Disclaimer: Microsoft introduced the project deployment model for Integration Services (SSIS) over 6 years ago with SQL Server 2012. At this point in time, it is likely that you know a lot about project deployment. This post will...
Jun 26, 2018 | Microsoft, PowerShell, SharePoint, SQL Server, Tech Tips, Technical Information
By: Mason Prewett This article covers a Key2 client’s upgrade to SQL 2016 of a SQL Server Reporting Services instance in SharePoint Integrated Mode (in a SharePoint 2013 environment). You can follow the information in this article to conduct your own...
Feb 26, 2018 | Microsoft, SQL Server, SSIS, Tech Tips, Technical Information
By: Jharred Williams To kick things off, let’s start with a quick refresh on SQL Server Integration Services (SSIS) and what’s new with the tool today. To say SSIS is strictly a data extract, transformation and loading (ETL)...
Oct 2, 2017 | Business Intelligence, Microsoft Power BI
By: Mike Pierre-Louis BI Consultant at Key2 Consulting In the business intelligence world, Power BI has become a favorite among many. During my time designing and building various Power BI reports, I’ve both overcome obstacles and made several...
