Why Can't We Go Backwards?
How many times have you wanted to restore a database to an earlier version? Today Steve Jones asks why can't we do this and includes a way for you to vote on this.
2014-09-04 (first published: 2010-01-13)
235 reads
Editorials
2014-09-02
265 reads
2014-09-01
80 reads
On the importance of a complete break
If you’re the type who habitually checks work email and thinks about work while on holiday, here’s Gail Shaw's challenge for next time: don’t.
2014-09-01
181 reads
Hooks
Building hooks from your software into enterprise monitoring systems is prudent, and might save you from a few late night phone calls.
2014-08-29
185 reads
Reverse Engineering Disasters
Preparing a disaster recovery plan means more than just trying to prevent a few specific disasters. It means turning around the way you view the world.
2014-08-28
202 reads
Smooth Database Deployment at SQL in the City 2014
SQL in the City is coming this fall to London and Seattle.
2014-08-26
62 reads
Testing is Your Best Investment
One of the things that can make a big difference in how well your software performs is testing.
2014-08-25
139 reads
The Flash Database
What is the impact of flash storage on databases? There are quite a few, but this week Steve Jones asks if SQL Server should do more to take advantage of them.
2014-08-25
189 reads
Yet Another Attack Vector
The lack of progress in amending our laws to handle the digital revolution in our leaves may leave us open to unexpected attacks.
2014-08-20
139 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