PASS 2008 - Day 1 (Mon)
Fairly easy day, up at 5 am for an 8:15 am flight to Seattle via Detroit, arrived about 2:30 pm...
2008-11-17
534 reads
Endorsing Andy Warren
OK, I'm biased. I'll admit it and you have every right to discount my endorsement, but I'll make the case...
2008-11-17
714 reads
Without SQL Server
I've been in Seattle since Friday afternoon and I've pretty much ignored SQL Server. And it's been nice!
I came up...
2008-11-16
641 reads
Why I Want To Be On The PASS Board
This is what I provided to the nominating committee today. I think I could have worked on this for weeks...
2008-11-16
1,431 reads
Pass Board of Directors Part 6
More updates from the nominating committee:
"As a PASS-slated candidate, we would like to promote you and your vision and experience...
2008-11-16
507 reads
PASS, anyone?
In less than two days I'll be in Seattle for my 6th PASS Summit. I am trying to put all the...
2008-11-14
471 reads
MSSQLTips.com: How to Audit SysAdmin Logins
One of the first things I tried to do when logon triggers came out with Service Pack 2 of SQL...
2008-11-14
2,592 reads
PASS Board of Directors Part 5
Looks like I'm still in the game! Just received word from Kevin Kline (Past PASS President). Here are the candidates:
Andy...
2008-11-14
1,314 reads
In remembrance of veterans and their families
Illiad has been running a series on his UserFriendly comic strip about veterans. It started on Monday and has continued...
2008-11-14
721 reads
Find the TCP port used by a named instance
We know for SQL Server default instance, if TCP/IP protocol is used, the default TCP port number is always 1433....
2008-11-13
1,429 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers