Jul 18, 2019 | How To, PowerShell, System Administration, Technical Information
By: Matt Wisor PowerShell to the Rescue Carrying out server maintenance on a regular basis can be challenging, especially if users are working in the application being serviced. Applying a Visual Studio update, for example, may corrupt the application if...
Jul 8, 2019 | Data Security, How To, 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, How To, 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, How To, 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, 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 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...
