I am speaking at SQLSaturday Guatemala 2019
I’m very thrilled to announce that I will be participating as speaker in this year’s SQL Saturday #828 event in Guatemala...
2019-02-05
156 reads
Blog Posts
Midlands PASS Meeting for March 2019
The March meeting for Midlands PASS will be held on March 5, 2019, from 5:30-7:30 PM. Brian Kelley and Paul...
2019-02-05
133 reads
Power BI Custom Visuals Class (Module 119 – Pie Charts Tree)
In this module you will learn how to use the Pie Charts Tree. This visual allows you to view your...
2019-02-05
403 reads
Read-only tables
Sometimes you need a table that is read only. You don’t want anyone to be able to write to it...
2019-02-05 (first published: 2019-01-21)
2,665 reads
SQL Server Looking into Differential Backups
I seem to be writing solely about Azure so to shake things up a bit I am going back to...
2019-02-05
187 reads
Two T-SQL features that I appreciate
We occasionally get cool improvements in T-SQL in newer versions of SQL Server. Here’s a short post on some of...
2019-02-05
190 reads
A brief introduction for bcp
I end up using the bcp utility to move tables between environments, and I’ve found that a lot of the...
2019-02-04 (first published: 2019-01-16)
3,182 reads
Classify your Azure SQL Database
Here I am talking about SQL Data Discovery & Classification feature that is built into Azure SQL Database. With this feature you...
2019-02-04
191 reads
Combine Extended Events and TagWith to Monitor Entity Framework
I’m going to start with a sentence that makes a lot of people crazy; As a DBA and database developer, I love Entity Framework. That’s right. Entity Framework is...
2019-02-04
20 reads
Combine Extended Events and TagWith to Monitor Entity Framework
I’m going to start with a sentence that makes a lot of people crazy; As a DBA and database developer,...
2019-02-04
165 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