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...
Feb 7, 2019 | Analytics, Business Intelligence, Data Visualization, How To, Microsoft, Microsoft Power BI, Tech Tips
By: Matt Wollner Power BI Desktop has been on a roll with monthly updates making it easier for users to get insight out of their data. Drag and drop visualizations are making it easier than ever to craft simple, complete dashboards. The highlighting...
Jan 28, 2019 | Custom Development, How To, JSON, Key2 Stories, Microsoft, SQL Server, SSIS, Tech Tips
By: Ken Adams JSON is a file format that has become more common for database professionals to encounter. Over the years, we have become accustomed to delimited text files, fixed length text files, Excel (I threw up in my mouth a little bit), and just as we got...
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...
