PASS Summit 2011 Day -2 (Monday), part 2
Today was a good day. I posted about the first part of today earlier, and we left off there with...
2011-10-11
519 reads
Blog Posts
PASS Summit Q&A RoundTable Discussion w/MVPs and Presenters...
Hello, SQL Community and PASS Summit attendees!
This is an exciting week for all of us! It's wheels down for so many in...
2011-10-11
753 reads
Remove All Foreign Keys
To clear test data from a database we could use truncate commands but sometimes we need to get rid of...
2011-10-11
40,825 reads
Useful queries #3: Get SQL Server Edition, Version, Build and Last Update date and time.
Keeping track of all the versions and editions SQL Server instances can be a daunting task if you don’t have...
2011-10-11
1,257 reads
Using Custom Code Functions in Reporting Services Reports
Reporting Services is one of those tools that just keeps on giving. I’ve been using SSRS since the early beta...
2011-10-11
2,865 reads
Call for Speakers–South Florida Code Camp 2012
The 2012 South Florida Code Camp is scheduled for February 11, 2012 at Nova University in Ft Lauderdale, and the...
2011-10-10
660 reads
MADPASS Follow-Up
A couple weeks back, I drove out to Madison to present at the MADPASS user group. These guys have a...
2011-10-10
531 reads
New and Improved DMVs in SQL Server 2008 R2 SP1
With relatively little fanfare, Microsoft added a few new DMVs into the SQL Server 2008 R2 SP1 release, which came...
2011-10-10
1,351 reads
PASS Summit 2011: Day One
After getting a little lost from the rail to the hotel, I finally got to sleep Sunday night after a...
2011-10-10
517 reads
PASS Summit Attendees: Remember to Network and Maintain
Previously, when I had attended conferences, I had used them to attend as many seminars or talks as I could...
2011-10-10
1,416 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