Creating a SQL Stored Procedure to Load a SCD2
This is a blog that I am writing for future me and hopefully it’ll help a few of you save some time too! It’s not often that I get...
2026-06-24 (first published: 2026-06-11)
386 reads
DataOnWheels
The end of an era – why I chose not to renew my MVP
Two years ago, two things happened within a few days of each other. I retired from 3Cloud going on full time disability due to ALS, and I was awarded...
2026-05-26
44 reads
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
Thanks to everyone who joined the blog party this month. I noticed three themes in the responses. Every response had one or more of these themes woven into their...
2026-04-17
17 reads
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new to this blog party, I encourage you to check out the rules. If you are...
2026-04-07
30 reads
T-SQL Tuesday #196 – Two risky career decisions I made
The T-SQL Tuesday topic this month comes James Serra. What career risks have you taken? I started my career as a preacher and ended it as a director in...
2026-03-20 (first published: 2026-03-10)
395 reads
Ramblings about data communities and your contributions, no excuses
I have been active in the data community throughout my career. I have met people and made friends in the process. As I look back on it, I am...
2026-02-26
20 reads
SQL, MDX, DAX – the languages of data
Ramblings of a retired data architect Let me start by saying that I have been working with data for over thirty years. I think that just means I am...
2026-01-23 (first published: 2026-01-12)
484 reads
T-SQL Tuesday #193 – Notes to my past self and from my future self
It has been a while since my last T-SQL Tuesday blog. When I saw Mike Walsh’s topic for T-SQL Tuesday #193, I was intrigued and inspired – “Notes to...
2025-12-24 (first published: 2025-12-09)
245 reads
Power BI, Excel, OneLake – Dreams Do Come True!
I can’t believe it’s finally here! A way to have Excel live in OneDrive and access it from Power BI nearly live! We can officially short cut files to...
2025-12-26 (first published: 2025-12-05)
390 reads
Managing subscribers, creating newsletters
When I created the website on WordPress, I was expecting all the features I had on our WordPress.com which powers this website. As I called out in my previous...
2025-11-21 (first published: 2025-11-20)
31 reads
Blogs
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Forums
whats that ssis analyzer product that documents lineage
hi, a few years ago was at a very large company that bought a...
Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
BIT_COUNT() III
Comments posted to this topic are about the item BIT_COUNT() III
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers