SQL

#PSTip Creating a SQL TCP mirroring endpoint with SMO and PowerShell

Ravikanth C
2 Min To Read
10 Jun, 2013
- SQL
- Tips and tricks

Note: This tip requires PowerShell 2.0 or above. In today’s tip, we will see how we can use PowerShell and SMO to create a SQL TCP mirroring endpoint.

#PSTip Check if a SQL endpoint exists or not

Ravikanth C
1 Min To Read
04 Jun, 2013
- SQL
- Tips and tricks

Note: This tip requires PowerShell 2.0 or above. Before we make an attempt at creating a new database mirroring endpoint, we need to verify if an endpoint with the given name and/or port already exists.

#PSTip List all endpoints in a SQL deployment

Ravikanth C
2 Min To Read
03 Jun, 2013
- SQL
- Tips and tricks

Note: This tip requires PowerShell 2.0 or above. When working with SQL Server database mirroring, it is desired to understand how to create and troubleshoot database endpoints.

#PSTip Retrieving SQL database last backup dates using SMO

Ravikanth C
1 Min To Read
31 May, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. For regular reporting and auditing purposes, it is always desired to capture the SQL last backup dates.

#PSTip Adding local users to SQL Server Logins using SMO

Ravikanth C
1 Min To Read
17 May, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. There was a question on StackOverflow about adding local users to SQL Server logins.

#PSTip List SQL database mirroring partner using SMO

Ravikanth C
1 Min To Read
14 May, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. In an earlier tip, we looked at how to verify if a SQL database is mirrored.

Showing items from SQL