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... 87 3/26/2024
3.0.1-previe... 54 1/5/2024
3.0.1-previe... 13 12/13/2023
3.0.1-previe... 93 9/7/2023
3.0.1-previe... 8 8/30/2023
3.0.1-previe... 8 8/28/2023
3.0.1-previe... 7 8/28/2023
3.0.1-previe... 9 8/28/2023
3.0.1-previe... 7 8/26/2023
3.0.1-previe... 11 8/19/2023
3.0.1-previe... 7 8/19/2023
3.0.1-previe... 8 8/16/2023
3.0.1-previe... 10 8/3/2023
3.0.1-previe... 12 7/18/2023
3.0.1-previe... 12 7/11/2023
3.0.1-previe... 7 7/10/2023
3.0.1-previe... 16 6/21/2023
3.0.1-previe... 17 5/31/2023
3.0.1-previe... 16 5/12/2023
3.0.1-previe... 13 5/9/2023
3.0.1-previe... 24 4/13/2023
3.0.1-previe... 7 4/12/2023
3.0.1-previe... 7 4/12/2023
3.0.1-previe... 7 4/11/2023
3.0.1-previe... 9 4/6/2023
3.0.1-previe... 10 3/30/2023
3.0.1-previe... 8 3/28/2023
3.0.1-previe... 7 3/28/2023
3.0.1-previe... 9 3/28/2023
3.0.1-previe... 26 3/7/2023
3.0.1-previe... 8 3/4/2023
3.0.1-previe... 12 2/18/2023
3.0.0-previe... 10 2/11/2023
3.0.0-previe... 8 2/11/2023
3.0.0-previe... 27 1/2/2023
2.0.18 23,086 2/3/2022
2.0.17 20 2/3/2022
2.0.16 42 2/2/2022
2.0.14 3,592 8/23/2021
2.0.13 19 8/23/2021
2.0.12 877 7/20/2021
2.0.11 2,911 4/7/2021
2.0.10 31 4/7/2021
2.0.9 2,190 12/14/2020
2.0.8 (current version) 236 11/24/2020
2.0.7 345 9/22/2020
2.0.4 743 7/16/2020
2.0.3 870 5/9/2020
1.2.29 630 3/29/2020
1.2.26 147 3/21/2020
1.2.25 124 3/15/2020
1.2.24 1,317 1/9/2020
1.2.22 316 12/22/2019
1.2.21 384 11/28/2019
1.2.20 75 11/26/2019
1.2.19 40 11/26/2019
1.2.18 21 11/26/2019
1.2.16 119 11/20/2019
1.2.15 656 10/17/2019
1.2.14 293 10/1/2019
1.2.13 21 10/1/2019
1.2.12 1,028 7/30/2019
1.2.11 26 7/30/2019
1.2.10 20 7/30/2019
1.2.9 70 7/29/2019
1.2.8 30 7/29/2019
1.2.7 28 7/29/2019
1.2.6 118 7/23/2019
1.2.5 321 7/8/2019
1.2.4 141 7/2/2019
1.2.3 24 7/2/2019
1.1.173 931 5/22/2019
1.1.172 86 5/21/2019
1.1.171 1,748 2/7/2019
1.1.170 54 2/6/2019
1.1.169 137 1/31/2019
1.1.168 67 1/29/2019
1.1.164 210 1/19/2019
1.1.162 931 11/23/2018
1.1.161 365 11/12/2018
1.1.160 348 10/29/2018
1.1.159 73 10/27/2018
1.1.158 24 10/27/2018
1.1.157 386 10/18/2018
1.1.156 219 10/11/2018
1.1.155 255 9/29/2018
1.1.153 97 9/25/2018
1.1.152 341 9/7/2018
1.1.151 91 9/5/2018
1.1.150 230 8/28/2018
1.1.149 116 8/24/2018
1.1.148 47 8/23/2018
1.1.147 193 8/16/2018
1.1.146 38 8/15/2018
1.1.145 37 8/15/2018
1.1.144 52 8/14/2018
1.1.143 53 8/13/2018
1.1.142 179 8/6/2018
1.1.141 157 7/31/2018
1.1.140 65 7/30/2018
1.1.139 610 6/28/2018
1.1.138 632 5/30/2018
1.1.137 27 5/30/2018
1.1.136 122 5/27/2018
1.1.135 26 5/27/2018
1.1.134 23 5/27/2018
1.1.133 69 5/25/2018
1.1.132 137 5/22/2018
1.1.130 30 5/22/2018
1.1.129 26 5/22/2018
1.1.128 125 5/19/2018
1.1.127 191 5/11/2018
1.1.126 68 5/9/2018
1.1.125 34 5/9/2018
1.1.124 238 4/27/2018
1.1.123 85 4/24/2018
1.1.122 139 4/19/2018
1.1.121 218 4/12/2018
1.1.120 122 4/10/2018
1.1.119 106 4/8/2018
1.1.118 101 4/4/2018
1.1.117 103 4/2/2018
1.1.116 44 3/31/2018
1.1.115 229 3/22/2018
1.1.114 90 3/20/2018
1.1.113 115 3/18/2018
1.1.112 42 3/17/2018
1.1.111 80 3/15/2018
1.1.110 53 3/14/2018
1.1.109 75 3/13/2018
1.1.108 165 3/8/2018
1.1.107 89 3/7/2018
1.1.106 38 3/7/2018
1.1.105 23 3/7/2018
1.1.104 109 3/6/2018
1.1.103 58 3/5/2018
1.1.102 33 3/5/2018
1.1.101 94 3/3/2018
1.0.9 27 3/3/2018
1.0.7 187 3/1/2018
1.0.5 58 2/28/2018
1.0.3 236 2/26/2018
1.0.2 99 2/26/2018
1.0.1 198 2/24/2018
1.0.0 396 2/22/2018
Show less