Cookbook How Do I

Cookbook - How Do I?

This page provides a tutorial on performing certain standard actions that are referenced by the workflows.

Collect a Network Trace
Different ways to collect a network trace for different circumstances.

Collect the Connectivity Ring Buffer
Get a history of logins from the SQL Server.

Determine If I Am Connected to SQL Server using Kerberos Authentication
Different methods to determine your authentication type. Kerberos is required for delegated credentials to work.

Test a Connection via a UDL File
How to use a UDL file to test a connection and try different OLE DB Providers.

Test a .NET Connection via PowerShell
A sample PowerShell script that allows you to test a System.Data.SqlClient.SqlConnection.