Cleaning up Query Store data after database restore
Query Store is a very powerful tool for performance tuning, if you are not using it already you should!! It...
2018-08-29 (first published: 2018-08-13)
2,091 reads
DBA Mastery
Enable SQLCMD Mode on SSMS
I really like Microsoft philosophy nowadays, they are putting a lot of time developing good open source tools like SQLCLI,...
2018-08-10 (first published: 2018-08-07)
3,542 reads
First time speaker at Denver’s SQL local group
06/21 was the date that marked my career as data professional, for the first time ever I decided to participate as...
2018-08-01
259 reads
Is your SQL Server environment ready for GDPR? Part 1
Unless you have been living under a rock lately, you have not heard about GDPR. This has been hot topic...
2018-05-25
147 reads
SQL Vulnerability Assessment
Vulnerability assessment is probably one of the most underrated new security features in SSMS 17. This feature is not new...
2018-05-21
149 reads
Reviewing the SQL Server ERROR log
The SQL Server ERROR log is the best source to understand what’s wrong with your SQL Server instance, think this...
2018-05-10
133 reads
ITIL certification for DBAs – Part 2
In my previous post I did my best explain a little bit what ITIL is and how important is for...
2018-04-13
250 reads
ITIL certification for DBAs – Part 1
In some point of your career as DBA you might have interacted with ITIL or at least your heard about...
2018-04-13
265 reads
SQL Saturday #695 Guatemala
This is probably a very delayed post, but I have been really busy lately.
As mentioned in my previous post, I...
2018-03-23
111 reads
Speaker at SQL Saturday’s Guatemala city 2018
I’m very thrilled to announce that I will be participating as speaker in this year’s SQL Saturday event in Guatemala city!
Here...
2018-01-04
118 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