Cleaning the Keyboard
I noticed that the keys on my laptop were pretty dirty the other day. The heavily used ones have a...
2009-09-17
803 reads
Browse and Script
One of the cool features of the SQL Server PowerShell snapins is the the ability to browse SQL Server as...
2009-09-16
450 reads
Nice Quote
Business conventions are important because they demonstrate how many people a company can operate without.
Since I got to so many,...
2009-09-16
655 reads
Trust Is Crucial in Security
Yesterday we were greeted to a ComputerWorld column talking about how Apple had betrayed the Enterprise's trust by having a...
2009-09-16
746 reads
DRP for SQL Server translation into French - traduction en français du plan de relève (à l'aide - help please)
There are about 45 paragraphs that I hope to progressively and quickly translate for the French version of the Disaster...
2009-09-16
1,238 reads
MVP Profile of the Week.....Jacob Sebastian
It’s been a busy month of September, and I’ve been getting feedback from the busy world of SQL Server MVP’s...
2009-09-16
1,713 reads
Featured Blogger: Simon Sabin
Simon is a prolific blogger, at rough look averaging 10-15 posts per month, and almost all of them are SQL,...
2009-09-16
798 reads
What's Your Build
This would probably be a good editorial, but I thought I'd drop it out here as a short note.
You ought...
2009-09-16
966 reads
Article of the Week – Kevin Kline “Social Media Scene”
This weeks article is written by Kevin Kline, which is titled “Getting Up-to-Speed on the SQL Server Social Medial Scene”. ...
2009-09-16
938 reads
Skipping Items in a Foreach Loop
Recently, my friend Jack Corbett asked a question on Twitter:
In a nutshell, the SSIS foreach loop will enumerate a given...
2009-09-16
5,794 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