The latest release of PSBlitz:
- has been updated with the latest sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, sp_BlitzLock, and sp_BlitzWho, from Brent Ozar's August release of the First Responder Kit
- outputs execution plans for queries involved in deadlocks if they are still in the cache.
- adds a new report page containing deadlock-related execution plan info

https://github.com/VladDBA/PSBlitz

#sqlserver #sqldba #powershell #microsoftsqlserver #mssqlserver #mssql #mssqldba #PSBlitz

This is just a brief post containing a script to get table sizes in SQL Server, along with some other information like table type, number of records, partition count, compression type, number of nonclustered indexes and their total size.

https://vladdba.com/2023/08/24/script-to-get-table-sizes-in-sql-server/

#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #dba #tsql

In this post I’ll cover ways of speeding up SELECT COUNT as well as some myths about best practices when it comes to SELECT COUNT.

https://vladdba.com/2023/08/21/speeding-up-select-count-in-sql-server/

#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba

The latest release of PSBlitz:
- returns info about opened transactions (including those belonging to sleeping sessions)
- has been updated with Brent Ozar's June release of the First Responder Kit
- adds comment-based help info
- lets you know when checks returned no records
- includes other bug fixes and minor improvements
#sqlserver #sqldba #powershell #microsoftsqlserver #mssqlserver #mssql #mssqldba #PSBlitz
https://github.com/VladDBA/PSBlitz

@robsewell I read this and was mildly offended as a DBA.
But then I re-read it and thought about it for a while. This is actually a Good Thing as it suggests an excellent way of implementing schemas without actually saying “You’ve been getting this wrong for a long time”… #nerd #SQLDBA

SSMS 19 was released last week, so I figured I'd take this opportunity to go through my usual SSMS configuration preferences.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #ssms
https://vladdba.com/2023/01/31/my-sql-server-management-studio-19-configuration

The latest release of PSBlitz:
- moves sp_BlitzWho to a background process where it gets executed every 10 seconds.
- adds parameters for connection timeout, max execution timeout, output directory, sp_BlitzWho execution interval, and a switch for debug information.
- provides error messages that specify if a step failed due to a command timeout or a connection timeout.
- other bug fixes and minor improvements
#sqlserver #sqldba #powershell #mssqlserver #mssql
https://github.com/VladDBA/PSBlitz

In this post I'll demo how to use PowerShell to automate exporting SQL Server execution plans as stand-alone .sqlplan files.

#sqlserver #sqldba #powershell #mssqlserver
https://vladdba.com/2023/01/17/save-execution-plan-files-powershell

I made #ChatGPT write (questionable) T-SQL so you won't have to.
#sqldba #sqlserver #mssqlserver #AI #tsql
https://vladdba.com/2022/12/20/using-chatgpt-to-write-t-sql

I made #ChatGPT write (questionable) T-SQL so you won't have to.
#sqldba #sqlserver #mssqlserver #AI #tsql
https://vladdba.com/2022/12/20/using-chatgpt-to-write-t-sql