Mar 15, 2019 | Analytics, Business Intelligence, Data Visualization, How To, SQL Server, Tech Tips, Technical Information
By: Andy Kim Introduction If you ask a SQL professional to name some data types, you might hear: varchar, int, datetime, decimal, or something to that effect. Rarely do people mention the spatial data types of: geography and geometry. This is because most SQL...
Mar 1, 2019 | How To, Microsoft, SharePoint, Tech Tips, Technical Information
By: Austin Gainey Are you seeing this error message when creating or using a SharePoint 2013 Web Part? If so, you’ve come to the right place. On a recent client project, a user reported this SharePoint 2013 web parts error to me after...
Jan 22, 2019 | Business Intelligence, Data Visualization, How To, Microsoft, Microsoft Power BI, Tech Tips, Technical Information
By: Mike Pierre-Louis Introduction With another year in the rearview, now is the time when companies will be reaching out to their clients and/or users to ask for feedback. Everyone knows that manually reading survey responses is so 2018 (ok, kidding,...
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...
