Connector Editorial for July 1, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-06-30
1,517 reads
Querying the Procedural Cache on Canada Day (July 1st)
The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources...
2009-06-30
2,444 reads
SSIS - Creating a Deployment Manifest
Using a Deployment Manifest in SSIS allows you to deploy a set of packages to a target location using a...
2009-06-30
42,031 reads
Unwired for Days
Today is the first day that I've really had any significant time on the computer over vacation. That probably sounds...
2009-06-30
1,380 reads
Tracking My Goals – Half the Year
I made a series of resolutions in January related to SQLServerCentral. These are things that I wanted to accomplish this...
2009-06-30
1,728 reads
Featured Blog: Jeremiah Peschka
I met Jeremiah at the PASS Summit last year and since then I’ve looked in on his blog from time...
2009-06-29
1,697 reads
Best Thing I Learned at PASS
At the 2003 PASS Summit in Seattle the organization had a "SIG Challenge" that involved developing a database solution to...
2009-06-29
1,369 reads
SQL Saturday #17 - Abstract Submitted
I was asked to attend SQLSaturday #17 in Baton Rouge, LA. Despite my lack of desire to travel, I've never...
2009-06-29
1,518 reads
LinkedIn Groups
I’ve written a few posts now about LinkedIn, and for now still find it be the best fit for me...
2009-06-28
1,557 reads
SQLPSX Release 1.6
I completed Release 1.6 of SQLPSX which adds support for SQL Authentication and addresses several issues. SQLPSX consists of 106 functions,...
2009-06-28
1,613 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