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
I saw someone struggling with getting started with a Visual Studio project and Azure DevOps. They got a conflict, which I’ll show and then get you started with an...
2023-09-13
92 reads
Foreword
This month’s invitation is from Grant Fritchey (t|b), aka the Scary DBA, about Extended Events (XEs).
If you look at the Tags section of my blog, you can see that...
2023-10-06 (first published: 2023-09-13)
385 reads
I’m currently in Enterprise Architecture in my organization and as a result, I blogged earlier about putting up study notes with regards to preparing for the two TOGAF (The...
2023-09-13
31 reads
I’m doing a webinar next week with Bob Ward, a principal architect for Microsoft working on Azure and SQL Server. I’ve had the chance to work with Bob quite...
2023-09-12
59 reads
When I was put on the list to host September’s T-SQL Tuesday, well, I forgot to put it in my calendar. So I’m late (and in the doghouse with...
2023-09-11
55 reads
In this article I will share the Microsoft SQL Server Security Checklist that I have used for many of my clients to help them achieve PCI compliance. This can...
2023-09-11
278 reads
vulture shock – n. the nagging sense that no matter how many days you spend in a foreign country, you never quite manage to step foot in it –...
2023-09-08
37 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