dbachecks
1.2.20
SQL Server Infrastructure validation Tests to ensure that your SQL Server estate is and continues to be compliant with your requirements
Minimum PowerShell version
5.0
See the version list below for details.
Installation Options
Owners
Copyright
(c) 2018. All rights reserved.
Package Details
Author(s)
- SQL Community Collaborative
Tags
sqlserver sql dba databases audits checklists Pester PowerBi validation
Functions
Get-DbcConfig Get-DbcConfigValue Get-DbcReleaseNote Set-DbcConfig Reset-DbcConfig Invoke-DbcCheck Invoke-DbcConfigFile Import-DbcConfig Export-DbcConfig Start-DbcPowerBi Update-DbcPowerBiDataSource Get-DbcTagCollection Get-DbcCheck Clear-DbcPowerBiDataSource Save-DbcRequiredModules Update-DbcRequiredModules
Dependencies
-
- dbatools (>= 1.0.23)
- Pester (>= 4.7.1)
- PSFramework (>= 1.0.0)
Release Notes
## Date 26th November
Thank you Tracey tboggiano
Added new CIS Check for OLE AUtomation Procedures to be disabled #707
Moving the Cross DB Ownership Chaining check into the AllInstance check to help speed up checks #708
Thank you Rob
Fixing the Tags so that they are picked up by AllInstanceInfo Fixes #715
##Latest
Run Get-DbcReleaseNotes for all release notes
FileList
- dbachecks.nuspec
- builddocs.ps1
- CODE_OF_CONDUCT.md
- dbachecks.psd1
- dbachecks.psm1
- header-mkdocs.yml
- install.ps1
- LICENSE
- mkdocs.yml
- readme.md
- RELEASE.md
- Test-Pester.XML
- bin\dbachecks.pbit
- bin\dbachecks.pbix
- bin\ReportUnit.exe
- checks\Agent.Tests.ps1
- checks\Database.Tests.ps1
- checks\Domain.Tests.ps1
- checks\HADR.Tests.ps1
- checks\Instance.Tests.ps1
- checks\LogShipping.Tests.ps1
- checks\MaintenanceSolution.Tests.ps1
- checks\Server.Tests.ps1
- docs\index.md
- docs\RELEASE.md
- docs\functions\Clear-DbcPowerBiDataSource.md
- docs\functions\Export-DbcConfig.md
- docs\functions\Get-DbcCheck.md
- docs\functions\Get-DbcConfig.md
- docs\functions\Get-DbcConfigValue.md
- docs\functions\Get-DbcReleaseNote.md
- docs\functions\Get-DbcTagCollection.md
- docs\functions\Import-DbcConfig.md
- docs\functions\Invoke-DbcCheck.md
- docs\functions\Invoke-DbcConfigFile.md
- docs\functions\Reset-DbcConfig.md
- docs\functions\Save-DbcRequiredModules.md
- docs\functions\Set-DbcConfig.md
- docs\functions\Start-DbcPowerBi.md
- docs\functions\Update-DbcPowerBiDataSource.md
- docs\functions\Update-DbcRequiredModules.md
- en-us\about_dbachecks.help.txt
- functions\Clear-DbcPowerBiDataSource.ps1
- functions\Export-DbcConfig.ps1
- functions\Get-DbcCheck.ps1
- functions\Get-DbcConfig.ps1
- functions\Get-DbcConfigValue.ps1
- functions\Get-DbcReleaseNote.ps1
- functions\Get-DbcTagCollection.ps1
- functions\Import-DbcConfig.ps1
- functions\Invoke-DbcCheck.ps1
- functions\Invoke-DbcConfigFile.ps1
- functions\Reset-DbcConfig.ps1
- functions\Save-DbcRequiredModules.ps1
- functions\Send-DbcMailMessage.ps1
- functions\Set-DbcConfig.ps1
- functions\Start-DbcPowerBi.ps1
- functions\Update-DbcPowerBiDataSource.ps1
- functions\Update-DbcRequiredModules.ps1
- internal\assertions\Agent.Assertions.ps1
- internal\assertions\Database.Assertions.ps1
- internal\assertions\Instance.Assertions.ps1
- internal\assertions\Server.Assertions.ps1
- internal\configurations\configuration.ps1
- internal\configurations\DbcCheckDescriptions.json
- internal\functions\Convert-ConfigValueToBoolean.ps1
- internal\functions\Get-CheckFile.ps1
- internal\functions\Get-CheckInformation.ps1
- internal\functions\Get-CheckRepo.ps1
- internal\functions\Get-ComputerName.ps1
- internal\functions\Get-DatabaseDetail.ps1
- internal\functions\Get-SqlInstance.ps1
- internal\functions\Get-Version.ps1
- internal\functions\Invoke-ConfigurationScript.ps1
- internal\functions\New-Json.ps1
- internal\functions\Select-DefaultView.ps1
- internal\functions\Set-DatabaseForIntegrationTesting.ps1
- internal\scripts\postimport.ps1
- internal\scripts\preimport.ps1
- internal\tepp\autocomplete.ps1
- xml\dbachecks.Format.ps1xml
Version History
Version | Downloads | Last updated |
---|---|---|
3.0.1-previe... | 99 | 3/26/2024 |
3.0.1-previe... | 54 | 1/5/2024 |
3.0.1-previe... | 13 | 12/13/2023 |
3.0.1-previe... | 93 | 9/7/2023 |
3.0.1-previe... | 8 | 8/30/2023 |
3.0.1-previe... | 9 | 8/28/2023 |
3.0.1-previe... | 7 | 8/28/2023 |
3.0.1-previe... | 9 | 8/28/2023 |
3.0.1-previe... | 7 | 8/26/2023 |
3.0.1-previe... | 11 | 8/19/2023 |
3.0.1-previe... | 7 | 8/19/2023 |
3.0.1-previe... | 8 | 8/16/2023 |
3.0.1-previe... | 10 | 8/3/2023 |
3.0.1-previe... | 12 | 7/18/2023 |
3.0.1-previe... | 12 | 7/11/2023 |
3.0.1-previe... | 7 | 7/10/2023 |
3.0.1-previe... | 16 | 6/21/2023 |
3.0.1-previe... | 17 | 5/31/2023 |
3.0.1-previe... | 16 | 5/12/2023 |
3.0.1-previe... | 13 | 5/9/2023 |
3.0.1-previe... | 24 | 4/13/2023 |
3.0.1-previe... | 7 | 4/12/2023 |
3.0.1-previe... | 7 | 4/12/2023 |
3.0.1-previe... | 7 | 4/11/2023 |
3.0.1-previe... | 9 | 4/6/2023 |
3.0.1-previe... | 10 | 3/30/2023 |
3.0.1-previe... | 8 | 3/28/2023 |
3.0.1-previe... | 7 | 3/28/2023 |
3.0.1-previe... | 9 | 3/28/2023 |
3.0.1-previe... | 26 | 3/7/2023 |
3.0.1-previe... | 8 | 3/4/2023 |
3.0.1-previe... | 12 | 2/18/2023 |
3.0.0-previe... | 10 | 2/11/2023 |
3.0.0-previe... | 8 | 2/11/2023 |
3.0.0-previe... | 27 | 1/2/2023 |
2.0.18 | 25,229 | 2/3/2022 |
2.0.17 | 20 | 2/3/2022 |
2.0.16 | 42 | 2/2/2022 |
2.0.14 | 3,592 | 8/23/2021 |
2.0.13 | 19 | 8/23/2021 |
2.0.12 | 877 | 7/20/2021 |
2.0.11 | 2,911 | 4/7/2021 |
2.0.10 | 31 | 4/7/2021 |
2.0.9 | 2,192 | 12/14/2020 |
2.0.8 | 236 | 11/24/2020 |
2.0.7 | 345 | 9/22/2020 |
2.0.4 | 746 | 7/16/2020 |
2.0.3 | 870 | 5/9/2020 |
1.2.29 | 630 | 3/29/2020 |
1.2.26 | 147 | 3/21/2020 |
1.2.25 | 124 | 3/15/2020 |
1.2.24 | 1,317 | 1/9/2020 |
1.2.22 | 317 | 12/22/2019 |
1.2.21 | 384 | 11/28/2019 |
1.2.20 (current version) | 75 | 11/26/2019 |
1.2.19 | 40 | 11/26/2019 |
1.2.18 | 21 | 11/26/2019 |
1.2.16 | 119 | 11/20/2019 |
1.2.15 | 656 | 10/17/2019 |
1.2.14 | 293 | 10/1/2019 |
1.2.13 | 21 | 10/1/2019 |
1.2.12 | 1,028 | 7/30/2019 |
1.2.11 | 26 | 7/30/2019 |
1.2.10 | 20 | 7/30/2019 |
1.2.9 | 70 | 7/29/2019 |
1.2.8 | 30 | 7/29/2019 |
1.2.7 | 28 | 7/29/2019 |
1.2.6 | 118 | 7/23/2019 |
1.2.5 | 321 | 7/8/2019 |
1.2.4 | 141 | 7/2/2019 |
1.2.3 | 24 | 7/2/2019 |
1.1.173 | 931 | 5/22/2019 |
1.1.172 | 86 | 5/21/2019 |
1.1.171 | 1,748 | 2/7/2019 |
1.1.170 | 54 | 2/6/2019 |
1.1.169 | 137 | 1/31/2019 |
1.1.168 | 67 | 1/29/2019 |
1.1.164 | 210 | 1/19/2019 |
1.1.162 | 931 | 11/23/2018 |
1.1.161 | 365 | 11/12/2018 |
1.1.160 | 348 | 10/29/2018 |
1.1.159 | 73 | 10/27/2018 |
1.1.158 | 24 | 10/27/2018 |
1.1.157 | 386 | 10/18/2018 |
1.1.156 | 219 | 10/11/2018 |
1.1.155 | 255 | 9/29/2018 |
1.1.153 | 97 | 9/25/2018 |
1.1.152 | 341 | 9/7/2018 |
1.1.151 | 91 | 9/5/2018 |
1.1.150 | 230 | 8/28/2018 |
1.1.149 | 116 | 8/24/2018 |
1.1.148 | 47 | 8/23/2018 |
1.1.147 | 193 | 8/16/2018 |
1.1.146 | 38 | 8/15/2018 |
1.1.145 | 37 | 8/15/2018 |
1.1.144 | 52 | 8/14/2018 |
1.1.143 | 53 | 8/13/2018 |
1.1.142 | 179 | 8/6/2018 |
1.1.141 | 157 | 7/31/2018 |
1.1.140 | 65 | 7/30/2018 |
1.1.139 | 610 | 6/28/2018 |
1.1.138 | 632 | 5/30/2018 |
1.1.137 | 27 | 5/30/2018 |
1.1.136 | 122 | 5/27/2018 |
1.1.135 | 26 | 5/27/2018 |
1.1.134 | 23 | 5/27/2018 |
1.1.133 | 69 | 5/25/2018 |
1.1.132 | 137 | 5/22/2018 |
1.1.130 | 30 | 5/22/2018 |
1.1.129 | 26 | 5/22/2018 |
1.1.128 | 125 | 5/19/2018 |
1.1.127 | 191 | 5/11/2018 |
1.1.126 | 68 | 5/9/2018 |
1.1.125 | 34 | 5/9/2018 |
1.1.124 | 238 | 4/27/2018 |
1.1.123 | 85 | 4/24/2018 |
1.1.122 | 139 | 4/19/2018 |
1.1.121 | 218 | 4/12/2018 |
1.1.120 | 122 | 4/10/2018 |
1.1.119 | 106 | 4/8/2018 |
1.1.118 | 101 | 4/4/2018 |
1.1.117 | 103 | 4/2/2018 |
1.1.116 | 44 | 3/31/2018 |
1.1.115 | 229 | 3/22/2018 |
1.1.114 | 90 | 3/20/2018 |
1.1.113 | 115 | 3/18/2018 |
1.1.112 | 42 | 3/17/2018 |
1.1.111 | 80 | 3/15/2018 |
1.1.110 | 53 | 3/14/2018 |
1.1.109 | 75 | 3/13/2018 |
1.1.108 | 165 | 3/8/2018 |
1.1.107 | 89 | 3/7/2018 |
1.1.106 | 38 | 3/7/2018 |
1.1.105 | 23 | 3/7/2018 |
1.1.104 | 109 | 3/6/2018 |
1.1.103 | 58 | 3/5/2018 |
1.1.102 | 33 | 3/5/2018 |
1.1.101 | 94 | 3/3/2018 |
1.0.9 | 27 | 3/3/2018 |
1.0.7 | 187 | 3/1/2018 |
1.0.5 | 58 | 2/28/2018 |
1.0.3 | 236 | 2/26/2018 |
1.0.2 | 99 | 2/26/2018 |
1.0.1 | 198 | 2/24/2018 |
1.0.0 | 396 | 2/22/2018 |