Idera Greek Sync: Performance Tuning with Execution Plans
On Wednesday July 11th, please join Idera Geek Sync at 11AM Central for a walk through some basics in Execution...
2018-06-24
359 reads
Blog Posts
SQLSaturday Houston!
Thanks for joining me for a full room and a boatload of quick-delivered SQL 2017 information in the second timeslot today at SQLSaturday Houston 2018! Lots of great questions,...
2018-06-23
11 reads
Analyzing Feedback From Music City Tech 2018
I recently presented two sessions at Music City Tech and just received my feedback. I got great feedback and looks...
2018-06-22 (first published: 2018-06-11)
1,475 reads
Moving to Azure: A change in processes – TSQL Tuesday 103
For this month’s t-sql Tuesday our host Bjoern Peters (b/t) wants us to describe our experiences with Azure SQL Database...
2018-06-22 (first published: 2018-06-12)
2,402 reads
Overview of File-group(s) and Piecemeal database restore operations in SQL Server
So far, we discussed many de-facto details about SQL Server database backup and restore. In this 15th article of the series,...
2018-06-22
760 reads
PoshSSDTBuildDeploy 2.0.271.0 - Now With Better Exception Handling!
Hello!
Another quick bulletin about the changes I made to PoshSSDTBuildDeploy today -
2018-06-22
27 reads
Prioritizing Index Performance Pains – What I Learned From Brent Ozar’s Master Index Tuning Class
I love continuing my education in SQL Server. Recently I was fortunate enough to take Brent Ozar’s 3-day live online...
2018-06-21 (first published: 2018-06-12)
2,493 reads
Speaking This Weekend in Iowa City!
Come out to SQL Saturday Iowa at the University of Iowa this Saturday 06/23/2018 for a SQL Saturday that never...
2018-06-21
417 reads
Transaction Logs and Availability Groups
Everyday I learn something new. A couple of days ago I posted about a problem I had with Always On...
2018-06-21
100 reads
Two Types of Performance Counters
I had an issue where an instance of SQL Server was only showing the XTP (In Memory) performance counters. None...
2018-06-21 (first published: 2018-06-11)
2,748 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