lowlydba/dba-multitool

📋 What's Changed

• Bump actions/checkout from 4.2.0 to 4.2.1 by @dependabot[bot] in https://github.com/lowlydba/dba-multitool/pull/307
• Bump actions/checkout from 4.2.1 to 4.2.2 by @dependabot[bot] in https://github.com/lowlydba/dba-multitool/pull/308
• Bump stefanzweifel/git-auto-commit-action from 5.0.1 to 5.1.0 by @dependabot[bot] in https://github.com/lowlydba/dba-multitool/pull/309
• Bump potatoqualitee/mssqlsuite from 1.7 to 1.8 by @dependabot[bot] in https://github.com/lowlydba/dba-multitool/pull/310
• Bump stefanzweifel/git-auto-commit-action from 5.1.0 to 5.2.0 by @dependabot[bot] in https://github.com/lowlydba/dba-multitool/pull/311
• Bump insightsengineering/coverage-action from 2.7.1 to 2.7.2 by @dependabot[bot] in https://github.com/lowlydba/dba-multitool/pull/312
• Bump insightsengineering/coverage-action from 2.7.2 to 3.0.1 by @dependabot[bot] in https://github.com/lowlydba/dba-multitool/pull/315
• Bump potatoqualitee/mssqlsuite from 1.8 to 1.10 by @dependabot[bot] in https://github.com/lowlydba/dba-multitool/pull/316
• + 13 more

📋 What's Changed

• Bump actions/checkout from 3.4.0 to 3.5.0 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/272
• Bump lowlydba/tsqlt-installer from 1.1.0 to 1.1.1 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/273
• Bump github/super-linter from 4.10.1 to 5.0.0 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/274
• Bump actions/checkout from 3.5.0 to 3.5.2 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/275
• Full Changelog: https://github.com/lowlydba/dba-multitool/compare/v1.9.1...v1.9.2

📋 What's Changed

• Bump actions/checkout from 3.3.0 to 3.4.0 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/271
• Fix typos in uninstall script & add sp_hexadecimal to uninstall list (which is bundled with sp_help_revlogin)
• Full Changelog: https://github.com/lowlydba/dba-multitool/compare/v1.9.0...v1.9.1

📋 What's Changed

• add sp_help_revlogin by @lowlydba in https://github.com/lowlydba/dba-multitool/pull/270
• Full Changelog: https://github.com/lowlydba/dba-multitool/compare/v1.8.0...v1.9.0

📋 What's Changed

• Bump stefanzweifel/git-auto-commit-action from 4.15.4 to 4.16.0 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/260
• Bump insightsengineering/coverage-action from 2.1.2 to 2.1.3 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/261
• Bump actions/checkout from 3.1.0 to 3.2.0 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/262
• Bump insightsengineering/coverage-action from 2.1.3 to 2.1.5 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/263
• Bump github/super-linter from 4.9.7 to 4.10.0 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/265
• Bump actions/checkout from 3.2.0 to 3.3.0 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/266
• Bump github/super-linter from 4.10.0 to 4.10.1 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/268
• sp_helpme - add incl col by @lowlydba in https://github.com/lowlydba/dba-multitool/pull/267
• + 1 more

📋 What's Changed

• shore up tsqllint for independent release by @lowlydba in https://github.com/lowlydba/dba-multitool/pull/245
• Update Linters by @lowlydba in https://github.com/lowlydba/dba-multitool/pull/247
• Bump github/super-linter from 4.9.5 to 4.9.6 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/248
• Bump stefanzweifel/git-auto-commit-action from 4.14.1 to 4.15.0 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/249
• Bump azure/sql-action from 1.3 to 2 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/250
• Bump actions/checkout from 3.0.2 to 3.1.0 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/251
• Bump stefanzweifel/git-auto-commit-action from 4.15.0 to 4.15.1 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/254
• Bump github/super-linter from 4.9.6 to 4.9.7 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/252
• + 6 more

📋 What's Changed

• Bump insightsengineering/coverage-action from 2.1.0 to 2.1.1 by @dependabot in https://github.com/lowlydba/dba-multitool/pull/243
• Suggestion fixes by @lowlydba in https://github.com/lowlydba/dba-multitool/pull/244
• Full Changelog: https://github.com/lowlydba/dba-multitool/compare/1.7.9...1.7.10

📋 What's Changed

• Create uninstall_dba-multitool.sql by @LowlyDBA in https://github.com/LowlyDBA/dba-multitool/pull/229
• Slim down release package size by ignoring non-asset files
• Update license copyright years
• Update TSQLLint rules & fix subquent errors (non-functional changes)
• Full Changelog: https://github.com/LowlyDBA/dba-multitool/compare/1.7.7...1.7.8

📝 sp_doc

• Resolved #224 - Ignore SSDT related tables in markdown output

📦 General

