Play the T-SQL Alphabet Game
I recently had the opportunity to play the T-SQL Alphabet Game, which was introduced to me by SQL Server MVP,...
2009-01-21
1,258 reads
Blog Posts
Video: xp_cmdshell execution in SQL Server 2005/2008
The video I did for Jumpstart TV on xp_cmdshell execution has hit the front page. Registration on the site is...
2009-01-21
689 reads
Conficker / Downadup Worm One More Time
Hopefully by now everyone has seen this, but if not, here's a reminder to continue to spread the details. Denis Gobo...
2009-01-20
918 reads
Fake LinkedIn profiles with links to malware
This is a little old (five days based on the last update), but TrendMicro put on their blog about fake...
2009-01-20
930 reads
Getting Information Where We Want It
I’ve been running every day, over 100 days in a row now, and one of the things that has helped...
2009-01-20
855 reads
Netbooks & Alternatives
A while back I mentioned that Radio Shack had an interesting promotion on a netbook and debated at what price...
2009-01-20
1,300 reads
Networking - Part 3
Continuing the conversation I began in Part 1 & Part 2, today I want to ruminate some more on networking. I've...
2009-01-20
1,140 reads
Kindle Review – How I Read
In the last 4 months of having the Kindle, I’ve gone through a few different ways of reading on it...
2009-01-19
962 reads
We Are Microsoft charity challenge
I got the opportunity to participate in the We Are Microsoft Charity Challenge (under the umbrella of GiveCamp) in Dallas...
2009-01-19
696 reads
Book Reviews - Worthwhile?
Lately I've been thinking (again) about books and book reviews, mostly because I'm looking to see if it makes sense...
2009-01-18
927 reads
Blogs
Ten Years of PowerShell
Ten years ago, I published a post about filming a Pluralsight Play by Play...
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...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
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