The Worst Advice
We all try to help others with advice, but sometimes we end up doing damage. Steve Jones asks for the worst advice you see given in this Friday poll.
2009-07-10
676 reads
Articles
The Worst Advice
We all try to help others with advice, but sometimes we end up doing damage. Steve Jones asks for the worst advice you see given in this Friday poll.
2009-07-10
428 reads
Instead of Trigger, Part 2 - SQL School Video
Part 2 of MVP Andy Warren's SQL School video on Instead of Triggers.
2009-07-09
5,256 reads
2009-07-09
30 reads
Create a Web-Based CRUD Automation Framework with Python
Implement a CRUD automation framework that handles insert and simple queries, an easy way to talk to a database without needing to write any database-access code.
2009-07-09
1,967 reads
Transaction Rollbacks with Identity Values
Have you ever noticed unexpected gaps in sequences in IDENTITY columns? Even though you’ve got transactions set up for your inserts and a no-deletion policy, you find that there are missing values in what should be an unbroken sequence of numbers. The problem could be partially related to transaction rollbacks.
2009-07-09
4,586 reads
Turning Over Passwords
Would you disclose the password for your online sites to get a job? That was required of applicants in Bozeman, MT until recently. Steve Jones is stunned by this.
2009-07-09
733 reads
Turning Over Passwords
Would you disclose the password for your online sites to get a job? That was required of applicants in Bozeman, MT until recently. Steve Jones is stunned by this.
2009-07-09
504 reads
The New Reality of an Audit Trail
With a continuation of his last article on auditing, Leo Peysakhovich enhances his solution to capture more details using XML.
2009-07-08
6,273 reads
Administering Securely
A common request is how can you secure SQL Server data and prevent the system administrator from viewing data. Steve Jones talks a little about the issue and how you can handle it.
2009-07-08
633 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