OFF-TOPIC: More about the pregnancy
Quite a few folks have commented about my previous post about missing the PASS Summit, whether publicly or in private....
2009-10-29
891 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
SQL University: Multiple Paths and Ownership Chaining
Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...
2009-10-29
2,672 reads
SQL University: Diving into Authorization
It's good to see all your bright and chipper faces here at SQL University. Hopefully you've digest Monday's lesson on...
2009-10-27
6,148 reads
SQL University: Authentication and Authorization
Welcome back to class, folks, here at SQL University. This week we're going to take a look at the basics...
2009-10-25
10,876 reads
Another Year, Another Missed PASS Summit
This year I was really looking forward to going to the PASS Summit. It's worth every penny in the knowledge you'll...
2009-10-23
1,667 reads
Habits and Activities for De-Stressing
I was chatting on FaceBook today with a guy from my church who is learning to be a network engineer. He's...
2009-10-22
927 reads
Enabling the Dedicated Administrator Connection (DAC) in SQL Server Express
SQL Server Express has the same code base as the rest of the versions of SQL Server, but there are some differences in how to set it up and configure various tasks. MVP Brian Kelley shows us how to enable the Dedicated Administrator Connection.
2009-10-21
5,978 reads
Review: ASUS Eee PC 1005HA Netbook
Our home desktop was several years old and due for replacement. I still have my Dell laptop, and it's still more than...
2009-10-19
2,254 reads
Vetting the PASS Board of Directors candidates
I've had a pretty heavy involvement in Brent Ozar's interview of Matt Morollo. The reason for my intense activity is he was...
2009-10-16
1,360 reads
Are you sticking to your goals? Do you know what they are?
I've engaged a little in the discussion on Matt Morollo's interview on Brent Ozar's blog. It made me go back...
2009-10-15
1,191 reads
Blogs
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen and the Revolt BI join forces
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
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...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
BIT_COUNT I
Comments posted to this topic are about the item BIT_COUNT I
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