What’s the Typical Resignation Notice Period for DBAs?
I was recently talking to a friend from the U.K about how much notice a DBA should give to their...
2009-06-24
2,007 reads
Windows 7 Issues
I went to add a few things to the new Windows 7 desktop today, and of course I have installer...
2009-06-24
790 reads
Better Know A SSIS Transform – The Sort Transform
This is part 2 of my 29 part series called Better Know A SSIS Transform. Hopefully you will find the...
2009-06-24
8,667 reads
SQL Server 2008 Encryption - Extensible Key Management
One of the new features with SQL Server 2008 is the addition of extensible key management, allowing hardware devices to...
2009-06-24
3,951 reads
Spring Cleaning
As happens occasionally I had a stack of books on my desk that needed to be put away, and as...
2009-06-23
531 reads
How to Identify Important Characteristics for a DBA Job Candidate
In the last year or so, there have been a lot of articles, blog entries,and forum posts on the kinds...
2009-06-23
3,053 reads
What Would You Like to See in a Book on Database Maintenance?
I am working on the outline of a new book I am writing, tentatively called Mastering SQL Server Database Maintenance....
2009-06-23
684 reads
Clear Ceases Operations
Saw this in email this morning, Clear has ceased operations after failing to negotiate with its senior creditor. I’ve written...
2009-06-23
630 reads
Paying for Content - SQL Server Knowledge
Someone asked me recently if I subscribed to any services to keep up with SQL Server content. Meaning did I...
2009-06-23
2,021 reads
Tips on Getting Hired – Part 5
I think the hardest part about the job search is interviewing and not being selected. You keep saying “why” with...
2009-06-22
616 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