In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential for revealing insights buried within extensive databases. However, basic SQL queries can only take you...
2024-10-07
40 reads
Thanks to everyone that came to my talks. Slides are below. Best Practices for Seamless Deployments Balance in Life with a Career If you have questions, please reach out.
2024-10-05
5 reads
Thanks to everyone that came to my talks. Slides are below. Best Practices for Seamless Deployments Balance in Life with a Career If you have questions, please reach out.
2024-10-06 (first published: 2024-10-05)
27 reads
I can’t remember how I heard about Small Data SF 2024, but it caught my eye. The mix of sessions had me interested in going, especially with Mother Duck...
2024-10-04
9 reads
I can’t remember how I heard about Small Data SF 2024, but it caught my eye. The mix of sessions had me interested in going, especially with Mother Duck...
2024-10-04
65 reads
moledro – n. a feeling of resonant connection with an author or artist you’ll never meet, who many have lived centuries ago and thousands of miles away but can...
2024-10-04
7 reads
moledro – n. a feeling of resonant connection with an author or artist you’ll never meet, who many have lived centuries ago and thousands of miles away but can...
2024-10-04
190 reads
Let’s go back to data platforms today and I want to talk about a very common integration I see nowadays, Azure Blob Storage linked to Snowflake via a storage...
2024-10-18 (first published: 2024-10-04)
170 reads
I don’t do a lot of work with disabled index, but I learned how to re-enable one today, which was a surprise to me. This short post covers how...
2024-10-02
16 reads
I don’t do a lot of work with disabled index, but I learned how to re-enable one today, which was a surprise to me. This short post covers how...
2024-10-18 (first published: 2024-10-02)
276 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...
Comments posted to this topic are about the item SSRS Reminded Me of the...
I have a need to execute a stored procedure and return the results to...
Title pretty much says it all - can this be done? I've tried several...
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