Networking - Part 6
You can read the previous posts here. To finish up (I think), I want to share a networking technique I...
2009-02-18
717 reads
The Limited Usefulness of Encrypting File System (EFS) and Transparent Data Encryption (TDE)
This is something that hit me as I was presenting to the Charlotte SQL Server User Group last night.
Back...
2009-02-18
4,103 reads
Database Mirroring FAQ: Why does Database Mirroring Monitor report that my mirror is disconnected?
Question: Why does Database Mirroring Monitor report that my mirror is disconnected?
This question was sent to a discussion list via...
2009-02-18
1,638 reads
Boulder SQL Server Users Group
Last night I went to the February Boulder SQL Server User’s Group meeting up in Broomfield, CO to deliver my...
2009-02-18
800 reads
MySpace
MySpace has been the Premier SQL Server site, and probably the largest SQL Server site, on the Internet. It’s a...
2009-02-18
833 reads
All In & Being Competitive
Many of us in IT are competitive, maybe slightly more so than in other professions. Competition adds a little spice...
2009-02-17
1,504 reads
Your Local User Group
When I talk to other SQL Server professionals, I’m often surprised at how many do not have any involvement in...
2009-02-17
1,238 reads
Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?
Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?
This question was sent...
2009-02-17
2,378 reads
Book Review - The Human Edge
I've always enjoyed the science fiction writings of Gordon Dickson, and recently re-read an old copy of The Human Edge,...
2009-02-16
881 reads
Database Mirroring FAQ: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online?
Question: If the principal fails while running in high performance mode, what options do I have for bringing the mirror...
2009-02-16
4,568 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
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