Power BI Architecture Diagram v2 is Now Available
I finally finished putting together version 2 of my Power BI architecture diagram. I previously put together an architecture diagram...
2016-06-18
975 reads
SQL with Dustin Ryan
What’s New in Reporting Services 2016
Today I had the pleasure of presenting to the Higher Ed Data Warehousing and BI Group. We discussed the long...
2016-06-21 (first published: 2016-06-14)
5,416 reads
Power BI Desktop May 2016 Update Info: Conditional Formatting and Quick Calc
*Update: The Power BI team has finally published a blog post with all the new features and its glorious! Read...
2016-05-31
1,314 reads
10 SQL Server Data Warehouse Design Best Practices to Follow (Part 1 )
This past Saturday I had the pleasure of speaking at SQL Saturday #552 here in beautiful Jacksonville, Florida. My good...
2016-05-24 (first published: 2016-05-16)
6,883 reads
Power BI and the Bing Maps API
This week I was working on a project for a school up North. This customer wanted to use Power BI...
2016-05-10 (first published: 2016-04-26)
4,189 reads
How to Use Data to Improve Student Outcomes with Microsoft Power BI
Almost fives months ago I joined Microsoft as a Data Platform Solutions Architect. As a DPSA for Microsoft, I am...
2016-04-01
659 reads
What’s New in Power BI Webinar Recording is Available
Thank you to everyone that attended my webinar with the PASS Excel BI Virtual Chapter today! I’d also like to...
2016-03-25
560 reads
View Getting Started with Power BI and Time Calculations with Dustin Ryan is Now Available!
Earlier today I had the pleasure of speaking with the PASS Business Intelligence Virtual Chapter on getting started with Power...
2016-02-09
911 reads
Power BI Publish to Web for Anonymous Access is Here
Earlier this week on Wednesday the Microsoft Power BI made an incredibly exciting announcement and released Power BI “publish to web”...
2016-02-05
1,928 reads
Microsoft & R Programming Session Materials & Resources Available
Last Thursday night I had the pleasure of speaking with Gregory Kramer and his friends at the Madison, WI Power...
2016-01-26
1,023 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers