Dropping Career Goals for Q2
I set goals at the beginning of 2023 for Q1. I didn’t do well, as my evaluation earlier this week has a D for my efforts. I’m re-evaluating things,...
2023-04-07
28 reads
New Job -> Week 4 -> Set Up Auditing
This is part of a series of new job blog posts. You can find them all here. The main goal for week 4: set up auditing for all Azure...
2023-04-19 (first published: 2023-04-06)
376 reads
Star Schema Merchandising Available
Those of you who follow me on social media (twitter | LinkedIn | mastadon) or who read my blog here, might be familiar with my catchphrase “STAR SCHEMA ALL...
2023-04-06
110 reads
WIT Women Speakers Survey
There is a survey from the WIT group for female speakers. If you are a woman and speak in front of groups, or used to, please fill it out....
2023-04-05
51 reads
If You Can't Clone Yourself, Be Professional
This is going to be a rant. I'm just a bit frustrated. When organizers work hard to assemble an event, and speakers submit to speak, we...
2023-04-05
2 reads
PASS Data Community Summit 2023 Registration is Open
You can register today for the 2023 PASS Data Community Summit. This year the event is in Seattle, Nov 14-17, and in-person only. The event was a lot of...
2023-04-21 (first published: 2023-04-05)
98 reads
EightKB Topics
Hello all, I’ve been speaking to various people about EightKB and there does seem to be a misunderstanding out there about the topics of submissions that we are looking...
2023-04-05
28 reads
Tales From The Field Weekly Wrap Up for the Week of 03-27-2023 & MegaCON
Zach's 1st MegaCon 2011 Hello Dear Reader! This past week is a blur. It was a tough week at work. That sentence is an understatement, but its really all I...
2023-04-04
34 reads
Goal Progress for March 2023
The grade for March is also D. Details below, but just not making a lot of progress in these areas. In fact, I find myself not motivated to work...
2023-04-03
26 reads
How Does SELECT * Affect Query Store?
I live for questions and recently, I had someone ask me, does using SELECT * affect Query Store. My immediate gut reaction was, hell no. Of course it doesn’t....
2023-04-24 (first published: 2023-04-03)
417 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