Oct 9, 2018 | Azure, Business Intelligence, Conferences, Consulting, Data Visualization, Key2 Stories, Microsoft, Microsoft Power BI
By: Andy Kim Introduction It was a beautiful fall morning as I drove towards the Microsoft office in Alpharetta, GA. I was on my way to attend the annual 2018 SQL Saturday Atlanta – BI Edition. When I arrived, there was a nicely furnished office with great...
Sep 17, 2018 | Microsoft, SharePoint
By: Austin Gainey In May of 2018, SharePoint Senior Technical Manager Bill Baer announced some of the details for Microsoft’s release of SharePoint Server 2019. Baer kept the details at a high level, and discussed primarily the strategic goals he...
Sep 10, 2018 | Fantasy Football, Microsoft, Microsoft Power BI, Tech Tips, Technical Information
By: Matt Wollner KICKOFF! Fantasy football season is back, and if you’ve done any research at all, you’ve probably noticed that the number of websites offering player projections is endless. You – if you’re like most people – probably have a site...
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...
Jun 5, 2018 | Microsoft, SQL Server, SSIS, Tech Tips, Technical Information
By: Andy Kim I was at the SQL Saturday Atlanta conference last week and attended a session in which the speaker asked the audience, “Has anyone here used fuzzy grouping or fuzzy lookups in SSIS?” To my surprise, I was the only one who raised their hand....
