LinkedIn - Part 2
Recently I posted LinkedIn (part 1) about my efforts to better understand and use it as a networking platform. It...
2009-04-01
516 reads
Blog Posts
Moving to MySQL
It’s time. After years of building this site to work with SQL Server, I sold it to Red Gate Software....
2009-04-01
495 reads
Undocumented Trace Flag Improves Performance By Up To 25%
As a production DBA I love to tweak things to optimal perfection. After all, if I paid for the hardware...
2009-04-01
546 reads
Buying A Plane
There's been a lot of bad press about 'corporate jets' in the news over the past year. Not that planes...
2009-03-31
1,477 reads
Keeping Relevant in the Face of Changing Technologies
I was recently asked by a co-worker on my team at work what he should do to keep up with...
2009-03-31
1,889 reads
Lunch in Town
One of the guys I met at the Denver User Group pinged me last week for lunch, and I agreed....
2009-03-31
1,817 reads
Microsoft Project Migration Template for the move to SQL 2008
If you are planning a move to SQL Server 2008, although this process can apply for many Database Migrations, perhaps...
2009-03-31
4,828 reads
Orlando .NET Code Camp 2009 Recap
On Saturday, 3/28, I presented Useful T-SQL Statements You May Not Be Aware Of at the 2009 Orlando .NET Code...
2009-03-31
1,450 reads
SQLSaturday #15 in Jacksonville
The call for speakers is still open and will close April 6th, there's still from for a few more sessions....
2009-03-31
1,339 reads
The Prius Update
Our second major repair will take place on the Prius, and once again it’s a cosmetic item. In fact, we’ve...
2009-03-31
1,901 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