For the first workdays of this new year, I had the pleasurable task of resetting a bunch of passwords. The passwords belong to Azure AD users, service principals, SQL...
2023-02-15 (first published: 2023-02-01)
531 reads
The grade for January is a D. Details below, but just not making a lot of progress in these areas. I set goals at the beginning of the year,...
2023-02-01
22 reads
Does Context Info work across databases? This post shows it does. Another post for me that is simple and hopefully serves as an example for people trying to get...
2023-02-15 (first published: 2023-02-01)
218 reads
Data On Rails is a Data On Wheels project designed to give a platform for up and coming data professionals in the data community. This project is the brainchild...
2023-02-01
37 reads
Today’s coping tip is to decide to lift people up rather than put them down. This is something I am trying to practice more as a coach, pointing out...
2023-02-01
14 reads
Tempdb is always a topic for me whether it’s in my sessions or blogs I have written. However, I’ve never been so excited about it then I am when...
2023-02-13 (first published: 2023-02-01)
2,914 reads
If you don’t have the backups of the certificate and private key from the old server, as well as the password used to encrypt the private key backup then...
2023-02-01
210 reads
Today’s coping tip is to take a small step towards and important goal. One of my goals this year was to work on a way to score myself with...
2023-01-31
9 reads
Hello Dear Reader! It's been a while since I had time to sit down and write out a Monday re-capThis past week was my birthday week. With all the...
2023-01-31
28 reads
I was writing some dynamic SQL that generates some SQL statements to load my facts and dimensions into a data warehouse. Some of those SQL statements can become very...
2023-02-17 (first published: 2023-01-31)
654 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