Applied SQL: sys.objects
I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page.
Prerequisites: basic...
2011-08-17
1,379 reads
Jen McCown
Applied SQL: You Have Homework
I found myself saying this week – for the N-zillionth time – that while studying is vital, it isn’t everything. What do...
2011-08-17
579 reads
We Are TOTALLY Amused: A T-SQL Error
This has to be the best error I’ve ever seen:
Msg 195, Level 15, State 10, Line 2
‘SUM’ is not a...
2011-08-11
830 reads
Roundup for Un-SQL Friday #005: Bad Interviews
It’s time for the Un-SQL Friday #005 roundup!
From managers…
First up, The Lone DBA admits that he wasn’t always (ahem) one of us…he’s got...
2011-07-29
1,774 reads
Speaking Schedule! I’m here (and there, and there…) to help
Depending on whether you’re (A) me, or (B) you, the next few weeks are either (A) an insanely busy but enjoyable...
2011-07-25
570 reads
Un-SQL Friday #005: Bad Interviews
Yesterday a friend told me a tale of an interview he conducted with a, shall we say, less than desirable...
2011-07-19
704 reads
Search Argument Case Study: WHERE the year was 2002…
Content Rating: Beginner, Tips
It’s entirely possible that you’re fiddling with your search arguments too much, and missing out on the...
2011-07-18
811 reads
SELECT INTO and IDENTITY (or, BOL is Sorta Wrong)
I am easily distracted. Lucky for all of us, I tend to be distracted by cool tidbits in SQL Server...
2011-07-14
982 reads
Meme Monday SQLstrology – Table Valued Zodiac Function
It’s Meme Monday time! Our topic is SQL Horoscopes, or more catchily, SQLStrology.
We’re going to have to figure out what astrological...
2011-07-11
951 reads
T-SQL Formatting Workaround (Word Macro)
Hi all! I’m on vacation this week, but I’ve cleverly scheduled this blog post so you won’t miss me too...
2011-06-20
1,576 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