Off-Hours Work: A Guide For Non-Managers
In my last post I talked about how I think managers should approach off-hours work with their teams. It's a...
2009-10-15
541 reads
SQL MVP Profile of the Week - Michael Coles
As we continue to get ready for the NY\NJ SQLSaturday User Group meeting this October 24, 2009, I had the...
2009-10-15
1,165 reads
SQL Lunch/Call for Speakers
Patrick Leblanc has started a new project called…SQL Lunch! The concept is to present a 30 minute topic every two...
2009-10-15
887 reads
Separating Out Indexes
I saw a post recently where someone was asking how to separate out all indexes from the data into a...
2009-10-15
912 reads
SNESSUG October Meeting
The Southern New England SQL Server Users Group’s October meeting was a bit sparsely attended with 7 attendees. The sponsor...
2009-10-15
707 reads
Live Writer Plugin for Amazon
Among the things I’m experimenting with this quarter is changing my book reviews to include an affiliate link to Amazon....
2009-10-14
317 reads
The Future of Technical Education
Some people just love to talk. I guess I’m one of those people. I admit it. But there is a...
2009-10-14
429 reads
What Is Using The Most Space In Your Database ?
As I work on moving a large system with multiple database servers from a 27TB SAN to a single database...
2009-10-14
814 reads
Network backup Access via Query Analyzer
Hi,
Today while working on query analyzer found very interesting thing about security.
My sql server A is running with service account...
2009-10-14
626 reads
PASS Election Voting Has Started
You should get an email if you’re eligible to vote with a subject line beginning with ‘Vote for the 2010/2011...
2009-10-14
291 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