Images in your blog
In a recent talk I gave, I recommended using images to spice up your blog. I think it's great, and...
2009-10-19
637 reads
Melbourne SQL Server Group is Fifth Stop in Down Under Tour
I spoke at the Melbourne SQL Server Users Group on Monday, October 12, 2009. The group meets at lunch time...
2009-10-19
444 reads
PASS Update #16
A one topic post this time. As a candidate for Vice President of Marketing for PASS this year I asked...
2009-10-18
629 reads
Fundamentals of Storage Systems – The System Bus
In my last post The Basics of Spinning Disks we covered hard drives, the back bone of our IO system....
2009-10-18
1,138 reads
SQL Saturday #21
I presented a 1 hr session at SQL Saturday #21 session SQL Server PowerShell Extensions: In this sesssion we will...
2009-10-18
399 reads
Post SQL Saturday #21 Orlando
Today I gave a two part session at SQL Saturday in Orlando. When originally planning this years event Andy Warren said many people who...
2009-10-17
1,328 reads
Shipping
I've got a conference to attend in a few weeks, and needed to get some things out the door. Every...
2009-10-16
635 reads
Table Variable and Temp Table
Today I come across the great blog by Wayne Sheffield on Sqlservercentral.com about temp table and table variable so I...
2009-10-16
583 reads
PASS Board of Directors Debate - Transparency and Vision
There is an amazing debate occurring on Brent Ozar's blog where he interviewed Matt Morollo. Being a little out of...
2009-10-16
1,380 reads
Vetting the PASS Board of Directors candidates
I've had a pretty heavy involvement in Brent Ozar's interview of Matt Morollo. The reason for my intense activity is he was...
2009-10-16
1,362 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