Using Context To Traverse Hierarchies In DAX
My friend and coworker Melissa Coates (aka @sqlchick) messaged me the other day to see if I could help with a...
2016-07-28
796 reads
Data Savvy
BimlScript – Get to Know Your Control Nuggets
This is post #2 of my BimlScript – Get to Know Your Code Nuggets series. To learn about text nuggets, see my...
2016-07-01
462 reads
BimlScript – Get to Know Your Code Nuggets
In BimlScript, we embed nuggets of C# or VB code into our Biml (XML) in order to replace variables and...
2016-06-30
936 reads
Colorblind Awareness and Power BI KPIs
Update: The ability to change the color of a KPI was delivered in August 2016!
Color blindness, or color vision deficiency (CVD)...
2016-04-23
583 reads
Trekking through the DAX Jungle In Search of Lost Customers
I like to think I’m proficient at writing DAX and building SSAS tabular models. I enjoy a good challenge and...
2016-03-01
454 reads
Creating a Matrix in Power BI With Multiple Values on Rows
This week I was asked to create a matrix in a Power BI report that looks like this:
Matrix with Values on...
2016-01-09
1,291 reads
Using a Variable to Populate the Query in a Lookup in SSIS
I encountered a situation on my last SSIS project in which I needed to be able to populate the query in lookup...
2015-12-29
816 reads
Type 6 or Hybrid Type 2 Slowly Changing Dimension with Biml
In my previous post, I provided the design pattern and Biml for a pure Type 2 Slowly Changing Dimension (SCD). When...
2015-12-27
602 reads
Demystifying the Type 2 Slowly Changing Dimension with Biml
Most data warehouses have at least a couple of Type 2 Slowly Changing Dimensions. We use them to keep history...
2015-12-21
865 reads
Blogs
A New Word: Foilsick
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Accelerated Database Recovery for tempdb in SQL Server 2025
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
Measuring What Matters: Operationalizing Data Trust for CDOs
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
ETL Framework In Production
Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through...
SQL Server Ghosts
Comments posted to this topic are about the item SQL Server Ghosts