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 or two that...
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 assume...
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 will display price...
Jul 11, 2018 | Amazon, Amazon MWS, Analytics, Business Intelligence, Custom Development, How To, Tech Tips, Technical Information
By: Phillip Sharpless If you sell products via Amazon and are interested in using data to improve your business, then look no further than Amazon Marketplace Web Service (MWS). Amazon MWS provides robust functionality for generating a wide variety of reports that...
Jun 26, 2018 | How To, 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 upgrade....
