Error Importing DTS package in SQL Server 2008
Opening DTS packages on a 2008 SQL Server requires several steps to be able to view the packages in a...
2009-08-26
1,590 reads
Writing Technical Articles - A Few Simple Tips
A few simple tips that I've learned over the years. Keep these in mind as you write your next article.
That...
2009-08-26
1,039 reads
Application and Multi-Server Management With SQL Server 2008 R2
Microsoft has published a good whitepaper that explains the new functionality in SQL Server 2008 R2 that will allow you...
2009-08-26
609 reads
Microsoft SQL Server 2008 Books Online (July 2009)
Microsoft has released the July 2009 standalone version of Books Online (BOL) for SQL Server 2008, which you can get...
2009-08-26
680 reads
PASS Connector Editorial for August 26, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-08-25
551 reads
Continuous Integration in a Development Environment using Red Gate Backup and SQL Compare
My co-worker and fellow DBA, Leigh Freijo has a blog entry about a Powershell script he created to re-integrate QA/Development database changes...
2009-08-25
1,110 reads
Database Mirroring Across Domains, Using Certificates.....
Database Mirroring w/o a Domain, Can be a Pain - but it can be done......
Have you ever had to setup mirroring...
2009-08-25
6,543 reads
PASS Board Nominations
I think the Professional Association of SQL Server users (PASS) is an extremely important organization for SQL Server DBA’s. Even...
2009-08-25
671 reads
Professional Growth – Community Involvement
As part of my professional development and to help raise my professional profile, I have become more involved with my...
2009-08-25
614 reads
Featured Blogger: Alexander Kuznetsov
I’ve been reading his blog for a while and getting consistently good value. I’d categorize it as a SQL blog...
2009-08-25
723 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