All notable changes to this project will be documented in this file.
The format is based on Keep a Changelog and this project adheres to Semantic Versioning.
v5.0.4 - 2025-02-18
- (CAT-2222) Update legacy facts #485 (amitkarsale)
v5.0.2 - 2024-07-18
v5.0.1 - 2024-02-22
v5.0.0 - 2024-02-16
- [CAT-1065] : Removing support for SQL Server 2012 #455 (rajat-puppet)
- (Bug) - Remove default switch of UpdateEnabled=false when Action=Install #466 (jordanbreen28)
- (bugfix) Update Issues URL #456 (pmcmaw)
v4.1.0 - 2023-06-27
- pdksync - (MAINT) - Allow Stdlib 9.x #438 (LukasAud)
- (CONT-567) allow deferred function for password #436 (Ramesh7)
v4.0.0 - 2023-04-26
- (CONT-800) - Add Puppet 8/Drop Puppet 6 #430 (jordanbreen28)
v3.3.0 - 2023-03-07
- (CONT-490) - Add support for SQL Server 2022 #420 (jordanbreen28)
v3.2.1 - 2022-12-13
v3.2.0 - 2022-08-23
v3.1.0 - 2022-05-30
- pdksync - (FM-8922) - Add Support for Windows 2022 #397 (david22swan)
- (MODULES-5472) Login values can now be passed as sensitive strings #393 (david22swan)
- (MODULES-10825) - Dotnet installation fix #392 (david22swan)
v3.0.0 - 2021-03-03
- pdksync - Remove Puppet 5 from testing and bump minimal version to 6.0.0 #369 (carabasdaniel)
- pdksync - (feat) - Add support for Puppet 7 #363 (daianamezdrea)
- (FM-8879) Handle T-SQL Errors Properly #349 (RandomNoun7)
v2.6.2 - 2020-01-21
- (MODULES-10384) - Registry value check tightened #343 (david22swan)
- (MODULES-10335) - Update exec's title to be unique #341 (david22swan)
v2.6.1 - 2020-01-20
- (MODULES-10388) fix missing gem #339 (sheenaajay)
v2.6.0 - 2019-10-22
- Add support for Server 2019 #327 (sanfrancrisko)
v2.5.1 - 2019-09-20
- (MODULES-9912) ERB Template Errors #320 (RandomNoun7)
- (MODULES-6904) Restart SQL Server Service with Dependent Services #315 (RandomNoun7)
- (MODULES-8439) Fix sqlserver_instances custom fact #314 (carabasdaniel)
- (MODULES-8600) add DQC to sqlserver_features #313 (tphoney)
2.5.0 - 2019-03-26
- (MODULES-8610) Add start agent job task #301 (RandomNoun7)
- (MODULES-8749) Make job_name param required. #303 (RandomNoun7)
- (MAINT) Increase timeout interval #306 (RandomNoun7)
- (MODULES-8761) Docs release review #305 (clairecadman)
2.4.0 - 2019-03-12
- Release Prep 2.4.0 #298 (RandomNoun7)
- (MODULES-8721) README edit #297 (clairecadman)
- (MODULES-8677) Made resource title unique among many instances #296 (dylanratcliffe)
- (MODULES-8685) Changed END to be in the same conditional as BEGIN #295 (dylanratcliffe)
- (MODULES-8692) Get Agent Jobs Task #294 (RandomNoun7)
- (MODULES-8606) Add SQL Logins Tasks #291 (RandomNoun7)
- (MAINT) Migrate test resources to artifactory - Fix Pipelines. #290 (RandomNoun7)
- (MODULES-8489) Mergeback to master #289 (ThoughtCrhyme)
2.3.0 - 2019-01-22
- (MODULES-8485) Release Prep 2.3.0 #288 (RandomNoun7)
- (MAINT) Fix changelog. #287 (RandomNoun7)
- Updated license terms #286 (turbodog)
- (MODULES-8438) Install 2019 #285 (RandomNoun7)
- (maint) Update pdk template #284 (jpogran)
- (MODULES-8130) Merge-back of release to master #283 (glennsarti)
- MODULES-7734 Detect installed features with value greater than 1 #274 (GrammatonKlaric)
2.2.0 - 2018-12-04
- Update Release Date In Changelog #281 (RandomNoun7)
- (MAINT) fix CHANGELOG compare link #280 (ThoughtCrhyme)
- (MODULES-8126) release prep for 2.2.0 #279 (ThoughtCrhyme)
- (L10n) Updating translations for readmes/README_ja_JP.md #278 (ThoughtCrhyme)
- (MODULES-7833) Update metadata for Puppet 6 #277 (ThoughtCrhyme)
- (maint) Spec fixes #273 (Iristyle)
- pdksync - (MODULES-7658) use beaker4 in puppet-module-gems #272 (tphoney)
- pdksync - (MODULES-7705) - Bumping stdlib dependency from < 5.0.0 to < 6.0.0 #271 (pmcmaw)
- pdksync - (MODULES-7658) use beaker3 in puppet-module-gems #270 (tphoney)
- (MODULES-7406) PDK Convert the module #269 (glennsarti)
- Merge Release Back To Master #268 (RandomNoun7)
2.1.1 - 2018-03-14
- (MAINT) Fix Release Date in Changelog #267 (RandomNoun7)
- (MAINT) Fix Changelog Link #266 (RandomNoun7)
- (MODULES-6760) prep for 2.1.1 release #265 (RandomNoun7)
- (DOCUMENT-824) Update Changelog Format #264 (RandomNoun7)
- (MODULES-6281) Return Errors from T-SQL #263 (RandomNoun7)
- (FM-6605) Add CONTRIBUTING.MD to repository #262 (glennsarti)
- (maint) modulesync 65530a4 Update Travis #260 (michaeltlombardi)
- (MODULES-6356) Fixes a problem still remaining from MODULES-2904 #259 (kreeuwijk)
- (maint) modulesync cd884db Remove AppVeyor OpenSSL update on Ruby 2.4 #258 (michaeltlombardi)
- (maint) - modulesync 384f4c1 #256 (tphoney)
- Merge Release back to master #255 (jpogran)
2.1.0 - 2017-12-08
- (MODULES-6239) prep for 2.1.0 release #254 (RandomNoun7)
- (MODULES-6244) Update 2017 Support #253 (RandomNoun7)
- Merge Release back to Master #252 (michaeltlombardi)
- (MODULES-6168) Detect SQL 2017 #251 (RandomNoun7)
2.0.2 - 2017-12-04
- (MODULES-6022) Make SQLServer Instance Idempotent Again #250 (michaeltlombardi)
- (maint) - modulesync 1d81b6a #248 (pmcmaw)
- Merge release back into master #247 (glennsarti)
- (FM-6464) Update metadata for open sourcing #245 (michaeltlombardi)
2.0.1 - 2017-11-14
- (MODULES-5961) Prep for release 2.0.1 #246 (michaeltlombardi)
- (MAINT) Correct supported versions & platforms #244 (michaeltlombardi)
- (MODULES-5693) Replace SQLOLEDB with SQLNCLI11 #243 (michaeltlombardi)
- (maint) Remove instance during acceptance tests #242 (glennsarti)
- (MODULES-5566) Rewrite Instance Discovery #241 (michaeltlombardi)
- (Maintenance) remove redundant rake task #240 (ThoughtCrhyme)
- Added 2016 to supported versions #239 (davinhanlon)
- (maint) modulesync 892c4cf #238 (HAIL9000)
- release 2.0.0 mergeback #237 (eputnam)
2.0.0 - 2017-08-10
- (maint) Update changelog to comply with Puppet formatting #236 (glennsarti)
- (maint) modulesync 915cde70e20 #235 (glennsarti)
- (MODULES-5209) Prepare for 2.0.0 release #234 (glennsarti)
- (FM-6141) Add test-tiering, and README to spec directory #233 (ThoughtCrhyme)
- some edits for sqlserver changes #232 (jbondpdx)
- (MODULES-5070) Add polybase parameters to sql_instance #231 (glennsarti)
- (MODULES-5126) Use integer in acceptance test #230 (glennsarti)
- (MODULES-5187)(MODULES-52080) mysnc puppet 5 and ruby 2.4 #229 (eputnam)
- (MODULES-5144) Prep for puppet 5 #228 (hunner)
- (MODULES-5126) Puppet4ing SQL Server #227 (glennsarti)
- (maint) Add more advanced examples to documentation #226 (glennsarti)
- (MODULES-4842) Update puppet compatibility with 4.7 as lower bound #225 (glennsarti)
- (MODULES-4915) Remove forced TCP connection for SQL management #224 (glennsarti)
- (FM-5062) Add testmode switcher to sqlserver module #223 (ThoughtCrhyme)
- (FM-5021) Escaping identifiers when creating a database #222 (glennsarti)
- (MODULES-2543) Purge members from SQL Server Role #221 (glennsarti)
- (MODULES-2386) Using as_sysadmin_accounts without AS feature should error #220 (glennsarti)
- (FM-5389) Fix sql_features when installing SNAC_SDK #219 (glennsarti)
- (FM-5389) Add missing shared feature SNAC_SDK #218 (glennsarti)
- (MODULES-5030) Remove service_ensure parameter #217 (glennsarti)
- (MODULES-5092) Failures during .Net 3 installation should be obvious #216 (glennsarti)
- (MODULES-4257) Modify instance and features for SQL Server 2016 #215 (glennsarti)
- (maint) Update test helper for SQL Server 2016 #213 (glennsarti)
- (MODULES-5031) Modify facts for SQL Server 2016 #212 (glennsarti)
- (MODULES-4257) Add SQL Server 2016 support in acceptance tests #211 (glennsarti)
- Release mergeback #210 (pmcmaw)
1.2.0 - 2017-05-09
- 1.2.0 Release Prep #209 (HelenCampbell)
- fixing a typo for jp translation #208 (jbondpdx)
- Adding correct project url and newline to metadata #207 (HelenCampbell)
- (MODULES-4667) Update beaker tests for Jenkins CI #206 (glennsarti)
- [msync] 786266 Implement puppet-module-gems, a45803 Remove metadata.json from locales config #205 (wilson208)
- (MODULES-4334) - Adding locales directory, POT file and config.yaml #204 (pmcmaw)
- [MODULES-4528] Replace Puppet.version comparison with Puppet::Util::Package.versioncmp #203 (wilson208)
- (maint) Release mergeback #202 (DavidS)
1.1.6 - 2017-03-07
- [FM-6077] Release 1.1.6 #201 (wilson208)
- [PE-17491] Do not fail on install when a restart exit code is returned #200 (wilson208)
1.1.5 - 2017-02-16
- (FM-6026) Release 1.1.5 #199 (glennsarti)
- (MODULES-4321): edit sqlserver for loc #198 (jbondpdx)
- (maint) Prime Feature and Instance installation with .Net 3.5 source #197 (wilson208)
- (MODULES-4098) Sync the rest of the files #196 (hunner)
- [MODULES-4255] Obfuscate passwords in sqlserver_instance #195 (wilson208)
- (MODULES-4263) add blacksmith rake tasks #194 (eputnam)
- (MODULES-4097) Sync travis.yml #193 (hunner)
- (FM-5972) Update to next modulesync_configs [dedaf10] #192 (DavidS)
- (MODULES-3632) Use json_pure always #191 (hunner)
- (MODULES-3704) Update gemfile template to be identical #190 (hunner)
1.1.4 - 2016-08-31
- (FM-5476) (docs) Edits for docs signoff #189 (gguillotte)
- (MODULES-3775) (msync 8d0455c) update travis/appveyer w/Ruby 2.3 #188 (MosesMendoza)
- (maint) modulesync 70360747 #187 (glennsarti)
- (FM-5473) Release 1.1.4 #186 (glennsarti)
- (MODULES-3752) Fix modifying server_roles for an existing WINDOWS_LOGIN #185 (glennsarti)
- (BKR-914) Add workaround for beaker bug BKR-914 #184 (glennsarti)
- (MODULES-3202) Fix install dependencies with custom source #183 (glennsarti)
- (MODULES-3256)(MODULES-2323)(MODULES-2554)(MODULES-3083) Fix sqlserver::login resource #182 (glennsarti)
- (MODULES-3640) Update modulesync 30fc4ab #181 (MosesMendoza)
- (PA-285) Branding name change #166 (jpogran)
1.1.3 - 2016-07-12
- (MODULES-3493) Prepare for Release v1.1.3 #179 (glennsarti)
- (MODULES-3536) modsync update #177 (glennsarti)
- (maint) Update rakefile for puppetlabs_spec_helper #176 (glennsarti)
- (FM-5387) Remove simplecov gem and update for modsync #175 (glennsarti)
- (PE-16132) Add Windows Based Authentication for sqlserver::config #174 (glennsarti)
- (FM-5324) Fix TSQL error propagation #173 (Iristyle)
- (maint) remove trailing README whitespace #171 (Iristyle)
- (MODULES-3355) Fix acceptance tests for Sqlserver role #169 (jpogran)
- (MODULES-3356) Branding Name Change #168 (jpogran)
- (MODULES-3355) Fix Role Name Collisions #167 (jpogran)
- Merge up to master from stable after modsync changes #165 (ferventcoder)
- (maint) modsync update - stable #163 (glennsarti)
- (MODULES-3240) Fix rspec-puppet incompatibility #162 (glennsarti)
1.1.2 - 2016-04-08
- (FM-5081) Supported Release 1.1.2 #160 (ferventcoder)
- (FM-5080) add Puppet version ranges #159 (ferventcoder)
- (FM-5041) Install PE License for Acceptance Testing #158 (cowofevil)
- (FM-4918) update modsync / Restrict Rake ~> 10.1 #153 (ferventcoder)
1.1.1 - 2015-12-08
- (FM-3940) Fix specs - Puppet 4.x validation errors #155 (ferventcoder)
- (FM-3502) Release 1.1.1 #154 (ferventcoder)
- (FM-3706)Create database with optional compatibility breaks CI #152 (phongdly)
- (FM-3655) SQL Server CI acceptance issues #151 (phongdly)
- (MODULES-2497) SQLSERVER - Create Automated Tests for sqlserver::login #150 (phongdly)
- (MODULES-2496) Create Automated Tests for sqlserver::database #149 (phongdly)
- (MODULES-3094) Release 1.1.0 #148 (cyberious)
- (MODULES-2469) Create Automated Tests for sqlserver::role #147 (phongdly)
- (MODULES-2454)/Automated_Test_For_Database_User #142 (phongdly)
- Merge master to stable #136 (cyberious)
1.1.0 - 2015-09-08
- (MODULES-2498) Fix the check on removal #146 (cyberious)
- (MODULES-2498) generate random instance name in each context #145 (phongdly)
- (MODULES-2464) Simplify query for sp_configure check #144 (cyberious)
- (MODULES-2453) Create Automated Tests for sqlserver_tsql #141 (phongdly)
- (MODULES-2392) Automated Tests for sqlserver::config #140 (phongdly)
- (MODULES-2451) Fix issue with integer interpretations #139 (cyberious)
- (FM-3094) Prepare for release 1.1.0 #137 (cyberious)
- (maint) Guarantee Facter version for old Puppets / (MODULES-2452) Update Beaker Version #135 (ferventcoder)
- (MODULES-2391) Create Automated Tests For sqlserver_instance 2015-08-26 #134 (phongdly)
- (MODULES-2430) Fix issue parsing facts with puppet 4 #133 (cyberious)
- (FM-3252) CI Pipeline for sqlserver at step 7a #132 (phongdly)
- (MODULES-2403) Improve error handling for sqlserver_tsql #131 (cyberious)
- (MODULES-2377) Add validation for sp_configure bools #130 (cyberious)
- (docs) Several docs updates #129 (cyberious)
- (docs) MODULES-2325 update readme to reflect permissions #128 (cyberious)
- (DO NOT MERGE)(MODULES-2312) Use sp_executesql to execute T-SQL #127 (Iristyle)
- (maint) puppetlabs_spec_helper ~>0.10.3 #125 (ferventcoder)
- (maint) replaced debian6 by centos7 master in nodesets yml files #124 (phongdly)
- (MODULES-2207) bin beaker-rspec to ~> 5.1 #123 (ferventcoder)
- (MODULES-2245) Fixes issue with assumption of strings #122 (cyberious)
- (MODULES-2207) Modulesync #121 (ferventcoder)
- (maint) Move to use Beaker-puppet_install_helper #120 (cyberious)
- (maint) fix future parser acceptance failures #119 (Iristyle)
- (maint) remove unneeded pre-suite module installs #118 (Iristyle)
- Fix Jenkins acceptance failures #117 (Iristyle)
- (FM-2303, FM-2790, FM-2445) WMI / Registry impl of Discovery Report #116 (Iristyle)
- (maint) remove references to beaker method step #115 (zreichert)
- (maint) Inject CommonProgramFiles env var #113 (Iristyle)
- (FM-2791) Add database param to sqlserver_tsql #112 (cyberious)
- Update README per DOC-1595 #110 (psoloway)
- (maint) Lint and strict variables #109 (cyberious)
- (MAINT) remove forge host from nodesets #108 (zreichert)
- (maint) fix module installation #107 (Iristyle)
- (FM-2713) Remove sqlserver::config file requirement #106 (cyberious)
- (FM-2577) Minor SQL server connection building refactorings #105 (Iristyle)
- (fix) - upcase instance name so we always have a consistent pattern to how SQL Server reports back names #104 (cyberious)
- (fix) - Autoload property sqlserver_tsql when running from master #100 (cyberious)
- (FM-2577) - Change from sqlcmd.exe to win32ole connector #99 (cyberious)
- (maint) - Add .geppetto-rc.json to configure excludes #98 (cyberious)
- Fix spec tests raise_error check #91 (cyberious)
- Setup acceptance tests #87 (zreichert)
- (BKR-147) add Gemfile setting for BEAKER_VERSION for puppet... #84 (anodelman)
- FM-2328: document install_switches param in sqlserver #82 (jbondpdx)
- FM-2303 Add install switches needed by customer #81 (cyberious)
- FM-2298 and FM-2299 update Login and User to take hash of permissions #79 (cyberious)
- FM-2303 Add install switches to sqlserver_install and sqlserver_features #78 (cyberious)
- FM-2288 Role members #77 (cyberious)
- FM-2287 Add Role Permissions ability #76 (cyberious)
- Update sqlserver_validate_range to take array #74 (cyberious)
- (DO NOT MERGE) - Pending Readme changes for Review #73 (cyberious)
- FM-1556 Add ability to manage login server level permissions #72 (cyberious)
- FM-2236 Add with_grant_option for user permissions #71 (cyberious)
- FM-1898 Add sqlserver::user::permssion with GRANT, REVOKE and DENY #70 (cyberious)
- FM1901 Add delete user capabilities #69 (cyberious)
- FM-1900 Add User defined type #68 (cyberious)
- Fix bug with TSQL provider rework #67 (cyberious)
- DOC-1510: edit tsql additions #66 (jbondpdx)
- FM-2110 README Predocs for sqlserver_tsql provider #65 (cyberious)
- FM-2110 Prep TSQL provider ... #64 (cyberious)
- FM-2102 fix examples/sp_configure.pp #63 (cyberious)
- FM-2122: Deleted irrelevant contribution information #62 (jbondpdx)
- add geppetto-rc file to ignore examples #61 (justinstoller)
- Fix metadata.json and capture back puppet module build metadata.json #60 (cyberious)