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,915 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,291 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
783 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
811 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
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Killing Explicit Sort Steps in Redshift with the Right SORTKEY
You paste a slow Redshift query plan into PlanTrace and one of the tuning...
AI Experiments: Parsing Payment Memos
By Steve Jones
As part of my running the SQL Saturday charitable foundation, I get sponsorship money...
Forums
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Calculating the Harmonic Mean in Power BI
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers