Validating text data. A few techniques.
/*datafile used in the SQL */
DECLARE @String VARCHAR(MAX)
SELECT @String = 'When you are starting out to validate text input, perhaps to clean...
2008-10-09
1,105 reads
Project Management Management - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-10-09
931 reads
Tethering vs Air Card & Other Miscellaneous Phone Thoughts
I've been using a Blackberry Curve for a while and I'm been entirely happy with it. Great phone, great battery...
2008-10-08
535 reads
Take the Plunge - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-10-08
392 reads
Red Gate SQL Response Review is up
Full Disclosure: I did receive a trial version of the software and payment for the review. I am also a...
2008-10-08
962 reads
Do You Love PASS?
Recently Tony Davis posted some thoughts (almost a rant) about his opinions of PASS, and there is a great follow...
2008-10-07
699 reads
Database Administration Librarian
If I cannot find a book or info in a library, I always go to a librarian for advice and...
2008-10-07
618 reads
Can't Attend SQL Server Training in Person, Consider Virtual Training
I am one of the biggest advocates there is of self-education. Whether you are a novice, intermediate, or expert-level DBA,...
2008-10-07
1,008 reads
Always more to do
My current "to do" list, which is only partially written down and organized. Putting it all one one list is...
2008-10-07
394 reads
Rendering code nicely in blogs and forums.
I wrote the prettifier specifically to help with posting SQL into blogs and forums. You can find it here http://extras.sqlservercentral.com/prettifier/prettifier.aspx...
2008-10-07
6,674 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
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...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
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