After Seven Years, Time for Something New
Earlier this month, I passed the seven year mark at Digineer. It was a weird feeling, since the last time...
2012-09-14
709 reads
Blog Posts
Book Review: SQL Server 2012 Integration Services Design Patterns
This book is written by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss, and Michelle Ufford. These are all highly...
2012-09-14
2,791 reads
Certificates of Completion for SQL Seminars
Most managers and employers distinguish between attending a conference and training. We (the royal SQL community we) offer quite a...
2012-09-14
1,121 reads
Change file logical name for mirror database
Today I encountered a interesting issue when rename logical name for mirror database.
We have a database which has been setup...
2012-09-14 (first published: 2012-09-09)
3,080 reads
Conference in Florida: SQL Server Live
This conference is new to me. In case it’s new to you, I thought I’d take a moment to point...
2012-09-14
982 reads
Detecting and Removing Duplicate Indexes
Indexes are the solution to many performance problems, but with too many indexes on tables can hurt the performance of...
2012-09-14
1,824 reads
Interesting Culture
A post from Alex Maccaw, programmer at Stripe. He talks about some things he likes about the company, and overall...
2012-09-14
1,204 reads
Register for Sean’s Dallas precon!
On October 13, Dallas will hold our second ever Special Bi Edition of SQLSaturday Dallas - #SQLSat163 for you Twitter folk...
2012-09-14
1,088 reads
Sleepless in Seattle – SQL in the City 2012
A few years ago I went to Seattle a few days before the PASS Summit started. I took my middle...
2012-09-14 (first published: 2012-09-10)
1,907 reads
Something for the Weekend – SQL Server Links 14/09/12
It’s SFTW Time, I hope you’ve had a great week!
Make sure you don’t miss this weekly round-up of SQL Server Links,...
2012-09-14
1,533 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
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
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
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