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)
369 reads
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)
369 reads
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
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
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
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
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
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)
483 reads
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)
389 reads
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)
244 reads
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)
29 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
WA:08218154393 Jl. Jenderal Sudirman No.74, Pati Kidul, Kec. Pati, Kabupaten Pati, Jawa Tengah 59114
Comments posted to this topic are about the item SSRS Reminded Me of the...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers