T-SQL Tuesday #62 – Healthy SQL
The invitation for T-SQL Tuesday this month comes from Robert Pearl. It’s called HealthySQL and it’s a topic I like....
2015-01-13
807 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
2015-01-13
2,359 reads
Data Lakes
An interesting new paradigm popped up in the news this week: the data lake. It examines data as a model for organizational architectures.
2015-01-12
211 reads
Multiple Backup Files
This Friday Steve Jones looks at your backup system and wonders how many people use striped backups.
2015-01-09
441 reads
2015-01-09
1,693 reads
Building Connection Strings
I ran across a great article on Connection Strings from my good friend, Allen White (b, t, c), recently. Quite...
2015-01-08
1,047 reads
Two Days Off
Verizon is taking their cloud service offline for maintenance for two days. Steve Jones doesn't think that sounds good.
2015-01-08
221 reads
2015-01-08
2,466 reads
Test Your Situation
One of the important things is to be able to recover your environment. That doesn't mean you need to know everything about SQL Server and potential disasters, but you should know their affect on your situation.
2015-01-07
132 reads
2015-01-07
2,350 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