January OPASS Meeting Recap
On January 20th OPASS was pleased to have had Kevin Kline (Blog|Twitter) from our sponsor, Quest, present 10 Things Every...
2011-02-04
862 reads
Blog Posts
Setting the Standard with Personal Appearance
Cross-posted from the Goal Keeping DBA blog:
Personal appearance matters. We all know this. Yet a lot of times we don’t...
2011-02-04
1,142 reads
Importing and Exporting SSIS Packages Using PowerShell
SQL Server PowerShell Extensions (SQLPSX) includes a set of function for working with SSIS which among other things allow you...
2011-02-03
11,114 reads
Is the new 4k sector hard drives a blessing or is it going to be the next best thing after Internet?
I read on lots of websites that the new hard drives will be moving to 4K sectors instead of the...
2011-02-03
1,745 reads
PASS Update #52 (ERC)
We’re doing weekly calls for the ERC (election review committee) and we seem to be making some progress. This past...
2011-02-03
659 reads
Poll Reveals DBAs Actively Tune TEMPDB
When I manage a SQL Server instance, I always make an extra effort to optimize the performance of TEMPDB, so...
2011-02-03
714 reads
SQL Saturday #63 Dallas Needs YOU
Dallas’ first SQL Saturday ”was full of nothing but smooth, rich #awesomesauce.” And we had Italian gelato.
Dallas’ second SQL Saturday (BI edition) ”had over...
2011-02-03
473 reads
SQL Saturday Advice–Upload Decks Early
One of the neat features for the SQL Saturday site is that it allows the speakers to upload a deck...
2011-02-03
1,418 reads
SQL University: State of the Union
The new SQL University Logo
Well the new year is here and SQL University is back and better than ever! I...
2011-02-03
648 reads
The Many Faces of SQL Server
Well, one of my goals this year was to focus on branding myself a little more. So I decided to...
2011-02-03
453 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