2013-08-12
121 reads
Editorials
Review Your Code
Steve Jones notes that SQL Injection is still a problem, and while it might be for some time to come, we should not be adding to the issues. Learn how to write secure code.
2013-08-12
539 reads
Would You Choose SQL Server?
This Friday Steve Jones has a poll asking how you feel about SQL Server for your own projects, or even your company's projects. Is it a given you'd use SQL Server?
2013-08-09
269 reads
The Standard Limitation
SQL Server Standard Edition only supports 64GB of RAM and it's our fault. Or is it, and is this a reasonable number? Steve Jones has a few thoughts today.
2013-08-07
406 reads
Separation of Duty
We want to ensure that the data we gather accurately reflects the state of some system or event. The analysis should decide how we interpret the data gathered. Neither should influence the other.
2013-08-06
133 reads
DEF CON SQL
An impromptu hacking session, in response to an inexplicably-changed password, reminds Rodney Landrum of some valuable lessons for every DBA.
2013-08-05
121 reads
2013-08-05
196 reads
The School Year
This Friday Steve Jones looks forward to the rest of the year. It's almost time for school and do you have plans? Should you be making some plans?
2013-08-02
113 reads
The Human Touch
Humans are often the weakest links in any computer process, but we do need human input. Steve Jones talks about a few issues, and how we should be changing our workflow to reduce issues.
2013-08-01
130 reads
Flying high on the Big Data hot-air
Today Phil Factor talks about Big Data, and all the hype that's in the news.
2013-07-30
275 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