Seeing Yourself as Others Do
As life skills go one of the hardest is to see yourself as others do – they apply all kinds of...
2011-10-25
866 reads
Blog Posts
SQL Server XQuery Against Execution Plans
One of the greatest things about all the DMOs is how you can combine the information they present to you...
2011-10-25
2,046 reads
The Basics of Joins – Skill #4
This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for...
2011-10-25
1,313 reads
Troubleshooting THREADPOOL Waits
Today I want to talk about a specified wait type that can be sometimes very hard to
troubleshoot: the THREADPOOL wait...
2011-10-25
12,605 reads
Tuesday Hardware Tidbits
There have been a few interesting developments on the hardware front over the past week that I want to cover...
2011-10-25
1,067 reads
ALTER SCHEMA
Use this select statement to create a list of ALTER SCHEMA statements for all stored procedures in a SQL Server...
2011-10-24
1,870 reads
Brad or Spot?
Today we have another guest post from Steve Jones.
I’m no expert on animals, but I have a little experience out...
2011-10-24
619 reads
Deploying SSIS Packages with BIxPress
Same functionality but obvious differences
If you’ve worked with SSIS for any amount of time, you may quickly come to find...
2011-10-24
1,446 reads
GiveCamp Tampa 2011
This past weekend I participated at GiveCamp Tampa 2011 (http://www.givecamptampabay.org/) as part as the Worldwide GiveCamp (http://www.givecamp.org) weekend sponsored by...
2011-10-24
1,023 reads
I Can’t Go To Space
If I could win the DBA In Space contest, I’d be all over it like white on rice. But I...
2011-10-24
1,465 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