Be Careful with String Concatenations in SQL Server with Big Strings.
Now, we are going to get slightly esoteric here. I'd noticed that the performance of string concatenation tasks didn't increase...
2009-02-16
14,624 reads
Recharged
It’s rare that I’ve taken vacation in the last few years. In fact, when I took an unwired week in...
2009-02-16
719 reads
Networking - Part 5
You can read the previous posts here. To finish up my thoughts on networking I want to brain storm some...
2009-02-15
637 reads
The Importance of the Segregation of Duties with Respect to Internal Controls
I diverge a little from the typical coding-based/oriented best practice to one that is focused on governance within public or government organisations...
2009-02-15
7,960 reads
Which is Better: Heaps or Tables with Clustered Indexes?
I have always been of the personal opinion that all SQL Server tables have a clustered index. As part of...
2009-02-13
4,303 reads
Another Reason to Avoid Cross-Database Ownership Chaining
This past weekend we were moving database files around because we added new LUNs to an existing production cluster. We...
2009-02-13
2,165 reads
SQL Injection - It's Not Just Me!!
I have a personal web site I set up years ago, mainly so I could post stuff for my extended...
2009-02-13
837 reads
Color E-Ink
I love my Kindle, but it uses an older e-ink technology that's a little slow and doesn't support color. Not...
2009-02-13
987 reads
Landing on the Hudson River & Being a Hero
I think we've all seen and heard about Flight 1549 doing the emergency landing on the Hudson River. Truly a...
2009-02-12
574 reads
Inserting Markup into a String with SQL
There are a number of occasions when one might want to insert information at various places in a string. Where...
2009-02-12
1,899 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