SQLDBAWithABeard 

| 12,906,582 downloads | Last Updated: 9/25/2020 | Latest Version: 1.0.121

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

| 361,905 downloads | Last Updated: 9/22/2020 | Latest Version: 2.0.7

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

| 36,644 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

| 31,032 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

| 28,786 downloads | Last Updated: 9/16/2020 | Latest Version: 0.0.20200916.1

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

| 20,307 downloads | Last Updated: 7/19/2017 | Latest Version: 0.9.0

Dopest dba dashboards ever

| 9,068 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

| 8,253 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

| 5,434 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

| 4,615 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

| 4,540 downloads | Last Updated: 11/6/2016 | Latest Version: 1.0

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

| 3,782 downloads | Last Updated: 11/6/2016 | Latest Version: 1.0

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

| 3,698 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

| 3,694 downloads | Last Updated: 11/6/2016 | Latest Version: 1.0

Returns the Job Duration for an agent job on an instance

| 3,677 downloads | Last Updated: 11/20/2016 | Latest Version: 1.0

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

| 3,095 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

| 2,850 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

| 2,804 downloads | Last Updated: 11/6/2016 | Latest Version: 1.0

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

| 2,796 downloads | Last Updated: 11/20/2016 | Latest Version: 1.0

Sets the OutputFile for a SQL Agent Job Step

| 1,974 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