Why I Say Something about Running as Administrator
On a couple of recent webcasts, I pointed out the folks were running with the local Administrator account. To start...
2009-05-28
2,174 reads
Good Article on Data Warehousing Best Practices in SQL Server 2008
If you are involved data warehousing, or even if you are just a beginner, you may want to check out...
2009-05-28
1,510 reads
Give Us TRIM()!
If you're like me, you've probably typed in LTRIM(RTRIM([value])) hundreds, if not thousands, of times during your travels through SQL...
2009-05-28
1,957 reads
I Can Run Hyper-V!
I noted recently that I purchased a new desktop with the intention of moving to Windows 2008 and Hyper-V. That...
2009-05-28
1,654 reads
Minimalist Design - Part 3
One of the labs I frequently do with students is to design a database for a training business, something which...
2009-05-27
1,462 reads
Configuring Auto-Retry on SQL Server Agent
The goal of this post is to explain how to take advantage of Auto-Retry and why you will want to...
2009-05-27
7,273 reads
Catalog view: sys.tcp_endpoints
I was playing around with the endpoint catalog views this afternoon just looking at ways to do poor man's configuration...
2009-05-27
2,841 reads
Speaking at Augusta Developer's Guild
Tomorrow night, May 28th, I'll be speaking the Augusta Developer's Guild. This is a make-up from earlier in the year...
2009-05-27
1,389 reads
Using Windows 2008 as a Workstation
I have a new machine, albeit one with a bad video card, running Windows 2008 Server R2 with Hyper-V. My...
2009-05-27
1,535 reads
Speaking at SQLSaturday #7 in Birmingham on May 30, 2009
I'm flying up Friday afternoon to participate in SQLSaturday #7 which is being led by John Baldwin and his team...
2009-05-26
1,357 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