dbachecks
2.0.9
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.1
See the version list below for details.
Installation Options
Owners
Copyright
(c) 2020. 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 Set-DbcFile Convert-DbcResult Write-DbcTable
PSEditions
Dependencies
-
- dbatools (>= 1.0.103)
- PSFramework (>= 1.1.59)
Release Notes
## December 14th 2020
Thank you tboggiano Browser check altered for instance count #758
Thank you zikato - Fixing datafile auto growth #786
Thank you fatherjack Typos #767
Thank you tboggiano Query Store enabled and disabled test improvements #791
Thank you relsna fixed issue with error log window #814
Thank you @TheAntGreen Typos #815
Thank you @TheAntGreen Add additional filter to filter out negative run_durations #816
Thank you @TheAntGreen Add policy for additional excluded dbs from the SAFE CLR check #817
Thank you @MikeyBronowski Fix the check for enabled alerts #819
Thank you @MikeyBronowski Updating the link in documentation #820
Thank you @mikedavem Updated HADR checks with additional checks #822
Thank you @mikedavem Database backup diff check - fix issue #812 #824
##Latest
Run Get-DbcReleaseNotes for all release notes
FileList
- dbachecks.nuspec
- builddocs.ps1
- CODE_OF_CONDUCT.md
- dbachecks.psd1
- dbachecks.psm1
- header-mkdocs.yml
- LICENSE
- mkdocs.yml
- PSScriptAnalyzerSettings.psd1
- readme.md
- RELEASE.md
- Test-Pester.XML
- workspace.code-workspace
- bin\dbachecks-FromDatabase.pbit
- 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\Convert-DbcResult.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\Set-DbcFile.md
- docs\functions\Start-DbcPowerBi.md
- docs\functions\Update-DbcPowerBiDataSource.md
- docs\functions\Update-DbcRequiredModules.md
- docs\functions\Write-DbcTable.md
- en-us\about_dbachecks.help.txt
- functions\Clear-DbcPowerBiDataSource.ps1
- functions\Convert-DbcResult.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\Set-DbcConfig.ps1
- functions\Set-DbcFile.ps1
- functions\Start-DbcPowerBi.ps1
- functions\Update-DbcPowerBiDataSource.ps1
- functions\Update-DbcRequiredModules.ps1
- functions\Write-DbcTable.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 (current version) | 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 | 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 |