dbachecks
1.1.153
SQL Server Infrastructure validation Tests to ensure that your SQL Server estate is and continues to be compliant with your requirements
Minimum PowerShell version
4.0
See the version list below for details.
Installation Options
Owners
Copyright
(c) 2017. 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 (>= 0.9.410)
- Pester (>= 4.3.1)
- PSFramework (>= 0.9.23.82)
Release Notes
## Date 24/09/2018
Moved the Instance Connection Check to the Instance Tests
Fixed bug with Set-DbcConfig not adding none-arrays!
New Check for Expected Trace Flags
New Check for Not Expected TraceFlags
Stopped dbatools chatty messages polluting the test results
Run Get-DbcReleaseNotes for all release notes
FileList
- dbachecks.nuspec
- CODE_OF_CONDUCT.md
- dbachecks.psd1
- dbachecks.psm1
- install.ps1
- LICENSE
- readme.md
- .git\COMMIT_EDITMSG
- .git\config
- .git\description
- .git\FETCH_HEAD
- .git\HEAD
- .git\index
- .github\issue_template.md
- .github\Pull_Request_Template.md
- 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
- 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
- .git\hooks\applypatch-msg.sample
- .git\hooks\commit-msg.sample
- .git\hooks\fsmonitor-watchman.sample
- .git\hooks\post-update.sample
- .git\hooks\pre-applypatch.sample
- .git\hooks\pre-commit.sample
- .git\hooks\pre-push.sample
- .git\hooks\pre-rebase.sample
- .git\hooks\pre-receive.sample
- .git\hooks\prepare-commit-msg.sample
- .git\hooks\update.sample
- .git\info\exclude
- .git\logs\HEAD
- .github\ISSUE_TEMPLATE\bug_report.md
- .github\ISSUE_TEMPLATE\feature_request.md
- .github\ISSUE_TEMPLATE\question.md
- internal\assertions\Database.Assertions.ps1
- internal\assertions\Instance.Assertions.ps1
- internal\assertions\Server.Assertions.ps1
- internal\configurations\configuration.ps1
- internal\configurations\DbcCheckDescriptions.json
- internal\configurations\ReleaseNotes.txt
- 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
- tests\checks\DatabaseChecks.Tests.ps1
- tests\checks\InstanceChecks.Tests.ps1
- tests\checks\ServerChecks.Tests.ps1
- tests\functions\Export-DbcConfig.Tests.ps1
- tests\functions\get-check.json
- tests\functions\Get-CheckFile.Tests.ps1
- tests\functions\Get-CheckInformation.tests.ps1
- tests\functions\Get-DatabaseDetail.Tests.ps1
- tests\functions\Get-DbcCheck.Tests.ps1
- tests\functions\Get-DbcConfig.Tests.ps1
- tests\functions\Get-DbcConfigValue.Tests.ps1
- tests\functions\Get-DbcTagCollection.Tests.ps1
- tests\functions\Import-DbcConfig.Tests.ps1
- tests\functions\Invoke-DbcCheck.Tests.ps1
- tests\functions\Invoke-DbcConfigFile.Tests.ps1
- tests\functions\Set-DbcConfig.Tests.ps1
- .git\objects\3a\a3dd669a9279cbd72ed373179cfe05219dbbd0
- .git\objects\9a\b3e4ff11c941a7d032d34a37252b4ae0252cd0
- .git\objects\fc\96173099a7b1b30bb76fd7e3b8d3876a46f676
- .git\objects\pack\pack-37512da92e17ca46b1c7d671e116aeddb2502d27.idx
- .git\objects\pack\pack-37512da92e17ca46b1c7d671e116aeddb2502d27.pack
- .git\refs\remotes\origin\ccc
- .git\refs\remotes\origin\development
- .git\refs\remotes\origin\master
- .git\logs\refs\remotes\origin\ccc
- .git\logs\refs\remotes\origin\development
- .git\logs\refs\remotes\origin\master
Version History
Version | Downloads | Last updated |
---|---|---|
3.0.2 | 51 | 3/10/2025 |
3.0.1-previe... | 257 | 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 | 33,749 | 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,194 | 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 | 318 | 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 | 351 | 10/29/2018 |
1.1.159 | 73 | 10/27/2018 |
1.1.158 | 24 | 10/27/2018 |
1.1.157 | 388 | 10/18/2018 |
1.1.156 | 219 | 10/11/2018 |
1.1.155 | 255 | 9/29/2018 |
1.1.153 (current version) | 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 |