Making Sense of the Power BI Ecosystem Presentation Materials
I just wrapped up my first presentation on Making Sense of the Power BI Ecosystem at SQL Saturday #755 in...
2018-06-09
356 reads
SQL with Dustin Ryan
Monitoring and Tuning Azure SQL Database at SQL Saturday Jacksonville and 24 Hours of Pass
I’m speaking at two upcoming events that I wanted to share with you! My topic is Monitoring and Tuning Azure...
2018-04-20
297 reads
Converting a Power BI Desktop File from Import to Live Query
A customer of mine is in the midst of a proof of concept using SQL Server and Power BI. During...
2018-01-30
1,130 reads
2017 Year in Review for SQLDusty.com
2017 was an awesome year for SQLDusty.com! Thank you to all of the readers and visitors that stopped by to...
2018-01-29
388 reads
Creating a Knowledge Base Chat Bot w/ Azure Bot Service
A while back you may have caught my blog post introducing the Power BI Chat Bot 9000. Since posting that...
2018-01-02 (first published: 2017-12-12)
1,326 reads
Making Sense of Data Migration Assistant Assessments with Power BI
The Data Migration Assistant is a great tool developed to assess your SQL Server environment for a migration to a...
2017-12-06
966 reads
Setting Up a Drillthrough Action in your Power BI Report
At some point this weekend, the Microsoft Power BI folks turned on the drill-through feature in the Power BI service....
2017-09-03
1,638 reads
Preparing for Microsoft Certification Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI
Late last month Microsoft released the certification exam for Power BI, 70-778: Analyzing and Visualizing Data with Microsoft Power BI....
2017-08-23
1,042 reads
Power BI FAQ Chat Bot 9000 lives!
So I’ve been working on a fun little project over the past couple weeks. A lot of my customers have...
2017-08-18
503 reads
Building Your Brand and Becoming a Thought Leader Session Materials
Thank you to everyone that attending my session today at SQL Saturday #649 in Jacksonville, Florida! It was a packed...
2017-08-12
582 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers