New Domain - My blog has a new domain name gethynellis.com
About a year ago I started to write a blog, previously to that, for about three years I had been...
2010-11-28
622 reads
Gethyn Ellis
SQLServerPedia – Awards 2010
The results of the SQLServerPedia Awards 2010 are out....I was nominated in two categories and I won the "New to...
2010-11-10
1,093 reads
Post 100 – A Year Gone (not quite)!
I wasn’t going to make a special effort for the one hundredth post on my blog, I was intending to...
2010-11-05
780 reads
SQL ServerPedia – Blog Awards
I have been catching up on some blog posts and I read a few posts by well known bloggers like...
2010-11-04
598 reads
What’s in a Full Backup?
I got asked a question today that I though was quite interesting. If my backup starts at 6pm and it...
2010-11-04
687 reads
TSQL2SDAY #12 - Why are DBA Skills Necessary?
WOW this is the 12th TSQL2Sday albeit this month’s is week early because of the PASS summit next week, so...
2010-11-02
630 reads
Movember – Team IPMO
Some friends of mine decided to support the Movember charity this year. I would try and explain what Movember is...
2010-11-01
713 reads
Bulk Insert Permissions
In order to be able to execute bulk operations you need to certain level of privilege both on the database...
2010-10-28
33,013 reads
What I Did This Weekend
About two weeks ago my good friend and former colleague Justin Hostettler-Davie -JHD (Blog | Twitter) asked me via my wife...
2010-10-18
780 reads
SQL Server Recovery Models
A SQL Server database can be in one of three recovery models. FULL, BULK_LOGGED and SIMPLE. The recovery model you...
2010-10-12
1,967 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