BrentOzarULTD/SQL-Server-First-Responder-Kit issues and pull requests

#3608 - sp_Blitz: Add positive confirmation that Enterprise features are NOT in use

Issue - State: closed - Opened by roliva6 15 days ago - 2 comments

#3607 - sp_DatabaseRestore doesn't pull logs when used with multi-file backups

Issue - State: open - Opened by sqlfunkateer 16 days ago

#3606 - Update sp_DatabaseRestore.sql

Pull Request - State: closed - Opened by maxiwheat 17 days ago

#3605 - sp_DatabaseRestore crashes due to database name being a little to long

Issue - State: closed - Opened by maxiwheat 17 days ago - 3 comments

#3604 - sp_restoredatabase error

Issue - State: closed - Opened by rkslife 25 days ago - 1 comment

#3603 - sp_Blitz - add check for sysadmins and securityadmins with common passwords

Issue - State: closed - Opened by VladDBA 27 days ago - 3 comments

#3602 - 2024-12-28 Release

Pull Request - State: closed - Opened by BrentOzar about 1 month ago

#3601 - 2024-12-28 release

Pull Request - State: closed - Opened by BrentOzar about 1 month ago

#3600 - #3599 sp_Blitz overflow

Pull Request - State: closed - Opened by BrentOzar about 1 month ago

#3599 - sp_Blitz - Arithmetic overflow error

Issue - State: closed - Opened by songomajk about 2 months ago - 3 comments

#3598 - sp_BlitzLock - conversion error

Issue - State: closed - Opened by mcdonald7662 about 2 months ago - 5 comments

#3597 - sp_Blitz - correctly check permissions for sys.traces

Pull Request - State: closed - Opened by Tisit about 2 months ago

#3596 - #3586 - adding target & total memory counters to server info section. Closes #3586.

Pull Request - State: closed - Opened by BrentOzar about 2 months ago

#3595 - Update Merge Blitz.ps1 so not hardcoded to directory path

Pull Request - State: closed - Opened by DanielLoth about 2 months ago - 5 comments

#3594 - Replace illegal character & in sp_Blitz for Markdown output result

Pull Request - State: closed - Opened by igaliney about 2 months ago

#3593 - sp_Blitz @OutputType = 'Markdown'. XML parsing: illegal name character

Issue - State: closed - Opened by igaliney about 2 months ago - 2 comments

#3592 - Findings Group "Security"- Elevated Permissions on a Database for MSDB database in specific

Issue - State: closed - Opened by emad-almousa 2 months ago - 1 comment

#3591 - sp_BlitzFirst: 'Sleeping Query with Open Transactions' is not executed if there are no sys.dm_exec_requests with total_elapsed_time > 5000

Issue - State: closed - Opened by spilkercompra 2 months ago - 1 comment

#3590 - sp_BlitzIndex - remove duplicate debug result set

Pull Request - State: closed - Opened by VincenzoMarchese 3 months ago
Labels: bug, sp_BlitzIndex

#3589 - Update sp_BlitzIndex.sql

Pull Request - State: closed - Opened by VincenzoMarchese 3 months ago

#3588 - sp_BlitzIndex change data type from INT to NUMERIC to report on indexes < 1 MB

Pull Request - State: closed - Opened by stone-de-croze 3 months ago - 1 comment
Labels: bug, sp_BlitzIndex

#3587 - When your lazy and do not want to fill in all parameters... for: @DatabaseName, @SchemaName, @TableName

Pull Request - State: closed - Opened by goranschwarz 3 months ago - 1 comment
Labels: sp_BlitzIndex

#3586 - sp_Blitz: add target & total memory Perfmon counters under CheckServerInfo = 1

Issue - State: closed - Opened by BrentOzar 3 months ago
Labels: enhancement, sp_Blitz

#3586 - sp_Blitz: add target & total memory Perfmon counters under CheckServerInfo = 1

Issue - State: open - Opened by BrentOzar 3 months ago
Labels: enhancement, sp_Blitz

