Jul 8, 2019 | Data Security, Microsoft Power BI, Technical Information
By: Matt Wollner What is Row Level Security (RLS) in Power BI? Row Level Security (RLS) can be setup in Power BI to restrict data access based on the logged in. For example, perhaps you have multiple sales teams and you want each team to see sales data...
Apr 30, 2019 | Big Data, Business Intelligence, Data Warehousing, Tech Tips, Technical Information
By: Jeff Levy Hadoop Distributed File System Overview This step-by-step tutorial will walk you through how to install Hadoop on a Linux Virtual Machine on Windows 10. Even though you can install Hadoop directly on Windows, I am opting to install Hadoop...
Apr 10, 2019 | Business Intelligence, Data Visualization, PowerShell, Tech Tips, Technical Information
By: Mason Prewett Introduction As an admin of many server types, I often encounter the issue of a machine running out of disk space. Tracking the culprit folder that was hogging up disk space used to be a troublesome, manual effort. However, I recently coded a...
Mar 22, 2019 | Consulting, 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 15, 2019 | Business Intelligence, Data Visualization, 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 | 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...