SNESSUG September Meeting
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and...
2009-10-08
604 reads
PASS Log Reader Awards
Brent Ozar, Andy Warren and Jeremiah Peschka have put together a blogger award called the PASS Log Reader Award. I...
2009-10-08
731 reads
Maintaining Security and Performance using Stored Procedures Part I – Using EXECUTE AS
Anyone who knows me, or has worked with me, knows that I am a proponent of using stored procedures for...
2009-10-08
1,553 reads
A DBA’s Fantasy
I happened upon the screenshot below, showing a stress test in progress against a Windows machine with 64 quad-core CPUs...
2009-10-08
1,410 reads
Very Useful SQL Server 2008 High Availability White Paper On MSDN
Fellow MVP, Paul Randal from SQLSkills.com has published a 35 page white paper on MSDN called “High Availability with SQL...
2009-10-08
792 reads
BI Bootcamp with an Industry Expert
I’ve been a regular speaker at the DevTeach/SQLTeach events in Canada for the past several years. Jean-Rene Roy and his...
2009-10-08
448 reads
Oovoo
We've been doing video conference calls for work through LiveMeeting for a few months. After two years of audio only...
2009-10-08
618 reads
MSDE – Database Size Limit
Most of you are aware that the Microsoft SQL Server 2000 Desktop Engine (MSDE) limits database size to 2 gigabytes. ...
2009-10-08
9,658 reads
SQL Server MVP Deep Dives Early Access Edition Now Available
SQL Server MVP Deep Dives, a new book written by 53 SQL Server MVPs, is now available as an eBook,...
2009-10-08
567 reads
Newcastle Coders Group is Third Stop on Down Under Tour
I just made a whirlwind trip to Newcastle to speak at the Newcastle Coders Group, on “Getting the Most Out...
2009-10-08
401 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