I focus most of my blog posts on the data platform and how companies can make better business decisions using structured data (think SQL tables), but I’m seeing more...
2024-03-18 (first published: 2024-03-11)
767 reads
DataTune 2024 was a huge success! Thank you so much to the organizers who spent countless months planning and making this an incredible conference! It was so great to...
2024-03-18 (first published: 2024-03-11)
124 reads
(2024-Mar-08) Software installation typically involves several steps. After accepting the license agreement, you may have an express option to streamline the installation process by accepting all defaults, including the installation...
2024-03-13 (first published: 2024-03-08)
580 reads
I had a customer ask about undoing changes made by developers, similar to what SQL Source Control does. I had to do a little research to show how to...
2024-03-15 (first published: 2024-03-08)
208 reads
I will be giving another Microsoft SQL Server-based webcast, this time on the administration of Microsoft SQL Server. The webcast is scheduled for March 26, 2024 at 1 PM...
2024-03-15 (first published: 2024-03-08)
312 reads
loss of backing– n. an abrupt collapse of trust in yourself – having abandoned a resolution, surrendered to your demons, or squandered an opportunity you swore you’d take seriously...
2024-03-08
28 reads
Using data effectively, leaders can make better decisions, drive innovation, and inspire trust. What is leadership through data? Leadership that utilizes data is the ability to use data as...
2024-03-13 (first published: 2024-03-07)
203 reads
This is very off topic, but I’ve been a fan of Rush since I was about 12 years old. Their Moving Pictures This is a few thoughts on Geddy...
2024-03-06
153 reads
From April 24 – 25, 2024 I will run a brand-new SQLpassion Live Training about Design, Deploy, and Optimize SQL Server on Microsoft Azure. Unlock the power of Microsoft...
2024-03-08 (first published: 2024-03-04)
330 reads
Navigating the Database Landscape is the headline of our Redgate Summit in Atlanta on Mar 13. I’m doing the Keynote with Grant Fritchey and Kathi Kellenberger with this title,...
2024-03-04
83 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