The MVP Summit Wrapup
This week I've been at the Microsoft MVP Summit in Washington State. This is my second summit, and I was...
2009-03-05
1,109 reads
Book Review: eBoot Camp, Proven Internet Marketing Techniques to Grow Your Business
My friend Chris loaned me his copy of eBoot Camp as I'm trying to strengthen what I consider to be...
2009-03-04
374 reads
Database Mirroring FAQ: How do we handle transaction log maintenance for a mirrored database?
Question: How do we handle transaction log maintenance for a mirrored database?
This question was asked on a technical discussion group....
2009-03-04
23,520 reads
[Off Topic] Get Fit in February – Wrap Up
During the month of February, I participated in the Get Fit in February challenge last month. Along with a few...
2009-03-04
632 reads
Owning an Object in SQL Server 2005/2008
One of the things that we have to re-learn when going from SQL Server 2000 to 2005/2008 is that objects...
2009-03-04
6,677 reads
SQL Agent Job failure with FTP connection
There are hundreds of post on this topic but I just ran into this problem recently so I thought I...
2009-03-04
1,533 reads
Book Review - Naked Conversations
This was one of the first books that I grabbed on my Kindle at the Business of Software Conference in...
2009-03-04
386 reads
Book Review - Team of Rivals: The Political Genius of Abraham Lincoln
I've been reading this for a few weeks and finally finished. Team of Rivals came up during the Presidential campaign...
2009-03-03
347 reads
A Mention on SQL Authority
I met Pinal Dave, whose blog I've followed for a year or so and just started to correspond with. A...
2009-03-03
578 reads
Branding on ESPN
I was listening to Colin Cowherd and the Herd one morning and he was talking about the Los Angeles Dodgers...
2009-03-03
594 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