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)

General

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

General

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

sp_doc

• 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

sp_helpme

• no changes

sp_sizeoptimiser

• no changes