PASS Update #47–Election Review Committee
As always, this represents my own views, I’m speaking only for me and not the entire PASS Board.
Early last week...
2010-11-16
681 reads
What's New In Denali for SSRS
I was so excited when I found out that Denali was released last week. Like it was Christmas time, I...
2010-11-16
483 reads
Can't Hit the Remote Registry through the Virtual Name
This is a problem we just solved, which was causing us to not be able to hit the remote registry...
2010-11-16
2,294 reads
My Weekend Just Got Busy
I’m traveling to New York City on Friday for SQL Saturday #59 and returning Sunday morning. As soon as I...
2010-11-16
801 reads
Another Plagiarizer
I received a note today about someone else that is plagiarizing content from SQLServerCentral. It’s a blog on Windows Live...
2010-11-16
1,111 reads
There should only be one ...
When visiting clients, I often find that one or more databases have a table (or several) containing metadata. Most often, these tables have only a single row of data...
2010-11-16
13 reads
There should only be one ...
When visiting clients, I often find that one or more databases have a table (or several) containing metadata. Most often, these tables have only a single row of data...
2010-11-16
29 reads
There should only be one ...
When visiting clients, I often find that one or more databases have a table (or several) containing metadata. Most often,...
2010-11-16
622 reads
Handy Hardware Assessment Tools For SQL Server
Here is a small selection of useful tools for getting some specific hardware information from any Windows based system you...
2010-11-16
2,261 reads
Backup log Truncate_Only in SQL Server 2008
BACKUP LOG <db_name> WITH truncate_only command, used for clearing the log file, is deprecated in SQL Server 2008. So this post will explain option...
2010-11-16
1,691 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