#3585 - sp_Blitz: Error with parameter @OutputType = 'markdown'

Issue - State: closed - Opened by jukkama 3 months ago - 3 comments

#3584 - 2024-10-19 Release

Pull Request - State: closed - Opened by BrentOzar 4 months ago

#3584 - 2024-10-19 Release

Pull Request - State: closed - Opened by BrentOzar 4 months ago

#3583 - 2024-10-19 release

Pull Request - State: closed - Opened by BrentOzar 4 months ago

#3583 - 2024-10-19 release

Pull Request - State: closed - Opened by BrentOzar 4 months ago

#3582 - Inclusive language changes for sp_BlitzIndex

Pull Request - State: closed - Opened by VladDBA 4 months ago

#3581 - sp_Blitz: Error reading sys.traces with specific permissions

Issue - State: closed - Opened by Tisit 4 months ago - 4 comments
Labels: bug, sp_Blitz

#3580 - sp_Blitz: Check 191 avoid false positives in case user doesn't have permissions on sys.master_files

Pull Request - State: closed - Opened by Tisit 4 months ago

#3579 - sp_Blitz: Fix checks 73 to work with sysadmin permissions

Pull Request - State: closed - Opened by Tisit 4 months ago

#3578 - sp_Blitz: Check 191 - 'Mismatch between the number of TempDB files in sys.master_files versus tempdb.sys.database_files' falsely reported when run without sysadmin

Issue - State: closed - Opened by Tisit 4 months ago - 1 comment

#3577 - sp_Blitz: Check 73 - 'No Failsafe Operator Configured' is skipped when run as sysadmin

Issue - State: closed - Opened by Tisit 4 months ago - 2 comments

#3576 - #3566 sp_BlitzLock better qualify synonym

Pull Request - State: closed - Opened by BrentOzar 4 months ago
Labels: bug, sp_BlitzLock

#3575 - sp_Blitz: Fix checks 191 and 73

Pull Request - State: closed - Opened by Tisit 4 months ago - 1 comment

#3574 - #3573 implemented

Pull Request - State: closed - Opened by mikaelljunghorn 4 months ago - 1 comment

#3573 - sp_BlitzIndex - When no missing index is found in the filtered result, an empty table is displayed instead of "No missing indexes".

Issue - State: closed - Opened by mikaelljunghorn 4 months ago - 4 comments
Labels: bug, sp_BlitzIndex

#3572 - Enable sp_DatabaseRestore to use Blob Storage

Issue - State: closed - Opened by gdoddsy 4 months ago - 5 comments
Labels: enhancement, sp_DatabaseRestore

#3571 - Question about inclusive language update for sp_BlitzIndex

Issue - State: closed - Opened by VladDBA 4 months ago - 6 comments
Labels: enhancement, sp_BlitzIndex

#3570 - Are there versions of the scripts without creating stored procedures?

Issue - State: closed - Opened by Tony20221 5 months ago - 2 comments

#3569 - SqlServerVersions - Added latest CUs and GDRs

Pull Request - State: closed - Opened by VladDBA 5 months ago - 1 comment

#3568 - Fix for sp_BlitzLock @Debug=1 throwing an error when no plans found in plan cache - #3567

Pull Request - State: closed - Opened by VladDBA 5 months ago

#3567 - sp_BlitzLock throwing an error when ran with @Debug = 1

Issue - State: closed - Opened by VladDBA 5 months ago

#3566 - sp_BlitzLock Throwing an Error when attempting to output to table

Issue - State: closed - Opened by BilliousBT 5 months ago - 5 comments
Labels: bug, sp_BlitzLock

#3565 - sp_BlitzFirst skips plan cache analysis when @ExportMode = 1

Issue - State: closed - Opened by JonasEckerman 5 months ago - 4 comments

#3564 - sp_BlitzLock error - Name cannot begin with the ' ' character, hexadecimal value 0x20.

Issue - State: closed - Opened by Sindric1 5 months ago - 2 comments

