This past week I had a great Client ask an even greater question, and it got me thinking. The question is straightforward (albeit nerdy, which I love). “We’ve enabled...
2021-05-19 (first published: 2021-05-10)
934 reads
A question that came up recently was how to track the query compile time. It’s actually a pretty interesting question because, there aren’t that many ways to tell how...
2021-05-10
13 reads
A question that came up recently was how to track the query compile time. It’s actually a pretty interesting question because, there aren’t that many ways to tell how...
2021-05-19 (first published: 2021-05-10)
544 reads
I 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...
2021-05-10
15 reads
Check out my new blog post-Best practices for migrating Microsoft SQL Server databases to Amazon EC2 using CloudEndure Migration
2021-05-09
14 reads
Check out my new blog post-Best practices for migrating Microsoft SQL Server databases to Amazon EC2 using CloudEndure Migration
2021-05-09
163 reads
I am very excited to announce that I will be speaking for Data Saturday #8 – Southwest US, coming up on Saturday, May 15, 2021. I will be delivering...
2021-05-08
21 reads
I am super excited about this new version of Data Weekender, coming up on Saturday, May 15, 2021. This will be the third time I have been selected to...
2021-05-08
30 reads
In Azure database, security is managed through multiple-layers such as network layer, server layer and database layer. A secure blue print in deploying Azure SQL(more...)
2021-05-08
29 reads
When migrating on-premise SQL Server database to Azure SQL environment, identifying the right compute capacity of the target environment to match the resource consumption of(more...)
2021-05-08
141 reads
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
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