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
Blog Posts
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
PowerView: Coordinating Chart Colors
During a recent customer engagement I was asked if it was possible to ensure that the colors in a Line...
2012-01-10
1,615 reads
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
SQL Server – Identifying default data directory for multiple instances through registry
This is a follow up post from a comment on my blog.
Earlier I posted about using xp_instance_regread to get default...
2012-01-10 (first published: 2012-01-05)
2,862 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
TSQL Tuesday #026 – Second Chances
Welcome to the first TSQL Tuesday of 2012! This month’s soiree is being hosted by Dave Howard (blog | twitter) and...
2012-01-10
922 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
T-SQL Tuesday #26 – Second Changes with Date/Time
I missed the very first T-SQL Tuesday, so when this month’s topic of second chances came up, I decided to...
2012-01-10
1,409 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