Alexander Chigrik

I would like to offer consultation on MS-SQL by E-Mail

I am from Rostov-on-Don in Russia.I work for a firm Bis Ltd (Banking Information Systems) as a Microsoft SQL Server DBA and developer. I have more than 4 years solid experience
with version 6.5 and more than 2 years experience (since december 1998) with version 7.0.


Current Certifications:

  • Brainbench:Master MS SQL Server 6.5 Administration

  • Master MS SQL Server 6.5 Programming
  • Master MS SQL Server 7 Administration
  • Master MS SQL Server 7 Programming

All exams on Brainbench

I am in the list of 15 top experts on MS SQL under the version of experts-exchange:http://www.experts-exchange.com/jsp/qList.jsp?ta=mssql

All authors

All authors

Blogs

KDA: Echoes of Deception - Case 6

By

A cryptic message, a book cipher hidden in art provenance records, and a trail...

Capturing My Own Metrics: #SQLNewBlogger

By

A customer was trying to compare two tables and capture a state as a...

Red Flags in Your Query (T-SQL Tuesday #200)

By

When I'm looking at a query, I bet it's bad if I see... a...

Read the latest Blogs

Forums

BIT_COUNT II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item BIT_COUNT II

I Can't Make You Learn

By Steve Jones - SSC Editor

Comments posted to this topic are about the item I Can't Make You Learn

Why Your SQL Permissions Disappeared

By deepeshdhake

Comments posted to this topic are about the item Why Your SQL Permissions Disappeared

Visit the forum

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       NULL
What is returned when I run this code: 
select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 4;

See possible answers