Partitioning Architecture in Azure Cosmos DB.
Introduction In my first article in Cosmos DB, I talked about the basic information about How to provision Cosmos DB, and today we will complete our discussion in How...
2020-07-19
38 reads
Good Bye Import-CliXML – Use the Secrets Management module for your labs and demos
Don’t want to read all this? There are two dotnet interactive notebooks here with the relevant information for you to use. https://beard.media/dotnetnotebooks Jaap is awesome I have to start...
2020-07-29 (first published: 2020-07-18)
519 reads
Renewed as Microsoft MVP for 2020-2021
I have been fortunate enough to be renewed as a Microsoft Data Platform MVP for the calendar year July 2020 to June 2021. I’m honored, humbled, and thrilled that...
2020-07-17
47 reads
Cancelling SQLSaturday Orlando 2020
I’m sure it’s no surprise, but we’ve decided to cancel SQLSaturday Orlando 2020. We decided a couple weeks ago but it’s been tough to summon the energy to write...
2020-07-17
102 reads
Thoughts on the PASS Virtual Summit
Some thoughts on the PASS Virtual Summit this year: Clearly the in-person option wasn’t doable. Just too hard to know infection rate, local rules, employer travel guidelines, attendee and...
2020-07-31 (first published: 2020-07-17)
228 reads
A Travel Milestone: Two Keystones
I used to travel a lot. Last year I flew over 140,000 miles in the air, drive another 1000 or so on vacation, and visited numerous countries. It’s hectic...
2020-07-17
34 reads
Database DevOps – Where do I start?
By now you have most likely heard the term DevOps and you are most likely working for a company that has implemented DevOps is some manner, that could be...
2020-07-29 (first published: 2020-07-17)
601 reads
Using LAST_QUERY_PLAN_STATS in SQL Server 2019
In my opinion, SQL Server 2019 is one of the greatest releases of the product that Microsoft has ever produced. The amount of improvements across the platform really allows...
2020-07-17
32 reads
Using LAST_QUERY_PLAN_STATS in SQL Server 2019
In my opinion, SQL Server 2019 is one of the greatest releases of the product that Microsoft has ever produced. The amount of improvements across the platform really allows...
2020-07-28 (first published: 2020-07-17)
1,107 reads
Daily Coping 17 Jul 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-17
13 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