SQL

#PSTip Validate if a SQL login exists using PowerShell

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

Note: This tip requires PowerShell 3.0 or above. Before performing tasks like adding roles to a SQL login, it is desired to validate the existence of SQL login.

#PSTip Add a SQL login to database roles using SMO

Ravikanth C
1 Min To Read
13 Aug, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. We can use SQL Server SMO object to add a SQL login to the database roles.

#PSTip Retrieve all SQL instance names on local and remote computers

Ravikanth C
1 Min To Read
06 Aug, 2013
- Tips and tricks
- SQL

I was looking at way to retrieve the SQL instance names on a remote computer without using SQL SMO. This is essential for me as I don’t always expect to have the SQL SMO DLLs on the computer where I run my scripts.

#PSTip Drop all Active Connections of SQL Database

Ravikanth C
1 Min To Read
02 Aug, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. In an earlier tip, we looked at how we can retrieve the active connection count for a SQL database.

#PSTip Change database recovery model using SMO

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

Note: This tip requires PowerShell 2.0 or above. Database mirroring requires that the database be in Full recovery model as a prerequisite to configure mirroring.

#PSTip Deleting a SQL mirroring endpoint with SMO and PowerShell

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

Note: This tip requires PowerShell 2.0 or above. In earlier tips, we looked at how we can get all SQL endpoints, check if a SQL endpoint exists or not, and creating SQL mirroring endpoints.

Showing items from SQL