Lowlydba.Sqlserver
Collection version 2.3.3
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
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
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 practicessp_configure module – Make instance level system configuration changes via
sp_configure
sp_whoisactive module – Install/update
sp_whoisactive
by Adam Mechanicspn 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
See also
List of collections with docs hosted here.