Vlad :verified: · @VladDBA
51 followers · 98 posts · Server mastodon.cloudThe 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
#sqlserver #sqldba #powershell #microsoftsqlserver #mssqlserver #mssql #mssqldba #psblitz
Vlad :verified: · @VladDBA
51 followers · 98 posts · Server mastodon.cloud
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
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #dba #tsql
Vlad :verified: · @VladDBA
51 followers · 96 posts · Server mastodon.cloudIn 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
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
Vlad :verified: · @VladDBA
51 followers · 96 posts · Server mastodon.cloud
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
#sqlserver #sqldba #powershell #microsoftsqlserver #mssqlserver #mssql #mssqldba #psblitz
Cheesecakes as a Service 👨🏾⚡ · @rsilvie
66 followers · 154 posts · Server masto.ai
Vlad :verified: · @VladDBA
44 followers · 71 posts · Server mastodon.cloud
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
#sqlserver #microsoftsqlserver #mssqlserver #sqldba #mssqldba #ssms #mssql