Aug 27, 2019 | How To, Microsoft, Microsoft PowerApps, SharePoint, Technical Information
By: Austin Gainey Did you know you can utilize Microsoft PowerApps to customize out of the box SharePoint Online forms, which can then be used to take down corrupt secret government projects, destroy cars with telekinesis, and cut through the fabric of...
Jun 3, 2019 | Business Intelligence, How To, Microsoft, SQL Server
By: Paul Schuliger Over a year ago I wrote an article that discussed using the SQL Window Function ROW_NUMBER() to set up a sort order within each layer of a hierarchy, and then showed how to use that information in Power BI. I recently found...
Mar 22, 2019 | Consulting, How To, Microsoft, SQL Server, Tech Tips, Technical Information
By: Jason E. Bacani Introduction When working with SQL Server Agent, one of the many useful features is the ability to schedule SQL Agent Jobs. The frequency and scheduling of such jobs can be as fancy and as specific as needed, and can be coordinated with...
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, 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...
