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

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.11

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

Install-PSResource -Name dbachecks -Version 2.0.11

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.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
Show less