dbachecks

2.0.14

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.14 (current version) 1,429 8/23/2021
2.0.13 4 8/23/2021
2.0.12 861 7/20/2021
2.0.11 2,892 4/7/2021
2.0.10 17 4/7/2021
2.0.9 1,966 12/14/2020
2.0.8 212 11/24/2020
2.0.7 328 9/22/2020
2.0.4 730 7/16/2020
2.0.3 857 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 321 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 179 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