dbachecks

2.0.8

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

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

Install-PSResource -Name dbachecks -Version 2.0.8

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


## Date November 23rd 2020

Finally Rob gets around to working on PRs - Really sorry it has taken so long

Fixes for bug 780 & 783 #784 - Thank you @TheAntGreen
Fix local windows groups, additional filter needed on the object filter #789 - Thank you @TheAntGreen
null check for anything running SQL2008R2 or below as containment doesnt exist in those versions. #790 - Thank you @TheAntGreen

Fix for IsClustered checks for service startup types #792  - Thank you @TheAntGreen

CertCheck took ages to run, was still checking excluded DB's then filtering, change to not query the excluded DBs #793  - Thank you @TheAntGreen

Fixed few typos in docs #799 - Thank you @jpomfret

Fixed few typos in docs #799 - Thank you @TheAntGreen

DuplicateIndex Check - Added new configuration option to allow people to filter out databases, as SSRS DB's have duplicate indexes and names are configuration in older versions, defaults to ReportServer & ReportServerTempDB

GuestUserConnect - Changes method to Get-Database instead of InstanceSMO so its easier to filter out none accessable databases as the check would report false positives for offline or restoring databases

NotExpectedTraceFlag - added a filter to filter out any trace flags which WHERE expected to prevent false positive alerts #801 - Thank you @TheAntGreen

Add policy to exclude databases on the trustworthy check #806  - Thank you @TheAntGreen

Unused Index Check wasn't executing correctly #808   - Thank you @TheAntGreen

#803 Addition of the date filter for File Autogrowth detection #809   - Thank you @TheAntGreen

New Check - Agent Mail Profile #811   - Thank you @TheAntGreen

Scan for startup procs, use config option to override the value in use #813  - Thank you @TheAntGreen

##Latest

Run Get-DbcReleaseNotes for all release notes
           

FileList

Version History

