MidnightDBA: We do a lot
We do a lot of things. It’s difficult to explain all the things we do to people. So I made...
2011-03-28
612 reads
Jen McCown
SQL Math: Whole Numbers, Real Numbers
It’s been a long time since grade school math, and for some the details have become kinda fuzzy. I’m no...
2011-03-28
1,879 reads
An Analogy is like a Tree….
For years, I’ve been trying to express how everything ties into everything else. A big part of understanding any given...
2011-03-25
491 reads
Maaaaaagic Tables!!!
I had an interview earlier this week. An interview for a SQL developer position. It went fine. But. Question number X...
2011-03-24
2,382 reads
Not Cool Enough for Firefox
I’m pretty consistently behind the curve on most things. It took three years for me to get into The Office...
2011-03-22
880 reads
Filmed: DBAs@Midnight Episode 2.30
Friday night (as per usual) we filmed a new episode of our 2 1/2 year old webshow, DBAs@Midnight in front...
2011-03-19
849 reads
Women in Technology SQL Lunch!
Attend SQL Lunch...the power of my sweater compels you...
This week on Friday, March 17 we’re having a free panel talk,...
2011-03-17
664 reads
24 Hours of PASS Spring 2011 Code Sins
Here is all the things related to the most awesome Code Sins session I gave at 24 Hours of PASS Spring...
2011-03-15
675 reads
SQL University – Teach Your Children Well
“If you had a daughter, would you really encourage her to get into IT?” … “Yes, if she loved it.”
- My...
2011-03-10
979 reads
T-SQL Tuesday #016: Aggregates and Windowing Functions and Ranking! Yum!
Let’s get this out of the way right now: I am SO going to take advantage of this T-SQL Tuesday...
2011-03-08
906 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