Hello Dear Reader! This past week was a busy one. As we've started to settle into the new house we are transitioning from eating out or having meals delivered,...
2023-06-19
58 reads
I’ve been working with Ryan Booz a bit more and as we’ve talked over the last few weeks, he has asked me a few times if I’ve booked travel...
2023-06-16
28 reads
astrophe n the feeling of being stuck on Earth. Us geeks are supposed to love space, right? Science Fiction? The Moon is a Harsh Mistress? Star Trek/Star Wars/Lost in...
2023-06-16
55 reads
At the end of 2021, I started using the new SFTP preview feature on Azure Data Lake Storage Gen 2. It was a great new addition to the...
2023-06-16
7 reads
This all started because I wanted to follow Tracy’s directions on setting up Ola for index maintenance in Runbooks. I couldn’t set up the automation account permissions unless I...
2023-07-03 (first published: 2023-06-15)
246 reads
In previous posts we've looked at a number of aspects of Always Encrypted and how it works. I think it's very useful to understand how it actually works in...
2023-07-03 (first published: 2023-06-15)
260 reads
I’m in Cambridge, UK this week for the internal Global Marketing Week and Level Up Conference. This is my first visit to Cambridge in 2023, and we have a...
2023-06-30 (first published: 2023-06-14)
270 reads
Here we look at a common query "anti-pattern" that can create performance problems - and how you work around it.
2023-06-14
416 reads
I repeat the phrase “If you aren’t monitoring it, you can’t measure it” all the time. Through my IT career, this has been a constant. If you don’t have...
2023-06-14
13 reads
In this post we’ll look at how you interact with data that is encrypted using Always Encrypted. The examples here will show how you run queries from SSMS, in...
2023-06-13
49 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 Stored Procedures for Server-Level Object...
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
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