Query backup history
As a quick script tip for today I’ll show you a script I use regularly for reporting purposes.
It shows you the...
2014-06-13
421 reads
DotNine SQL Server and more
Query backup history
As a quick script tip for today I'll show you a script I use regularly for reporting purposes.
It shows you the...
2014-06-13
18,125 reads
Examining PAGEIOLATCH waits
In a previous article we looked at CXPACKET waits, a wait type that is can be on the top of your...
2014-06-06
745 reads
Examining PAGEIOLATCH waits
In a previous article we looked at CXPACKET waits, a wait type that is can be on the top of...
2014-06-06
11,516 reads
How SQL Server statistics are generated and updated
One of the easiest ways to increase query performance on your database is making sure your statistics are up-to-date. Statistics...
2014-05-16
461 reads
How SQL Server statistics are generated and updated
One of the easiest ways to increase query performance on your database is making sure your statistics are up-to-date. Statistics...
2014-05-21 (first published: 2014-05-16)
6,367 reads
Analyzing CXPACKET waits
One of the most common wait types you will see on a SQL Server is the CXPACKET wait type.
This wait...
2014-04-04
536 reads
Analyzing CXPACKET waits
One of the most common wait types you will see on a SQL Server is the CXPACKET wait type.
This...
2014-04-09 (first published: 2014-04-04)
4,826 reads
The power of the baseline
There is one thing we all have in common, and a lot of us probably don’t even realize it, baselines!
While...
2014-03-21
712 reads
The power of the baseline
There is one thing we all have in common, and a lot of us probably don’t even realize it, baselines!
...
2014-03-27 (first published: 2014-03-21)
2,531 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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