A Patch Disaster
What would happen if the wrong patches were applied to your database server? The results could be a huge problem. Steve Jones reminds you to be careful with mass patches.
2013-01-10
148 reads
Editorials
Statistical Protection
Statistical databases contain lots of information that can be used in a variety of ways, but it can also be abused. Steve Jones talks about some of the problems and potential solutions.
2013-01-08
113 reads
The $50,000 Laptop
The average value of a lost laptop has been found to be much more than you might expect. Steve Jones talks about a recent study.
2013-01-07
226 reads
What Counts for a DBA: Amnesia
Louis Davidson explains why DBAs often need a healthy dose of selective, enforced amnesia about the pain of previous failures.
2013-01-07
162 reads
DR Prep
This week Steve Jones asks how you might handle DR preparation or process differently in the new year.
2013-01-04
121 reads
All Flash
Should you think about using SSD storage in your SQL Server databases? Steve Jones thinks this might be something you should consider.
2013-01-03
225 reads
2013-01-01
290 reads
2012-12-31
227 reads
'At-Rest Data-Leakage': The Euphemism
If you let working drives leave the building in a readable state, you’re unintentionally in the publishing business.
2012-12-31
97 reads
2013 Goals
For the last Friday poll of the year, Steve Jones looks ahead to 2013 and the goals you might set for your career.
2012-12-28
192 reads
Blogs
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...
Adding an HTTP MCP Server to VSCode
By Steve Jones
I wrote earlier this week about the SQL MCP Server using the Data API...
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