Loop Through Excel Files in SSIS
You can loop through excel files using SSIS. This will use the For Each Loop container and a data flow...
2013-09-16
1,993 reads
Announcing the SQLpassion Online Academy
Over the last weeks it was a little bit silent on my Weblog for a very good reason: I’m very...
2013-09-16
828 reads
Free Conference Pass to SQL Server Live! in Orlando
Want a free pass to the SQL Server Live! conference in Orlando this year? Look no further, here is your...
2013-09-16
657 reads
SQLSaturday #250 Pittsburgh
SQLSaturday #250 Pittsburgh is in the books, and I'd like to sincerely thank the organizers, sponsors, volunteers, and speakers for...
2013-09-16
492 reads
Thoughts About MS Advanced Certification
Now MS has decided to cancel all its advanced certifications. I am here to share some of my thoughts on...
2013-09-16
394 reads
Thoughts About MS Advanced Certification
Now MS has decided to cancel all its advanced certifications. I am here to share some of my thoughts on...
2013-09-16
748 reads
Certifications: What are they good for?
Reblogged from SQL Studies: Since Microsoft decided to drop the MCM/MCA program there has been an enormous amount of discussion...
2013-09-16
627 reads
SQL SERVER 2012 - How to get a value from previous result row effectively
Reblogged from SQL Server Portal: I came across this query many times and most often we need the previous row...
2013-09-16
700 reads
10 signs you're not talking to a developer
Reblogged from the pluralsight blog: There are many types of developers out there. And while not all speak the same...
2013-09-16
852 reads
SQL Server – How to Create Registered Servers to Easily Manage and Query Multiple Instances at a Time
Registered servers is a great way to manage, categorize and access the SQL servers through SSMS and also one of...
2013-09-16
505 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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