Version Downloads Last updated
3.1.0-previe... 261 3/24/2025
3.0.2 4,382 3/10/2025
3.0.1-previe... 261 3/26/2024
3.0.1-previe... 57 1/5/2024
3.0.1-previe... 16 12/13/2023
3.0.1-previe... 97 9/7/2023
3.0.1-previe... 11 8/30/2023
3.0.1-previe... 11 8/28/2023
3.0.1-previe... 10 8/28/2023
3.0.1-previe... 12 8/28/2023
3.0.1-previe... 10 8/26/2023
3.0.1-previe... 14 8/19/2023
3.0.1-previe... 10 8/19/2023
3.0.1-previe... 10 8/16/2023
3.0.1-previe... 12 8/3/2023
3.0.1-previe... 15 7/18/2023
3.0.1-previe... 16 7/11/2023
3.0.1-previe... 10 7/10/2023
3.0.1-previe... 19 6/21/2023
3.0.1-previe... 20 5/31/2023
3.0.1-previe... 19 5/12/2023
3.0.1-previe... 16 5/9/2023
3.0.1-previe... 27 4/13/2023
3.0.1-previe... 9 4/12/2023
3.0.1-previe... 10 4/12/2023
3.0.1-previe... 9 4/11/2023
3.0.1-previe... 12 4/6/2023
3.0.1-previe... 13 3/30/2023
3.0.1-previe... 11 3/28/2023
3.0.1-previe... 9 3/28/2023
3.0.1-previe... 15 3/28/2023
3.0.1-previe... 29 3/7/2023
3.0.1-previe... 11 3/4/2023
3.0.1-previe... 17 2/18/2023
3.0.0-previe... 12 2/11/2023
3.0.0-previe... 10 2/11/2023
3.0.0-previe... 30 1/2/2023
2.0.18 36,378 2/3/2022
2.0.17 24 2/3/2022
2.0.16 51 2/2/2022
2.0.14 3,597 8/23/2021
2.0.13 22 8/23/2021
2.0.12 880 7/20/2021
2.0.11 2,916 4/7/2021
2.0.10 35 4/7/2021
2.0.9 2,198 12/14/2020
2.0.8 (current version) 240 11/24/2020
2.0.7 350 9/22/2020
2.0.4 752 7/16/2020
2.0.3 874 5/9/2020
1.2.29 635 3/29/2020
1.2.26 152 3/21/2020
1.2.25 129 3/15/2020
1.2.24 1,326 1/9/2020
1.2.22 336 12/22/2019
1.2.21 392 11/28/2019
1.2.20 84 11/26/2019
1.2.19 49 11/26/2019
1.2.18 30 11/26/2019
1.2.16 128 11/20/2019
1.2.15 665 10/17/2019
1.2.14 303 10/1/2019
1.2.13 29 10/1/2019
1.2.12 1,036 7/30/2019
1.2.11 35 7/30/2019
1.2.10 29 7/30/2019
1.2.9 78 7/29/2019
1.2.8 39 7/29/2019
1.2.7 36 7/29/2019
1.2.6 127 7/23/2019
1.2.5 329 7/8/2019
1.2.4 150 7/2/2019
1.2.3 33 7/2/2019
1.1.173 937 5/22/2019
1.1.172 92 5/21/2019
1.1.171 1,755 2/7/2019
1.1.170 60 2/6/2019
1.1.169 143 1/31/2019
1.1.168 73 1/29/2019
1.1.164 216 1/19/2019
1.1.162 937 11/23/2018
1.1.161 371 11/12/2018
1.1.160 357 10/29/2018
1.1.159 79 10/27/2018
1.1.158 30 10/27/2018
1.1.157 401 10/18/2018
1.1.156 225 10/11/2018
1.1.155 261 9/29/2018
1.1.153 103 9/25/2018
1.1.152 347 9/7/2018
1.1.151 97 9/5/2018
1.1.150 239 8/28/2018
1.1.149 122 8/24/2018
1.1.148 53 8/23/2018
1.1.147 199 8/16/2018
1.1.146 43 8/15/2018
1.1.145 42 8/15/2018
1.1.144 57 8/14/2018
1.1.143 59 8/13/2018
1.1.142 185 8/6/2018
1.1.141 162 7/31/2018
1.1.140 70 7/30/2018
1.1.139 615 6/28/2018
1.1.138 637 5/30/2018
1.1.137 32 5/30/2018
1.1.136 128 5/27/2018
1.1.135 31 5/27/2018
1.1.134 29 5/27/2018
1.1.133 74 5/25/2018
1.1.132 143 5/22/2018
1.1.130 35 5/22/2018
1.1.129 31 5/22/2018
1.1.128 132 5/19/2018
1.1.127 197 5/11/2018
1.1.126 74 5/9/2018
1.1.125 40 5/9/2018
1.1.124 244 4/27/2018
1.1.123 90 4/24/2018
1.1.122 145 4/19/2018
1.1.121 223 4/12/2018
1.1.120 127 4/10/2018
1.1.119 112 4/8/2018
1.1.118 107 4/4/2018
1.1.117 109 4/2/2018
1.1.116 49 3/31/2018
1.1.115 236 3/22/2018
1.1.114 95 3/20/2018
1.1.113 121 3/18/2018
1.1.112 48 3/17/2018
1.1.111 85 3/15/2018
1.1.110 62 3/14/2018
1.1.109 81 3/13/2018
1.1.108 172 3/8/2018
1.1.107 94 3/7/2018
1.1.106 44 3/7/2018
1.1.105 28 3/7/2018
1.1.104 115 3/6/2018
1.1.103 63 3/5/2018
1.1.102 39 3/5/2018
1.1.101 99 3/3/2018
1.0.9 33 3/3/2018
1.0.7 192 3/1/2018
1.0.5 64 2/28/2018
1.0.3 242 2/26/2018
1.0.2 105 2/26/2018
1.0.1 204 2/24/2018
1.0.0 402 2/22/2018
Show less