SQL Saturday NYC
I excited to say that PASS SQL Saturday NYC is back on the schedule and will be May 30, 2015...
2014-11-25
1,020 reads
NJSSUG SSIS Performance Tuning
On November 18, 2014 I had presented to the New Jersey SQL Server User Group (NJSSUG) on SSIS Performance Tuning. ...
2014-11-21
417 reads
Dating Tips Part 1
This is the first in a series of dating tips, so if you need you’ve come to the right place.
...
2014-02-01
268 reads
SQL 2012 SSIS Catalog Permissions
With the introduction of the SQL 2012 SSIS Catalog there has been the question of what permissions are available and...
2013-07-20
1,113 reads
Use Lookups the right Way
SSIS Lookup tasks are all too easy to abuse as they are easy to setup and not really think about...
2013-05-27
325 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
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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...
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