SQL Quiz: Two Mistakes
I was tagged by Gail Shaw to post two big mistakes made during my professional career. The only challenge here...
2008-12-18
841 reads
Evaluate Jack Corbetts Blog
My friend Jack has been blogging for almost a year now and is looking for feedback. If you're a blogger...
2008-12-18
597 reads
The December Car Update
I missed the November Car update, but I was too busy with the PASS Summit to get one done.
However last...
2008-12-18
663 reads
A Week of Books - Part 4
Magazines today instead of books, but hopefully you'll count that as close enough to my theme of the week. I...
2008-12-17
540 reads
Dos and Don'ts for Projecting a Professional Image on the Internet
In a previous blog post, I suggested that less than professional content, that you or others post on the Internet...
2008-12-17
1,163 reads
Is Your Internet Activity Hurting Your DBA Career?
I have been active on the Internet for 15 years, and during that time I have left a long trail...
2008-12-17
1,074 reads
Microsoft’s First iPhone Application
Can you believe it? Microsoft has just released an iPhone application for the first time and I doubt it will...
2008-12-17
2,054 reads
A Week of Books - Part 3
I'm still finishing up two books that I'll mention today. Most non-technical books I read straight through, anything technical/learning based...
2008-12-17
543 reads
The Best Thing About The Kindle
You might think it's the e-ink screen. It's not.
You might think it's the ability to carry around hundreds of books...
2008-12-17
865 reads
Jumpstart TV SQL Server security videos on-line
Back in October I had the opportunity to work with Andy Warren and do a series of SQL Server security...
2008-12-17
1,402 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