SQL Saturday Baton Rogue Recap
Thank you to everyone who came out and saw me present at the SQL Saturday in Baton Rogue! It was a blast to see smiling faces and not be...
2022-09-09 (first published: 2022-08-23)
118 reads
DataOnWheels
Power BI: Data Quality Checks Using Python & SQL
Picture this, you have a report in Power BI that someone passes off to you for data quality checks. There are a few ways to make sure your measures...
2022-08-03 (first published: 2022-07-26)
547 reads
Power BI: Dynamically Removing Errors From Columns in M
If you have excel data, or user-entered data, you have likely experienced frustration from repeatedly seeing the error message below upon hitting “Close & Apply” or refreshing your data...
2022-08-10 (first published: 2022-07-19)
232 reads
Typing with Your Tongue – Voice to Text Technologies
This is the second in the series of tools and technologies that I use to deal with the loss of functionality in my hands and arms. Check out this article for...
2022-07-15
39 reads
When is a mouse not a mouse?
This is the first in the series of tools and technologies that I use to deal with the loss of functionality in my hands and arms. Check out this...
2022-07-08 (first published: 2022-06-24)
334 reads
The Impact of Change
I started this summary on LinkedIn. Check out that article here. I only used LinkedIn to introduce what is happening, if you’re interested in learning more keep reading. First,...
2022-06-16
24 reads
Power BI: Calculating Network Days in M Custom Columns
Knowing the days between events is a fairly common reporting request because a lot of reporting is created to track SLA’s (service level agreement) and other KPI’s (key performance...
2022-06-17 (first published: 2022-06-03)
289 reads
Power BI Adding Dynamic Hierarchies – XMLA, TOM, C#
This post is a continuation of my adventure into the Tabular Object Model and how we can use it to make Power BI scalable and incorporate it into existing...
2022-06-06 (first published: 2022-05-12)
250 reads
Power BI: Creating an Info Button with UNICHAR()
Reports are only as useful as they are easily understandable. When making reports for executives and other business leaders, it is vital to ensure the context and insights of...
2022-05-13 (first published: 2022-05-04)
425 reads
Power BI Embedded: Stress Testing & Capacity Planning
When deciding if Power BI is the correct reporting platform to meet your business’s needs, price is a large factor. Power BI pricing models are based around SKU’s and...
2022-03-07 (first published: 2022-02-22)
478 reads
Blogs
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...
A Small LLM Fail
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
SQL Server Versions: Out With the Old, In With the Supported
By Kevin3NF
If your production SQL Servers are still running 2016 (or older) you’re basically banking...
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