2012-12-17
73 reads
Editorials
Deployment Failures
Today Steve Jones talks about deployment and how well it can work. He also asks about the problems from you and how easily it can fail.
2012-12-14
127 reads
Cloud Concerns
Security is a concern in the cloud, but should it be your number one concern? Steve Jones notes that business continuity might be a bigger issue.
2012-12-13
168 reads
Disaster After Disaster
A disaster can easily lead to another disaster. Can you respond to multiple problems? Have you even considered the cascade effects of a large disaster?
2012-12-12
223 reads
Test Your Restores
Part of an effective response to a disaster situation is practice and testing of your skills and procedures. Steve Jones reminds us this is important today.
2012-12-11
151 reads
Grace Under Pressure
When a disaster strikes, how will you respond? Will you not only successfully recover, but will you do so with professionalism and grace under pressure? Steve Jones tells you how you can.
2012-12-10
139 reads
What Counts for a DBA: Being Replaceable
Louis Davidson describes why all DBAs should strive to be replaceable, and what that really means.
2012-12-10
330 reads
Keynotes
This Friday we look forward to the various tech events of 2008 and which speakers you think are worth seeing. This editorial was originally published on Jan 11, 2008. It is being re-run as Steve is traveling.
2012-12-07 (first published: 2008-01-11)
63 reads
Try To Be More Inefficient
Steve Jones is recommending that you don't work the most efficient way at your job. Sometimes. This editorial was originally published on Apr 3, 2008. It is being re-run as Steve is out of town.
2012-12-06 (first published: 2008-04-03)
493 reads
Type A, B, or C
Do personality types matter and did you know there are more than just A or B types? This editorial was originally published on Feb 26, 2008. It is being re-run as Steve is traveling.
2012-12-05 (first published: 2008-02-26)
287 reads
Blogs
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...
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
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