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 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...
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...
