dbachecks

2.0.10

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

There is a newer prerelease version of this module available.
See the version list below for details.

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name dbachecks -RequiredVersion 2.0.10

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name dbachecks -Version 2.0.10

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

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

Desktop Core

Dependencies

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

Version History

Version Downloads Last updated
3.1.0-previe... 261 3/24/2025
3.0.2 4,381 3/10/2025
3.0.1-previe... 261 3/26/2024
3.0.1-previe... 57 1/5/2024
3.0.1-previe... 16 12/13/2023
3.0.1-previe... 97 9/7/2023
3.0.1-previe... 11 8/30/2023
3.0.1-previe... 11 8/28/2023
3.0.1-previe... 10 8/28/2023
3.0.1-previe... 12 8/28/2023
3.0.1-previe... 10 8/26/2023
3.0.1-previe... 14 8/19/2023
3.0.1-previe... 10 8/19/2023
3.0.1-previe... 10 8/16/2023
3.0.1-previe... 12 8/3/2023
3.0.1-previe... 15 7/18/2023
3.0.1-previe... 16 7/11/2023
3.0.1-previe... 10 7/10/2023
3.0.1-previe... 19 6/21/2023
3.0.1-previe... 20 5/31/2023
3.0.1-previe... 19 5/12/2023
3.0.1-previe... 16 5/9/2023
3.0.1-previe... 27 4/13/2023
3.0.1-previe... 9 4/12/2023
3.0.1-previe... 10 4/12/2023
3.0.1-previe... 9 4/11/2023
3.0.1-previe... 12 4/6/2023
3.0.1-previe... 13 3/30/2023
3.0.1-previe... 11 3/28/2023
3.0.1-previe... 9 3/28/2023
3.0.1-previe... 15 3/28/2023
3.0.1-previe... 29 3/7/2023
3.0.1-previe... 11 3/4/2023
3.0.1-previe... 17 2/18/2023
3.0.0-previe... 12 2/11/2023
3.0.0-previe... 10 2/11/2023
3.0.0-previe... 30 1/2/2023
2.0.18 36,378 2/3/2022
2.0.17 24 2/3/2022
2.0.16 51 2/2/2022
2.0.14 3,597 8/23/2021
2.0.13 22 8/23/2021
2.0.12 880 7/20/2021
2.0.11 2,916 4/7/2021
2.0.10 (current version) 35 4/7/2021
2.0.9 2,198 12/14/2020
2.0.8 240 11/24/2020
2.0.7 350 9/22/2020
2.0.4 752 7/16/2020
2.0.3 874 5/9/2020
1.2.29 635 3/29/2020
1.2.26 152 3/21/2020
1.2.25 129 3/15/2020
1.2.24 1,326 1/9/2020
1.2.22 336 12/22/2019
1.2.21 392 11/28/2019
1.2.20 84 11/26/2019
1.2.19 49 11/26/2019
1.2.18 30 11/26/2019
1.2.16 128 11/20/2019
1.2.15 665 10/17/2019
1.2.14 303 10/1/2019
1.2.13 29 10/1/2019
1.2.12 1,036 7/30/2019
1.2.11 35 7/30/2019
1.2.10 29 7/30/2019
1.2.9 78 7/29/2019
1.2.8 39 7/29/2019
1.2.7 36 7/29/2019
1.2.6 127 7/23/2019
1.2.5 329 7/8/2019
1.2.4 150 7/2/2019
1.2.3 33 7/2/2019
1.1.173 937 5/22/2019
1.1.172 92 5/21/2019
1.1.171 1,755 2/7/2019
1.1.170 60 2/6/2019
1.1.169 143 1/31/2019
1.1.168 73 1/29/2019
1.1.164 216 1/19/2019
1.1.162 937 11/23/2018
1.1.161 371 11/12/2018
1.1.160 357 10/29/2018
1.1.159 79 10/27/2018
1.1.158 30 10/27/2018
1.1.157 401 10/18/2018
1.1.156 225 10/11/2018
1.1.155 261 9/29/2018
1.1.153 103 9/25/2018
1.1.152 347 9/7/2018
1.1.151 97 9/5/2018
1.1.150 239 8/28/2018
1.1.149 122 8/24/2018
1.1.148 53 8/23/2018
1.1.147 199 8/16/2018
1.1.146 43 8/15/2018
1.1.145 42 8/15/2018
1.1.144 57 8/14/2018
1.1.143 59 8/13/2018
1.1.142 185 8/6/2018
1.1.141 162 7/31/2018
1.1.140 70 7/30/2018
1.1.139 615 6/28/2018
1.1.138 637 5/30/2018
1.1.137 32 5/30/2018
1.1.136 128 5/27/2018
1.1.135 31 5/27/2018
1.1.134 29 5/27/2018
1.1.133 74 5/25/2018
1.1.132 143 5/22/2018
1.1.130 35 5/22/2018
1.1.129 31 5/22/2018
1.1.128 132 5/19/2018
1.1.127 197 5/11/2018
1.1.126 74 5/9/2018
1.1.125 40 5/9/2018
1.1.124 244 4/27/2018
1.1.123 90 4/24/2018
1.1.122 145 4/19/2018
1.1.121 223 4/12/2018
1.1.120 127 4/10/2018
1.1.119 112 4/8/2018
1.1.118 107 4/4/2018
1.1.117 109 4/2/2018
1.1.116 49 3/31/2018
1.1.115 236 3/22/2018
1.1.114 95 3/20/2018
1.1.113 121 3/18/2018
1.1.112 48 3/17/2018
1.1.111 85 3/15/2018
1.1.110 62 3/14/2018
1.1.109 81 3/13/2018
1.1.108 172 3/8/2018
1.1.107 94 3/7/2018
1.1.106 44 3/7/2018
1.1.105 28 3/7/2018
1.1.104 115 3/6/2018
1.1.103 63 3/5/2018
1.1.102 39 3/5/2018
1.1.101 99 3/3/2018
1.0.9 33 3/3/2018
1.0.7 192 3/1/2018
1.0.5 64 2/28/2018
1.0.3 242 2/26/2018
1.0.2 105 2/26/2018
1.0.1 204 2/24/2018
1.0.0 402 2/22/2018
Show less