Steven Whaley

Retrieve SQL Instance Connect Info

This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2013-04-11 (first published: 2013-03-24)

1,483 reads

Next week I’m at VS Live in San Diego (register and join me) and...

Ten years ago today, I filmed a Pluralsight Play by Play on open source...

It’s time for T-SQL Tuesday again and this is a great prompt to start...

Comments posted to this topic are about the item Stored Procedures for Server-Level Object...

Comments posted to this topic are about the item Databricks Genie Spaces for SQL...

Comments posted to this topic are about the item The Costs of Multiple Platforms

I have this data in a table in a SQL Server 2025 database:

EmailAddressID EmailAddress
7              dylan0@ADVENTURE-WORKS.COM
8              Diane1@ADVENTURE-WORKS.COM

If I run this query, which row(s) are returned?

SELECT top 10
 *
 FROM person.EmailAddress
 WHERE REGEXP_LIKE(EmailAddress, '^d')
 AND BusinessEntityID IN (7,8)