There is Now A Delete Activity in Data Factory V2!
Data Factory can be a great tool for cloud and hybrid data integration. But since its inception, it was less...
2019-03-21 (first published: 2019-03-07)
1,908 reads
Blog Posts
Using docker named volumes to persist databases in SQL Server
I’ve previously talked about using named volumes to persist SQL Server databases but in that post I only used one...
2019-03-21
431 reads
Disabling and enabling triggers
I tend to feel that a lot of people who use triggers don’t really understand them. That said, every now...
2019-03-20 (first published: 2019-03-06)
2,955 reads
Filelistonly and headeronly – Find SQL server version from backup and use of header only version, ldf mdf size and LSN restore and file list only logical name.
Problem: SQL server database refresh / restore...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-03-20
27 reads
Filelistonly and headeronly – Find SQL server version from backup and use of header only version, ldf mdf size and LSN restore and file list only logical name.
Problem: SQL server database refresh / restore...
[[ This is a content summary only. Visit my website for full links, other content,...
2019-03-20
381 reads
SheLeadsTech Community
ISACA, which is primarily an Audit and Compliance professional organization, has recently started an initiative with the following purpose:
ISACA’s SheLeadsTech...
2019-03-20
332 reads
Sizing your Azure SQL Database
Do you want to identify the correct Service Tier and Compute Size ( was once known as performance level) for your...
2019-03-20
666 reads
The Curiously Large CASE Statement
A powerful little expression in SQL Server is the CASE statement. The CASE statement has the ability to "transform" data per business rules to help better understand the data...
2019-03-20
11 reads
The free SQL to Excel Export tool
Earlier this month I released a new, free tool to export SQL Server query data to Excel files without needing Excel....
2019-03-20
672 reads
Two Weeks to #sqlinthecity Streamed
It’s just two weeks until the SQL in the City Streamed starts up again in 2019. I’m ready to travel...
2019-03-20
444 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