Download the Power BI Architecture Diagram
Update: I’ve updated the Power BI architecture diagram! Click here to view version 2!
As a Data Platform Solution Architect for...
2016-01-06
4,620 reads
SQL with Dustin Ryan
Getting Started with R Visuals in Power BI
Thanks to the December 2015 update released for Power BI, we can now use R to visualize our data in...
2016-01-05 (first published: 2015-12-30)
4,928 reads
Sentiment Analysis & Key Phrase Detection w/ Power Query & Power BI
Recently I worked on a neat little POC with Patrick Leblanc for a customer in Education who wished to perform sentiment...
2015-12-24 (first published: 2015-12-16)
2,388 reads
Why I Joined Microsoft
If you follow me in social media, you may have seen my announcement that I’ve joined Microsoft. Late in October...
2015-12-02
610 reads
Tons of Updates to Power BI in October!
There were so many updates to Power BI this month I thought I’d put all the links to the information...
2015-10-29
1,067 reads
Tons of Updates to Power BI in October!
There were so many updates to Power BI this month I thought I’d put all the links to the information...
2015-10-29
862 reads
10 DAX Calculations for your Tabular or Power Pivot Model (Part 2)
This is part two of my 10 DAX Calculations blog series. In this series I’ve blogged ten different DAX calculations...
2015-11-02 (first published: 2015-10-21)
2,426 reads
10 DAX Calculations for your Tabular or Power Pivot Model (Part 2)
This is part two of my 10 DAX Calculations blog series. In this series I’ve blogged ten different DAX calculations...
2015-10-21
489 reads
Data Warehouse Design Challenge: Relating a Temporal Fact Table to a Date Dimension
This past week I ran into an interesting challenge with a client. The data warehouse is capturing testing data for...
2015-10-23 (first published: 2015-10-19)
2,867 reads
Data Warehouse Design Challenge: Relating a Temporal Fact Table to a Date Dimension
This past week I ran into an interesting challenge with a client. The data warehouse is capturing testing data for...
2015-10-19
484 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers