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'