Fun in Seattle
I know there are a number of people heading to Seattle this weekend for the PASS Summit next week. I...
2009-10-30
1,625 reads
Running to the PASS Summit
Well, not literally. I’m not going to run to Seattle from Denver, but I’ll be running at the Summit.
Last year...
2009-10-30
1,526 reads
PASS Presentation Rehearsal
My friend Trevor Barkhouse called me up a couple of nights ago and asked if I could host a Live...
2009-10-30
1,587 reads
SQL University: Multiple Paths and Ownership Chaining
Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...
2009-10-29
2,677 reads
Diners, Drive-Ins, and Dives – In Seattle
If you’re going to spend 3-5 days in Seattle at the PASS Summit it’s worth sampling the local food rather...
2009-10-29
1,751 reads
Suggested Max Memory Settings for SQL Server 2005/2008
It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something...
2009-10-29
253,862 reads
My PASS Summit 2009 Schedule
Hooray! The PASS Summit is upon us (finally)! Here's what my plans look like for next week:
Monday
My week starts...
2009-10-29
661 reads
Special Events at the PASS Community Summit
If you’ve ever been to a PASS Community Summit, you know that each day is packed with a ton of...
2009-10-29
467 reads
OFF-TOPIC: More about the pregnancy
Quite a few folks have commented about my previous post about missing the PASS Summit, whether publicly or in private....
2009-10-29
892 reads
More Seattle Food
Was browsing on a break and found this, http://www.seattle.com/dining/. Of them I’ve been to Palomino (good) and Ruths Chris (good),...
2009-10-29
757 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