I had a customer question whether Flyway Desktop (FWD) would cause problems if developers were adding columns into the middle of tables. It’s a valid concern, and this post...
2024-03-22 (first published: 2024-03-15)
437 reads
malotype– n. a certain person who embodies all the things you like the least about yourself – a seeming caricature of your worst tendencies – which leave you feeling...
2024-03-15
27 reads
Wednesday March 13th 2024 I had the honor of speaking at the Redgate Summit in Atlanta and got to meet a lot of new people and get to hang...
2024-03-20 (first published: 2024-03-15)
143 reads
I was trying some stuff out in a notebook on top of a Microsoft Fabric Lakehouse. I was wondering what some of the default values are of the configuration...
2024-03-20 (first published: 2024-03-13)
189 reads
Today is the first Redgate Summit of 2024 in Atlanta. I flew to town yesterday, There is a packed schedule, which is mostly repeated at our other events coming...
2024-03-13
20 reads
Had an absolutely amazing time at SQLBits this year! It was lovely to see all my data friends again and had the opportunity to introduce my husband to everyone...
2024-03-12
51 reads
We’re kicking off a major refresh of my Certified Kubernetes Administrator series at Pluralsight!
The second course “Certified Kubernetes Administrator: Using kubeadm to Install a Basic Cluster” in the updated...
2024-03-22 (first published: 2024-03-12)
156 reads
I focus most of my blog posts on the data platform and how companies can make better business decisions using structured data (think SQL tables), but I’m seeing more...
2024-03-18 (first published: 2024-03-11)
772 reads
DataTune 2024 was a huge success! Thank you so much to the organizers who spent countless months planning and making this an incredible conference! It was so great to...
2024-03-18 (first published: 2024-03-11)
130 reads
(2024-Mar-08) Software installation typically involves several steps. After accepting the license agreement, you may have an express option to streamline the installation process by accepting all defaults, including the installation...
2024-03-13 (first published: 2024-03-08)
585 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