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...
Jun 24, 2019 | Business Intelligence, Compression, How To, SQL Server
By: Ken Adams Not Enough Space On my current engagement, we are trying to build a reporting platform that meets the needs of our client while simultaneously adhering to best practices. One of the best practices we’ve established as part of the platform is...
Jun 18, 2019 | How To, Microsoft Power BI, PowerShell
By: Mike Pierre-Louis Microsoft has made Power BI even more powerful with its latest round of updates. Whether you are an admin or a user, the software’s new benefits are for everyone to enjoy. One of the main hurdles Power BI users had to overcome...
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...
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...