• Updated licensing year to 2021 - only took 8 months 😄

📝 sp_doc

• Resolved #210 - Added schemas and their EPs to documentation output

📦 General

• Added icons for individual tools on their documentation pages
• Pester query timeouts are now variables instead of hard coded

📝 sp_doc

• Resolved (partially) #191 - added feature to display _all_ extended properties
• Fixed primary keys for user defined table types not showing up
• Misc. code style improvements
• Fixed #211 - Markdown url formatting now properly escaped

📦 sp_helpme

• Fixed #200 - nvarchar columns listed twice
• Started re-styling some of the original sp_help code for readability & standardization
• Fixed #207 and #203 - issues around case sensitivity, thank you @mattcargile for the fixes!

📝 sp_doc

• Fixed #208 - Updated documentation to clarify importance of supplying `-y 0` to sqlcmd for this stored proc

📦 sp_sizeoptimiser

• Also affected by fix #203

📦 sp_estindex

• Fixed #193

📝 sp_doc

• Resolved #190 - object dependencies are now tracked under "Referenced By" section
• Fixed non-standard variable names
• Fixed formatting issues in Synonyms section

📦 sp_sizeoptimiser

• Fixed ordering of results
• Compressed tables are now skipped for the sparse columns check, since those features are incompatible

📝 sp_doc

• Fixed missing line break in Synonyms section #186
• Fixed display of multi-line EPs that are shown in tables
• Fixed display of markdown *inside* EPs #185
• Pipes are replaced with HTML code equivalent
• Line breaks are replaced with `<br/>` tag
• This renders markdown as raw text instead of applying usual markdown formatting
• Fixed broken EPs for User Defined Table Types
• sys.extended_properties docs were missing UDTT specific class (https://github.com/MicrosoftDocs/sql-docs/pull/6154)

📋 Changes

• Upgraded pester to 5.1.0+ and now using `BeforeDiscovery` to tighten up some of the repetitive commands run in tests
• Added timeouts to unit test calls after encountering #177 which effectively paused query executions
• Now setting the max memory and max DOP on the SQL Instances at start to ensure ideal configurations are in use
• Setting tSQLt as Simple recovery mode at creation
• Leveraging the latest tSQLt version for non-Azure builds (see #165 for details as to why not Azure)
• Added [In Solidarity Bot](https://github.com/jpoehnelt/in-solidarity-bot) as a commit checker

📦 sp_sizeoptimiser

• N/A

📦 sp_helpme

• N/A

📦 sp_estindex

• N/A

📝 sp_doc

• Improved some variable naming and data type usage
• add view/table indexes + tests (#176)
• Removed, then fixed the buggy sensitivity classification test (#177)
• Added general database info (#171)
• More usage of object-specific system catalogs as opposed to `sys.objects` for performance improvements
• Added lots of `NOLOCK` statements during (#177) troubleshooting, keeping them just in case they help

📋 Changes

• Major overhaul of the testing components, both local and appveyor
• Pester 5 now runs all tests & the T-SQL linting, reporting results to appveyor 🎉
• tSQLt is fetched at run time on appveyor, reducing the repo size considerably
• Fewer files/steps in general to get tests up and running
• Improved overall linting, including PowerShell linting
• Inclusion in [dbatools](https://dbatools.io) via Install-DbaMultiTool !!

📦 sp_sizeoptimiser

• Fixed example in header content that was causing issues when running via dbatools' `Invoke-DbaQuery`

📦 sp_helpme

• N/A

📦 sp_estindex

• Fixed unit tests that weren't compatible with Azure SQL (we can't use system databases for these tests)

📝 sp_doc

• Includes Data Sensitivity Classifications in 2019+ (when present)

📦 General

• Improved readability and organizing of unit tests

📝 sp_doc

• Added verbose mode

📦 sp_estindex

• New script! 🎉
• Estimates statistics, sizes, and missing index stats without having to actually create an index.

📦 sp_sizeoptimiser

• Fixes #142
• Fixes #141
• Improved general heuristics

📦 General

• Rebranding from "Express SQL" to "DBA MultiTool" for a more self-descriptive name.

📝 sp_doc

• Completes #130 - Only shows the first 8,000 characters of stored proc definitions by default (large markdown files cause issues in some IDEs / git renderers)
• Completes #134 - Added User Defined Table Types
• Completes #137 - Emoji mode now available

📦 sp_helpme

• no changes

📦 sp_sizeoptimiser

• no changes

📋 Changes

• Bold primary key columns
• Misc. fixes around variable data types
• Wrap foreign keys in [ ] to allow line wrapping and more even table column widths
• Add support for programmable object parameter documentation
• no changes
• no changes

📋 Changes

• All HTML tags properly closed
• Sample WideWorldImporters documentation generated during each build
• no changes
• no changes
• Minor markdown linting errors corrected