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,674 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,655 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,914 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,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,267 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
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
781 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,824 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
853 reads
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
We Are Eating Our Own Seed Corn
Comments posted to this topic are about the item We Are Eating Our Own...
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers