The SQLCLR Impact
Has the SQLCLR system impacted your SQL Server environment? Steve Jones wants to know if it has or has not today.
2014-02-21
219 reads
Editorials
2014-02-19
822 reads
The Security of Interconnected Systems
We are interconnecting more and more computer systems and applications all the time. Security becomes a problem when one of these systems hasn't been properly configured, secured, or coded. Steve Jones notes this is becoming a real problem.
2014-02-18
141 reads
2014-02-17
185 reads
Why Should You Network?
Networking is one of those things that so many people say is good for your career? But why? Steve Jones has a few examples today from his own experience.
2014-02-17 (first published: 2009-08-17)
250 reads
What is Continuous Integration for Databases?
What is continuous integration for databases? Steve Jones gives a short explanation and information on why you might care about this.
2014-02-13
440 reads
How Often Do I Backup my Log?
Do you know how often to back up your SQL Server transaction log? Steve Jones has a few thoughts today and notes that you definitely need to know how to restore the log backups.
2014-02-12
563 reads
The Data Platform Vision
Microsoft published a vision for their data platform and SQL Server recently. Steve Jones has a few thoughts on what this means for you. Hint: it's cloudy.
2014-02-11
139 reads
Performance Tuning Through Panic
We've all been there, trying to improve performance in a panic situation and not making things better.
2014-02-10
392 reads
Oddball Interview Questions
Today we have a guest editorial from Andy Warren. He talks about strange questions in interviews and whether they help you assess the candidate.
2014-02-07
393 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
KONTAK BCA KCP Joyoboyo Telp:08218154392
WA CS (08218154392) Jl. Joyoboyo No.34, Kemasan, Kec. Kota, Kota Kediri, Jawa Timur 64125
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...
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