Lowlydba.Sqlserver

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.