SQLDBAWithABeard's Profile

Items

• 

  Script

  Set Extended Events Session to Auto Start

  Connects to the servers in the DBA Database and for Servers above 2012 sets alwayson_health Extended Events Sessions to Auto-Start and starts it if it is not running

• 

  Script

  set-sqllogfiles

  Uses SMO to set the number of Log files for a single or group of SQL Servers

• 

  Script

  Backup-OLADatabase

  This function will perform an ad-hoc backup using OLA Hallengrens solution - It doesnot expose all of the capabilities but is useful for quick backups when needed Note the Database paramter is dynamically filled once you type it

• 

  Script

  Test-OLA

  This script will check the status of the SQL Servers OLA set up including all agent jobs, folders and existence of backup files

• 

  Script

  Test-OLAInstance

  Tests an instance or a number of instances to ensure that the OLA Hallengren solution is set up correctly. That all agent jobs exist, are schedeuled and were successful That the relevant folders for each database exist and that there are backups files in the folders It uses the Test-Ola.ps1 file You will need to add the path to Test-Ola.ps1 on Line... More information

• 

  Script

  Show-DatabasesOnServer

  Returns Database Name and Size in MB for databases on a SQL server

• 

  Script

  When-WillSQLComplete

  Runs some t-sql to gather some information about requests from the sys.dm_exec_requests dmv to estimate the amount of time remaining for a statement which can be filtered by BACKUP,RESTORE,INDEX,DBCC,STATS commands

• 

  Script

  Test-SQLDefaults

  Function to run a series of Pester tests for SQL Defaults against a server or array of servers

• 

  Script

  Get-SQLAgentJobDuration

  Returns the Job Duration for an agent job on an instance

• 

  Script

  Get-SQLAgentJobOutPutFile

  This function returns the output file value for each step in an agent job

• 

  Script

  Get-SQLInstancesPort

  This function will show the Instances and the Port Numbers on a SQL Server using WMI and the status of the relevant SQL Service and its start mode

• 

  Script

  Set-SQLAgentJobOutputFile

  Sets the OutputFile for a SQL Agent Job Step

• 

  Script

  Get-DBADatabaseSize

  returns a database smo object of the size of the databases on an instance in Mb and enables top N if required

• 

  Script

  Get-DBAErrorLogPath

  returns the SQL or Agent Error log paths for a SQL Server

• 

  Script

  New-WindowsDataScienceVM

  Creates a Windows Data Science Virtual Machine in Azure with a simple switch to remove complexity or the ability to configure all resources

• 

  Module

  SQLDiagAPI

  This is a module to work with the SQL Server Diagnostics (Preview) API. See https://blogs.msdn.microsoft.com/sql_server_team/sql-server-diagnostics-preview/ for more details

• 

  Module

  dbareports

  Dopest dba dashboards ever

• 

  Script

  Get-PwnedPassword

  Connects to the API at https://haveibeenpwned.com/ to see if a Password or Password hash has been found in a breach. Troy Hunt @troyhunt has created an API which allows you to query if a Password has been found in a breach. This is a simple function enabling you to query it

• 

  Module

  BeardAnalysis

  This is a demo module for demoing Plaster and TDD with Pester and CI with VSTS to the PowerShell Gallery