No In-Person SQLBits For Me
I am saddened to report that I will not be able to attend SQLBits in person this year as originally planned. I was involved in a terrible car accident...
2023-02-24
44 reads
One Thing You Wish You Knew While Learning PostgreSQL: PGSqlPhriday #006
I will not even attempt to hide it, I’m very much in the learning phase of my PostgreSQL journey. As such, I’m constantly picking up new facts. However, I’m...
2023-02-24
19 reads
Daily Coping 24 Feb 2023
Today’s coping tip is to be gentle with someone you feel inclined to criticize. It’s very easy, and maybe very human, to start to criticize others for doing something...
2023-02-24
22 reads
Speaking at Data Saturday Rheinland – Migrating SSIS to ADF
I’m pleased to announce that I’ll be talking about how you can migrate your SSIS skills to Azure Data Factory at Data Saturday Rheinland. At the time of writing...
2023-02-24
21 reads
Architecting MS SQL Server on VMware vSphere 8.0 released
I’m thrilled to announce that the “Architecting Microsoft SQL Server on VMware vSphere” 8.0 best practices guide has been released! I’m pleased to have been able to contribute to...
2023-02-23
223 reads
Daily Coping 23 Feb 2023
Today’s coping tip is to give sincere compliments today to people. A tough day recently coaching, but I kept this in mind. Complementing parents, competitors and fellow coaches, and...
2023-02-23
23 reads
A Test Client for Zero Downtime Deployments
I’ll be at VS Live in Las Vegas this March to discuss zero downtime deployments. If you want to come and join me for this session, or any of...
2023-03-03 (first published: 2023-02-22)
180 reads
Daily Coping 22 Feb 2023
Today’s coping tip is to share something you find inspiring, helpful, or amusing. Maybe not inspiring to you, but it was for me. We recorded a number of customers...
2023-02-22
22 reads
Daily Coping 21 Feb 2023
Today’s coping tip is to respond kindly to everyone you talk to today. This is often easy for me. I did this last week while traveling. I got coffee...
2023-02-21
28 reads
What Happens On AWS RDS?
I was talking with some developers from my team about monitoring, and I said, “We all use the same tools,” referring to other monitoring software. Then, it hit me....
2023-02-21
26 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
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
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
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