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

Installation Options

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

Install-Module -Name dbachecks

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

Author(s)

SQL Community Collaborative

Copyright

(c) 2020. All rights reserved.

Owners

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
           

Version History

Version Downloads Last updated
2.0.11 (current version) 894 4/7/2021
2.0.10 17 4/7/2021
2.0.9 1,887 12/14/2020
2.0.8 211 11/24/2020
2.0.7 328 9/22/2020
2.0.4 729 7/16/2020
2.0.3 854 5/9/2020
1.2.29 610 3/29/2020
1.2.26 133 3/21/2020
1.2.25 110 3/15/2020
1.2.24 1,299 1/9/2020
1.2.22 299 12/22/2019
1.2.21 368 11/28/2019
1.2.20 61 11/26/2019
1.2.19 26 11/26/2019
1.2.18 6 11/26/2019
1.2.16 105 11/20/2019
1.2.15 641 10/17/2019
1.2.14 278 10/1/2019
1.2.13 7 10/1/2019
1.2.12 1,011 7/30/2019
1.2.11 12 7/30/2019
1.2.10 6 7/30/2019
1.2.9 56 7/29/2019
1.2.8 16 7/29/2019
1.2.7 14 7/29/2019
1.2.6 104 7/23/2019
1.2.5 307 7/8/2019
1.2.4 127 7/2/2019
1.2.3 10 7/2/2019
1.1.173 916 5/22/2019
1.1.172 72 5/21/2019
1.1.171 1,734 2/7/2019
1.1.170 40 2/6/2019
1.1.169 123 1/31/2019
1.1.168 52 1/29/2019
1.1.164 196 1/19/2019
1.1.162 916 11/23/2018
1.1.161 351 11/12/2018
1.1.160 334 10/29/2018
1.1.159 58 10/27/2018
1.1.158 10 10/27/2018
1.1.157 276 10/18/2018
1.1.156 205 10/11/2018
1.1.155 241 9/29/2018
1.1.153 83 9/25/2018
1.1.152 327 9/7/2018
1.1.151 77 9/5/2018
1.1.150 209 8/28/2018
1.1.149 102 8/24/2018
1.1.148 33 8/23/2018
1.1.147 178 8/16/2018
1.1.146 24 8/15/2018
1.1.145 23 8/15/2018
1.1.144 38 8/14/2018
1.1.143 39 8/13/2018
1.1.142 165 8/6/2018
1.1.141 143 7/31/2018
1.1.140 50 7/30/2018
1.1.139 596 6/28/2018
1.1.138 618 5/30/2018
1.1.137 13 5/30/2018
1.1.136 107 5/27/2018
1.1.135 11 5/27/2018
1.1.134 9 5/27/2018
1.1.133 53 5/25/2018
1.1.132 123 5/22/2018
1.1.130 15 5/22/2018
1.1.129 11 5/22/2018
1.1.128 110 5/19/2018
1.1.127 176 5/11/2018
1.1.126 54 5/9/2018
1.1.125 20 5/9/2018
1.1.124 222 4/27/2018
1.1.123 71 4/24/2018
1.1.122 124 4/19/2018
1.1.121 204 4/12/2018
1.1.120 108 4/10/2018
1.1.119 92 4/8/2018
1.1.118 87 4/4/2018
1.1.117 89 4/2/2018
1.1.116 30 3/31/2018
1.1.115 215 3/22/2018
1.1.114 75 3/20/2018
1.1.113 101 3/18/2018
1.1.112 28 3/17/2018
1.1.111 66 3/15/2018
1.1.110 39 3/14/2018
1.1.109 61 3/13/2018
1.1.108 150 3/8/2018
1.1.107 75 3/7/2018
1.1.106 23 3/7/2018
1.1.105 9 3/7/2018
1.1.104 95 3/6/2018
1.1.103 44 3/5/2018
1.1.102 19 3/5/2018
1.1.101 80 3/3/2018
1.0.9 12 3/3/2018
1.0.7 173 3/1/2018
1.0.5 44 2/28/2018
1.0.3 222 2/26/2018
1.0.2 85 2/26/2018
1.0.1 184 2/24/2018
1.0.0 381 2/22/2018