Jan 7, 2019 | Business Intelligence, Consulting, Data Warehousing, Key2 Stories, Tech Tips
By: Paul Schuliger Happy New Year to you! And welcome back to the working world. We hope that you are feeling reinvigorated after some much-needed rest and relaxation. Making resolutions at the start of a New Year is a tradition that spans many cultures....
Nov 27, 2018 | Analytics, Business Intelligence, How To, Microsoft, SQL Server, Tech Tips, Technical Information
By: Jeff Levy SQL Server 2019 – Key Features At the 2018 Pass Summit conference in Seattle, I had the opportunity to attend many sessions about the new Big Data features being introduced in SQL Server 2019. One of Microsoft’s biggest announcements...
Nov 12, 2018 | PowerShell, SQL Server, Tech Tips, Technical Information
By: Mason Prewett This article is Part 2 of our previous Key2 article, How to Execute and Store Transact-SQL (T-SQL) Query Results in a PowerShell Array. In this article, I will cover: Getting a SQL Server result set from a stored procedure The stored procedure has a...
Sep 10, 2018 | Analytics, Fantasy Football, How To, 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, How To, 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...
Jul 24, 2018 | Analytics, Application Development, Business Intelligence, How To, Tech Tips
By: Jeff Levy Introduction In today’s world, REST APIs are a common way to exchange data across IT systems. This article will demonstrate how to view a sample REST API response from Uber, the peer-to-peer ride-sharing company. The API response...
