How can I configure SQL Server to listen on multiple TCP/IP ports?
Run the SQL Server Configuration Manager, expand SQL Server Network Configuration and select the protocols for appropriate instance. Double click...
2012-02-18
10,337 reads
Re-blog – February 10 – February 16
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-02-17
616 reads
SQL Server 2012 (“Denali”): Microsoft StreamInsight
Microsoft StreamInsight, first introduced in Microsoft SQL Server 2008 R2, is a way to effectively analyze large amounts of event...
2012-02-17
3,151 reads
Performance VC Feb Meeting
Jes Borland will be speaking for the Performance Virtual Chapter this month. Don’t miss out on this free training. Here...
2012-02-17
758 reads
Split Typeperf Output in More Managable Chunks
I really like using typeperf for perfmon counter collection. It allows me to save a collection of counters to monitor and store those readings in a csv file for...
2012-02-17
56 reads
Split Typeperf Output in More Managable Chunks
I really like using typeperf for perfmon counter collection. It allows me to save a collection of counters to monitor...
2012-02-17
1,422 reads
Speaking at MagicPASS on February 22, 2012
Next Wednesday I’ll be returning to MagicPASS to do a presentation on SQL security for developers. It’s an interesting topic,...
2012-02-17
684 reads
Building Visual Studio Deployment Projects With MSBuild
I recently hit what I would call a fairly serious limitation of MSBuild and that is that it cant build...
2012-02-17
177 reads
SQL Server – read only database status
This post describes how to return the database read-only status via T-SQL .
The system view – sys.databases returns a column called...
2012-02-17
1,125 reads
2012-02-17
8 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