SQL PASS Summit 2009 – Day 3
The day started off with the Quest Software breakfast presentation, to which I arrived late to find a standing-room-only crowd. ...
2009-11-04
621 reads
Blog Posts
SQL Server 2008 Diagnostic Information Queries
Here is the script that I used in my Dr. DMV presentation this afternoon at PASS. It is a set...
2009-11-04
1,651 reads
Tuesday at the PASS Community Summit
Today was the first official day of the full (3-day) conference, with about 2,200 full conference attendees. Officially, PASS claims...
2009-11-04
417 reads
What Do You Do When Your Employer Doesn’t Want to Support Your DBA Career?
At the 2009 PASS Community Summit, I have gotten the opportunity to talk to many DBAs, and to find out...
2009-11-04
600 reads
Women in Technology Luncheon
I've never attended this in the past, but I've wanted to. As the father of young girl I want to...
2009-11-04
2,772 reads
Basic iFTS Monitoring Queries
This is one of the scripts that I will be using for my presentation “Tips and Tricks for Using SQL...
2009-11-03
1,484 reads
Check out Straight to 8 Program
We seem to be busting at the seams lately with quality content from great providers. I wanted to recommend to...
2009-11-03
225 reads
Date Expressions in SSIS
There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted...
2009-11-03
574 reads
Day 1 – PASS Summit 2009
Up early again, started my day at the Convention Center for breakfast. Light breakfast, drinking water, never seem to drink...
2009-11-03
381 reads
Day Zero of PASS (Pre-conference seminar with Kim Tripp)
This week, I’m blogging and tweeting from the PASS Community Summit in Seattle, Washington. The week of the Summit is...
2009-11-03
795 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