What's In a PodCast - Part 1
Well, lots of mistakes. Here's a good example of one: Friday Oct 5 mistake.
I decided to go the budget route...
2007-10-04
980 reads
My Book is Out!
How to Cheat at Securing SQL Server 2005
I recently had the opportunity to contribute a couple of chapters to this...
2007-10-04
547 reads
Midlands PASS October Meeting
Taya Blanchard to speak on A
Practical Guide to Making Sense of Your SQL Server Application
Performance
Midlands PASS Chapter - October...
2007-10-03
576 reads
Estimates - Part 1
I saw a very interesting post about estimating software from Steve McConnell, of Code Complete fame. He compared his estimate...
2007-10-02
1,012 reads
Paperwork Day
Doing payments for articles, expenses, and a few articles. This is definitely a paperwork day. As much as I like...
2007-10-01
645 reads
The Quickest Podcast in the Business
I almost forgot to record the podcast for tomorrow's editorial. In case you're a glutton for punishment, it's here. I'd...
2007-09-30
1,613 reads
Clustered Indexes
I work almost exclusively with third party applications. I don't get to do a lot of tuning except for reports...
2007-09-30
1,294 reads
I Don't Have a Black Eye
Though it kind of looks like that. Here's the first video podcast.
Halo 3
Actually it's probably the 20th, but it's close...
2007-09-29
1,451 reads
Monitoring and Alerting
I responded in an interesting thread this morning where someone was looking for advice on what to monitor on their...
2007-09-28
1,570 reads
Points or Posts
It's an interesting question that we had come up, and honestly I'm not completely sure what I want. I'll describe...
2007-09-27
1,420 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