dbachecks
1.2.7
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 29th July 2019
Thank you @TracyBoggiano
Added tags for checks that will be part of CIS checks #642
CIS project started
Added check for default trace enabled #684
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
- 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
- xml\dbachecks.Format.ps1xml
- 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
- 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
Version History
Version | Downloads | Last updated |
---|---|---|
3.0.1-previe... | 71 | 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... | 8 | 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 | 21,230 | 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,173 | 12/14/2020 |
2.0.8 | 236 | 11/24/2020 |
2.0.7 | 345 | 9/22/2020 |
2.0.4 | 743 | 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 | 316 | 12/22/2019 |
1.2.21 | 384 | 11/28/2019 |
1.2.20 | 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 (current version) | 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 | 385 | 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 |