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...

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...

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...

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...

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...

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...

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,...

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...

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...

24 Hours of Free, Nonstop SQL Server Training