Spotlight: Jes Borland
It’s been a few months…time for another Spotlight!
Just to catch you up, occasionally someone in the SQL community – usually someone...
2010-12-09
1,422 reads
Microsoft Codename Atlanta Attempts to Help Out DBAs By Providing Basic Assistance
I have always recommended that DBAs be as proactive as possible, catching potential problems, and actual problems, as soon as...
2010-12-09
1,106 reads
SQL Server 2008 R2 System Views Map
Update from Microsoft for SQL Server 2008 & 2008 R2. There is the graphical map of the system views included SQL...
2010-12-09
1,042 reads
Bundle of Joy
After baking for 9 months, our bouncing baby girl has finally arrived. She arrived Thursday Dec 2, 2010 at 8:28 AM (PST). There were no complications and the delivery...
2010-12-09
5 reads
Bundle of Joy
After baking for 9 months, our bouncing baby girl has finally arrived. She arrived Thursday Dec 2, 2010 at 8:28...
2010-12-09
634 reads
December 2010 SSSOLV Reminder
Here is a quick reminder and a repost of the announcement from last week. This month we will be broadcasting the meeting once again. This month the technology bug...
2010-12-08
8 reads
December 2010 SSSOLV Reminder
Here is a quick reminder and a repost of the announcement from last week.
This month we will be broadcasting the...
2010-12-08
851 reads
Perfmon counters list - Quest poster
Stumbled upon this PDF from quest which lists the important Perfmon counters and their acceptable values. A must print and...
2010-12-08
504 reads
One Week Left in the PASS SQLRally Call For Speakers
There is only one week left to submit your abstract for the PASS SQLRally. This is a great opportunity for...
2010-12-08
366 reads
SQLSaturday #62–Too Many Speakers
I received the email this week that I won’t be getting a place on the schedule, nor will the other...
2010-12-08
788 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