The old INNER JOIN syntax vs. the new INNER JOIN syntax
I was in a presentation last week where the presenter was talking about the ANSI/ISO SQL standards. For the most part the...
2009-09-30
47,179 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Midlands PASS Chapter October Meeting
Next Meeting - October 6, 2009
Speaker - SQL Server MVP Brian Kelley
Trigger Happy Database Security
In this presentation we'll look at the use...
2009-09-29
1,831 reads
One Step Closer to Being a Technical Trainer
Cross posted from The Goal Keeping DBA:
This is about a long term goal that I’ve had which isn’t posted on...
2009-09-27
937 reads
Trust Is Crucial in Security
Yesterday we were greeted to a ComputerWorld column talking about how Apple had betrayed the Enterprise's trust by having a...
2009-09-16
746 reads
First Meeting of the Charleston PASS Chapter
The first meeting of the Charleston PASS Chapter will take place Thursday night, September 17, starting at 6 PM. The first topic...
2009-09-15
745 reads
PASS Chapter Starting Up in Charleston, SC
Woo hoo! Charleston, SC is starting up a Professional Association for SQL Server official chapter. It is being started up...
2009-09-14
1,100 reads
Remember the Milk: Smart Adds
A while ago, Brent Ozar pointed me to Remember the Milk to help with task tracking. It's a web-based task...
2009-09-08
1,005 reads
Setting Realistic Goals & Learning to Adjust
There is a lot of advice out there about how to get more done and how to accomplish one's dreams. I...
2009-08-31
2,034 reads
Quick 2005/2008 Script to Export Permissions
I had a need to export permissions to be run against the database once an older version was restored (but which didn't...
2009-08-28
13,583 reads
PASS Board of Directors Call for Nominations
This is just a reminder that the call for nominations for the PASS Boards of Directors is open. The final...
2009-08-24
934 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