The Limited Usefulness of Encrypting File System (EFS) and Transparent Data Encryption (TDE)
This is something that hit me as I was presenting to the Charlotte SQL Server User Group last night.
Back...
2009-02-18
4,095 reads
Database Mirroring FAQ: Why does Database Mirroring Monitor report that my mirror is disconnected?
Question: Why does Database Mirroring Monitor report that my mirror is disconnected?
This question was sent to a discussion list via...
2009-02-18
1,629 reads
Boulder SQL Server Users Group
Last night I went to the February Boulder SQL Server User’s Group meeting up in Broomfield, CO to deliver my...
2009-02-18
795 reads
MySpace
MySpace has been the Premier SQL Server site, and probably the largest SQL Server site, on the Internet. It’s a...
2009-02-18
825 reads
All In & Being Competitive
Many of us in IT are competitive, maybe slightly more so than in other professions. Competition adds a little spice...
2009-02-17
1,500 reads
Your Local User Group
When I talk to other SQL Server professionals, I’m often surprised at how many do not have any involvement in...
2009-02-17
1,230 reads
Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?
Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?
This question was sent...
2009-02-17
2,183 reads
Book Review - The Human Edge
I've always enjoyed the science fiction writings of Gordon Dickson, and recently re-read an old copy of The Human Edge,...
2009-02-16
858 reads
Database Mirroring FAQ: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online?
Question: If the principal fails while running in high performance mode, what options do I have for bringing the mirror...
2009-02-16
4,555 reads
Be Careful with String Concatenations in SQL Server with Big Strings.
Now, we are going to get slightly esoteric here. I'd noticed that the performance of string concatenation tasks didn't increase...
2009-02-16
14,611 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
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
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
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