31 Days of SSIS – Small Package, Big Win (26/31)
Welcome to day twenty-sixth post of the 31 Days of SSIS. We’re getting near the end now. If you have...
2011-01-27
913 reads
Blog Posts
A Half-Price Seat at the Masters’ Table
Well, it looks like I half-won the SQLskills competition for a free seat at a SQLskills Master Immersion Event on...
2011-01-27
523 reads
Creating a deep hierarchy with FOR XML
I have two tables in an application that I support. One is called [Report], and the other is [ReportParameter].
--SAMPLE...
2011-01-27
19,170 reads
My Most Popular Posts From 2010
I was recently looking through my blogging statistics and discovered that I can see the most viewed posts during that...
2011-01-27
729 reads
SQLLunch and SQL University have Combined Forces - SSIS Tips & Tricks (Advanced SSIS)
The SQL Lunch and SQL University have combined forces. Come and watch, laugh, and learn.
#48-SSIS Tips&Tricks (Advanced SSIS)
Speaker: Josef Richberg
Add To...
2011-01-27
739 reads
SSAS Dimension Attribute Discretization Methods
Discretization (one of my favorite tech words to say J) is a really great feature of Analysis Services that is...
2011-01-27
3,818 reads
Two Profiler Tips
I’ve had occasion to watch a lot of people try Profiler, and to hear a lot more about their previous...
2011-01-27
574 reads
31 Days of SSIS – One Package, Unlimited Tables (25/31)
31 Days of SSIS
One day at a time and we have reached the twenty-fifth post in the 31 Days of...
2011-01-26
1,714 reads
A SQL Azure Customer
Not me, though I’m not necessarily against Azure in principle. I had a friend ask me for a SQL Server...
2011-01-26
737 reads
Immersion in Internals
Paul Randal (Blog | Twitter) and Kimberly Tripp (Blog | Twitter) of SQLSkills are hosting an Immersions training event in Dallas. This is not run of the mill training, but it...
2011-01-26
10 reads
Blogs
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...
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Forums
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
I Can't Make You Learn
Comments posted to this topic are about the item I Can't Make You Learn
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