Tales, Travels and Travails of the NYC DBA....
So, finally, I got my SQLServerCentral.com Blog, that Mr. Jones was kind enough to set up. Many thanks SJ!
My very...
2009-08-07
546 reads
PASS News to Be Aware Of
2009 PASS Summit Trip Contest:
If you want an opportunity to win an all expenses paid trip to the PASS Summit,...
2009-08-07
806 reads
Baton Rouge SQL Saturday – Evaluation Summary
Well I just finished reviewing the evaluations for my presentation, Introduction to SQL Profiler, which I gave at the Baton...
2009-08-07
500 reads
Use SQL Compare by Red Gate to Find a Missing Index
A couple of weeks ago one of our developers sent me an email saying, “I have a query that returns...
2009-08-07
4,386 reads
Installing Software – HP Mini Netbook
I was heading out on a trip to SQLSaturday #17 recently and decided that I wanted to try and travel...
2009-08-07
937 reads
Introduction To Pearl Knowledge Solutions, Inc
Introduction To Pearl Knowledge Solutions, Inc., an ISV and MSP of Remote Database Administration services.....How we're helping small-midsized companies.
Pearl Knowledge...
2009-08-07
834 reads
Book Review: Magnificent Desolation
Magnificent Desolation by Buzz Aldrin ($18 @Amazon) is his second autobiography (haven’t read the first one Return To Earth). I...
2009-08-06
358 reads
The effects UNION in a SQL query
In a recent blog, I shared some of the natural but sometimes unanticipated consequences of adding DISTINCT to a SELECT...
2009-08-06
595 reads
Scripting in SSIS
Tim Mitchell presented at SQLSaturday #17 on Scripting in SSIS. I thought it was a really interesting presentation, and I’m...
2009-08-06
2,245 reads
Review of Bluetooth Speakerphone
I was visiting Compusa recently looking for a couple small things and noticed the Samsung Bluetooth Speakerphone for $24.99 (can...
2009-08-05
399 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