dbachecks

2.0.3

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

PSEditions

Desktop Core

Dependencies

Release Notes


## Date 9th May 2020
UPDATED TO VERSION 2

New Commands

           Convert-DbcResult - To parse results and add Label, ComputerName, Instance and Database
           Set-DbcFile - To save the parsed results to a file json, csv or xml
           Write-DbcTable - to add results to a database

New Parameter
           -FromDatabase on Star-DbcPowerBi - to open new Power Bi template file

New PowerBi template file for reporting on results from the database

Improved Spelling

Updated Unit Tests for Checks to enabled results to be parsed

Improved Check Titles

Configuration for Max history days for Job duration

Stop trying to check inaccessible databases for checks

Improved Query Store checks

Ensure long running agent jobs ignores durations longer than 24 hours

Ignore jobs that never stop from the duration check

##Latest

Run Get-DbcReleaseNotes for all release notes
           

Version History

Version Downloads Last updated
2.0.3 (current version) 704 5/9/2020
1.2.29 605 3/29/2020
1.2.26 130 3/21/2020
1.2.25 107 3/15/2020
1.2.24 1,274 1/9/2020
1.2.22 295 12/22/2019
1.2.21 364 11/28/2019
1.2.20 58 11/26/2019
1.2.19 23 11/26/2019
1.2.18 3 11/26/2019
1.2.16 102 11/20/2019
1.2.15 638 10/17/2019
1.2.14 275 10/1/2019
1.2.13 4 10/1/2019
1.2.12 1,008 7/30/2019
1.2.11 9 7/30/2019
1.2.10 3 7/30/2019
1.2.9 53 7/29/2019
1.2.8 13 7/29/2019
1.2.7 11 7/29/2019
1.2.6 101 7/23/2019
1.2.5 303 7/8/2019
1.2.4 124 7/2/2019
1.2.3 7 7/2/2019
1.1.173 913 5/22/2019
1.1.172 69 5/21/2019
1.1.171 1,731 2/7/2019
1.1.170 35 2/6/2019
1.1.169 120 1/31/2019
1.1.168 49 1/29/2019
1.1.164 193 1/19/2019
1.1.162 913 11/23/2018
1.1.161 348 11/12/2018
1.1.160 331 10/29/2018
1.1.159 55 10/27/2018
1.1.158 7 10/27/2018
1.1.157 249 10/18/2018
1.1.156 202 10/11/2018
1.1.155 238 9/29/2018
1.1.153 80 9/25/2018
1.1.152 324 9/7/2018
1.1.151 74 9/5/2018
1.1.150 205 8/28/2018
1.1.149 99 8/24/2018
1.1.148 30 8/23/2018
1.1.147 175 8/16/2018
1.1.146 21 8/15/2018
1.1.145 20 8/15/2018
1.1.144 35 8/14/2018
1.1.143 36 8/13/2018
1.1.142 160 8/6/2018
1.1.141 140 7/31/2018
1.1.140 47 7/30/2018
1.1.139 593 6/28/2018
1.1.138 615 5/30/2018
1.1.137 10 5/30/2018
1.1.136 104 5/27/2018
1.1.135 8 5/27/2018
1.1.134 6 5/27/2018
1.1.133 50 5/25/2018
1.1.132 120 5/22/2018
1.1.130 12 5/22/2018
1.1.129 8 5/22/2018
1.1.128 107 5/19/2018
1.1.127 173 5/11/2018
1.1.126 51 5/9/2018
1.1.125 17 5/9/2018
1.1.124 219 4/27/2018
1.1.123 68 4/24/2018
1.1.122 120 4/19/2018
1.1.121 201 4/12/2018
1.1.120 105 4/10/2018
1.1.119 89 4/8/2018
1.1.118 84 4/4/2018
1.1.117 86 4/2/2018
1.1.116 27 3/31/2018
1.1.115 212 3/22/2018
1.1.114 72 3/20/2018
1.1.113 98 3/18/2018
1.1.112 25 3/17/2018
1.1.111 63 3/15/2018
1.1.110 36 3/14/2018
1.1.109 58 3/13/2018
1.1.108 147 3/8/2018
1.1.107 72 3/7/2018
1.1.106 20 3/7/2018
1.1.105 6 3/7/2018
1.1.104 92 3/6/2018
1.1.103 41 3/5/2018
1.1.102 16 3/5/2018
1.1.101 77 3/3/2018
1.0.9 9 3/3/2018
1.0.7 170 3/1/2018
1.0.5 41 2/28/2018
1.0.3 219 2/26/2018
1.0.2 82 2/26/2018
1.0.1 180 2/24/2018
1.0.0 377 2/22/2018