Update duplicate xml attribute values to unique value
I was going through some really old blogging ideas and I stumbled over this one and seeing as I love...
2016-06-23
1,117 reads
Automating Azure Resource Management Authentication
I love Azure and I love PowerShell. They are a perfect marriage. It’s amazing how much automation you can do...
2016-06-23
546 reads
Comparing databases using SSDT
Another Twitter-born blog post! I love getting new ideas from the community. Real world ideas for solving real world problems!
The...
2016-06-23
1,284 reads
Selecting Speakers for the Summit
This is a series of posts on the PASS Summit and SQL Saturdays. I’m outlining some thoughts here, sometimes for...
2016-06-23
498 reads
Azure SQL Data Warehouse pricing
The pricing for Azure SQL Data Warehouse (SQL DW) consists of a compute charge and a storage charge. For compute, it is...
2016-06-23
917 reads
I’m speaking at Summit!
I’m excited to announce that I have been selected to speak at PASS Summit again this year! I’ll be presenting...
2016-06-23
347 reads
What if Your Employer Won’t Support Your Career?
I’ve had a lot of luck in my career, especially as it pertains to my work environment. Although I can’t...
2016-07-01 (first published: 2016-06-23)
2,046 reads
Comparing databases using SSDT
Another Twitter-born blog post! I love getting new ideas from the community. Real world ideas for solving real world problems!
The...
2016-06-23
329 reads
Azure Cortana Intelligence Suite – with Azure Data Catalog
[read this post on Mr. Fox SQL blog] I presented at our local Melbourne SQL Server User Group (SSUG) this week on Azure Cortana Intelligence Suite – and the integration with the...
2016-06-23
21 reads
Azure Cortana Intelligence Suite – with Azure Data Catalog
[read this post on Mr. Fox SQL blog]
I presented at our local Melbourne SQL Server User Group (SSUG) this week on Azure Cortana...
2016-06-27 (first published: 2016-06-23)
1,888 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers