It’s been awhile since I’ve set up a new project in Redgate’s SQL Change Automation project. I’ve mostly used this in Visual Studio, but I need to demo something...
2020-07-23 (first published: 2020-07-15)
1,055 reads
The event is tonight, and it’s my first time helping out as a moderator. I got a call for volunteers, and I added my name. The event starts at...
2020-07-23
21 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-22
16 reads
Watch this week's video on YouTube
A Giant Heap
Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don't ask me why this 3.5 billion...
2020-07-22
16 reads
Watch this week's video on YouTube
A Giant Heap
Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don't ask me why this 3.5 billion...
2020-07-22
16 reads
T-SQL Tuesday is a monthly blog party for the SQL Server community. It is the brainchild of Adam Machanic (b|t) and this month’s edition is hosted by Kerry Tyler...
2020-07-22 (first published: 2020-07-14)
446 reads
I was using LEN() to troubleshoot an issue I was having with a dynamically constructed string truncating while inserting into an NVARCHAR(MAX) column. Since I know that NVARCHAR(MAX) has...
2020-07-22 (first published: 2020-07-14)
1,590 reads
At last week’s presentation to the Edmonton SQL Server user group, I spoke at length about the many extensions that are available for Azure Data Studio, and was asked...
2020-07-22
59 reads
You should always seriously consider enabling this feature. This is part of the ADS suite – Advanced Data Security and I will show you how good this pro-active service...
2020-07-21
145 reads
Recently I have been able to work with our development teams to not create new databases. There are several reasons for me making this request of the teams. The...
2020-07-21
14 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers