Book Review: SQL Server 2008 Query Performance Tuning Distilled
I recently finished reading the Apress book SQL Server 2008 Performance Tuning Distilled by Grant Fritchey and Sajal Dam. I...
2010-01-07
1,349 reads
Jack Corbett
- Interests: Sports, books, Bible
2010-01-04
763 reads
Final Recap – 2009 Goals
Well, I set 7 professional goals for 2009 and I did okay in meeting them, but I was not successful...
2009-12-31
1,388 reads
Presenting a Live Meeting vs. a Real Meeting
I recently had the opportunity to present, Nuggets Found by Mining the Default Trace, for SQLLunch. This was my first...
2009-12-28
347 reads
OT: What Christmas Means to Me
Merry Christmas to everyone. As many of you know, at least I hope you do, I am a born-again Christian...
2009-12-24
358 reads
Speaking at SQLSaturday #32 – Tampa
I just found out that I’ve been accepted to speak at SQLSaturday #32 – Tampa on January 23, 2010. My session...
2009-12-23
376 reads
SQLLunch Resources – Mining Nuggets from the Default Trace
I did my first SQLLunch today and it was fun. I don’t know how many attended, my last look was...
2009-12-21
362 reads
Have Lunch with Me
I know you all are clamoring for the opportunity to have lunch with me so I agreed to do a...
2009-12-18
343 reads
Where’d the Data Go?
The Reported Problem
A few weeks ago I was contacted by a former employer because an SSRS report I had written...
2009-12-17
412 reads
What is Your Biggest Weakness?
I was tagged by Ken Simmons (@kensimmons) in the blog chain started by David Stein (@made2mentor). Here’s Ken’s post and...
2009-12-14
510 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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