SQL Server trace flags
Normally I’m not a big fan of using traceflags, my advice is only to use these when it is absolutely...
2011-11-22
2,362 reads
Blog Posts
SQLSaturday 97 Speaker Recap
Great Content + Great Speakers = Awesome Event
All the evaluations have been tallied, its official SQLSaturday #97 was a hit! As a...
2011-11-22
799 reads
Throne of Fire
Finally, I have completed another book. I took the opportunity while traveling to catch up on some reading. Better yet, I was able to do this while testing out...
2011-11-22
7 reads
Throne of Fire
Finally, I have completed another book. I took the opportunity while traveling to catch up on some reading. Better yet,...
2011-11-22
638 reads
17 WordPress Plug-Ins That I Use
In the past week, I’ve had a number of requests for a list of the WordPress plug-ins that I use. ...
2011-11-21
1,142 reads
Book Review: Highest Duty, My Search For What Really Matters
Highest Duty, My Search For What Really Matters by Chesley Sullenberger is the autobiography of the pilot who landed Flight...
2011-11-21
894 reads
Conformed dimensions
A conformed dimension is a dimension that has the same meaning to every fact with which it relates. Conformed dimensions allow...
2011-11-21
3,514 reads
DBA in Space: Behind the Scenes—Questions 2 & 3
Part 1 of Question 2—The question.Part 2 of Question 2—The follow up to the question.This is a continuation of my...
2011-11-21
644 reads
Installing SQL Server 2012 RC0
Very short informational post.
If you’re like me and you’ve been running the public Client Technology Preview (CTP3) of SQL Server...
2011-11-21
2,017 reads
OT: Goodbye Dad
This is a bit of ramble.
At about 2:15AM November 21st, 2011 my dad, Arthur Corbett, went home to be with...
2011-11-21
851 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
ALAMAT KANTOR BCA KCU KISARAN TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
ALAMAT BCA KCU PEMATANG SIANTAR TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
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