Which version of SSIS-DTS Package Search is right for you
The download page for SSIS-DTS Package search presents three choices:
SSIS-DTS Package Search for SQL Server 2000 on Windows x86SSIS-DTS Package...
2009-08-12
1,477 reads
ThrowAway Scripts
Although I tend to write a lot of formal scripts, as part of the development process I'll explore an object...
2009-08-12
573 reads
Some Statement Start Times!
I thought I had captured statement start times within the DMV sys.dm_exec_sessions. I was absolutely wrong. However, this has sparked...
2009-08-11
959 reads
Security is a Zero-Sum Game...
but I don't mean with respect to privacy. But I do mean with respect to the time it takes securing...
2009-08-11
710 reads
Passed The 70-251 Microsoft Exam
I took the final, non-BI Microsoft SQL Server 2008 Certification Exam on Friday, so now I have finished all of...
2009-08-11
551 reads
The Joy of Data Modelling.
You may think that the task of teasing out the exact nature
of the data and processes within a company...
2009-08-11
2,505 reads
Does File Exist Check in SSIS
A very common need in SSIS is to check to see if a file exist before you run what could be...
2009-08-11
15,185 reads
Review: Motorola H710 Headset
Last week I posted about getting a new bluetooth speakerphone, so I thought I’d follow up with some notes about...
2009-08-11
522 reads
Data Theft
Is employee data theft on the rise? I saw this blog post on the subject, but I had to take...
2009-08-11
795 reads
Journey to trouble-shoot Error 5042 (cannot remove a file xxx because it is not empty)
I was working on a table partition management task yesterday. The table is partitioned on a datetime column, and each...
2009-08-10
8,961 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