dbachecks

2.0.9

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

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

Install-PSResource -Name dbachecks -Version 2.0.9

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


## December 14th 2020

Thank you tboggiano Browser check altered for instance count #758
Thank you zikato - Fixing datafile auto growth #786
Thank you fatherjack Typos #767
Thank you tboggiano Query Store enabled and disabled test improvements #791
Thank you relsna fixed issue with error log window #814
Thank you @TheAntGreen Typos #815
Thank you @TheAntGreen Add additional filter to filter out negative run_durations #816
Thank you @TheAntGreen Add policy for additional excluded dbs from the SAFE CLR check #817
Thank you @MikeyBronowski Fix the check for enabled alerts #819
Thank you @MikeyBronowski Updating the link in documentation #820
Thank you @mikedavem Updated HADR checks with additional checks #822
Thank you @mikedavem Database backup diff check - fix issue #812 #824
       
##Latest

Run Get-DbcReleaseNotes for all release notes
           

FileList

Version History

Version Downloads Last updated
3.1.0-previe... 255 3/24/2025
3.0.2 4,129 3/10/2025
3.0.1-previe... 260 3/26/2024
3.0.1-previe... 56 1/5/2024
3.0.1-previe... 15 12/13/2023
3.0.1-previe... 96 9/7/2023
3.0.1-previe... 10 8/30/2023
3.0.1-previe... 10 8/28/2023
3.0.1-previe... 9 8/28/2023
3.0.1-previe... 11 8/28/2023
3.0.1-previe... 9 8/26/2023
3.0.1-previe... 13 8/19/2023
3.0.1-previe... 9 8/19/2023
3.0.1-previe... 9 8/16/2023
3.0.1-previe... 11 8/3/2023
3.0.1-previe... 14 7/18/2023
3.0.1-previe... 15 7/11/2023
3.0.1-previe... 9 7/10/2023
3.0.1-previe... 18 6/21/2023
3.0.1-previe... 19 5/31/2023
3.0.1-previe... 18 5/12/2023
3.0.1-previe... 15 5/9/2023
3.0.1-previe... 26 4/13/2023
3.0.1-previe... 8 4/12/2023
3.0.1-previe... 9 4/12/2023
3.0.1-previe... 8 4/11/2023
3.0.1-previe... 11 4/6/2023
3.0.1-previe... 12 3/30/2023
3.0.1-previe... 10 3/28/2023
3.0.1-previe... 8 3/28/2023
3.0.1-previe... 14 3/28/2023
3.0.1-previe... 28 3/7/2023
3.0.1-previe... 10 3/4/2023
3.0.1-previe... 16 2/18/2023
3.0.0-previe... 11 2/11/2023
3.0.0-previe... 9 2/11/2023
3.0.0-previe... 29 1/2/2023
2.0.18 36,157 2/3/2022
2.0.17 23 2/3/2022
2.0.16 50 2/2/2022
2.0.14 3,596 8/23/2021
2.0.13 21 8/23/2021
2.0.12 879 7/20/2021
2.0.11 2,915 4/7/2021
2.0.10 34 4/7/2021
2.0.9 (current version) 2,197 12/14/2020
2.0.8 239 11/24/2020
2.0.7 349 9/22/2020
2.0.4 751 7/16/2020
2.0.3 873 5/9/2020
1.2.29 634 3/29/2020
1.2.26 151 3/21/2020
1.2.25 128 3/15/2020
1.2.24 1,324 1/9/2020
1.2.22 330 12/22/2019
1.2.21 390 11/28/2019
1.2.20 82 11/26/2019
1.2.19 47 11/26/2019
1.2.18 28 11/26/2019
1.2.16 126 11/20/2019
1.2.15 663 10/17/2019
1.2.14 301 10/1/2019
1.2.13 27 10/1/2019
1.2.12 1,034 7/30/2019
1.2.11 33 7/30/2019
1.2.10 27 7/30/2019
1.2.9 76 7/29/2019
1.2.8 37 7/29/2019
1.2.7 34 7/29/2019
1.2.6 125 7/23/2019
1.2.5 327 7/8/2019
1.2.4 148 7/2/2019
1.2.3 31 7/2/2019
1.1.173 935 5/22/2019
1.1.172 90 5/21/2019
1.1.171 1,753 2/7/2019
1.1.170 58 2/6/2019
1.1.169 141 1/31/2019
1.1.168 71 1/29/2019
1.1.164 214 1/19/2019
1.1.162 935 11/23/2018
1.1.161 369 11/12/2018
1.1.160 355 10/29/2018
1.1.159 77 10/27/2018
1.1.158 28 10/27/2018
1.1.157 399 10/18/2018
1.1.156 223 10/11/2018
1.1.155 259 9/29/2018
1.1.153 101 9/25/2018
1.1.152 345 9/7/2018
1.1.151 95 9/5/2018
1.1.150 237 8/28/2018
1.1.149 120 8/24/2018
1.1.148 51 8/23/2018
1.1.147 197 8/16/2018
1.1.146 41 8/15/2018
1.1.145 40 8/15/2018
1.1.144 55 8/14/2018
1.1.143 57 8/13/2018
1.1.142 183 8/6/2018
1.1.141 160 7/31/2018
1.1.140 68 7/30/2018
1.1.139 613 6/28/2018
1.1.138 635 5/30/2018
1.1.137 30 5/30/2018
1.1.136 126 5/27/2018
1.1.135 29 5/27/2018
1.1.134 27 5/27/2018
1.1.133 72 5/25/2018
1.1.132 141 5/22/2018
1.1.130 33 5/22/2018
1.1.129 29 5/22/2018
1.1.128 130 5/19/2018
1.1.127 195 5/11/2018
1.1.126 72 5/9/2018
1.1.125 38 5/9/2018
1.1.124 242 4/27/2018
1.1.123 88 4/24/2018
1.1.122 143 4/19/2018
1.1.121 221 4/12/2018
1.1.120 125 4/10/2018
1.1.119 110 4/8/2018
1.1.118 105 4/4/2018
1.1.117 107 4/2/2018
1.1.116 47 3/31/2018
1.1.115 234 3/22/2018
1.1.114 93 3/20/2018
1.1.113 119 3/18/2018
1.1.112 46 3/17/2018
1.1.111 83 3/15/2018
1.1.110 60 3/14/2018
1.1.109 79 3/13/2018
1.1.108 170 3/8/2018
1.1.107 92 3/7/2018
1.1.106 42 3/7/2018
1.1.105 26 3/7/2018
1.1.104 113 3/6/2018
1.1.103 61 3/5/2018
1.1.102 37 3/5/2018
1.1.101 97 3/3/2018
1.0.9 31 3/3/2018
1.0.7 190 3/1/2018
1.0.5 62 2/28/2018
1.0.3 240 2/26/2018
1.0.2 103 2/26/2018
1.0.1 202 2/24/2018
1.0.0 400 2/22/2018
Show less