The Netbook: Upgrade to Windows 7
I’m more than 2 months into the netbook experience, and I’m happy to report that it’s still a good investment. ...
2009-09-19
607 reads
Upcoming Speaking Engagements for Q4
In the next few months, I’ll be giving a couple of talks on SQL Server business intelligence. For October, I...
2009-09-18
835 reads
SQL Server 2008 R2 August CTP – Utility Control Point (UTP)
I finally carved out some time in my day to try and get the August CTP of SQL Server 2008...
2009-09-18
1,362 reads
SQL Server High Availabilty Webinar
Always On: SQL Server High Availabilty
Just wanted to tell you all about a fantastic Webinar on SQL Server High Availability,...
2009-09-18
947 reads
Prepping for SQL Connections in Las Vegas
I started watching Leverage this season, after it was recommended by Wil Wheaton (blog/twitter). For those of you that don't...
2009-09-18
943 reads
Building a Chair – Part 2
Last week I posted Part 1 and Steve Jones gave some grief about not posting some pictures (rightfully so) of...
2009-09-17
841 reads
Fundamentals of Storage Systems - The Basics of Spinning Disks
Your servers are only as fast as the slowest part, hard drives.To feed other parts of the system we have...
2009-09-17
3,335 reads
SSMS "Connect to Database Engine" Prompt Behavior When Dragging And Dropping Files
A minor annoyance of mine for a long time has been how SSMS will sometimes prompt you to connect to...
2009-09-17
380 reads
SQL Server Job Trends on Graphs
A colleague pointed out a site that collects a lot of job posting data and exposes graphs - so I've taken...
2009-09-17
4,229 reads
Interacticely sorting columns in SQL Server 2005 Reporting Services
Business Intelligence Developers Studio (aka BIDS) for Microsoft SQL Server 2005 Reporting Services makes creating engaging and dynamic reports nearly...
2009-09-17
1,226 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