Server Name and SQL Server Name
I have, in the past had the need to rename a server, either because the server has been named incorrectly...
2012-01-10
789 reads
TSQL Tuesday #26 or #23 – Identity Crisis
This second chance, gives me the opportunity to finally talk about a topic that has been on my to-blog list for quite some time. I hope this post will...
2012-01-10
9 reads
TSQL Tuesday #26 or #23 – Identity Crisis
The first opportunity of this New Year to participate in TSQLTuesday, we have been invited by David Howard (blog) to...
2012-01-10
894 reads
How safe are your secrets?
We’ve all have service accounts, application accounts, sysadmin and domain admin accounts and other privileged shared accounts on our systems....
2012-01-10
647 reads
T-SQL Tuesday #26 - Second Chances - Correlate Missing Index with Related Query
Everybody deserves a second chance in love, life, and in TSQL as well! Now that it's the beginning of a New...
2012-01-10
5,164 reads
SQL Server – Maintaining different environments
A busy Database Server and application development environment can have – Sandbox, Dev, Test, QA, Staging, Production .
Maintaining multiple environments requires...
2012-01-10
2,657 reads
Making Schema Changes in a Replication Topology
I've noticed in the forums there have been a number of people inquiring about making schema changes in a replication...
2012-01-10
5,796 reads
Orlando IT Pro Camp
The Orlando IT Pro Camp marks our third event after Tampa and South Florida. As with the prior IT Pro...
2012-01-10
988 reads
January 2012 Speaking Events
It has been a quiet past few months while my family has adjusted to having
two new additions (twins!), but...
2012-01-10
924 reads
DBAs in Denver
I have a friend looking for a production DBA in Denver, so if you’re interested, email me at SQLServerCentral.
They need...
2012-01-09
781 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