Identity Columns Can’t Be Updated: #SQLNewBlogger
I’m not sure I knew identity column values could not be updated. I ran into this while trying to solve a problem recently and had to check the error...
2026-02-25
40 reads
The Voice of the DBA
Rolling Back a Broken Release
We had an interesting discussion about deployments in databases and how you go forward or back from the point when you discover a problem. You can watch the episode...
2026-03-13 (first published: 2026-02-23)
277 reads
Advice I Like: In 100 Years
In 100 years a lot of what we take to be true now will be proved to be wrong, maybe even embarrassingly wrong. A good question to ask yourself...
2026-03-06 (first published: 2026-02-20)
596 reads
RANK() vs DENSE_RANK(): #SQLNewBlogger
I haven’t done one of these in awhile, but I saw an article recently about this and decided to explain it to myself, but in a slightly different way....
2026-03-02 (first published: 2026-02-18)
545 reads
The Book of Redgate: SQL Server Central
It was neat to stumble on this in the book, a piece by me, just a few years after Redgate acquired SQL Server Central. I’ll let the words speak...
2026-02-20 (first published: 2026-02-13)
304 reads
Setting FK Constraints in Data Modeler
One of the things a customer asked recently about Redgate Data Modeler was how to set a FK constraint between two tables. The tool seemed to make it easy,...
2026-02-27 (first published: 2026-02-11)
318 reads
Webinar: Navigating the Database Landscape in 2026
For a number of years, we’ve produced the State of the Database Landscape report, based on surveys and research we do every year. I have found it very interesting...
2026-02-10
77 reads
Claude AI Convinced Me Not to Build an iPad App
I coach volleyball and I do a lot of stat stuff on paper. I decided recently to see if I could find a way to more easily automate things....
2026-02-18 (first published: 2026-02-09)
563 reads
A New Word: Dolorblindness
dolorblindness – n. the frustration that you’ll never be able to understand another person’s pain, only ever searching their face for some faint evocation of it, then rifling through...
2026-02-06
32 reads
Claude Code Helps Analyze Test Data Manager Log Files
I had a customer ask about analyzing their Test Data Manager (TDM) usage to determine how many people were protecting data in dev databases and how often. TDM creates...
2026-02-16 (first published: 2026-02-04)
259 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor BCA KCU KUDUS Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Alamat Kantor BCA KCU SEMARANG Telp:0817839777
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
Question of the Day
BIT_COUNT I
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