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,418 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,884 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,338 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
595 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,057 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
839 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,403 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
469 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,845 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
416 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers