PASS Data Community Summit 2025 Slides and Code
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with Automation! I will have a more comprehensive post in the coming days. Slides and demo...
2025-11-21
49 reads
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with Automation! I will have a more comprehensive post in the coming days. Slides and demo...
2025-11-21
49 reads
Tech conferences aren't just for networking and learning how to address a problem you're having technically. They are also for expanding your view of what's possible.
2025-12-03 (first published: 2025-11-20)
15 reads
When I created the website on WordPress, I was expecting all the features I had on our WordPress.com which powers this website. As I called out in my previous...
2025-11-21 (first published: 2025-11-20)
35 reads
I wrote a piece on the new SUBSTRING in SQL Server 2025 and got asked a question. How do we get the last last name, such as only getting...
2025-11-19
160 reads
The terminology around reliability is a mess If you’ve ever said, “We’re covered, it’s replicated,” you’re in good company. SQL Server is a massive, 35+ year-old product that...
2025-11-19
31 reads
If you aren’t watching the Ignite keynotes today, then you might have missed the announcement that SQL Server 2025 officially releases today. The main SQL Server page gives you...
2025-11-18
54 reads
Short version You want to get this running as fast as possible. Do these four steps, and then check the compatibility section later in this post. Step 1: Install...
2025-11-18
69 reads
Last week I asked you to write about SQL Server 2025 and what things you might be looking forward to in the new version. First, as usual, is Rob...
2025-11-18
147 reads
Writing Better Dynamic SQL
This updated and "sort" of a style guide is for SQL developers and, to some extent, DBAs, essentially anyone daring (and sometimes...
2025-11-18
385 reads
Holy cow FabCon Vienna was incredible! This recap is extremely delayed because I’ve run into some serious decision fatigue about what to include (and my amazing hubby got me...
2025-11-18
18 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
Comments posted to this topic are about the item 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