Yeah, I've got the Go-Go's running in my head because I'm going on vacation tomorrow (holiday for you UK types). I've been slogging through a really dense book, War in Human Civilization. Total recommendation. Get it. Read it. However, I'm right near the end and there's been a lot of discussion about the impact of […]
2026-08-01
163 reads
I was performing research for requested AI work and noticed that I was viewing the risks from a database perspective. As the saying goes in the tech industry, “Once a DBA always a DBA…” As foreign as some of the views were, much of it feels familiar and I simply begin to look at it […]
2026-07-25
153 reads
This article documents a SQL injection vulnerability I discovered in sys.sp_dbmmonitorupdate, a Microsoft-signed system stored procedure. For other SQL Server security vulnerabilities I’ve discovered, see the full series here.
2026-07-22
2026-07-22
814 reads
Large databases usually have a negative impact on maintenance time, scalability and query performance. For maintenance, these large single databases have to be backed up daily while the amount of actual changing data might be small. For performance, tables without correct indexes result in full table or clustered index scans. As the data grows the total query time increase linearly. How can we decrease downtime for the maintenance window for large databases and optimize the performance of daily queries?
2026-07-20
2026-07-13 (first published: 2026-07-10)
1,119 reads
Learn about a few new features built into SQL Server 2022 that can help improve performance on your workload.
2026-07-08
3,514 reads
In a previous tip on Orphaned User Detection for SQL Server High Availability Databases, we have seen how to identify when there are orphaned database users in an Availability Group database. Is there a way where we no longer need to worry about missing database users or different SID values between primary and secondary databases in an Availability Group?
2026-07-06
Learn how to get started with an MCP server that can query your SQL Server database.
2026-07-03
4,428 reads
Learn how parameter sniffing appeared in a real system and how the issues were solved.
2026-06-29
5,412 reads
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers