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,917 reads
Sam Vanga
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,187 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,002 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,295 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
786 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,611 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
854 reads
Analyzing Baby Names using Power BI
Me and my wife are contemplating names for our first baby we’re expecting in a couple of months! We don’t...
2015-06-16
812 reads
Team-based Database Development: Playing Nice With Others
Here are the slides and links to awesome resources for my presentation, “Team-based Database Development: Playing Nice With Others”
If you...
2014-04-29
2,650 reads
Read Flat File Contents to Variable – Write Variable Value to Flat File
When working with SSIS, you’ll often find the need to read the contents of a flat file to a variable,...
2014-04-22 (first published: 2014-04-08)
7,577 reads
Blogs
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers