Nov 12, 2018 | SQL Server
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 | 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...
