Kill all USer Sessions before starting to restore a Database
If you have a requirement to Kill all USer Sessions before starting to restore a Database, you may use this script
2015-08-05 (first published: 2015-07-08)
2,154 reads
If you have a requirement to Kill all USer Sessions before starting to restore a Database, you may use this script
2015-08-05 (first published: 2015-07-08)
2,154 reads
If you want to monitor few specific alerts for SQL Replication (Merge and Transnational), you can may consider adding these 14 alerts.
2015-07-21 (first published: 2015-06-16)
1,491 reads
IF you have need to schedule job to cleanup backup files older than N days, you can use my written script.
2015-07-02 (first published: 2015-06-04)
666 reads
-- Backup Growth Trend Check To Understand how much disk space you need in future
2015-06-23 (first published: 2015-06-02)
1,290 reads
IF you have a requirement to check disk free space and want to report to the team using email, can use my script
2015-06-17 (first published: 2015-06-03)
1,664 reads
If you have a requirement to setup with a default global dbmail profile and account you can use my script.
2015-06-16 (first published: 2015-05-28)
1,084 reads
IF you have a requirement to check disk free space and want to report to the team using email, can use my script
2015-06-03
344 reads
2015-05-26 (first published: 2015-05-08)
1,138 reads
2015-05-20 (first published: 2015-05-05)
2,344 reads
Wrote the script to take compressed backup with combining many other features.
2015-05-18 (first published: 2015-04-29)
1,060 reads
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Most embedding pipelines on AWS have the same shape: a job reads rows out...
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Comments posted to this topic are about the item Symmetric Key Encryption
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Comments posted to this topic are about the item Building Your Own Software
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers