After Restoring MSDB perform the following two steps
This script has two essential Steps after restoring MSDB
2010-09-21 (first published: 2010-09-20)
2,338 reads
Scripts
Way to Check Multiple LIKE without dynamic SQL
I was asked to do so by one of my colleague. So, I thought to share it with you how to use multiple LIKE conditions.
2010-09-16 (first published: 2010-09-15)
3,787 reads
Retreive the Schema of a Stored Procedure or Function
This script shows you code that retrives schema of a routine (Stored procedure or a function).
2010-09-09 (first published: 2010-09-04)
1,989 reads
2010-09-08 (first published: 2010-09-02)
2,367 reads
Just for fun
Do you need to take your mind off of the SQL mess you are dealing with? Try my funny words generator.
2010-09-03 (first published: 2010-08-27)
2,664 reads
Change the collation of Columns
This script changes the collation of columns to default database collation in all the tables
2010-09-02 (first published: 2010-09-01)
2,178 reads
Windows Group Membership Checker
A script to reveal which logins have access to your sql server via windows groups.
2010-09-01 (first published: 2010-08-26)
2,432 reads
Make string columns unicode compliant
Generates scripts to make text, ntext, varchar and char columns nvarchar/nchar
2010-08-30 (first published: 2010-08-26)
1,326 reads
2010-08-27 (first published: 2010-08-25)
3,680 reads
Get daylight savings time
After scouring the site, and googling until my fingers bled, I finally put together a function that will return the dates when daylight savings time began/ended since at least 1990.
2010-08-26 (first published: 2010-08-19)
2,001 reads
Blogs
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out...
Resolving SQL Server Transaction Log Issues Efficiently
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Forums
KONTAK BCA KCU SCBD Telp:08218154392
WA CS (08218154392) Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E,...
BCA KCU GADING SERPONG Telp:08218154392
WA CS (08218154392) Summarecon Serpong, Perumahan Gading Serpong, Jl. Gading Serpong Boulevard Cluster Scientia...
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
Question of the Day
Symmetric Key Encryption
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