Upgrading to SQL Server 2012?
Do you have any plans in place to upgrade to SQL Sever 2012 this year. We are now well into...
2013-03-06
1,058 reads
Gethyn Ellis
Virtualising your SQL Server?
Having just completed the latest revision of Learning Tree's SQL Server Virtualisation and consolidation course I thought I'd share with...
2013-03-04
677 reads
SELECT TOP 5 PERCENT WITH TIES
LinkedIn sent me an email on Monday that said my profile was in the top 5% of viewed profiles in...
2013-02-12
874 reads
SQL Server Auto grow
I had a great response to my blog post and poll last week about how DBAs use auto grow. In...
2013-01-16
1,037 reads
SQL Server Consulting: Weekly Round-up
The first full week in 2013 has been a a busy week for me with lots of SQL Server consulting...
2013-01-12
1,004 reads
#SQLSaturdayExeter–Superb SQL Server Event
#SQLSaturday194 is coming to Exeter on the 8th – 9th March.
What is SQL Saturday? The brain child of Steve Jones,...
2013-01-11
762 reads
Auto grow–On or Off Straw Poll
David Postlethwaite who contributes to this blog regularly sent me an email this morning asking about Database Auto grow.
This...
2013-01-10 (first published: 2013-01-07)
2,009 reads
SQL Server Virtualisation and Consolidation
Come and join me in London this March for a 3 day course on SQL Server virtualisation and consolidation.The course...
2013-01-10
1,033 reads
SQL Server Contracting and Business Network Wales - LinkedIn Groups Updates
I have been doing some work on some LinkedIn groups that I manage and look after over the holidays. There...
2013-01-04
866 reads
SQL Saturday #194 Exeter
I have read much about SQL Saturday’s but I have yet to attend one, that is about to change. I...
2013-01-03
833 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