Why is my SQL Server using all of the RAM on the server?
The TL;DR on this is simple:
"BECAUSE IT'S SUPPOSED TO!"
A frequent complaint we receive comes from a client that has an...
2016-01-14 (first published: 2016-01-08)
7,744 reads
Transaction Logging & Recovery (part 2)
Transaction Logging & Recovery (part 2)
… Continuation of some notes regarding the excellent content by Paul Randal in Pluralsight: SQL Server:...
2016-01-08
444 reads
Trace Flag 3226 - Suppress all successful backups in SQL server error log
SQL server error log contain all information about how a SQL server is running, what is happening and occurring for...
2016-01-13 (first published: 2016-01-08)
22,405 reads
Transaction Logging & Recovery (part 2)
... Continuation of some notes regarding the excellent content by Paul Randal in Pluralsight: SQL Server: Logging, Recovery, and the Transaction...
2016-01-08
321 reads
Alter Event Session
Altering an Extended Event session is not necessarily a difficult task, but it is a very useful ability. Having this basic skill in your wheelhouse can be very positive...
2016-01-08
19 reads
Alter Event Session
Ready for a change of pace? Good! Today is a really good time to start looking into one of the...
2016-01-13 (first published: 2016-01-08)
2,524 reads
What is SSDT? Part 3 - an API for me, an API for you, an API for everyone!
In the final part of this 3 part series on what SSDT actually is I am going to talk about...
2016-01-07
885 reads
What is SSDT? Part 3 - an API for me, an API for you, an API for everyone!
In the final part of this 3 part series on what SSDT actually is I am going to talk about the documented API. What I mean by documented is...
2016-01-07
6 reads
What is SSDT? Part 3 - an API for me, an API for you, an API for everyone!
In the final part of this 3 part series on what SSDT actually is I am going to talk about...
2016-01-07
32 reads
What is SSDT? Part 3 - an API for me, an API for you, an API for everyone!
In the final part of this 3 part series on what SSDT actually is I am going to talk about...
2016-01-07
53 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
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