Search results for 'app:weblogs' matching tags 'PowerShell', 'scripting', and 'SQL'

PoshUtils: Get all mirrored SQL databases using PowerShell and SMO

Anonymous — Sat, 17 Nov 2012 06:00:00 GMT

I have been validating different aspects of SQL mirroring and in the process I wanted a quick and automated way to handle database mirroring functions. This includes listing all mirrored databases, failing over databases manually to a mirrored instance, etc. So, in the process, I created several small functions in PowerShell to achieve what I [...]

PoshUtils: Get-DBSize – Get SQL Database space usage

Anonymous — Sat, 30 Jul 2011 05:00:00 GMT

Here is an improved version of the script I am using to get the database space usage details. This is one of the utility scripts I have been using and will be publishing soon as PoshUtils on Codeplex. Function Get-DBSize { [CmdletBinding()] param ( [Parameter(Mandatory=$false)] [String[]] $dbname, [Parameter(Mandatory=$false, ValueFromPipeline=$true)] [alias("cn","server","computer")] [String[]] $computername = "localhost" ) [...]

Creating SQL snapshots using SMO and PowerShell

Anonymous — Mon, 11 Apr 2011 05:00:00 GMT

First of all, I am not SQL guy. I work on SharePoint quite a bit and venturing into SQL now. So, the first thing is to learn how I can script my SQL management tasks. I know there are quite a few things on the Internet but exploring all this myself gives an opportunity to [...]