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

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

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

Install-PSResource -Name dbachecks -Version 2.0.18

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

FileList

Version History

Version Downloads Last updated
3.0.1-previe... 36 1/5/2024
3.0.1-previe... 8 12/13/2023
3.0.1-previe... 88 9/7/2023
3.0.1-previe... 3 8/30/2023
3.0.1-previe... 3 8/28/2023
3.0.1-previe... 2 8/28/2023
3.0.1-previe... 4 8/28/2023
3.0.1-previe... 2 8/26/2023
3.0.1-previe... 6 8/19/2023
3.0.1-previe... 2 8/19/2023
3.0.1-previe... 3 8/16/2023
3.0.1-previe... 5 8/3/2023
3.0.1-previe... 7 7/18/2023
3.0.1-previe... 7 7/11/2023
3.0.1-previe... 2 7/10/2023
3.0.1-previe... 11 6/21/2023
3.0.1-previe... 12 5/31/2023
3.0.1-previe... 11 5/12/2023
3.0.1-previe... 8 5/9/2023
3.0.1-previe... 19 4/13/2023
3.0.1-previe... 2 4/12/2023
3.0.1-previe... 2 4/12/2023
3.0.1-previe... 2 4/11/2023
3.0.1-previe... 4 4/6/2023
3.0.1-previe... 5 3/30/2023
3.0.1-previe... 3 3/28/2023
3.0.1-previe... 2 3/28/2023
3.0.1-previe... 4 3/28/2023
3.0.1-previe... 21 3/7/2023
3.0.1-previe... 3 3/4/2023
3.0.1-previe... 7 2/18/2023
3.0.0-previe... 5 2/11/2023
3.0.0-previe... 3 2/11/2023
3.0.0-previe... 21 1/2/2023
2.0.18 (current version) 14,361 2/3/2022
2.0.17 15 2/3/2022
2.0.16 37 2/2/2022
2.0.14 3,587 8/23/2021
2.0.13 14 8/23/2021
2.0.12 872 7/20/2021
2.0.11 2,906 4/7/2021
2.0.10 26 4/7/2021
2.0.9 2,130 12/14/2020
2.0.8 231 11/24/2020
2.0.7 339 9/22/2020
2.0.4 738 7/16/2020
2.0.3 865 5/9/2020
1.2.29 625 3/29/2020
1.2.26 142 3/21/2020
1.2.25 119 3/15/2020
1.2.24 1,312 1/9/2020
1.2.22 310 12/22/2019
1.2.21 378 11/28/2019
1.2.20 70 11/26/2019
1.2.19 35 11/26/2019
1.2.18 16 11/26/2019
1.2.16 114 11/20/2019
1.2.15 651 10/17/2019
1.2.14 287 10/1/2019
1.2.13 16 10/1/2019
1.2.12 1,022 7/30/2019
1.2.11 21 7/30/2019
1.2.10 15 7/30/2019
1.2.9 65 7/29/2019
1.2.8 25 7/29/2019
1.2.7 23 7/29/2019
1.2.6 113 7/23/2019
1.2.5 316 7/8/2019
1.2.4 136 7/2/2019
1.2.3 19 7/2/2019
1.1.173 926 5/22/2019
1.1.172 81 5/21/2019
1.1.171 1,743 2/7/2019
1.1.170 49 2/6/2019
1.1.169 132 1/31/2019
1.1.168 62 1/29/2019
1.1.164 205 1/19/2019
1.1.162 926 11/23/2018
1.1.161 360 11/12/2018
1.1.160 343 10/29/2018
1.1.159 68 10/27/2018
1.1.158 19 10/27/2018
1.1.157 378 10/18/2018
1.1.156 214 10/11/2018
1.1.155 250 9/29/2018
1.1.153 92 9/25/2018
1.1.152 336 9/7/2018
1.1.151 86 9/5/2018
1.1.150 224 8/28/2018
1.1.149 111 8/24/2018
1.1.148 42 8/23/2018
1.1.147 188 8/16/2018
1.1.146 33 8/15/2018
1.1.145 32 8/15/2018
1.1.144 47 8/14/2018
1.1.143 48 8/13/2018
1.1.142 174 8/6/2018
1.1.141 152 7/31/2018
1.1.140 60 7/30/2018
1.1.139 605 6/28/2018
1.1.138 627 5/30/2018
1.1.137 22 5/30/2018
1.1.136 117 5/27/2018
1.1.135 21 5/27/2018
1.1.134 18 5/27/2018
1.1.133 64 5/25/2018
1.1.132 132 5/22/2018
1.1.130 25 5/22/2018
1.1.129 21 5/22/2018
1.1.128 120 5/19/2018
1.1.127 185 5/11/2018
1.1.126 63 5/9/2018
1.1.125 29 5/9/2018
1.1.124 233 4/27/2018
1.1.123 80 4/24/2018
1.1.122 134 4/19/2018
1.1.121 213 4/12/2018
1.1.120 117 4/10/2018
1.1.119 101 4/8/2018
1.1.118 96 4/4/2018
1.1.117 98 4/2/2018
1.1.116 39 3/31/2018
1.1.115 224 3/22/2018
1.1.114 85 3/20/2018
1.1.113 110 3/18/2018
1.1.112 37 3/17/2018
1.1.111 75 3/15/2018
1.1.110 48 3/14/2018
1.1.109 70 3/13/2018
1.1.108 160 3/8/2018
1.1.107 84 3/7/2018
1.1.106 33 3/7/2018
1.1.105 18 3/7/2018
1.1.104 104 3/6/2018
1.1.103 53 3/5/2018
1.1.102 28 3/5/2018
1.1.101 89 3/3/2018
1.0.9 22 3/3/2018
1.0.7 182 3/1/2018
1.0.5 53 2/28/2018
1.0.3 231 2/26/2018
1.0.2 94 2/26/2018
1.0.1 193 2/24/2018
1.0.0 391 2/22/2018
Show less