Category Archives: Database Connection

Powershell Function to Get SQL Server’s Network Protocols

The output of the above function usually looks like this: ProtocolName ProtocolDisplayName ProtocolOrder sm Shared Memory 1 tcp TCP/IP 2 np Named Pipes 3 via VIA 0 Number ‘0’ means corresponding protocol is ‘disabled’, while the NO. ‘1’ has the … Continue reading

Posted in Database Connection, Powershell | Leave a comment

T-SQL Stored Procedure to Get the Number of Connections and Login Names per DB

Posted in Database Connection, T-SQL Script | Tagged | Leave a comment

Workaround to Register an Instance Out of Your Domain in Central Management Server

It sucks that Central Management Server (CMS) doesn’t support registering an instance by SQL Server authentication (and unfortunately in very DBA’s inventory, there are always a few servers that are out your normal domain but you still have to manage). … Continue reading

Posted in Database Connection, SQL Server | Tagged , , | 2 Comments