File: //lib/python3.9/site-packages/ansible_collections/lowlydba/sqlserver/changelogs/changelog.yaml
ancestor: null
releases:
0.1.0:
changes:
release_summary: It's a release! First version to publish to Ansible Galaxy.
fragments:
- v0.1.0_summary.yml
modules:
- description: Configures a SQL Agent job.
name: agent_job
namespace: ''
- description: Configures a SQL Agent job category.
name: agent_job_category
namespace: ''
- description: Configures a SQL Agent job schedule.
name: agent_job_schedule
namespace: ''
- description: Configures a SQL Agent job step.
name: agent_job_step
namespace: ''
- description: Creates and configures a database.
name: database
namespace: ''
- description: Configures a login for the target SQL Server instance.
name: login
namespace: ''
- description: Install/update Maintenance Solution
name: maintenance_solution
namespace: ''
- description: Sets the maximum memory for a SQL Server instance.
name: memory
namespace: ''
- description: Executes a generic nonquery.
name: nonquery
namespace: ''
- description: Configures the resource governor on a SQL Server instance.
name: resource_governor
namespace: ''
- description: Configures a resource pool for use by the Resource Governor.
name: rg_resource_pool
namespace: ''
- description: Configures a workload group for use by the Resource Governor.
name: rg_workload_group
namespace: ''
- description: Make instance level system configuration changes via sp_configure.
name: sp_configure
namespace: ''
- description: Install/update sp_whoisactive by Adam Mechanic.
name: sp_whoisactive
namespace: ''
- description: Enable or disable global trace flags on a SQL Server instance.
name: traceflag
namespace: ''
release_date: '2022-03-30'
0.1.1:
changes:
release_summary: Add database tag for Galaxy
fragments:
- v0.1.1_summary.yml
release_date: '2022-03-31'
0.10.0:
changes:
minor_changes:
- Update minimum required DBATools version universally to 1.1.108 to accommodate
new tcp module.
release_summary: The first_responder_kit and tcp_port modules, along with a
bump in the required dbatools version.
fragments:
- 105-update-dbatools-version.yml
- v0-10-0-release-summary.yml
modules:
- description: Install/update the First Responder Kit scripts.
name: first_responder_kit
namespace: ''
- description: Sets the TCP port for the instance.
name: tcp_port
namespace: ''
release_date: '2022-06-27'
0.10.1:
changes:
bugfixes:
- Fix change detection in resource_governor module.
release_summary: Bug fix for resource_governor.
fragments:
- 108-rg-bug-fix.yml
- v0-10-1-release-summary.yml
release_date: '2022-06-28'
0.11.0:
changes:
release_summary: Adding new dbops module.
fragments:
- 0-11-0-release-summary.yml
modules:
- description: Runs migration scripts against a database.
name: install_script
namespace: ''
release_date: '2022-07-03'
0.11.1:
changes:
bugfixes:
- Fix `availability_group` module so that NUL backups can be properly taken
if needed.
- Fix incorrect examples in `availability_group` module documentation.
- Fix incorrect examples in `install_script` module documentation.
- Fix incorrect examples in `spn` module documentationb.
- Fixed bugs where adding replica did not work properly for several reasons.
release_summary: Bug fixes for AlwaysOn related modules and fixing errors in
some documentation examples.
fragments:
- 0-11-1-release-summary.yml
- 113-fix-ag-module.yml
- x-fix-spn-docs.yml
release_date: '2022-07-06'
0.11.2:
changes:
release_summary: Bumping required dbatools version to ensure the `restore` module
works on MacOS PowerShell Core (https://github.com/dataplat/dbatools/pull/8435).
fragments:
- 0-11-2-release-summary.yml
release_date: '2022-07-09'
0.2.0:
changes:
minor_changes:
- Add DbaTools module requirement to documentation and fix missing examples.
(https://github.com/lowlydba/lowlydba.sqlserver/pull/47)
- Utilize PowerShell Requires for dbatools min version needs instead of custom
function. Consolidate/standardize credential setup and serialization. (https://github.com/lowlydba/lowlydba.sqlserver/pull/48)
release_summary: Code cleanup, testing improvements, new _info module!
fragments:
- 47-improve-module-documentation.yml
- 48-cleanup-utils.yml
modules:
- description: Returns basic information for a SQL Server instance.
name: instance_info
namespace: ''
release_date: '2022-04-04'
0.3.0:
changes:
minor_changes:
- Fix logic to properly pass password policy options to function in the login
module.
release_summary: New sa module and fixes for login related modules.
fragments:
- 55-fix-login-param.yml
- v0.3.0-release-summary.yml
modules:
- description: Configure the 'sa' login for security best practices.
name: sa
namespace: ''
release_date: '2022-04-05'
0.4.0:
changes:
breaking_changes:
- All modules should use a bool 'enabled' instead of a string 'status' to control
object state.
minor_changes:
- Test for 'Name' property for sa module after dbatools release 1.1.95 standardizes
command outputs. (https://github.com/dataplat/dbatools/releases/tag/v1.1.95)
release_summary: Two new AlwaysOn modules and a few consistency fixes!
fragments:
- 0.4.0-release-summary.yml
- 56-test-for-login-name.yml
- 60-standardize-enabled-option.yml
modules:
- description: Configures availability group(s).
name: availability_group
namespace: ''
- description: Enable or disable HADR.
name: hadr
namespace: ''
release_date: '2022-04-27'
0.5.0:
changes:
minor_changes:
- Remove CI support for Ansible 2.10
release_summary: CI and testing improvements, along with the final availability
group module ag_replica.
fragments:
- 70-deprecate-ansible-2.10.yml
- release-summary.yml
modules:
- description: Configures an availability group listener.
name: ag_listener
namespace: ''
- description: Configures an availability group replica.
name: ag_replica
namespace: ''
release_date: '2022-05-11'
0.6.0:
changes:
release_summary: Adding new SPN module
fragments:
- release-summary-0-6-0.yml
modules:
- description: Configures SPNs for SQL Server.
name: spn
namespace: ''
release_date: '2022-05-20'
0.7.0:
changes:
release_summary: Add module for DBA Multitool.
fragments:
- release-summary-0-7-0.yml
modules:
- description: Install/update the DBA Multitool suite by John McCAll
name: dba_multitool
namespace: ''
release_date: '2022-05-21'
0.8.0:
changes:
bugfixes:
- Fix inability to enable an agent job schedule after it has been disabled.
minor_changes:
- Standardize use of 'database' vs 'database_name' in all documentation and
options specs. Not a breaking change.
release_summary: A few small fixes and the new 'backup' module.
fragments:
- 83-fix-agent-schedule.yml
- 84-standardize-database-option.yml
modules:
- description: Performs a backup operation.
name: backup
namespace: ''
release_date: '2022-05-31'
0.9.0:
changes:
bugfixes:
- backup - Only use blocksize when specified.
fragments:
- 90-fix-backup-blocksize.yml
modules:
- description: Performs a restore operation.
name: restore
namespace: ''
release_date: '2022-06-18'
0.9.1:
changes:
bugfixes:
- Allow agent job steps to be removed by specifying the step ID only. This is
likely needed in cleanup of steps from previous job configurations.
release_summary: Bugfix!
fragments:
- 0-9-1-release_sumary.yml
- 95-fix-agent-job-step-removal.yml
release_date: '2022-06-21'
0.9.2:
changes:
bugfixes:
- agent_job - Fix incorrectly reported change status when no change occurred.
- agent_job_schedule - Fix incorrectly reported change status when no change
occurred.
- agent_job_step - Fix incorrectly reported change status when no change occurred.
release_summary: Bugfixes for agent related modules that incorrectly reported
change statuses.
fragments:
- 97-fix-agent-related-status.yml
- 97-release-summary.yml
release_date: '2022-06-22'
0.9.3:
changes:
bugfixes:
- memory - Fix improper changed detection.
release_summary: More change detection fixing.
fragments:
- 100-fix-memory.yml
- v0-9-3-release-summary.yml
release_date: '2022-06-22'
1.0.0:
changes:
release_summary: "Bumping to version 1.0.0 now that this collection is being
used in production in at least one place \U0001F389"
fragments:
- v1-release-summary.yml
release_date: '2022-08-03'
1.0.1:
changes:
bugfixes:
- Fixed bug in how the classifier function name is being assigned to the variable
in the resource_governor module.
release_summary: Minor bug fix.
fragments:
- 1-0-1-release_summary.yml
- resource_governor.yml
release_date: '2022-08-20'
1.0.2:
changes:
bugfixes:
- _SqlServerUtils module_util - added explicit license to private module util
(https://github.com/lowlydba/lowlydba.sqlserver/pull/119).
- meta/runtime.yml - updated out of date runtime version info (https://github.com/lowlydba/lowlydba.sqlserver/pull/119).
- most modules - fixed alignment, formatting, and typos in module documentation
(https://github.com/lowlydba/lowlydba.sqlserver/pull/119).
release_summary: Minor documentation bugfixes and enhancements as requested
in the Ansible inclusion process.
fragments:
- 119-doc-updates.yml
- v1-0-2-release-summary.yml
release_date: '2022-08-29'
1.0.3:
changes:
bugfixes:
- Minor documentation fixes (https://github.com/lowlydba/lowlydba.sqlserver/pull/122).
release_summary: Minor documentation fixes from the second Ansible inclusion
review.
fragments:
- 122-doc-fixes.yml
- v1-0-3-release-summary.yml
release_date: '2022-09-03'
1.0.4:
changes:
bugfixes:
- Fix cleanup_time default to match documentation default & lint fixes (https://github.com/lowlydba/lowlydba.sqlserver/pull/127).
release_summary: Minor fixes to resolve new dlevel sanity checks.
fragments:
- 127-fix-doc-check.yml
- release-summary.yml
release_date: '2022-11-05'
1.1.0:
changes:
release_summary: Adding a new user module.
modules:
- description: Configures a user within a database
name: user
namespace: ''
release_date: '2022-11-12'
1.1.1:
changes:
minor_changes:
- modules - all modules now document their platform and support for check mode
in their attributes documentation (https://github.com/lowlydba/lowlydba.sqlserver/pull/134).
fragments:
- 137-add-attributes.yml
release_date: '2022-11-28'
1.1.2:
changes:
bugfixes:
- Removed the default value for xp_dirtree to allow compatibility with Azure
SQL Mangaed instances (https://github.com/lowlydba/lowlydba.sqlserver/pull/141)
release_summary: Bug fix for Azure Database Managed Instance compatibility.
fragments:
- 1-1-2-release-summary.yml
- xpdirtree_sql_mi_bugfix.yml
release_date: '2022-12-02'
1.1.3:
changes:
bugfixes:
- Removed default value for reuse_source_folder_structure to fix compatability
with SQL MI (https://github.com/lowlydba/lowlydba.sqlserver/pull/145)
release_summary: Another minor fix to increase SQL Managed Instance support.
fragments:
- reuse_source_folder_structure_sql_mi_bugfix.yml
- v1-1-3-release-summary.yml
release_date: '2022-12-05'
1.2.0:
changes:
bugfixes:
- Removed default value for ReplaceDbNameInFile to fix compatability with SQL
MI (https://github.com/lowlydba/lowlydba.sqlserver/pull/148)
minor_changes:
- Fixed typo in the traceflag module's documentation. (https://github.com/lowlydba/lowlydba.sqlserver/pull/150)
- Return "RestartRequired" when a module performs changes that require an addition
service restart to take effect. (https://github.com/lowlydba/lowlydba.sqlserver/pull/150/)
release_summary: Azure SQL MI compatibility fixes & indicating required restarts
for settings changes.
fragments:
- 1-2-0-release-summary.yml
- 150-restart-indicator.yml
- ReplaceDbNameInFile_sql_mi_bugfix.yml
release_date: '2022-12-05'
1.2.1:
changes:
bugfixes:
- Added missing mapping for UseDestinationDefaultDirectories (https://github.com/lowlydba/lowlydba.sqlserver/pull/153)
- Removed default value for KeepCDC to fix compatability with SQL MI (https://github.com/lowlydba/lowlydba.sqlserver/pull/153)
- Removed default value for UseDestinationDefaultDirectories to fix compatability
with SQL MI (https://github.com/lowlydba/lowlydba.sqlserver/pull/153)
release_summary: More Azure SQL Managed Instance compatibility fixes.
fragments:
- 1-2-1-release_summary.yml
- 153-additional_sql_mi_fixes.yml
release_date: '2022-12-06'
1.3.0:
changes:
minor_changes:
- Adding a new credential module
release_summary: New module to manage credentials added!
fragments:
- 1-3-0-release_summary.yml
- add_credential_module.yml
modules:
- description: Configures a credential on a SQL server
name: credential
namespace: ''
release_date: '2022-12-09'
1.3.1:
changes:
bugfixes:
- Fixes to incorrect variable reference in Login module (https://github.com/lowlydba/lowlydba.sqlserver/pull/161)
minor_changes:
- Update login module documentation to indicate result will always be changed
when a password is supplied. (https://github.com/lowlydba/lowlydba.sqlserver/pull/167)
release_summary: Small bugfixes and documentation enhancements.
fragments:
- 1-3-1-release_summary.yml
- 167-update-login-docs.yml
- fix_sa.yml
release_date: '2022-12-18'