DB Audit Challenge #1 - Part II - Get a Clue
In the spirit of my Who DID IT and RAN SQL Caper presentation.....
OK, I was hoping to get the creative juices...
2009-11-03
745 reads
Blog Posts
Importing a SQL Server 2008 Analysis Services Database
Have you ever lost your project file for a SQL Server Analysis Services database? There is a great option to...
2009-11-03
1,052 reads
Kick xp_sendmail to the curb
With the advent of SQL Server 2005 and 2008, mail in the database engine has changed dramatically. Previously you had...
2009-11-03
1,430 reads
My First PASS Experiences
Getting to Seattle
I started my travels to the PASS Summit at about 9:30 am (EST) on Sunday and arrived at...
2009-11-03
712 reads
PASS Day –1 (Monday) at PASS Summit 2009
Started the day with a long walk, then off to Top Pot doughnuts for coffee with Don Gabor, Jack Corbett,...
2009-11-03
378 reads
PASS Summit - Bob Muglia
President of server tools at Microsoft, Bob Muglia, he overseas Windows Server, Systems Center, Hyper-V, and of course, SQL Server....
2009-11-03
733 reads
Pass Summit 2009 - Live Blogging
I'm blogging from the PASS Summit 2009, making notes as the keynotes unfold. This is my second year doing it...
2009-11-03
327 reads
PASS Summit 2009 - Ted Kummert
After Bob Muglia, Ted Kummert came on stage. He's the senior VP of the server tools division and works for...
2009-11-03
942 reads
PASS Summit 2009 - Wayne Snyder
The opening remarks of the first day are typically from the President of PASS. Wayne Snyder, the outgoing president started...
2009-11-03
935 reads
PASS Summit 2009 Day – 0
Monday at the PASS Summit. It’s always a big day. This year it’s the eve of the Summit and the...
2009-11-03
761 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT 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