Columbus User Group webcast on SQL Server locking
Later this afternoon, I’m presenting at the Columbus, Ohio, SQL Server User Group meeting. The topic: SQL Server Locking and...
2009-09-10
356 reads
What happened to that email?
This question:
Created script to send mails using sp_send_dbmail- working like a charm.
Now searching for a way to get...
2009-09-10
942 reads
SQL Lunch - Oracle-CDC for SQL Server Integration Services
We have been working hard trying to get speakers to complete the year for our SQL Lunch schedule. I am...
2009-09-10
716 reads
Updating Existing Data with SSIS
I see a lot of questions on the forums about updating existing data in SSIS. When the update is dynamic...
2009-09-10
22,373 reads
Don't Make Me Work, VIA Rail
I got an email the other day from Canada's VIA Rail, advertising "Discover Canada by Train" and the chance to...
2009-09-10
887 reads
Denver SQL Server User Group Board Meeting Notes from 20090901
To address a few questions on what does the board actually do and to bring more visibility to all of...
2009-09-10
705 reads
Struggling with C#
I taught myself programming with Quick Basic (started with Turbo Basic but couldn’t find a book on it, so bought...
2009-09-09
375 reads
Spools in Execution Plans
I got the question the other day, when are you likely to see a spool in an execution plan? Easy,...
2009-09-09
2,849 reads
Some 24 Hours of PASS Sessions Can Now be Viewed Online
If you missed out on some of the 24 free, live sessions that made up the 24 Hours of PASS,...
2009-09-09
494 reads
Speaking at Space Coast User Group
I have the privilege of presenting, Dive into the Default Trace, at the Space Coast User Group, tomorrow evening (Sept....
2009-09-09
308 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