Speaking at PASS Summit 2018
I am honored to have been selected to be a presenter at this year’s PASS Summit coming up this November....
2018-06-06
295 reads
Blog Posts
Speaking at PASS Summit 2018!
I found out a few days ago that one of my sessions was selected for Summit this Fall - I will...
2018-06-06
284 reads
The June 2018 SQL in the City is coming
We’ve got the schedule up and you can register today. Once again I’m heading to the UK, along with Grant,...
2018-06-06
1,163 reads
T-SQL aside: replace PRINT with RAISERROR
I was minding my own business innocently reading a blog post by Erik Darling, when this tip smacked me in...
2018-06-06
1,157 reads
Understanding the Role of SQL Server Agent in SQL Server
SQL Server Agent is a component of Microsoft SQL Server that is responsible to execute & schedule tasks or jobs in SQL Server. It runs as a Windows service...
2018-06-06
34 reads
Understanding the Role of SQL Server Agent in SQL Server
SQL Server Agent is a component of Microsoft SQL Server that is responsible to execute & schedule tasks or jobs in...
2018-06-06
4,007 reads
4 Ways To Define Lookup Values In A Query
Watch this week's video on YouTube
Occasionally you may need to create a lookup table of values for a single query. Building a permanent table of these values is a...
2018-06-05
40 reads
4 Ways To Define Lookup Values In A Query
Watch this week's video on YouTube
Occasionally you may need to create a lookup table of values for a single query. Building a permanent table of these values is a...
2018-06-05
12 reads
Bring Your Own Key to Azure SQL Database TDE New UI
In a recent post I wrote about a new functionality for Azure SQL Database’s TDE feature: Bring Your Own Key. At the time the only way to bring your...
2018-06-05
25 reads
Choosing a Color Palette For Your Power BI Report
Color is a powerful attribute in data visualization. In a good visualization, it can focus attention and enhance meaning and...
2018-06-05 (first published: 2018-05-27)
2,660 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