Checking SQL Server Versions
This question comes up enough on the forums and with SP1 for SQL Server
2005 released, I'll cover it again. You...
2006-04-30
1,625 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Sharing Internet Connections?
This study out of the University of Illinois at Urbana-Champaign sounds great:
Software Allows Neighbors To Improve Internet Access At No...
2006-04-30
1,611 reads
More on xp_logininfo
In this post,
I talked about using xp_logininfo in order to get the permission paths
for a particular Windows account. If you've...
2006-04-29
10,581 reads
Fix for SSIS SP1 "service failed to start" issue
I was catching up on my blog reading and found the following post from Jamie Thomson:
SSIS: Another SP1 problem
The post...
2006-04-28
1,460 reads
Issues with SQL Server 2005 SP1
There have been reports of some issues with SQL Server 2005 SP1, especially
with SQL Server Integration Services not starting as...
2006-04-27
1,640 reads
When life intrudes
I have MVP Raymond Lewallen in my list of blogs to follow. I read with great sadness the following blog...
2006-04-26
1,480 reads
Issues tracking members of the sysadmin fixed server role
I received an email from another DBA asking how to track a user who is
probably mapping into SQL Server via...
2006-04-25
1,605 reads
Determining if it's a SQL login, Windows Login, or Windows group
A recent question on the forums asked how to determine if a database
user was a Windows user or group and...
2006-04-06
3,943 reads
Kerberos Delegation with SQL Server Reporting Services and SQL Server
I've been dealing with Kerberos delegation setup with respect to
Microsoft's CRM 3.0 product and while the process isn't difficult, if
you...
2006-04-05
2,182 reads
March/April 2006 Edition of SQL Server Standard Available
The March/April 2006 edition of SQL Server Standard magazine is now
available. This issue focuses on Transact-SQL for SQL Server 2005.
Though...
2006-04-03
1,522 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