The transaction log for database ‘MyDB’ is full due to ‘LOG_BACKUP’
Your transaction log is full. Both Microsoft, and about 100 articles and blogs have covered this topic, but let's take...
2018-06-14
373 reads
Blog Posts
What queries are getting blocked?
Monday Grant Fritchey (b/t) put up a great post EXTENDED EVENTS, THE SYSTEM_HEALTH SESSION, AND WAITS that talks about how...
2018-06-14 (first published: 2018-06-06)
2,687 reads
4 Ways To Define Lookup Values In A Query
Watch this week’s episode on YouTube.
Occasionally you may need to create a lookup table of values for a single query. ...
2018-06-13 (first published: 2018-06-05)
4,343 reads
Azure SQL Database – Stairway Series
Hello all – I am excited to announce that I will be doing a Stairway series on Azure SQL Database hosted...
2018-06-13
405 reads
Dates and Times in SQL Server: DATEPART()
In my previous posts in this series we’ve seen reference to Transact-SQL (T-SQL) functions that are used to get the...
2018-06-13
301 reads
Linked Server to Azure SQL Database
You may (or may not) have a requirement to setup a linked server to Azure SQL Database from a locally...
2018-06-13 (first published: 2018-06-05)
1,866 reads
10 Years Young
It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the previous year’s PASS Summit and started I-380 PASS,...
2018-06-12
37 reads
10 Years Young
It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the...
2018-06-12
322 reads
10 Years Young
It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the previous year’s PASS Summit and started I-380 PASS,...
2018-06-12
29 reads
10 Years Young
It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the previous year’s PASS Summit and started I-380 PASS,...
2018-06-12
20 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