A Big Milestone-SQLSaturday #100
Just announced yesterday, SQLSaturday #100 will be held in Brazil on November 26, 2011. Just a little over four years...
2011-07-19
774 reads
Blog Posts
A Guest at the Ranch
From the other side of the world, I had a guest at the ranch today.
Pinal Dave, a friend from...
2011-07-19
822 reads
Denali–IIF and CHOOSE
In Denali CTP3, we have a new of new functions to play with. For this post, im going to focus...
2011-07-19
805 reads
Knowing Someone Makes a Difference-Part 1
I’ve put a lot more emphasis on networking in the last few years and I’ve always considered it an investment,...
2011-07-19
618 reads
SQL in the City (London) is a Great Success
This is what my audience looked like from the stage just before I started speaking at the first of my...
2011-07-19
997 reads
SQL Server – SET STATISTICS [IO|TIME] ON
My colleagues and I often joke around with “If it takes less than a second, then it’s okay!”. The reason...
2011-07-19
1,478 reads
The SQLSaturday Sensation - Celebrating the 100th Event!
The SQLSaturday Sensation!
Congratulations, Brazil! You are the recipient host country for SQLSaturday #100!! On Saturday, November 26, 2011, when the...
2011-07-19
2,437 reads
Un-SQL Friday #005: Bad Interviews
Yesterday a friend told me a tale of an interview he conducted with a, shall we say, less than desirable...
2011-07-19
705 reads
Vote for the 2011 Exceptional DBA of the Year Award
It’s been my experience that most DBA’s aren’t properly recognized for their contributions to their organizations. As the “protectors of...
2011-07-19
743 reads
Denali SQLPS First Impressions
I’ve taken a few hours to try out Denali CTP 3 sqlps and noticed some welcome changes. The biggest change...
2011-07-18
2,047 reads
Blogs
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...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
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