Skip to content

SQLDBAWithABeard/Functions

Folders and files

NameName
Last commit message
Last commit date

Latest commit

e70bbba · Dec 10, 2022
Mar 5, 2018
Mar 7, 2018
Nov 16, 2016
Nov 6, 2016
Dec 19, 2018
Sep 9, 2019
Mar 5, 2018
Oct 5, 2021
Sep 8, 2016
Mar 27, 2017
Jun 3, 2018
Dec 10, 2022
Mar 28, 2018
Mar 28, 2018
Sep 21, 2020
Dec 3, 2018
Dec 3, 2018
Sep 21, 2020
Aug 20, 2018
Sep 16, 2016
Feb 24, 2020
Jul 5, 2019
Nov 18, 2019
Apr 22, 2017
Sep 21, 2020
Aug 21, 2018
Feb 19, 2017
Sep 8, 2016
Sep 8, 2016
Jun 8, 2016
Jun 8, 2016
Mar 5, 2017
Jan 9, 2019
Nov 6, 2016
Aug 21, 2017
Nov 6, 2016
Feb 19, 2017
Nov 6, 2016
Nov 30, 2018
Sep 21, 2020
Jul 5, 2019
Apr 22, 2017

Repository files navigation

Functions

Contains useful functions that I use and am able to share.

Get-DriveSize - Returns the Drive or Volume Name, Label, Size in Gb, Free Space in GB and Free space as a percentage of drives and mount points on local and remote servers

Test-SQLDefault - Runs a series of Pester tests against a SQL Instance or an array of SQL Instances. Should be easy to customise to your own environments required defaults

Show-DatabasesOnServer - Returns the Name and sizes of databases on a server or array of servers

Set-OlaJobSchedule - Sets the agent job schedule for the jobs created by Ola Hallengrens Maintenance plan

When-WillSQLComplete - Quick function to check progress of SQL Commands via sys.dm_exec_requests. Useful for DBCC, Backup, Restore and indexing progress

Test-OLAInstance - Wrapper to call a Pester Test script Test-OLA to test Ola Hallengren Maintenance Solution is installed correctly