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.0.1-previe... 21 3/26/2024
3.0.1-previe... 47 1/5/2024
3.0.1-previe... 10 12/13/2023
3.0.1-previe... 90 9/7/2023
3.0.1-previe... 5 8/30/2023
3.0.1-previe... 5 8/28/2023
3.0.1-previe... 4 8/28/2023
3.0.1-previe... 6 8/28/2023
3.0.1-previe... 4 8/26/2023
3.0.1-previe... 8 8/19/2023
3.0.1-previe... 4 8/19/2023
3.0.1-previe... 5 8/16/2023
3.0.1-previe... 7 8/3/2023
3.0.1-previe... 9 7/18/2023
3.0.1-previe... 9 7/11/2023
3.0.1-previe... 4 7/10/2023
3.0.1-previe... 13 6/21/2023
3.0.1-previe... 14 5/31/2023
3.0.1-previe... 13 5/12/2023
3.0.1-previe... 10 5/9/2023
3.0.1-previe... 21 4/13/2023
3.0.1-previe... 4 4/12/2023
3.0.1-previe... 4 4/12/2023
3.0.1-previe... 4 4/11/2023
3.0.1-previe... 6 4/6/2023
3.0.1-previe... 7 3/30/2023
3.0.1-previe... 5 3/28/2023
3.0.1-previe... 4 3/28/2023
3.0.1-previe... 6 3/28/2023
3.0.1-previe... 23 3/7/2023
3.0.1-previe... 5 3/4/2023
3.0.1-previe... 9 2/18/2023
3.0.0-previe... 7 2/11/2023
3.0.0-previe... 5 2/11/2023
3.0.0-previe... 23 1/2/2023
2.0.18 15,330 2/3/2022
2.0.17 17 2/3/2022
2.0.16 39 2/2/2022
2.0.14 3,589 8/23/2021
2.0.13 16 8/23/2021
2.0.12 874 7/20/2021
2.0.11 2,908 4/7/2021
2.0.10 28 4/7/2021
2.0.9 2,135 12/14/2020
2.0.8 (current version) 233 11/24/2020
2.0.7 341 9/22/2020
2.0.4 740 7/16/2020
2.0.3 867 5/9/2020
1.2.29 627 3/29/2020
1.2.26 144 3/21/2020
1.2.25 121 3/15/2020
1.2.24 1,314 1/9/2020
1.2.22 312 12/22/2019
1.2.21 380 11/28/2019
1.2.20 72 11/26/2019
1.2.19 37 11/26/2019
1.2.18 18 11/26/2019
1.2.16 116 11/20/2019
1.2.15 653 10/17/2019
1.2.14 289 10/1/2019
1.2.13 18 10/1/2019
1.2.12 1,024 7/30/2019
1.2.11 23 7/30/2019
1.2.10 17 7/30/2019
1.2.9 67 7/29/2019
1.2.8 27 7/29/2019
1.2.7 25 7/29/2019
1.2.6 115 7/23/2019
1.2.5 318 7/8/2019
1.2.4 138 7/2/2019
1.2.3 21 7/2/2019
1.1.173 928 5/22/2019
1.1.172 83 5/21/2019
1.1.171 1,745 2/7/2019
1.1.170 51 2/6/2019
1.1.169 134 1/31/2019
1.1.168 64 1/29/2019
1.1.164 207 1/19/2019
1.1.162 928 11/23/2018
1.1.161 362 11/12/2018
1.1.160 345 10/29/2018
1.1.159 70 10/27/2018
1.1.158 21 10/27/2018
1.1.157 382 10/18/2018
1.1.156 216 10/11/2018
1.1.155 252 9/29/2018
1.1.153 94 9/25/2018
1.1.152 338 9/7/2018
1.1.151 88 9/5/2018
1.1.150 226 8/28/2018
1.1.149 113 8/24/2018
1.1.148 44 8/23/2018
1.1.147 190 8/16/2018
1.1.146 35 8/15/2018
1.1.145 34 8/15/2018
1.1.144 49 8/14/2018
1.1.143 50 8/13/2018
1.1.142 176 8/6/2018
1.1.141 154 7/31/2018
1.1.140 62 7/30/2018
1.1.139 607 6/28/2018
1.1.138 629 5/30/2018
1.1.137 24 5/30/2018
1.1.136 119 5/27/2018
1.1.135 23 5/27/2018
1.1.134 20 5/27/2018
1.1.133 66 5/25/2018
1.1.132 134 5/22/2018
1.1.130 27 5/22/2018
1.1.129 23 5/22/2018
1.1.128 122 5/19/2018
1.1.127 187 5/11/2018
1.1.126 65 5/9/2018
1.1.125 31 5/9/2018
1.1.124 235 4/27/2018
1.1.123 82 4/24/2018
1.1.122 136 4/19/2018
1.1.121 215 4/12/2018
1.1.120 119 4/10/2018
1.1.119 103 4/8/2018
1.1.118 98 4/4/2018
1.1.117 100 4/2/2018
1.1.116 41 3/31/2018
1.1.115 226 3/22/2018
1.1.114 87 3/20/2018
1.1.113 112 3/18/2018
1.1.112 39 3/17/2018
1.1.111 77 3/15/2018
1.1.110 50 3/14/2018
1.1.109 72 3/13/2018
1.1.108 162 3/8/2018
1.1.107 86 3/7/2018
1.1.106 35 3/7/2018
1.1.105 20 3/7/2018
1.1.104 106 3/6/2018
1.1.103 55 3/5/2018
1.1.102 30 3/5/2018
1.1.101 91 3/3/2018
1.0.9 24 3/3/2018
1.0.7 184 3/1/2018
1.0.5 55 2/28/2018
1.0.3 233 2/26/2018
1.0.2 96 2/26/2018
1.0.1 195 2/24/2018
1.0.0 393 2/22/2018
Show less