Quick SQL connection and process details with current SQL - Version2
Quick check SQL connection and process details with current SQL text
2018-12-19 (first published: 2018-11-27)
933 reads
Quick check SQL connection and process details with current SQL text
2018-12-19 (first published: 2018-11-27)
933 reads
Get backup status email daily to your inbox in HTML format.
2013-03-27 (first published: 2013-03-14)
2,002 reads
This script will be useful to quickly check incase of any blocking or log wait occurs
2011-12-30 (first published: 2011-12-05)
1,505 reads
This script can be used to generate alter column length of any string data type column(s) in a database.
2011-12-27 (first published: 2011-11-22)
1,195 reads
ntext, text, and image (Transact-SQL). This script will alter the data type from image to
varbinary(max) which is very much required as the data type is out
of support.
2011-11-28 (first published: 2011-11-14)
853 reads
Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...
By Arun Sirpal
Chaos engineering is fun but especially important when building solutions in the cloud. It...
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
I have a varchar(max) column which has sensitive data and want to encrypt it....
We have a stored procedure that calls xp_cmdshell in order to use the BCP...
Replacing an old server with a newer one. A job that runs fine on...