Log Buffer #22: A Carnival of the Vanities for DBAs
Welcome to the 22nd edition of Log Buffer, a
weekly compendium of postings and news from database-related blogs across the...
2006-12-08
1,599 reads
Inserting missing rows
I can think of three ways to insert just the missing rows from one table or query into another table. ...
2006-12-06
3,052 reads
Extreme Work
"The Productivity Pro" Laura Stack posted in her blog today about jobs where long hours are the norm:
'Extreme' jobs...
2006-12-05
1,485 reads
Guidance on Microsoft Certified Architect Submissions
For those considering the Microsoft Certified Architect program, some guidance on what to submit as documentation has been posted to...
2006-12-05
1,459 reads
Bad weather and Power Outage
After years of mild weather in the St. Louis area, this is the second time we have been hit hard...
2006-12-02
1,336 reads
Professional Association of SQL Server - Midlands Chapter First Meeting
If you are in South Carolina or a nearby location (Charlotte, Augusta, etc.) and are interested in participating in an...
2006-12-01
1,581 reads
TechEd 2007 tracks announced
The Microsoft TechEd tracks have been released early here:
Sneak Peak at the 2007 Tracks
For those who are interested in attending...
2006-12-01
1,492 reads
Excellent post on encryption
Laurentiu Cristofor has an excellent blog post, Who needs encryption?, which presents some point blank facts about encryption and the...
2006-12-01
1,653 reads
Data Dude
I went to an abbreviated version of the Visual Studio 2005 Team Edition for Database Professionals launch this morning. The...
2006-11-30
1,586 reads
Microsoft Network Monitor 3.0 Released
If you aren't familiar with Network Monitor, it's a packet sniffer that's a Windows component on the server builds (Control...
2006-11-29
1,604 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