My Prize Has Arrived!
Back in November, I was lucky enough to be nominated and then got enough votes to win the New to...
2011-01-17
548 reads
Gethyn Ellis
Which Process ID is SQL Server running on?
There was an interesting question posted on a forum recently, asking how can you tell which sqlservr.exe process (shown in...
2011-01-04
5,992 reads
Happy New Year
Well it’s Friday again and another big day.
Hopefully you all had a great Christmas and as we move to...
2010-12-31
1,502 reads
SELECT * FROM SQLBLOGGERS WHERE LOCATION = ‘UK’
I published a post yesterday where I listed my top 5 bloggers from the worldwide SQL community for 2010. The...
2010-12-30
1,930 reads
SELECT TOP 5 * FROM BLOGGERS
Hopefully my title gives away what this post is about. This my list of the top five people or more...
2010-12-29
538 reads
Merry Christmas
This is just a short post for a Friday and not just any old Friday either, Santa is on his...
2010-12-24
564 reads
SQL Bits 8
It seems the dates for the next SQLBITS have been released will take between April the 7th and April 9th...
2010-12-23
508 reads
Should I have AutoGrowth enabled on my SQL Server Database
I was reading a few forum posts yesterday where a few people were complaining that the transaction log had grown...
2010-12-22
1,997 reads
Turn Off AutoShrink!
This is kind of a follow up to a post I published last week regarding autogrowth. A forum poster said...
2010-12-20
616 reads
Let it Snow, Let it Snow, Let it Snow!
I don’t usually post on my blog on the weekend, but this weekend, the weekend before a Christmas is a...
2010-12-18
490 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