Daily Coping 26 Oct 2022
Today’s coping tip is to recognize that you have a choice in what to prioritize A good one for me, especially as I’m a little stressed and overloaded with...
2022-10-26
18 reads
The SQL Server Central Casino Party #SeattleSummitMoments
Redgate started a new marketing thing and I like it. They’re asking for memories of attending the Summit in Seattle. I’ve been lucky enough to go to many of...
2022-11-07 (first published: 2022-10-25)
904 reads
Daily Coping 25 Oct 2022
Today’s coping tip is to share a helpful quote, picture, or video with a friend. I usually enjoy sharing quotes with friends on their birthdays. Those of you who...
2022-10-25
19 reads
What can you do with a SELECT statement without a FROM clause?
Some people have shower thoughts, I have 1am thoughts. In this case it was the only keyword required in a ... Continue reading
2022-11-07 (first published: 2022-10-25)
673 reads
Tales From The Field Weekly Wrap Up for the Week of 10-17-2022
Hello Dear Reader! I hope you had a fantastic weekend. This weekend we celebrated my parents 50th wedding anniversary, my oldest daughter flew into town for an early birthday,...
2022-11-02 (first published: 2022-10-24)
125 reads
Getting Help Online
I spend a lot of time in the forums on various web sites, trying to assist people with getting help online. It’s shocking how hard they make it. Let’s...
2022-11-02 (first published: 2022-10-24)
150 reads
Daily Coping 24 Oct 2022
Today’s coping tip is to find joy in tackling something that you have put off. I on not a bad procrastinator, but I do put plenty of things off....
2022-10-24
14 reads
From Manual to DevOps at the Data Community Summit
This year the annual PASS Data Community Summit is hybrid, both in-person and virtual. It’s exciting to have this coming back and I look forward to seeing people in...
2022-11-04 (first published: 2022-10-21)
121 reads
Daily Coping 21 Oct 2022
Today’s coping tip is to do something constructive to improve a difficult situation. My life is amazing, but there are certainly some difficult times. Sometimes at work, sometimes at...
2022-10-21
18 reads
Presenting at DeveloperWeek Global!
I'm excited to be presenting my talk on Building a complete API in Azure
2022-10-21 (first published: 2022-10-20)
25 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
I Can't Make You Learn
Comments posted to this topic are about the item I Can't Make You Learn
Why Your SQL Permissions Disappeared
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
Question of the Day
BIT_COUNT II
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