Category: SQL PowerShell

Mirroring not working in SQL Cluster

Mirroring not working in SQL Cluster

Some of you might see this error on a SQL Cluster "Database mirroring login attempt by user 'xxxx' failed with error: Connection handshake failed. The ...
SQL Counters with PowerShell

SQL Counters with PowerShell

Many times a DBA will want to check specific SQL counters. In this article we will show you exactly how you can easy do that in PowerShell. #Get a li ...
Checking SQL Services with PowerShell

Checking SQL Services with PowerShell

From time to time every SQL DBA needs to know if their SQL Database servers are functioning properly. With PowerShell's Get-Service command-let it is ...
Reading and Writing to SQL Databases with PowerShell

Reading and Writing to SQL Databases with PowerShell

First let's start off by saying that this is not meant to be the end to end all solutions especially for large databases with thousands of records. Th ...
4 / 4 POSTS