Selecting Speakers for SQL Saturday #70
The Call for Speakers for SQL Saturday #70 - Columbia, SC, ended on February 17, 2011. We wanted to put the...
2011-02-25
1,651 reads
Blog Posts
Some Suggested SQL Server 2008 R2 Instance Configuration Settings
Depending on your anticipated workload and which SQL Server components you have installed, there are a number of instance level...
2011-02-25
13,806 reads
SQLskills Immersion Event on Internals and Performance – Day 4
Overview
We just finished the fourth day of SQLskills learning. Today was all on indexes and statistics. We learned about choosing...
2011-02-25
1,396 reads
Test Complete – MCM
I took the MCM test today, and finished it. I needed the time allotted and it was, well, an experience....
2011-02-25
1,789 reads
“Apparently, you signed a software services agreement without fully understanding it.”
I am not a lawyer. Let me say that again, I am not a lawyer.
Todays Dilbert has prompted me...
2011-02-24
807 reads
Configuring Antivirus for SQL Servers
I've been on both sides of the debate with respect to whether or not to install antivirus software on a...
2011-02-24
3,388 reads
I've Got A New Job
You've probably noticed I've been quiet on this blog lately, eeking out a post every other week on average. I've...
2011-02-24
1,523 reads
PASS in Five Years: It's about the Members
Andy Warren (blog | twitter) recently blogged about wanting input on What Should PASS Be? and I think it's a reasonable...
2011-02-24
1,499 reads
SQLskills Immersion Event on Internals and Performance – Day 3
Overview
Today was mostly about Table Design, Partitioning, with a little of Indexing. Partitioning is a big, complex topics with a...
2011-02-24
477 reads
Visualize Tech Skills
Is your area of responsibility starved for resources? Is it difficult to get a raise? If so, don't despair. You're...
2011-02-24
1,821 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