31 Days of SSIS – Data Flow Expressions (22/31)
31 Days of SSIS
Today, we continue on with the 31 Days of SSIS blog series. Yesterday’s post was on the...
2011-01-22
2,340 reads
Blog Posts
SSMSDeploy 1.5 Available: new configuration form and highly tweaked request list
SSMSDeploy version 1.5 is ready. This one has a LOT of GUI tweaks. No database changes in this one, so...
2011-01-22
960 reads
Tampa IT Camp Saturday
The first annual Tampa IT Camp will be held on Saturday, March 19th 2011.
What’s an IT Camp?
In the...
2011-01-22
578 reads
31 Days of SSIS – Controlling Your Flow In The Control Flow (21/31)
Remember, what I said last Friday? I’m going do it, again. Which means, I’m taking the day off. There will...
2011-01-21
937 reads
A Friend of Red Gate No More
Don’t get me wrong. It’s been great. The beta tests. The advanced notices. The opportunity for feedback. It’s been a...
2011-01-21
781 reads
Blog Sins
Thoughts come together, and the hybridization of your thoughts give rise to new ideas. Here are the thoughts:
I have this...
2011-01-21
677 reads
Deprecation, Trace and Execution Plans
As I’m sure you know, Microsoft occasionally changes it’s mind. Or, it makes bad decisions and then rectifies them. Or,...
2011-01-21
889 reads
Disk Partition Alignment–MCM Prep
Does disk partition alignment matter to SQL Server? Without a doubt. When new disk partitions are created, there could be...
2011-01-21
1,461 reads
Free SQL Server Training for the week of January 24, 2011
We're finally getting a handle on things with the new baby. 🙂 As a result, I've started this weekly accumulation of...
2011-01-21
838 reads
PowerShell Week at SQL University – Post 6
Yesterday we went over some loop constructs to get information out of SQL Server. While getting the information out is great, as Data Professionals our very next concern is...
2011-01-21
20 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