#3563 - sp_Blitz.sql: Updated #IgnorableWaits to match the 2021 version of Paul Randal's script

Pull Request - State: closed - Opened by ReeceGoding 5 months ago

#3562 - Add the SQL Server 2019+ ignorable waits to sp_Blitz's #IgnorableWaits.

Issue - State: closed - Opened by ReeceGoding 5 months ago - 1 comment

#3561 - sp_BlitzIndex details in separate columns

Issue - State: closed - Opened by Tarjei-stavanger 5 months ago - 1 comment

#3560 - sp_DatabaseRestore: fix backup file selection for @StopAt and non-split full backups

Pull Request - State: closed - Opened by Rob-Hague 5 months ago

#3559 - sp_BlitzLock - empty export to tables

Issue - State: closed - Opened by lduczmal 5 months ago - 3 comments

#3558 - Running sp_blitz with outputtype

Issue - State: closed - Opened by EdwardQuicksall 5 months ago - 1 comment

#3557 - #3556 sp_BlitzIndex missing index processing

Pull Request - State: closed - Opened by BrentOzar 6 months ago
Labels: bug, sp_BlitzIndex

#3556 - sp_BlitzIndex: missing indexes column query processing more data than it should, causing error

Issue - State: closed - Opened by BrentOzar 6 months ago
Labels: bug, sp_BlitzIndex

#3555 - sp_DatabaseRestore: Document the other half of the parameters.

Issue - State: closed - Opened by ReeceGoding 7 months ago - 1 comment

#3554 - sp_Blitz - "Query Store Disabled" false positive on secondary replica

Issue - State: closed - Opened by petervandivier 7 months ago - 1 comment

#3553 - sp_Blitz: Added check for unusual Query Store configuration and Query Store Trace Flags

Pull Request - State: closed - Opened by ReeceGoding 7 months ago

#3552 - Update sp_Blitz.sql validate logins if we are sysadmin

Pull Request - State: closed - Opened by PowerDBAKlaas 7 months ago - 3 comments
Labels: bug, sp_Blitz

#3551 - sp_validatelogins never executed

Issue - State: closed - Opened by PowerDBAKlaas 7 months ago - 4 comments
Labels: bug, sp_Blitz

#3550 - 2024-07-01 Release

Pull Request - State: closed - Opened by BrentOzar 7 months ago

#3549 - 2024-07-01 Release

Pull Request - State: closed - Opened by BrentOzar 7 months ago

#3548 - `sp_BlitzLock` Lock data

Issue - State: closed - Opened by Imran-imtiaz48 7 months ago - 1 comment

#3547 - sp_BlitzLock failed with a data conversion error

Issue - State: closed - Opened by Aussie-Scum 7 months ago - 8 comments
Labels: bug, sp_BlitzLock

#3546 - Closes #3545

Pull Request - State: closed - Opened by erikdarlingdata 7 months ago
Labels: enhancement, sp_BlitzLock

#3545 - sp_BlitzLock - Add max CPU and elapsed times to available plans section

Issue - State: closed - Opened by erikdarlingdata 7 months ago - 2 comments
Labels: enhancement, sp_BlitzLock

#3544 - Add Point In Time restore parameter

Issue - State: closed - Opened by pge92 7 months ago - 1 comment

#3543 - sp_DatabaseRestore: allow enabling service broker on restore

Pull Request - State: closed - Opened by lowlydba 7 months ago - 1 comment

#3542 - sp_DatabaseRestore: add ability to enable service broker

Pull Request - State: closed - Opened by lowlydba 7 months ago

#3541 - sp_Blitz: Added check for unusual Query Store query capture mode

Pull Request - State: closed - Opened by ReeceGoding 8 months ago - 1 comment

#3540 - sp_Blitz: Should we be actively recommending Trace Flag 3226?

Issue - State: closed - Opened by ReeceGoding 8 months ago - 1 comment

#3539 - sp_Blitz: Added checks for disabled but recommended Query Store Trace Flags

Pull Request - State: closed - Opened by ReeceGoding 8 months ago - 1 comment

