Article re-featured on SQLServerCentral
The second article I had published on SQLServerCentral, ANSI PADDING, Trailing Whitespace, and Variable Length Character Columns, was re-featured in...
2009-07-31
1,415 reads
Jack Corbett
- Interests: Sports, books, Bible
ActiveAugust –> Getting More Fit
ActiveAugust started as a discussion on Twitter and Mike Walsh (@mike_walsh) has set the bar with his blog post about...
2009-07-28
1,201 reads
SQLSaturday 21 – Orlando Announced!
Andy Warren and crew at OPASS have announced that SQLSaturday 21 – Orlando will be held at Seminole Community College, 100...
2009-07-28
1,303 reads
Learning some javascript
As part of my work I need to be a “Jack of all trades” meaning I not only need to...
2009-07-24
645 reads
Meet, Greet, & Remember?
How many of you have said, “I have a real hard time remembering names” or “Excuse me, I know we...
2009-07-21
416 reads
Mystery of Failing Database Mail
Have you ever seen this error when you have setup database mail:
The mail could not be sent to the recipients...
2009-07-20
434 reads
July OPASS Meeting Recap
Last night I attended, along with about 20 others, the latest and greatest OPASS meeting. I got there early to...
2009-07-15
536 reads
Off Topic – Why I’m unclebiguns on Twitter
There may be some people wondering why I go by the name @unclebiguns on Twitter. I am basing this on...
2009-07-15
400 reads
OPASS Meeting July 14th
Hey, Orlando area SQL Server folks, don’t forget the OPASS meeting 6pmTuesday, July 14th at End to End Training (map). ...
2009-07-13
448 reads
Mid-year update on my goals
I recently saw that Steve Jones had posted an update on his 2009 goals and realized that is was about...
2009-07-07
375 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