Lowlydba.Sqlserver

Collection version 2.7.0

Description

Ansible collection using PowerShell to configure and maintain SQL Server.

Author:

• John McCall (github.com/lowlydba)

Supported ansible-core versions:

• 2.12 or newer

• Issue Tracker
• Repository (Sources)

Plugin Index

These are the plugins in the lowlydba.sqlserver collection:

Modules

• ag_listener module – Configures an availability group listener

• ag_replica module – Configures an availability group replica

• agent_job module – Configures a SQL Agent job

• agent_job_category module – Configures a SQL Agent job category

• agent_job_schedule module – Configures a SQL Agent job schedule

• agent_job_step module – Configures a SQL Agent job step

• availability_group module – Configures availability group(s)

• backup module – Performs a backup operation

• credential module – Configures a credential on a SQL server

• database module – Creates and configures a database

• dba_multitool module – Install/update the DBA Multitool suite by John McCall

• first_responder_kit module – Install/update the First Responder Kit scripts

• hadr module – Enable or disable HADR

• install_script module – Runs migration scripts against a database

• instance_info module – Returns basic information for a SQL Server instance

• login module – Configures a login for the target SQL Server instance

• login_role module – Configures a login’s server roles.

• maintenance_solution module – Install/update Maintenance Solution by Ola Hallengren

• memory module – Sets the maximum memory for a SQL Server instance

• nonquery module – Executes a generic nonquery

• resource_governor module – Configures the resource governor on a SQL Server instance

• restore module – Performs a restore operation

• rg_resource_pool module – Configures a resource pool for use by the Resource Governor

• rg_workload_group module – Configures a workload group for use by the Resource Governor

• sa module – Configure the sa login for security best practices

• sp_configure module – Make instance level system configuration changes via sp_configure

• sp_whoisactive module – Install/update sp_whoisactive by Adam Mechanic

• spn module – Configures SPNs for SQL Server

• tcp_port module – Sets the TCP port for the instance

• traceflag module – Enable or disable global trace flags on a SQL Server instance

• user module – Configures a user within a database

• user_role module – Configures a user’s role in a database.

See also

List of collections with docs hosted here.