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,417 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,316 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,884 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,247 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
660 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
561 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
915 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,931 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,026 reads
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
WITH clause gets a 26ai boost!
By way of background, a while back I did video called “My New Favourite...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
Question of the Day
Getting the Average
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers