Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

29 January
2018
Author: SteveHughes

Power BI Data Security – Sharing

Microsoft recently added more sharing capabilities that may change my view on sharing within the enterprise. As with all things Power BI, change is inevitable. Up to this point, I recommended that customers did not use sharing as an enterprise solution due to the inability to manage it and the...
24 January
2018
Author: Robert Cain

Azure PowerShell PlaybooK: Azure SQL–Now on Pluralsight!

My latest course is now available on Pluralsight! It’s the Azure PowerShell Playbook: Azure SQL. If you aren’t familiar with Pluralsight’s Playbook format, they are fast past courses that are almost 100% demo driven. They are meant to be consumed quickly, my course is just one hour and four...
22 January
2018
Author: Robert Cain

Mobile Report Publisher–Dashboards Everywhere

My latest article on RedGate’s SimpleTalk site has just come out: Mobile Report Publisher – Dashboards Everywhere. In it, I give a quick overview of using SQL Server 2016’s Mobile Report Publisher to create a simple but useful dashboard. Mobile Report dashboards can be assembled easily, and...
14 January
2018
Author: AlanFaulkner

Exposure Data Audit – Locating Personally Identifiable Information (PII) in SQL Server

Introduction As a BI Architect/Developer, it may become necessary to conduct an Exposure Data Audit to uncover Personally Identifiable Information (PII)-related data within your SQL Server 2016 environment.  The objective is to uncover any potential data security exposure risks in a continued...
08 January
2018
Author: Anil
Anil

Happy and excited to be a Program committee member for DATA and BI Summit 2018.

Happy and excited to be a Program committee member for DATA and BI Summit 2018 in Visualize Track focusing on Building and Designing Dashboards and Reports. Thanks to the DATA and BI Summit 2018 Program committee team for giving me an opportunity to work as a Volunteer Program...
02 January
2018
Author: Robert Cain

Opening Port 80 in Windows Firewall to Support Calling SSRS From Another Computer

Recently I was working on another article for RedGate’s SimpleTalk site. As part of it, I had SSRS installed on a Windows 10 computer, and needed to connect to it from another computer. I was having a lot of issues connecting, until I remembered SSRS connects using Port 80, and by default Windows...
26 December
2017
Author: Anil
Anil

SQL Saturday #692 Conference and Nepal Power BI User Group Meetup a big success.

Last Saturday, we conducted SQL Saturday #692 conference and Nepal Power BI User Group Meetup Event in Kathmandu, Nepal successfully on 23rd Dec, 2017. SQLSaturday#692 conference and Nepal Power BI User Group Meetup Event is free event for a Microsoft Data Platform professionals and those...
22 December
2017
Author: Robert Cain

Introduction to DW/BI–My Newest Old Course at Pluralsight

Way back in November of 2010, I published my second course with Pluralsight, Introduction to Data Warehousing and Business Intelligence. Over that time a lot has transpired. While the basic fundamentals haven’t changed, a lot of technology has. In addition, Microsoft’s WideWorldImporters sample...
19 December
2017
Author: Robert Cain

iTunes 12.7.2.60 Won’t Recognize iPad/iPhone after upgrade on Windows 10

I recently installed iTunes 12.7.2.60 on Windows 10; after the installation it would no longer recognize my iPad Pros (either one of them). The iPad would ask if I wanted to grant access to photos, etc., but iTunes itself would never show the iPad as being connected. Prior to the upgrade I had no...
18 December
2017
Author: Robert Cain

Adults Only Minecraft for Suicide Prevention

For some time now I’ve been working with a group of Minecrafters to raise money for the American Foundation for Suicide Prevention. So far we’ve raised over $3,400 dollars toward our year end goal of $3,650, so I’m writing to ask your help toward our goal. Anything you could give at ...