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...
Aug 6, 2018 | Entrepreneurship, How To
By: Mike Pierre-Louis Owning or running a business can be challenging at times, but there are few things more rewarding than watching your business meet – or exceed – its aspirations and goals. We at Key2 know that feeling. And we also know the lows that come...
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....
Jun 5, 2018 | Fuzzy Logic, How To, 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. When data...
