Currently viewing the tag: "SQL"

Get SQL database size using Windows Powershell

By On May 26, 2009 · 4 Comments

The following script examines servers from (part of) your Active Directory domain, identifies SQL servers and lists the instances with their total database sizes.

Continue Reading →

Get SQL Log Messages with Windows Powershell

By On December 4, 2008 · Leave a Comment

Here’s a little something for the sysadmin that monitors SQL servers (who doesn’t?). This handy little function retrieves SQL log messages for a specified instance. You can also specify how many of the most recent messages to retrieve.

function Get-SQLLog
{
param([string]$Instance, [Int]$SizeLimit = 10)
If ($Instance -eq $null){Write-Warning “Syntax: Get-SQLLog [-Instance] [...]

Continue Reading →