Technical Article

SQL Server Availability Monitoring

This VB script will attempt to make a connection to all SQL Servers enumerated in the SQLInventory table over Named Pipes and TCP\IP. If a SQL Instance is listed, it will attempt TCP\IP connections using both port and instance name. Once the connection is established to each server using each protocol, the script will query […]

2007-01-11 (first published: )

1,227 reads

Blogs

Converting Types in C#

By

I am not a great software developer. I’m OK, and I do know how...

Daily Coping 22 Mar 2023

By

Today’s coping tip is to appreciate your hands and all the things they do...

FIRST Robotics Competition 2023 - World Championships!

By

On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...

Read the latest Blogs

Forums

Swapping coordinate pairs round

By Charlottecb

So I'm using SQL Server 2014 and I've been using Jeff Moden's excellent string...

DOP_FEEDBACK in SQL MI

By cooldude001

I'm changing the DB Compatibility mode to 2022 in SQL Managed Instance. below features...

index analysis help

By vsamantha35

Hi All, We see some tables in Prod are having 20-30 indexes and we...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Cloud Diagrams

See possible answers