Something About Nothing: NULL
You wouldn’t think that “nothing” would cause so many problems. But seriously, understanding how to correctly use NULLs is a...
2005-10-16
1,385 reads
Blog Posts
Blogging Is Hard
Why is that? My Database Daily editorial for this week focuses on that and I thought it would be interesting...
2005-10-14
1,386 reads
Remote Access
We typically have great weather in Colorado where I live, but we do get
snow. And occassionally it causes issues. Like...
2005-10-12
1,522 reads
Minor Panic
I know, I need some stuff posted about PASS and I'll get to it. My wife
was injured (she's ok) while...
2005-10-09
1,414 reads
Using the sa account -- Just say "NO!"
Aunt Kathi knows many of you do things you know are wrong, like rolling through stop signs, littering, and using the sa...
2005-10-04
1,304 reads
Thoughts about the future
So far my posts have been non-technical musings about my life outside of work. I guess it is time to...
2005-10-03
1,245 reads
Back home after PASS
The past week at PASS was more informative and fun than I could ever have imagined. By getting involved in the...
2005-10-01
1,288 reads
PASS 2005: Day Four
Day Four wrapped up SQL Pass 2005. As a first time attendee to this event, my head was swimming by...
2005-10-01
1,373 reads
PASS 2005: Day Three
Day Three of PASS had a decidedly better start than did the previous day. After finally figuring out the effective...
2005-09-29
1,310 reads
PASS 2005: Day One
This year, I have the opportunity to attend the SQL PASS event in Grapevine, Texas. This is my first PASS...
2005-09-28
1,423 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor BCA KCU KUDUS Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Alamat Kantor BCA KCU SEMARANG Telp:0817839777
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers