Sep 20, 2019 | Data Security, SQL Server, Web Applications, Web Development
By: Phillip Sharpless Security, as part of many projects, is all too often an afterthought. The standing up of a new system or the development of a new project can be quite rapid and dynamic. Not pausing during this process to think about security as an...
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...
Jul 24, 2018 | Application Development, Business Intelligence, 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...
Jul 11, 2018 | Amazon, Amazon MWS, Business Intelligence, Custom Development, 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 5, 2018 | 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....