My Ignite 2018 SQL PowerShell Scripts now available in GitHub
It appears that I forgot to post my SQL PowerShell Scripts from my talk at Ignite 2018 (video here). Big thanks to Tony Green ( t ) for bringing...
2019-04-27
65 reads
SQLvariant
My Ignite 2018 SQL PowerShell Scripts now available in GitHub
It appears that I forgot to post my SQL PowerShell Scripts from my talk at Ignite 2018 (video here). Big thanks to Tony Green ( t ) for bringing...
2019-04-27
14 reads
My Ignite 2018 SQL PowerShell Scripts now available in GitHub
It appears that I forgot to post my SQL PowerShell Scripts from my talk at Ignite 2018 (video here). Big thanks to Tony Green ( t ) for bringing...
2019-04-27
2 reads
What Chocolatey Packages Does a Business Intelligence Developer Need?
I’m getting a new work laptop next week: Hooray!! I’m going to have to install A LOT of software: Opportunity! Problem: I have a lot of meetings next week,...
2019-04-18 (first published: 2019-04-05)
760 reads
What Chocolatey Packages Does a Business Intelligence Developer Need?
I’m getting a new work laptop next week: Hooray!! ?? I’m going to have to install A LOT of software: Opportunity! ?? Problem: I have a lot of meetings...
2019-04-05
23 reads
What Chocolatey Packages Does a Business Intelligence Developer Need?
I’m getting a new work laptop next week: Hooray!! ?? I’m going to have to install A LOT of software: Opportunity! ?? Problem: I have a lot of meetings...
2019-04-05
4 reads
Group By Conference is Back April 11th!
I have joined forces with Blyther Morrow & Daniel Hutmacher to keep the GroupBy Virtual Conference going. We’re aiming to host the conference at least twice this year, and...
2019-04-02
111 reads
Group By Conference is Back April 11th!
I have joined forces with Blyther Morrow & Daniel Hutmacher to keep the GroupBy Virtual Conference going. We’re aiming to host the conference at least twice this year, and...
2019-04-02
5 reads
Group By Conference is Back April 11th!
I have joined forces with Blyther Morrow & Daniel Hutmacher to keep the GroupBy Virtual Conference going. We’re aiming to host the conference at least twice this year, and...
2019-04-02
5 reads
Export AdventureWorksDW2017 to Excel for a Power BI Demo with Export-Excel
Have you ever wanted to export an entire SQL Server database to Excel file? Yeah, me neither. Until yesterday, when...
2019-03-28 (first published: 2019-03-14)
624 reads
Blogs
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
ROLLUP to calculate Month total for all Categories
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()
Comments posted to this topic are about the item Level 28: DAX Text Functions:...
Creating JSON I
Comments posted to this topic are about the item Creating JSON I
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers