SSIS – Send Errors to Message Box
While in the process of developing SSIS packages it’s likely you will deal with errors occasionally unless you’re the Superstar...
2009-08-09
1,806 reads
Blog Posts
Active August - Week 1 Recap
Well, I made it through the first week of Active August (Twitter) without killing myself. In my first Active August...
2009-08-08
337 reads
Active August #2
Hrmmm… 198. Up four pounds. That just doesn’t seem possible. I did a tabata on Monday. I did have a...
2009-08-08
539 reads
SQL Saturday Baton Rouge Downloads
I’ve published my materials from both of my sessions from SQL Saturday Baton Rouge on August 1. You can find...
2009-08-08
785 reads
SQLSaturday #16 South Florida Downloads
I presented a 1 hr session at SQL Saturday #16 session PowerShell and SQL Server Administration: In this sesssion we...
2009-08-08
465 reads
Baton Rouge SQL Saturday – Evaluation Summary
Well I just finished reviewing the evaluations for my presentation, Introduction to SQL Profiler, which I gave at the Baton...
2009-08-07
496 reads
Installing Software – HP Mini Netbook
I was heading out on a trip to SQLSaturday #17 recently and decided that I wanted to try and travel...
2009-08-07
937 reads
Introduction To Pearl Knowledge Solutions, Inc
Introduction To Pearl Knowledge Solutions, Inc., an ISV and MSP of Remote Database Administration services.....How we're helping small-midsized companies.
Pearl Knowledge...
2009-08-07
830 reads
PASS News to Be Aware Of
2009 PASS Summit Trip Contest:
If you want an opportunity to win an all expenses paid trip to the PASS Summit,...
2009-08-07
805 reads
Presenting “Understanding Execution Plans”
The PASS Application Development SIG is hosting a web cast next week on Tuesday where I’ll be presenting Understanding Execution...
2009-08-07
821 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers