SQL University: Home-Grown, with Real Options!
There's the light, as this is the last class for Security week at SQL University. From the scenarios we specified...
2011-02-11
1,612 reads
There's the light, as this is the last class for Security week at SQL University. From the scenarios we specified...
2011-02-11
1,612 reads
Last night’s Oregon SQL user
group meeting was very enlightening. Mark Simms form the SQLCAT team came
down from Redmond to talk...
2011-02-11
1,089 reads
I was looking for a static list of all the T-SQL Tuesday topics and couldn’t find one. The domain moves...
2011-02-11
899 reads
Last week, I asked the Twitter hive-mind about its favorite tech companies: “Which SQL (or SQL-adjacent) tech companies are doing...
2011-02-11
509 reads
One Windows setting that I think is extremely important for SQL Server usage is the “Perform volume maintenance tasks” right,...
2011-02-11
1,785 reads
31 Days of SSIS
Last month, I published the 31 Days of SSIS blog series. As a conclusion to that series,...
2011-02-10
782 reads
One of the things I enjoy about work is seeing the various cultures that evolve. Some companies are rigid, some...
2011-02-10
1,365 reads
This next week I’m launching a series of posts centered around how you could be a part of the leading...
2011-02-10
618 reads
I received notification earlier this week that my session “ETL Head-To-Head: T-SQL vs. SSIS” was selected by community vote for...
2011-02-10
569 reads
First and foremost, I would like to send a sincere thank you to everyone who voted for my Reporting Services...
2011-02-10
591 reads
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
Comments posted to this topic are about the item 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