VMUG Ireland – Belfast
The second VMUG Ireland event of the year is taking place on the 15th of June in Belfast! When: Thursday 15th of June @ 2pm until 5pm Where: Ormeau...
2023-05-16
27 reads
Top Tools for SQL Server Performance Troubleshooting
When you've got the symptoms of a database issue you can run a series of diagnostic queries to try and drill down on the problem and then start figuring...
2023-05-26 (first published: 2023-05-16)
660 reads
Stop Using Balanced Power with SQL Server
The OS default Power Plan for Windows is Balanced Power. This can cause degraded overall performance for SQL Server. Balanced Power is a great concept to help conserve energy...
2023-05-16
28 reads
Using Docker on Windows with Persistent SQL Server Settings and Databases
This is an easy way to retain the data and settings you create and change on your SQL Server Docker instance. There’s a lot of talk about attaching databases...
2023-05-31 (first published: 2023-05-15)
493 reads
Leveling Up for Sales and Marketing
I’m heading to Austin today for Redgate’s internal Level Up conference. This is designed to help employees improve their skills in some way. The original ones focused on technology...
2023-05-15
49 reads
Microsoft Digital Event Pre-Show: Azure FastTrack, Power BI CAT, & Azure Synapse Analytics PG
Next week is Microsoft Build and there is a Microsoft Digital Event occurring on May 24 - 25 starting at 9 AM Pacific Time for a live simulcast with a lot...
2023-05-15
21 reads
Tales From The Field Weekly Wrap Up for the Week of 05-08-2023 Mother's Day, Big News for MS Build, & the recap
Hello Dear Reader!! We also have some really, really, BIG NEWS for next week! It also happens that next week is Microsoft Build, make sure to register for free! But...
2023-05-15
31 reads
TDE: Database Backups and High Availability
Database backups continue to work without change when you have TDE enabled. The only difference is that the backups contain encrypted data that cannot be read without the certificate...
2023-05-15
45 reads
Techorama Slides – Analyze Cosmos DB Data with Synapse Link
I’ve uploaded the slides for my session at Techorama to Github.
The post Techorama Slides – Analyze Cosmos DB Data with Synapse Link first appeared on Under the kover of...
2023-05-15
23 reads
A New Word: Vemödalen
vemoödalen – the fear that originality is no longer possible I used to worry about this, and often I thought that I’d run out of original things to do....
2023-05-12
104 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
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
Why Your SQL Permissions Disappeared
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
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