How-To Convert Excel Date & Time to SQL
Hey data friends! This one comes from my personal vault (aka backlog of drafts I’ve been needing to write up) and is a really simple code that I always...
2025-02-14 (first published: 2025-01-28)
1,319 reads
Hey data friends! This one comes from my personal vault (aka backlog of drafts I’ve been needing to write up) and is a really simple code that I always...
2025-02-14 (first published: 2025-01-28)
1,319 reads
Hey data friends! This blog is to discuss an edge case I’ve run into in Microsoft Fabric. I won’t go into all the context, but the goal was to...
2025-02-03 (first published: 2025-01-21)
2,422 reads
Wow I am so late in posting these notes! But this conference was amazing, so figured still good to post my notes from the incredible sessions I attended! Hope...
2025-01-14
29 reads
I was asked to review the following book by the publisher, and I must say that it was a good experience for me. I used the book to help...
2024-07-22
23 reads
DIVERSIFY! We devote a lot of time to mastering the technology that we are passionate about or use for our jobs. For example, I specialized in Microsoft business intelligence,...
2024-07-02
96 reads
As of June 1, I am no longer an employee at 3Cloud. I am now officially on long term disability. This marks the first time since I graduated from...
2024-06-20
30 reads
Ever since Excel made its debut in the 1980’s, it has been used as a quick way for end users to input and manipulate data on their own without...
2024-06-03 (first published: 2024-05-14)
389 reads
Picture this, your data ingestion team has created a table that has the sales for each month year split into different columns. At first glance, you may think “what’s...
2024-05-27 (first published: 2024-05-10)
701 reads
Hey there happy coders! Last weekend I had the pleasure of speaking at the SQL Saturday Atlanta event in Georgia! It was an awesome time of seeing data friends...
2024-04-30
35 reads
Over the past couple of months, I have started losing my ability to talk without a mask. One of the effects of a disease, ALS, is that I am...
2024-04-19
32 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 Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571
WA:08218154393 Jl. Maluku No.10, Dauh Puri, Kec. Denpasar Bar., Kota Denpasar, Bali 80119
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
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