Why Did Your Availability Group Creation Fail?
Availability Groups are a fantastic way to provide high availability and disaster recovery for your databases, but it isn’t exactly...
2017-04-22
3,738 reads
Anthony Nocentino Blog
Why Did Your Availability Group Creation Fail?
Availability Groups are a fantastic way to provide high availability and disaster recovery for your databases, but it isn’t exactly the easiest thing in the world to pull off...
2017-04-22
17 reads
New Pluralsight Course – LFCE: Network and Host Security
My new course “LFCE: Network and Host Security” in now available on Pluralsight here! If you want to learn about the course, check...
2017-04-09
540 reads
New Pluralsight Course – LFCE: Network and Host Security
My new course “LFCE: Network and Host Security” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right...
2017-04-09
12 reads
Speaking at PowerShell Summit!
Speaking at PowerShell + DevOps Global Summit 2017!
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit...
2017-03-22
328 reads
Speaking at PowerShell Summit!
Speaking at PowerShell + DevOps Global Summit 2017!
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2017 on the conference runs from April...
2017-03-22
7 reads
Using dbatools for automated restore and CHECKDB
OK, so if you haven’t heard of the dbatools.io project run by Chrissy LeMaire and company…you’ve likely been living under a...
2017-03-22 (first published: 2017-03-04)
4,183 reads
Using dbatools for automated restore and CHECKDB
OK, so if you haven’t heard of the dbatools.io project run by Chrissy LeMaire and company…you’ve likely been living under a rock. I strongly encourage you to check it out...
2017-03-04
12 reads
TugaIT – Pre-conference workshop on PowerShell on Linux
Where – Thursday, May 18, 2017
Where – TUGA IT – Lisbon, Portugal
Full Day Session – “Open Source PowerShell on Linux – Skills to Manage Your...
2017-02-08
459 reads
TugaIT – Pre-conference workshop on PowerShell on Linux
Where – Thursday, May 18, 2017 Where – TUGA IT – Lisbon, Portugal
Full Day Session – “Open Source PowerShell on Linux – Skills to Manage Your Heterogenous Data Center“ ...
2017-02-08
11 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