Happy New Year
Image: ponsuwan / FreeDigitalPhotos.net
As 2011 draws to a close and as people look forward to evening of partying and celebrating I’d...
2011-12-31
1,954 reads
SQLServerDBA News - 2011 Review for SQLServerDBA
2011 was a great year on a personal and professional level
1) Completed the Brighton Marathon in 4hrs 36 secs
2) Blogged...
2011-12-31
1,576 reads
Good Bye 2011
Good Bye 2011
Hey there, this year is going to an end and just want to recall what all happened this...
2011-12-31
1,298 reads
Thoughts on SSSOLV December Meeting
This is very late – I know. The meeting was held on December 8, 2011 and I haven’t yet shared my recap/thoughts about the meeting. We hold the SQL...
2011-12-30
11 reads
Thoughts on SSSOLV December Meeting
This is very late – I know. The meeting was held on December 8, 2011 and I haven’t yet shared my...
2011-12-30
1,477 reads
Estimated Completion Time for Backups and Restores
I’m in the middle of a database migration and thought I’d quickly share a script I threw together to show...
2012-01-03 (first published: 2011-12-30)
82,188 reads
SSIS Community Tasks and Components
Do you know there are hundreds of additional tasks, tools, and components for SSIS, many which are free? Why re-invent...
2012-01-04 (first published: 2011-12-30)
3,096 reads
Re-blog – December 23 – December 29
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2011-12-30
1,443 reads
Increase SQL Server Error Log Files
Recently I learned that you can and probably should increase the number of SQL Server Error logs that your instance...
2012-01-04 (first published: 2011-12-30)
4,117 reads
January 2012 Las Vegas SQL UG
This month I am attempting to get a jump on things a bit. I am hoping to get the info out in a more timely fashion throughout this new...
2011-12-30
12 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