Interview on SQLAuthority.com
Well-known Indian SQL MVP Pinal Dave has posted a short interview he did with me recently. Pinal is the founder...
2009-08-10
568 reads
Why Use Named Pipes?
The other day a colleague and I were shadowing a vendor who was installing their 3rd party application on a...
2009-08-10
24,669 reads
Notes on SQLSaturday #16
I went down to Miramar Fri morning, taking the loooong drive from Sarasota across Alligator Alley on I-75. Miles of...
2009-08-10
491 reads
Adding Multiple Columns to a Table With a Single T-SQL Statement
You know, I believe the old saying, “If you don’t use it you will lose it”. Well, I write a...
2009-08-10
82,556 reads
24 Hours of PASS
Rick Heiges has put together an interesting event coming up on Sep 2, 2009 called 24 Hours of PASS. As...
2009-08-10
841 reads
Networking for Your Career
It's hard to actually put a specific value on networking, and I've been skeptical of it in the past. However...
2009-08-10
1,201 reads
Social Networking: Where Do I Start?
In a blog post a few weeks ago, I wrote about social networking in the SQL Server community. I was...
2009-08-10
1,010 reads
Good News for IT professionals? - Ray of Economic Light Shines in July........
Here's some upbeat info to share as the week kicks off to a new start!
Data just recently released by the Department of...
2009-08-10
699 reads
What's new in Sql server 2008
Hi...Finally... the Complete Enterprise product sql server 2008 is a great product, it has everything includes features which other competitors...
2009-08-10
917 reads
SSIS – Send Errors to Message Box
While in the process of developing SSIS packages it’s likely you will deal with errors occasionally unless you’re the Superstar...
2009-08-09
1,807 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