SWAG Saves the Day
PASS Summit East is in one week. I was on the road last week in the UK and then Houston for the Houston AI-lytics event. I had been a...
2026-04-30
27 reads
The Voice of the DBA
Upgrading SQL Server Containers on the Laptop
I don’t have SQL Server installed on my laptop. In an effort to keep things clean and smooth in case I need to rebuild things, I’ve gone with containers....
2026-05-11 (first published: 2026-04-29)
314 reads
Questions and Answers from Running a Local LLM
I had a few random questions from my Running a Local LLM on Your Laptop session at the Houston AI-lytics 2026 event last week, so this post looks at...
2026-04-27
20 reads
Houston AI-Lytics 2026–Powerpoint Slides
Thanks to everyone for attending my session on running a Local LLM. If you have any questions, please feel free to reach out with them. The slides with links...
2026-04-25
22 reads
The Book of Redgate: Do the Right Things
I do believe that Redgate has been very customer focused since it’s inception. I’ve worked with them in some capacity since 2002 and I’ve felt this along the way:...
2026-04-25 (first published: 2026-04-24)
41 reads
Get a Range of Sequence Values: #SQLNewBlogger
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks at how the proc works. Another post for me that is simple and hopefully serves...
2026-05-08 (first published: 2026-04-22)
249 reads
Monday Monitor Tips: Oracle Custom Metrics
One of the popular features of Redgate Monitor has been the ability to add custom mertics for various purposes. This has been popular, and along with our curated list...
2026-05-04 (first published: 2026-04-20)
94 reads
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an example of why it can behave weirdly. This post looks at something you might not...
2026-04-27 (first published: 2026-04-15)
199 reads
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on Wheels blog for a long time and I appreciate all that he does, especially given...
2026-04-24 (first published: 2026-04-14)
238 reads
Changing the Cardinality of a FK in Redgate Data Modeler
One of the things a customer asked recently about Redgate Data Modeler was how to adjust a FK constraint between two tables. The tool seemed to makes this easy,...
2026-04-20 (first published: 2026-04-13)
156 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 JOMBANG Telp:08218154398
WhatsApp:0821-8154-398 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415...
Alamat kantor BCA KCU MADIUN Telp:08218154398
WhatsApp:0821-8154-398 9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132...
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