A New Word: Rubatosis
rubatosis– n. the unsettling awareness of your own heartbeat, whose tenuous muscular throbbing feels less like a metronome than a nervous ditty your heart is tapping to itself, as...
2024-03-22
364 reads
Dear Women in Tech, You Can Present at EightKB, Too
Last year, I submitted and was accepted to present at the EightKB conference. At first, I thought my current presentation wasn’t advanced enough, but Tracy Boggiano convinced me otherwise....
2024-03-29 (first published: 2024-03-21)
180 reads
SQL Compare Force Column Order in a Table
I had a client that was concerned about SQL Compare behavior when a developer adds a column to the middle of a table. I wanted to reassure them, so...
2024-04-03 (first published: 2024-03-20)
398 reads
Speaking at dataMinds Saturday & Techorama 2024
I have the pleasure to announce I’ll be presenting at two conferences this spring. The first one is at dataMinds Saturday 2024 (back in-person!): Yes, it’s a long abstract...
2024-03-29 (first published: 2024-03-20)
100 reads
Interview around DevOps, Data, AI and Microsoft Fabric
A few weeks ago I did an interiview with Nagaraj Venkatesan – a good friend of mine who works for Microsoft Singapore. You can watch video below – I...
2024-04-01 (first published: 2024-03-20)
189 reads
Goals for 2024
Way back in 2019 I set some goals…. well I wrote some goals and posted them here 2019 seems a lifetime ago…..that was the year I travelled 200,000 air...
2024-03-20
49 reads
DevOps: It’s About the Team, Not Just the Tech
In November 2023 I did a session at PASS Summit and one of my sessions was voted https://passdatacommunitysummit.com/about/news/have-you-watched-some-of-the-most-popular-sessions-from-summit-2023/ That session was called DevOps is about Growing People rather than...
2024-03-27 (first published: 2024-03-20)
210 reads
What Does Redgate Test Data Manager Do?
At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM), which was a new product for us. You can watch the video linked above to...
2024-03-27 (first published: 2024-03-18)
152 reads
Extracting PostgreSQL database metadata for presentation in Excel format
(2024-Mar-16) I have been a big fan of using the Excel application for various tasks for more than half of my life. I believe it's the most widely used spreadsheet...
2024-03-25 (first published: 2024-03-16)
283 reads
Change Notebook Spark Session Time-Out in Microsoft Fabric
You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric and suddenly you have to leave your workstation for a while. Someone ran the doorbell...
2024-03-25 (first published: 2024-03-16)
139 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