The nice people from Packt Publishing sent me a digital copy of Benjamin Nevarez new book to review: SQL Server Query Tuning and Optimization – Optimize Microsoft SQL Server...
2022-12-26 (first published: 2022-12-02)
335 reads
Today’s coping tip is to discover your artistic side. Design a friendly greeting card. A fun one for me today. I saw this just after returning from the PASS...
2022-12-01
16 reads
So, we made it through our first 90 days, things start getting tougher now as now we really got to start looking at getting projects
The post New Database Job...
2022-12-19 (first published: 2022-12-01)
301 reads
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I ... Continue reading
2022-12-19 (first published: 2022-12-01)
460 reads
At the PASS Summit a few weeks ago, I had a great chat with some folks about our home office setups. More and more of us are working from...
2022-12-16 (first published: 2022-12-01)
300 reads
I previously blogged about how to create a STONITH resource for a pacemaker cluster in VMWare virtual machines. Ok, I have a confession…you need to specify credentials when creating...
2022-12-16 (first published: 2022-12-01)
113 reads
Foreword
Have you ever wondered where the .xel file is saved when you create a new Extended Event session and don’t specify the full path (just the file name)?
Like so:
Well,...
2022-12-14 (first published: 2022-11-30)
187 reads
Another neat little feature in SQL Server 2022 is Query Store Hints. This is the ability to apply a query hint through Query Store rather than having to modify...
2022-11-30
76 reads
Today’s coping tip is to learn a new skill from a friend or share one of yours with them. I like learning, so in this case, I took advantage...
2022-11-30
12 reads
Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we hear news of large companies that have had data stolen with both financial and reputational...
2022-12-14 (first published: 2022-11-30)
386 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