#3538 - 3537 removing readme references

Pull Request - State: closed - Opened by BrentOzar 8 months ago

#3537 - README.md: sp_BlitzIndex's docs still mention sp_BlitzInMemoryOLTP, even though it's depreicated

Issue - State: closed - Opened by ReeceGoding 8 months ago

#3536 - sp_Blitz: Added check for Query Store not being in READ_WRITE state and check for it not being in desired state.

Pull Request - State: closed - Opened by ReeceGoding 8 months ago - 2 comments

#3535 - sp_Blitz: Add check for Query Store Wait Stats being turned off

Pull Request - State: closed - Opened by ReeceGoding 8 months ago

#3534 - brentozar.com/blitz/query-store-disabled/ Still Recommends sp_BlitzQueryStore

Issue - State: closed - Opened by ReeceGoding 8 months ago - 1 comment

#3533 - sp_Blitz: Add check for very high Query Store memory usage

Pull Request - State: closed - Opened by ReeceGoding 8 months ago - 1 comment

#3532 - sp_DatabaseRestore: Add param to enable service broker on restore

Issue - State: closed - Opened by lowlydba 8 months ago - 2 comments
Labels: enhancement, sp_DatabaseRestore

#3531 - sp_Blitz: Add more detail to Query Store Trace Flag rows

Pull Request - State: closed - Opened by ReeceGoding 8 months ago

#3530 - README.md: Removed sp_AllNightLog from the table of contents

Pull Request - State: closed - Opened by ReeceGoding 8 months ago - 1 comment

#3529 - README.md: sp_AllNightLog is still in the table of contents

Issue - State: closed - Opened by ReeceGoding 8 months ago - 3 comments

#3528 - sp_BlitzIndex has dependency on depricated procedure sp_BlitzInMemoryOLTP

Issue - State: closed - Opened by netsec4u 8 months ago - 1 comment

#3527 - sp_Blitz: Add more Query Store best practice checks.

Issue - State: closed - Opened by ReeceGoding 8 months ago - 3 comments
Labels: enhancement, sp_Blitz

#3526 - Adds DeadlockType parameter for filtering to regular or parallel deadlocks

Pull Request - State: closed - Opened by erikdarlingdata 8 months ago - 1 comment
Labels: enhancement, sp_BlitzLock

#3525 - sp_BlitzLock - Add the ability to filter to a specific type of deadlock

Issue - State: closed - Opened by erikdarlingdata 8 months ago
Labels: enhancement, sp_BlitzLock

#3524 - 2024-05-22 Release

Pull Request - State: closed - Opened by BrentOzar 9 months ago

#3523 - #3522 sp_BlitzIndex permissions

Pull Request - State: closed - Opened by BrentOzar 9 months ago

#3522 - sp_BlitzIndex fails if you don't have permissions to query sys.sql_expression_dependencies

Issue - State: closed - Opened by BrentOzar 9 months ago

#3521 - 2024-05-22 version numbers

Pull Request - State: closed - Opened by BrentOzar 9 months ago

#3520 - DROP TABLE IF EXISTS is use, but Blitzindex should be compatibel with SQL Server 2014 and below

Issue - State: closed - Opened by EMeisel 9 months ago - 1 comment

#3519 - Typos in the index script

Issue - State: closed - Opened by garyhuntddn 9 months ago - 1 comment

#3518 - Typos in the index script

Pull Request - State: closed - Opened by garyhuntddn 9 months ago

#3517 - Can DB_NAME() ever return a different value to sys.databases.name?

Issue - State: closed - Opened by garyhuntddn 9 months ago - 1 comment

#3516 - Database count does not exclude all databases that will be excluded

Issue - State: closed - Opened by garyhuntddn 9 months ago - 1 comment

#3515 - Name column from sys.schemas accessed using [NAME] rather than [name]

Issue - State: closed - Opened by garyhuntddn 9 months ago - 1 comment

GitHub / BrentOzarULTD/SQL-Server-First-Responder-Kit issues and pull requests