If you happen to be using C# there is a very easy way to set your application up to take advantage of Read-Only replicas.
Using this connection string: (Some portions...
2023-10-09 (first published: 2023-09-18)
1,729 reads
In this series of articles I will be sharing the common mistakes in SQL Server. I am certain that this is going to be very interesting read, here is...
2023-09-18
18 reads
In this series of articles I will be sharing the common mistakes in SQL Server. I am certain that this is going to be very interesting read, here is...
2023-09-18
494 reads
Today I’m presenting at DataMospit, the most metal conference in the data space! You can download the Sea of Madness bingo card from here: https://github.com/spaghettidba/CodeSamples/raw/master/SQLServerInfernals/InfernalBingo.xlsx The winner will get...
2023-09-16
77 reads
Flyway Desktop includes version control features with Git. One thing that was added in v6.5+ was the ability to commit and push. I’ve been working with Flyway Desktop for...
2023-09-15
45 reads
Once more, my apologies for being late on getting the T-SQL Tuesday announcement out. I have no excuse. However, our extended event on Extended Events (yes, I’m the third...
2023-09-15
41 reads
justing – n. the habit of telling yourself that just one tweak could solve all your problems – if only you had the right haircut, if only you found...
2023-09-15
24 reads
Running a bit late this month for T-SQL Tuesday (it’s not exactly Tuesday is it!) but that’s Grant Fritchey’s (blog|twitter) ... Continue reading
2023-10-04 (first published: 2023-09-14)
647 reads
Introducing the Fabric 5 from Data on Wheels Microsoft Fabric went to public preview this past summer. There has been content created around using the various cool features that...
2023-10-04 (first published: 2023-09-14)
341 reads
With 165 T-SQL Tuesday events, two, just two, this one, T-SQL Tuesday #166, and another one back in 2018 or 2019 (I forget and I’m far too lazy to...
2023-09-14
40 reads
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Comments posted to this topic are about the item BIT_COUNT II
Comments posted to this topic are about the item I Can't Make You Learn
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
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