T-SQL Tuesday #17 – APPLY Knowledge
We have another opportunity to write as a part of TSQL Tuesday today. This month Matt Velic (Blog | Twitter). Matt...
2011-04-12
531 reads
Blog Posts
T-SQL Tuesday #17 – APPLY Knowledge
It’s that time of the month again… again. Time for T-SQL Tuesday! This month’s event is being hosted by Matt...
2011-04-12
1,244 reads
T-SQL Tuesday #17 – APPLY Knowledge
We have another opportunity to write as a part of TSQL Tuesday today. This month Matt Velic (Blog | Twitter). Matt has proposed a challenge that was derived from...
2011-04-12
9 reads
#SqlBits and SSIS custom components
If you are in anyway interested in SQL Server and live in the UK, you cant of failed to of...
2011-04-11
714 reads
A SQL Server Hardware Nugget A Day – Day 11
For Day 11, I want to talk about the new processor numbering system for Xeon processors that Intel introduced on...
2011-04-11
388 reads
April PASSMN Meeting (April 19)
Every career, whether on purpose or accident, is a journey from one job or project to another. To achieve great...
2011-04-11
579 reads
April Version of SQL Server 2008 Diagnostic Queries
I have added two new queries to this month’s version, to try to collect some more hardware information about the...
2011-04-11
498 reads
Cloud computing – not without risk?
Interesting quote from Sharepoint Best Practices Conference :” 17% of IT Pros think benefits of cloud computing outweigh the risks”!!
That’s not...
2011-04-11
830 reads
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
If you truly want to understand something try and change it.
I saw this quote on facebook last week and it really hit close to home. I had just started working...
2011-04-11
695 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