Lost in the Chaos
This morning I had an 8am call with the owners of my company and a consultant that was proposing some...
2009-05-01
444 reads
Blog Posts
New Community Resource for IT Pros - Server Fault
Not too long ago the developer community got a fantastic resource called Stack Overflow. It's a question and answer site,...
2009-05-01
1,072 reads
Transparent Data Encryption - A hole?
Transparent Data Encryption (TDE) sounded like a really cool feature when I first heard of it. Encrypt your database without...
2009-05-01
523 reads
Up and Running
I’ve neglected my weather station for a few weeks. Lots of work, high winds, and snow have slowed me down.
Finally...
2009-05-01
406 reads
Building Something Fun - 2
Last Friday I posted about turning my first pen on a lathe, this week I'm discussing my other recent project,...
2009-04-30
1,740 reads
Midlands PASS May Meeting
The Midlands PASS Chapter will be meeting next Thursday night, May 7, at Training Concepts. We have the privilege of welcoming...
2009-04-30
1,413 reads
PASS Summit Early Bird Registration Ends Tomorrow - Why it Matters
I serve on the PASS Board of Directors, but this post reflects my personal views and not an official PASS...
2009-04-30
1,428 reads
Speaking / Teaching Engagements in May
May 21
I will be teaching a half day course on SQL Server security and auditing for the Midlands Chapter of...
2009-04-30
1,524 reads
SQL This, Not That – Episode 2
When creating a table with a column that will hold the name of a stored procedure that feeds an EXEC...
2009-04-30
1,434 reads
SQLTeach to be Held June 8-12 in Vancouver
SQLTeach (a part of the larger DevTeach event) will be held in Vancouver, BC this June 8-12, 2009. It will...
2009-04-30
1,382 reads
Blogs
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
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...
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