SQL Deep Dives 2 on the Kindle
Since Deep Dives 2 came out, I had been putting off getting my copy of the e-book until I wanted...
2011-11-23
787 reads
Blog Posts
SQL Server Magazine's Top 10 Blogger....#3
So, it seems that I have been selected by the 2011 SQL Server Community Choice Awards, as among the Top 10...
2011-11-23
1,381 reads
The Mute the Phone Office Prank
The client I work with as a lot of conference rooms, all with the standard Polycom conference phone that works...
2011-11-23
668 reads
DBA in Space: Behind the Scenes—Question 4
This is a continuation of my DBA in Space journal.
With each episode, DBA in Space becomes goofier and goofier. Episode...
2011-11-22
542 reads
Download SQL Server 2008 SP3 CU2
MS has recently released SQL Server 2008 Service Pack 3 Cumulative Update 2 Released? which has fixes reported after SQL...
2011-11-22
963 reads
Monitoring a Rollback and sys.dm_exec_requests
The dynamic management view (DMV) sys.dm_exec_requests returns information about each request that is executing within SQL Server.
Instead of using Activity...
2011-11-22
1,477 reads
Optimizing Backup Performance
If your environment is anything like mine, backups are usually not allocated the speediest disk. Generally speaking, those disks are...
2011-11-22
1,740 reads
Review: Gamma Seal Lids
Last weekend I needed to go to Home Depot to get a five gallon bucket and a lid so we...
2011-11-22
709 reads
SQL Server 2008 Service Pack 2 Cumulative Update 7 Released
Microsoft has released SQL Server 2008 Service Pack 2 Cumulative Update 7, which is Build 10.00.4323.00. I count 18 fixes...
2011-11-22
1,830 reads
SQL Server 2008 Service Pack 3 Cumulative Update 2 Released
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 2, which is Build 10.00.5768.00. I count only 3...
2011-11-22
1,794 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