SQL

#PSTip Verify if a SQL database is mirrored or not

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

Note: This tip requires PowerShell 2.0 or above. When using SQL SMO to work with mirroring configuration, it is essential to verify if the database is mirrored, or not, before performing any other operations.

#PSTip Failing over a mirrored SQL database using SMO

Ravikanth C
1 Min To Read
29 Apr, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. After I configure SQL mirroring, I usually perform some checks to ensure that the overall mirroring configuration is working fine.

#PSTip Enumerate all SQL Server instances in a network

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

Note: This tip requires PowerShell 2.0 or above. Ever thought about how you can list of all SQL Server instances on the local network?

#PSTip Changing SQL database AutoShrink property using SMO and PowerShell

Ravikanth C
1 Min To Read
22 Apr, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. In today’s tip, we will see how we can use SQL SMO and PowerShell to change the AutoShrink property of a SQL database.

#PSTip Restoring a SQL Database using SMO

Ravikanth C
1 Min To Read
18 Apr, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. In a couple of earlier tips on using SMO, we looked at backing up a SQL database and transaction logs.

#PSTip Backing up SQL transaction log using SMO

Ravikanth C
1 Min To Read
16 Apr, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. In an earlier tip, we looked at how we can use SQL SMO to perform database backup.

Showing items from SQL