SQLDBAWithABeard 

By: | 2,521,661 downloads | Last Updated: 1/27/2023 | Latest Version: 1.1.145

The community module that enables SQL Server Pros to automate database development and server administration

By: | 36,191 downloads | Last Updated: 2/3/2022 | Latest Version: 2.0.18

SQL Server Infrastructure validation Tests to ensure that your SQL Server estate is and continues to be compliant with your requirements

By: | 4,415 downloads | Last Updated: 7/19/2017 | Latest Version: 0.9.0

Dopest dba dashboards ever

By: | 1,478 downloads | Last Updated: 8/21/2018 | Latest Version: 1.0.0.2

Uploads PBIX files to a PowerBi report server and sets the data source

By: | 1,259 downloads | Last Updated: 10/8/2020 | Latest Version: 0.0.20201008.1

For creating Azure Data Studio Notebooks and adding PowerShell to the MarkDown

By: | 1,103 downloads | Last Updated: 12/2/2017 | Latest Version: 0.9.27

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

By: | 671 downloads | Last Updated: 7/3/2017 | Latest Version: 0.9.0

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

By: | 659 downloads | Last Updated: 8/10/2017 | Latest Version: 1.3

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

By: | 624 downloads | Last Updated: 11/6/2016 | Latest Version: 1.0

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

By: | 423 downloads | Last Updated: 11/6/2016 | Latest Version: 1.0

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

By: | 412 downloads | Last Updated: 11/6/2016 | Latest Version: 1.0

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

By: | 375 downloads | Last Updated: 12/15/2016 | Latest Version: 1.2

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

By: | 358 downloads | Last Updated: 11/20/2016 | Latest Version: 1.0

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

By: | 350 downloads | Last Updated: 11/6/2016 | Latest Version: 1.0

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

By: | 334 downloads | Last Updated: 11/20/2016 | Latest Version: 1.0

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

By: | 333 downloads | Last Updated: 11/6/2016 | Latest Version: 1.0

Returns the Job Duration for an agent job on an instance

By: | 318 downloads | Last Updated: 11/6/2016 | Latest Version: 1.0

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

By: | 316 downloads | Last Updated: 11/6/2016 | Latest Version: 1.0

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

By: | 312 downloads | Last Updated: 3/28/2016 | Latest Version: 1.0

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

By: | 307 downloads | Last Updated: 11/6/2016 | Latest Version: 1.0

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 info