UNION vs UNIONALL: #SQLNewBlogger
While writing another post I realized my UNION query didn’t work as one might initiall expect, so I decided a short post was worth writing. This is based on...
2026-06-03
40 reads
While writing another post I realized my UNION query didn’t work as one might initiall expect, so I decided a short post was worth writing. This is based on...
2026-06-03
40 reads
2026-06-02 (first published: 2026-05-27)
455 reads
I got a new laptop recently and instead of installing SQL Server, I decided to try and use containers to see how well this works. This article looks at how I got this working relatively quickly. The short list of things I did is: Install Docker Desktop Create a location for data/logs/etc. Create a docker-compose […]
2026-06-02 (first published: 2024-09-06)
6,986 reads
Lessons on impostor syndrome from a marketer apply to technologists as well.
2026-06-01 (first published: 2022-09-09)
409 reads
2026-06-01
593 reads
Do meetings and paperwork take a toll on administrators? Steve draws a comparison to some of the changes in the US healthcare system.
2026-05-29 (first published: 2020-10-14)
227 reads
2026-05-29
589 reads
2026-05-25
437 reads
Redgate is a for-profit company. We look to make money by building and selling tools that help you. If we do a good job, we make money. If we...
2026-05-22
48 reads
Software teams are changing with AI and this might be an exciting time for developers if they take advantage of the capabilities available.
2026-05-22
97 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...
Comments posted to this topic are about the item Is Fabric a Reliable Service...
hi , a new user wants to be able to add sql agent jobs...
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