SQLDBAWithABeard 

By: | 3,716,217 downloads | Last Updated: 1/24/2024 | Latest Version: 2.1.7

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

By: | 43,465 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: | 5,215 downloads | Last Updated: 7/19/2017 | Latest Version: 0.9.0

Dopest dba dashboards ever

By: | 1,862 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,362 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: | 1,318 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: | 947 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: | 694 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: | 649 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: | 505 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: | 445 downloads | Last Updated: 11/20/2016 | Latest Version: 1.0

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

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

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

By: | 422 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: | 385 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: | 366 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: | 350 downloads | Last Updated: 11/6/2016 | Latest Version: 1.0

Returns the Job Duration for an agent job on an instance

By: | 332 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: | 328 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: | 323 downloads | Last Updated: 1/5/2024 | Latest Version: 2.0.3

A module for gathering information about SQLBits agenda. This module can be used to return the information in Sessionize about the SQLBits agenda in a number of formats for both training days and general sessions.New for 2024

By: | 321 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