Tracking S&P 500 Using Power BI
S&P 500 index is an American stock market index consisting of 500 large companies and is considered to be the...
2015-08-17
2,669 reads
Samuel Vanga
Replace Blank Values to NULL in SSIS
Blank values are annoying, anywhere and everywhere. If your source system contains them, here’s how to convert blank values to NULL in...
2015-08-11
15,599 reads
Iterate Over Web Pages Using Power Query
Power Query makes it easy to pull data from a web page. As easy as deflating a football. Poof. Gone. However,...
2015-08-10 (first published: 2015-08-05)
3,910 reads
Baltimore Crime Report Using Power BI
As part of my quest for using data to find answers to everyday questions using Power BI – after analyzing baby names...
2015-08-06 (first published: 2015-07-27)
3,183 reads
Community Reactions to Power BI General Availability
Power BI is released to the public on Friday, 07/24. There’re both free and Pro versions. For full details about...
2015-08-03 (first published: 2015-07-26)
2,000 reads
Include File Name in Content Using Power Query
When importing data from a flat file using Power Query, you’d want to combine multiple files and include file name...
2015-07-28 (first published: 2015-07-21)
27,130 reads
Are People’s Food Habits Changing? A Power BI Analysis
A few years ago on road trips I’d happily grab whatever I can find to eat at service stations. That...
2015-07-14 (first published: 2015-07-07)
2,609 reads
Automating SSIS Design Pattern: Load Flat File Into Staging Table
Delimited flat files are commonly used to move data from one system to the other.
In this two part series published...
2015-07-14
780 reads
Automating SSIS Design Pattern - Stage Delimited Flat File
How long does it take to create to 100 staging packages? The answer will shock you!
2015-07-13
9,814 reads
I’m on WOxPod! Podcast
A few weeks ago, while at SQL Saturday Philadelphia, Chris Bell, SQL Server MVP and co-leader of PASS DC user group graciously...
2015-06-29
852 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
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...
Forums
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
ROLLUP to calculate Month total for all Categories
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
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