Read About SQLSatuday #100 & See the Coffee Cup Too!
Here’s a great post from Karla Landrum about her trip (with husband Rodney) to Brazil for the milestone making #100....
2011-12-19
729 reads
Blog Posts
SELECT GetDate() – 30 AS [This actually works??];
I just ran across this in a piece of code (that I didn’t write):
… WHERE Thing >GETDATE()- 30
Aaaand it works....
2011-12-19
1,231 reads
SharePoint Reports and Scorecards on Apple Devices
While some people may consider this topic off limits the fact remains that more and more companies are adopting Apple...
2011-12-19
708 reads
Suspect Database
Suspect database generally caused by internal IO issue, and the best way to resolve it to ask hardware person to...
2011-12-19
489 reads
Why Do I Blog? #meme15
As I mentioned in a post last week, a new meme has been born. This one is dedicated to discussing...
2011-12-19 (first published: 2011-12-15)
1,556 reads
Undocumented Gotcha in Merge Replication Tracking
In the spirit of Robert Davis's (blog | @SQLSoldier) blog post: Undocumented Gotchas of Transactional Replication, I decided to contribute an...
2011-12-18
1,350 reads
Using Dynamic Values in XMLA
Using Dynamic Values in XMLA
XMLA
A question was raised on Twitter today via the #sqlhelp hash tag about passing parameter values...
2011-12-18
1,930 reads
Albanian SQL Server Users Group - First meeting
Today, I’m so excited to announce that we had the first meeting of our Users Group – Albanian SQL Server Users...
2011-12-17
1,323 reads
Albanian SQL Server Users Group–First Meeting
Today, I’m so excited to announce that we had the first meeting of our Users Group – Albanian SQL Server Users...
2011-12-17
921 reads
Configuring and monitoring transactional replication between two SQL Server 2005 instances…
Replication often plays an important part in your database management strategy. An organization may use database replication for load balancing,...
2011-12-17
2,273 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
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