SQL Server 2008 Service Pack 3 Cumulative Update 2 Released
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 2, which is Build 10.00.5768.00. I count only 3...
2011-11-22
1,794 reads
Blog Posts
SQL Server trace flags
Normally I’m not a big fan of using traceflags, my advice is only to use these when it is absolutely...
2011-11-22
2,362 reads
SQLSaturday 97 Speaker Recap
Great Content + Great Speakers = Awesome Event
All the evaluations have been tallied, its official SQLSaturday #97 was a hit! As a...
2011-11-22
799 reads
Throne of Fire
Finally, I have completed another book. I took the opportunity while traveling to catch up on some reading. Better yet,...
2011-11-22
638 reads
Throne of Fire
Finally, I have completed another book. I took the opportunity while traveling to catch up on some reading. Better yet, I was able to do this while testing out...
2011-11-22
7 reads
17 WordPress Plug-Ins That I Use
In the past week, I’ve had a number of requests for a list of the WordPress plug-ins that I use. ...
2011-11-21
1,144 reads
Book Review: Highest Duty, My Search For What Really Matters
Highest Duty, My Search For What Really Matters by Chesley Sullenberger is the autobiography of the pilot who landed Flight...
2011-11-21
894 reads
Conformed dimensions
A conformed dimension is a dimension that has the same meaning to every fact with which it relates. Conformed dimensions allow...
2011-11-21
3,515 reads
DBA in Space: Behind the Scenes—Questions 2 & 3
Part 1 of Question 2—The question.Part 2 of Question 2—The follow up to the question.This is a continuation of my...
2011-11-21
645 reads
Installing SQL Server 2012 RC0
Very short informational post.
If you’re like me and you’ve been running the public Client Technology Preview (CTP3) of SQL Server...
2011-11-21
2,017 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