The unhealthy obsession with ROLLBACK
So I jumped onto an LLM and asked it to give me some PL/SQL to handle a 3-step series of DML statements and out popped the following code: That...
2026-04-30
3 reads
So I jumped onto an LLM and asked it to give me some PL/SQL to handle a 3-step series of DML statements and out popped the following code: That...
2026-04-30
3 reads
I don’t have SQL Server installed on my laptop. In an effort to keep things clean and smooth in case I need to rebuild things, I’ve gone with containers....
2026-05-11 (first published: 2026-04-29)
321 reads
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying the most expensive queries is crucial to optimize resource usage and improve overall system efficiency.
Step-by-Step...
2026-05-15 (first published: 2026-04-28)
98 reads
If you’ve been here before, you know this blog is usually about SQL Server, PowerShell, and the day-to-day work of being a DBA. Execution plans, availability groups, dbatools scripts...
2026-05-13 (first published: 2026-04-28)
451 reads
You may have already seen that thanks to Kris Rice, we now have a baseline set of Oracle skills available for your favourite AI tools. Check out the skills...
2026-04-28
1 reads
I’ve been doing storage load tests for SQL Server for a long time, both as a consultant and now in my work at Everpure, and I see the same...
2026-05-11 (first published: 2026-04-27)
225 reads
I had a few random questions from my Running a Local LLM on Your Laptop session at the Houston AI-lytics 2026 event last week, so this post looks at...
2026-04-27
21 reads
For those entering the AI space whether professionally or personally I wanted to give a quick overview on the different models on offer within the Claude family – when...
2026-05-06 (first published: 2026-04-27)
381 reads
Thanks to everyone for attending my session on running a Local LLM. If you have any questions, please feel free to reach out with them. The slides with links...
2026-04-25
23 reads
I do believe that Redgate has been very customer focused since it’s inception. I’ve worked with them in some capacity since 2002 and I’ve felt this along the way:...
2026-04-25 (first published: 2026-04-24)
42 reads
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Most embedding pipelines on AWS have the same shape: a job reads rows out...
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Comments posted to this topic are about the item Symmetric Key Encryption
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Comments posted to this topic are about the item Building Your Own Software
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