SQLSaturday #40 – South Florida Recap
I had the great privilege to be able to attend and speak at SQLSaturday #40 – South Florida this past weekend...
2010-08-02
655 reads
Jack Corbett
- Interests: Sports, books, Bible
Personal or Professional Ethics
Steve Jones had an interesting blog post the other day, Do as I Say, Not as I Do, and I...
2010-07-30
1,541 reads
Interviewed by Andy Leonard
Andy Leonard is posting interviews of all the candidates PASS Board of Directors on his blog and mine is up...
2010-07-28
390 reads
Speaking at SQLSaturday #40 – South Florida
I finally get to head down to Miramar to speak at SQLSaturday #40 – South Florida. I really wanted to go...
2010-07-27
338 reads
How I Prepared to Run for the PASS Board
The Boy Scouts have “Be Prepared” as their motto and, while I was never a scout, I think it’s always...
2010-07-23
330 reads
July OPASS Meeting Wrap up
Last Tuesday, July 13th, we had our monthly OPASS meeting. The meeting was sponsored by RedGate who were kind enough...
2010-07-20
456 reads
I’m All In – Running for the PASS Board
Yes, I’m going to run for the PASS Board of Directors. I have my application and will be sending it out...
2010-07-19
541 reads
ANSI PADDING, Trailing Whitespace, and Variable Character Columns
What does ANSI_PADDING mean and how does it affect my SQL Server database?
2010-07-16 (first published: 2008-09-12)
25,482 reads
Article Featured on SQLServerCentral
My article, ANSI Padding, Trailing Whitespace, and Variable Length Character Columns, is featured in today’s SQLServerCentral newsletter. Check it out!...
2010-07-16
364 reads
July OPASS Meeting
OPASS will be holding it’s July meeting this evening from 6pm – 8:30pm at 225 S. Westmonte Drive, Altamonte Springs, FL. ...
2010-07-13
432 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