Hostettler the Viking Needs a New Ship and Your Help
Hostettler the Viking Needs a New Ship…And Your Help.
My good friend Justin Hostettler Davies (Blog@DBExpertise) pinged me a mail in...
2011-04-11
588 reads
Gethyn Ellis
Microsoft Migration Assistant v5.0 Released
As I was surfing around twitter after the marathon TV event that was the Royal Wedding came to end last...
2011-04-06
722 reads
Blog Syndication
I got sent an email recently asking how I went about syndicating my blog on some of the popular SQL...
2011-03-21
1,741 reads
Stored Procedure Definitions and Permissions
I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database...
2011-03-18
2,146 reads
Becoming a DBA: How to gain experience
Last week I had an interesting telephone call from a someone who I connected with on linkedin.com. On Linkedin I’m...
2011-03-16
1,690 reads
Stored Procedure Definitions and Permissions
I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database...
2011-03-14
2,793 reads
The Joy of Contracting
As you may or may not know I have been contracting since 2007, almost 4 years now and I have...
2011-02-21
919 reads
February Update
I haven't written anything for a while and again, for the second month running I missed TSQL2usday. It's a shame...
2011-02-15
489 reads
Shameless Plug: My First SSC Article Published Today
Please forgive the shameless plug. My first article was published today on sqlservercentral.com. It’s titled “Backup and Housekeeping with Maintenance...
2011-01-26
554 reads
Ebooks: Deal of the Day
Apress, as I expect you know, publish some really good SQL Server books. Some of which are on the MCM...
2011-01-24
628 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