dbachecks

2.0.18

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 Set-DbcCisConfig

PSEditions

Desktop Core

Dependencies

Release Notes


## 23rd August 20
Removed the Verbose for the Pester load - Apologies, this was Rob!
Thank you [@MikeyBronowski](https://www.github.com/MikeyBronowski) Get the file at the end so Export-DbcConfig can be used with Invoke-Item addresses #843 #845
Thank you [@MikeyBronowski](https://www.github.com/MikeyBronowski) spelling and full stops #842
Thank you [ashdar](https://github.com/ashdar) Check for existence in the Tag list before adding a Tag to the Tag list #853
Thank you [ashdar](https://github.com/ashdar) Updated PowerPlan Assertion #850
Thank you [tboggiano](https://github.com/tboggiano) CIS check for SQL Mail XPS for SQL Server 2008 and below (was) #779
Thank you [tboggiano](https://github.com/tboggiano) Added function to set CIS config (was) #776
Thank you [tboggiano](https://github.com/tboggiano) CIS check for TCP IP Protocols (was) #775

##Latest

Run Get-DbcReleaseNotes for all release notes
           

Version History

Version Downloads Last updated
2.0.18 (current version) 3,803 2/3/2022
2.0.17 10 2/3/2022
2.0.16 32 2/2/2022
2.0.14 3,578 8/23/2021
2.0.13 11 8/23/2021
2.0.12 868 7/20/2021
2.0.11 2,898 4/7/2021
2.0.10 22 4/7/2021
2.0.9 2,053 12/14/2020
2.0.8 223 11/24/2020
2.0.7 336 9/22/2020
2.0.4 735 7/16/2020
2.0.3 862 5/9/2020
1.2.29 620 3/29/2020
1.2.26 138 3/21/2020
1.2.25 115 3/15/2020
1.2.24 1,306 1/9/2020
1.2.22 305 12/22/2019
1.2.21 374 11/28/2019
1.2.20 66 11/26/2019
1.2.19 31 11/26/2019
1.2.18 12 11/26/2019
1.2.16 110 11/20/2019
1.2.15 647 10/17/2019
1.2.14 283 10/1/2019
1.2.13 12 10/1/2019
1.2.12 1,018 7/30/2019
1.2.11 17 7/30/2019
1.2.10 11 7/30/2019
1.2.9 61 7/29/2019
1.2.8 21 7/29/2019
1.2.7 19 7/29/2019
1.2.6 109 7/23/2019
1.2.5 312 7/8/2019
1.2.4 132 7/2/2019
1.2.3 15 7/2/2019
1.1.173 921 5/22/2019
1.1.172 77 5/21/2019
1.1.171 1,739 2/7/2019
1.1.170 45 2/6/2019
1.1.169 128 1/31/2019
1.1.168 57 1/29/2019
1.1.164 201 1/19/2019
1.1.162 921 11/23/2018
1.1.161 356 11/12/2018
1.1.160 339 10/29/2018
1.1.159 64 10/27/2018
1.1.158 15 10/27/2018
1.1.157 355 10/18/2018
1.1.156 210 10/11/2018
1.1.155 246 9/29/2018
1.1.153 88 9/25/2018
1.1.152 332 9/7/2018
1.1.151 82 9/5/2018
1.1.150 220 8/28/2018
1.1.149 107 8/24/2018
1.1.148 38 8/23/2018
1.1.147 184 8/16/2018
1.1.146 29 8/15/2018
1.1.145 28 8/15/2018
1.1.144 43 8/14/2018
1.1.143 44 8/13/2018
1.1.142 170 8/6/2018
1.1.141 148 7/31/2018
1.1.140 56 7/30/2018
1.1.139 601 6/28/2018
1.1.138 623 5/30/2018
1.1.137 18 5/30/2018
1.1.136 112 5/27/2018
1.1.135 16 5/27/2018
1.1.134 14 5/27/2018
1.1.133 60 5/25/2018
1.1.132 128 5/22/2018
1.1.130 20 5/22/2018
1.1.129 17 5/22/2018
1.1.128 115 5/19/2018
1.1.127 181 5/11/2018
1.1.126 59 5/9/2018
1.1.125 25 5/9/2018
1.1.124 229 4/27/2018
1.1.123 76 4/24/2018
1.1.122 129 4/19/2018
1.1.121 209 4/12/2018
1.1.120 113 4/10/2018
1.1.119 97 4/8/2018
1.1.118 92 4/4/2018
1.1.117 94 4/2/2018
1.1.116 35 3/31/2018
1.1.115 220 3/22/2018
1.1.114 81 3/20/2018
1.1.113 106 3/18/2018
1.1.112 33 3/17/2018
1.1.111 71 3/15/2018
1.1.110 44 3/14/2018
1.1.109 66 3/13/2018
1.1.108 155 3/8/2018
1.1.107 80 3/7/2018
1.1.106 29 3/7/2018
1.1.105 14 3/7/2018
1.1.104 100 3/6/2018
1.1.103 49 3/5/2018
1.1.102 24 3/5/2018
1.1.101 85 3/3/2018
1.0.9 17 3/3/2018
1.0.7 178 3/1/2018
1.0.5 49 2/28/2018
1.0.3 227 2/26/2018
1.0.2 90 2/26/2018
1.0.1 190 2/24/2018
1.0.0 388 2/22/2018