SQLSaturday #86 in Tampa–Tomorrow!
With a little bit of luck I’ll be arriving in Orlando today around 9 am as I return from SQLConnections...
2011-11-04
532 reads
Blog Posts
SQLSaturday #96 in DC - 11/5/2011
Coming to the Capitol, tomorrow Saturday, November 5, 2011 is SQLSaturday#96 in Washington, D.C.! This great event down in DC,...
2011-11-04
886 reads
Things I Favorited on Twitter (a weekly wrapup, of sorts)
Each Friday on @Midnight">DBAs@Midnight (my live weekly webshow, 11pm CST at webshow.MidnightDBA.com!) I don’t feel like I have enough time...
2011-11-04
935 reads
What is SQL PASS?
A few weeks ago I asked a colleague, who is a DBA, if he was going to the SQL PASS...
2011-11-04
1,118 reads
Why I'm Running For The PASS Board Of Directors
If you read this week's onnector email you may have noticed that I'm one of the six candidates who have...
2011-11-04
821 reads
Why SQL Server is using so LESS memory
Today I want to talk about a phenomenon regarding memory management in SQL Server.
A few weeks ago I had a...
2011-11-04
7,209 reads
An Attempt to Make SSIS Package Deployment More Reasonable
Full disclosure: There might be a better way to do this. I am not aware of it.
Problems:
Maintaining multiple DB environments...
2011-11-03
1,470 reads
Another Color Wheel
Some time ago, I had the opportunity to work on a problem involving the color wheel. The requirements for that problem lent themselves to a solution involving bitwise operations...
2011-11-03
8 reads
Another Color Wheel
Some time ago, I had the opportunity to work on a problem involving the color wheel. The requirements for that...
2011-11-03
1,266 reads
DDL Auditing presentation – feedback
Well, I finally got the feedback from my SQL Audit presentation last month, and I’m very pleased. Ok, more than...
2011-11-03
783 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