"Wet" Pet Food Recall
Animals are near and dear to my heart, to the point where I have a cat even though I am...
2007-03-17
1,352 reads
Windows Mobile Security
I'm working on a new article for SQL Server Central talking about physical security and SQL Server and I was...
2007-03-17
1,366 reads
The Great Migration
We migrated to a new set of servers tonight. Actually am for the Red Gate folks and a late, 11pm-2am...
2007-03-17
1,461 reads
SQL Server 2005 SP2 and Maintenance Plans - Still not fixed yet
SQL Server MVP Aaron Bertrand has posted that there is still a bug with maintenance plans for SQL Server 2005...
2007-03-15
1,450 reads
New Version of ApexSQL Doc (2005.11.0203)
ApexSQL announced that a new version of ApexSQL doc is available.
News Announcement
The latest version is 2005.11.0203 and there are...
2007-03-14
1,522 reads
Windows 2003 SP2 is Out
Here is a list of what was fixed:
http://support.microsoft.com/default.aspx/kb/914962
Downloads are available off of the SP2 home page:
http://www.microsoft.com/technet/windowsserver/sp2.mspx
Technorati Tags:Microsoft | Windows 2003
2007-03-14
1,466 reads
Conditional formatting in Reporting Services
Yesterday's post reminded me of another interesting technique I have used to change the color of the values on a...
2007-03-11
1,329 reads
Using IIF in Reporting Services
I found an interesting use for the IIF function in a Reporting Services report this week. I needed to provide...
2007-03-10
1,727 reads
SQL Server Learning Opportunities!
There are two big SQL Server learning opportunities I want to remind you about. First, DevTeach/SQLTeach will be held in...
2007-03-09
1,800 reads
Midlands PASS Job Board
In order to assist those members of the Midlands PASS Chapter looking for new positions, I have put up a...
2007-02-26
1,347 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