Spend Money to Make Money
One of those old sayings that has a grain or two of truth to it. Stocks, real estate, education even,...
2008-11-25
1,563 reads
Blog Posts
The Advantage of Seattle - Where to host the PASS Community Summit
I heard during last week that the 2009 PASS Community Summit will be back in Seattle, on Nov 3-6 next...
2008-11-25
1,570 reads
Digging into Replication
It's fun to read good work, and my friend Kendal Van Dyke recently posted How CommitBatchSize And CommitBatchThreshold Affect Replication....
2008-11-24
1,416 reads
Immersed in work, and missing out on everything else
After 2 years working on a data conversion and software implementation project, I’ve finally started to get caught up on...
2008-11-24
1,676 reads
Looking Back at the PASS 2008 Summit
I definitely need to write up a few summaries about last week, but right now I'm a bit buried with...
2008-11-24
1,588 reads
Post PASS Summit 2008
So now that PASS is over and life is getting back to normal I thought it would share my final...
2008-11-24
1,598 reads
Raising the Bar
Turning up the heat. Take it up a notch. Stepping up to the plate. Less talk, more action.
However you choose...
2008-11-24
1,641 reads
PASS Day 5 (Fri)
Friday I was up early for breakfast and check out of the hotel, then down to the convention center to...
2008-11-23
693 reads
SQLSaturday #8 Session Evaluations
Session evaluations are one real benefit that speakers derive from participating in community events - a chance to see how they...
2008-11-23
517 reads
The Need to Catch Up
I got back Friday afternoon from the PASS Summit and immediately was busy with family stuff. In fact, through Saturday...
2008-11-23
695 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