Detect and Alert DBA of Blocking SPIDS
This script will detect and alert the DBA of blocking processes. The DBA can adjust the length of time the block has exisited before sending the net send message.
2001-08-29
5,180 reads
Blogs
Parameter Sensitive Plan Optimization in SQL Server 2022. What is it and is it any good?
Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...
Azure chaos STUDIO
By Arun Sirpal
Chaos engineering is fun but especially important when building solutions in the cloud. It...
Announcing a New Book on SQL from 3Cloud Authors
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
Forums
Azure DW default schema in a query / proc equal to "Search_Path" in AWS
I know you can't do this in MSSQL, but hoping DW has progressed more....
Call SQL Agent job using different account to one executing powershell
Hi Folks trying the below but having zero luck and was wondering if anybody...
Encrypt Varchar(max) column in SQL Server
I have a varchar(max) column which has sensitive data and want to encrypt it....
Ask SSC