Exploring Big Data: Course 1 – Microsoft Professional Orientation: Big Data

  (This is part 1 of my review of the Microsoft Professional Program in Big Data) Course #1 of 10 – Microsoft Professional Orientation: Big Data Overview: Titled as the Big Data orientation, the course does just that as it gives a great overview of several key concepts. I really liked digging into CosmosDB to…

0

My Journey into the Microsoft Professional Program in Big Data

  Exploring Big Data with the Microsoft Professional Program After the introduction of a very successful online education curriculum focusing on Data Science, Microsoft recently announced its next Microsoft Professional Program (MPP) in Big Data. I absolutely loved the Data Science program and have decided to start on the Big Data courses this week. During…

0

Compiling a XAML-based project fails in Visual Studio with FIPS enabled

Compiling a XAML-based project fails in Visual Studio in a FIPS-enabled environment with an error message stating “This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms”. Solution: This bug has been fixed in .NET 4.7.1. As of August 2017, this fix has been released as part of .NET 4.7.1 early access…

0

Power BI Desktop and “The Case of the Missing Taskbar Icon”

Power BI Desktop and “The Case of the Missing Taskbar Icon” For the past two years, I’ve installed and reinstalled Power BI Desktop builds hundreds of times on numerous machines. My typical pattern is to install the software and pin it to the taskbar. After pinning the application to the taskbar, I see the standard…

2

IP Address Mapping in Power BI

I recently assisted in troubleshooting an issue where the error logs contained several unknown IP addresses. During this process, I created a quick dashboard in Power BI to display the location of these IP addresses on a map to get a better understanding of where the machines were located. I used a free service from…

3

Troubleshooting SCCM Database Replication Service (DRS)

Problem: SCCM Database Replication Service is not working Solution: Service Broker had been disabled on MSDB, causing SCCM DRM to fail I was recently called in to assist with a large System Center Configuration Manager (SCCM) environment where the Database Replication Service (DRS) was not processing messages. As a SQL Server engineer, I’ve supported customer…

0

SQL Nexus 2017 Conference Recap

SQL Nexus 2017 – Conference Recap   Nearly 500 Microsoft data professionals attended SQL Nexus 2017 this week in Copenhagen, Denmark, with specialized tracks covering data platform, business intelligence, application and DB development, database administration, AI/data science, and IoT. I was honored to attend this year for the second time as a speaker for two…

0

Tracking LinkedIn and Twitter social media shares in Power BI

How to: Retrieve Twitter & LinkedIn share totals for a list of URLs in Power BI / Power Query / M If you have a Power BI or Power Query report that contains a list of URLs, the following M functions can be used to add the number of times the URL has been shared…

2

Adding a Continent Slicer to Power BI Reports

HOW TO: Adding a Continent Slicer to Power BI Reports After building Power BI reports for many customers over the past couple years, one thing is certain – people love maps. Nearly every organization I support operates at a global scale, with offices (or business) spanning the world. I’ve recently starting using this small trick…

0

Power BI Desktop – Terms and Definitions

Power BI Desktop – Terms and Definitions The following list of Power BI Desktop terms and definitions are intended to help users better understand the terminology used within the product and referenced in documentation and blogs. As I work on customer sites to teach, develop, and evangelize Power BI, I’ve been asked often for a…

4