I have been working in various computer languages for a long time. When I saw that the || operator was coming, I was a bit confused as to why we needed this, and how it would work. After all, this is a part of other languages. I decided to dig in a bit. This is […]
2025-12-19
8,633 reads
I am not much for working in languages other than English. That's my native language and I know little about others. However, the last few years I find myself using emojis more and more in quick communications as they seem to add some fun to the interaction. And those interactions need to be stored in […]
2025-12-05
404 reads
2025-12-03
141 reads
2025-12-01
581 reads
This is a list of the builds for SQL Server 2025. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]
2026-05-21 (first published: 2025-11-24)
1,185 reads
2025-11-21
153 reads
If you’re a SQL Server DBA or developer looking to harness AI for your everyday scripting workflows, this article will walk you through building an AI-powered T-SQL assistant using Python and SQL Server.
2025-11-19
SQL Server 2025 has been released to GA. Read about the new version in this piece by Bob Ward.
2025-11-19 (first published: 2025-11-18)
15,938 reads
This article takes a look at the changes in SQL Server 2025 to the SUBSTRING function.
2025-11-07
9,621 reads
This article examines the new regular expression functions added to T-SQL in SQL Server 2025.
2025-10-31
17,326 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