Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2019-2020 award year, my third MVP award. This is an truly an honor and...
2019-07-03
13 reads
Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2019-2020 award year, my third MVP award. This is an truly an honor and...
2019-07-03
3 reads
Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2019-2020 award year, my third MVP award. This is an truly an honor and...
2019-07-03
33 reads
The index is very important and powerful object...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-07-03
184 reads
I am so excited and honored to have been awarded my second Data Platform MVP from Microsoft on Monday. It’s been a crazy busy 18 months and the next...
2019-07-03
11 reads
Watch this week’s episode on YouTube. A long time ago I built an application that captured user input. One feature of the application was to compare the user’s input...
2019-07-03 (first published: 2019-06-18)
1,045 reads
Watch this week's video on YouTube
Today I want to share my process for blogging and making weekly YouTube videos.
I've been hesitant to write this post because of how much...
2019-07-02
7 reads
Watch this week's video on YouTube
Today I want to share my process for blogging and making weekly YouTube videos.
I've been hesitant to write this post because of how much...
2019-07-02
7 reads
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to...
2019-07-02 (first published: 2019-06-18)
628 reads
There are multiple ways of retrieving data from a table when you have a list of values. This article explores the use of the table value constructor.
Related Posts:
Finding Data...
2019-07-02
28 reads
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Comments posted to this topic are about the item BIT_COUNT II
Comments posted to this topic are about the item I Can't Make You Learn
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
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