Monday Morning SQL Break – July 11, 2016
It’s Monday and time for this week’s blog and twitter round-up for last week. I spent the weekend with family...
2016-07-11
883 reads
Same Query, Different Servers, Different Performance. Now What?
Based on the number of times I see this question on forums, it must be occurring all the time. You...
2016-07-19 (first published: 2016-07-11)
2,431 reads
Tips to Fix Database Consistency Errors – Reported By DBCC CHECKDB
Overview
While working on SQL Server, sometimes users get stuck in annoying situations when database become inaccessible. After executing DBCC CHECKDB...
2016-07-11
6,093 reads
ETL Modularity
Imagine for a moment that you’ve built a software thing. In fact, we’ll call it Thing. You put a lot...
2016-07-18 (first published: 2016-07-11)
2,093 reads
Basic Statistics with SQL – Introduction
I was a student of statistics in school and college. I didn’t get to use much of anything I learned...
2016-07-10
681 reads
SQL Server – String_Escape function in SQL Server 2016
Hi friends, in SQL server 2016 another string function that introduced is String_Escape. This function can escape special characters within...
2016-07-10
1,527 reads
Join me for a free SQL Performance webcast on July 14th!
With less than we week away, I can say that I’m really excited to reach more people in the community...
2016-07-08
410 reads
Dallas, TX Fallen Officers Relief Fund
If you want to make a Donation to the Dallas, TX Fallen Officers Relief Fund, Please click this Link.
http://bluealert.us/
2016-07-08
413 reads
Converged virtual architectures and SQL Server licensing
Hyper-converged compute architectures, meaning clusters of physical servers with self-contained storage configured for a traditional SAN-less solution, are growing in...
2016-07-08
596 reads
Influence Skills: Live from @LearningTree London Day 4
We've made it to the final day, day 4 of Learning Tree course 294 Influence Skills: Getting Results without Direct Authority.
Today...
2016-07-08
520 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