New Pluralsight Course – LFCE: Advanced Network and System Administration
My new course “LFCE: Advanced Network and System Administration” in now available on Pluralsight here! If you want to learn about the course,...
2017-01-13
690 reads
Anthony Nocentino Blog
New Pluralsight Course – LFCE: Advanced Network and System Administration
My new course “LFCE: Advanced Network and System Administration” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to...
2017-01-13
9 reads
Understanding Network Latency and Impact on Availability Group Replication
When designing Availability Group systems one of the first pieces of information I ask clients for is how much transaction...
2017-01-17 (first published: 2017-01-06)
3,226 reads
Understanding Network Latency and Impact on Availability Group Replication
When designing Availability Group systems one of the first pieces of information I ask clients for is how much transaction log their databases generate. *Roughly*, this is going to...
2017-01-06
16 reads
Microsoft Most Valuable Professional – Data Platform
Today, I’m proud to announce that I have been named a Microsoft MVP – Data Platform. This is an exceptional honor...
2017-01-02
664 reads
Microsoft Most Valuable Professional – Data Platform
Today, I’m proud to announce that I have been named a Microsoft MVP – Data Platform. This is an exceptional honor and I’m humbled to be included in this...
2017-01-02
21 reads
Speaking at SQLSaturday Nashville!
Speaking at SQLSaturday Nashville!
I’m proud to announce that I will be speaking at SQL Saturday Nashville on January 14th 2017! This...
2016-12-19
339 reads
Speaking at SQLSaturday Nashville!
Speaking at SQLSaturday Nashville!
I’m proud to announce that I will be speaking at SQL Saturday Nashville on January 14th 2017! This will be my first speaking event this year...
2016-12-19
17 reads
SQL Server on Linux – How I think they did it!
OK, so everyone wants to know how Microsoft did it…how they got SQL Server running on Linux. In this article,...
2016-11-29 (first published: 2016-11-21)
2,926 reads
SQL Server on Linux – How I think they did it!
OK, so everyone wants to know how Microsoft did it…how they got SQL Server running on Linux. In this article, I’m going to try to figure out how.
Update: Since...
2016-11-21
17 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