dbachecks
2.0.11
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
## April 7th 20
Thank you @mikedavem Fixed rogue verbose when importing #834
Thank you @mikedavem Test NetBios Over TCP/IP should be disabled for cluster network interface #833
Thank you conseilit Add LogfilePercentUsed check. Log might fill even if simple recovery model or full recovery model + Tlog backup in case of replication, CDC, HADR issues. #831 #832
Thank you conseilit Getting SQL Server instance DateTime prevent Log Backup checks to fail if the instance is not in the same timezone than the computer running dbaChecks scripts. #830
Thank you @MikeyBronowski Get-DbcConfig Adding support to multiple names #829
Thank you @MikeyBronowski Spellings #827
Thank you @TheAntGreen updated variables to make errors obvious #825
Thank you MrBlueSky - add info to suggest using Duplicate index command #807
Thank you PsPsam - Ping check to work on core and 5.1 #763
Thank you zikato - certificate expiration gives two failures if in the past #785
Thank you mikedavem - allow more than 99 days for retention for Olas jobs #835
Thank you Shashtsoh - Remove aliases to work in core #837
Thank you a4ic6n - Max Memory check false succeeds #836
##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... | 87 | 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 | 23,001 | 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 (current version) | 2,911 | 4/7/2021 |
2.0.10 | 31 | 4/7/2021 |
2.0.9 | 2,189 | 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 | 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 |