The Design Investment
How much of an investment should you make in learning design? Steve Jones talks about why we should learn how to do it right.
2015-03-11 (first published: 2010-09-29)
336 reads
Editorials
Limitations of MongoDb
This article looks at two critical limitations suffered by MongoDb compared with SQL Server.
2015-03-10
467 reads
Don’t Understand? You’re About to Learn Something
Learning opportunities abound, but they can be stressful, as shown in today's guest editorial.
2015-03-09
263 reads
Fifty Words for Databases
Phil wonders whether it is our poor vocabulary about databases that has lead to the failure of developers and Operations people to understand each other on the topic of deployment.
2015-03-09
241 reads
Upgrade and Refresh, or Not?
Today we have a guest editorial from Andy Warren that looks at the upgrade cycle and how that affects our jobs.
2015-03-06
137 reads
Measuring Career Growth
A guest editorial from Tim Mitchell today looks at keeping track of what we have done in our careers, and the value that it gives us.
2015-03-05 (first published: 2010-10-01)
447 reads
2015-03-04
571 reads
Pier to Pier Replication on Frozen Lake Erie
In a guest post, Rodney Landrum ponders the gaps in his DBA experience at the edge of Lake Erie.
2015-03-02
126 reads
The Express Choice
This week Steve Jones wonders if you'd be willing to use Express edition in production situations.
2015-02-27
145 reads
Building Small Habits
Today Steve Jones talks about development, and finding ways to make small changes that improve your code.
2015-02-26
209 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