How I use Ansible to automate routine tasks by running an Adhoc script
As a Platform Engineer, I would like to run a script on over 1000 servers and i don not want to spend the whole day running script manually. There...
2024-03-31
40 reads
As a Platform Engineer, I would like to run a script on over 1000 servers and i don not want to spend the whole day running script manually. There...
2024-03-31
40 reads
Finding the Latest Backup Timestamps for Your Databases
I wanted to find out the most recent date and time each database was last backed up, focusing specifically on full, differential,...
2024-04-08 (first published: 2024-03-29)
690 reads
We use SQL elastic pools at work. I needed to learn more about their nuances and help you with some of their challenges. Setting Up Elastic Pools Here‘s some...
2024-04-05 (first published: 2024-03-29)
506 reads
On April 16, 2024, I will be giving another webcast; this one will be on SQL Server security. Sign up link As always, the registration is free. Here’s the...
2024-03-29
106 reads
1202– n. the tipping point when your brain becomes so overwhelmed with tasks you need to do, you feel too guilty to put anything off until later, prioritizing every...
2024-03-29
42 reads
(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh” has dropped on Amazon to its...
2024-04-08 (first published: 2024-03-28)
546 reads
I was working with a customer and discussing how to do error handling. This is a short post that looks at how you can start adding TRY.. CATCH blocks...
2024-04-22 (first published: 2024-03-27)
641 reads
The 14th annual Ability Summit is a global event that I attended a few weeks ago. It is hosted by Microsoft, and it presents the latest technology innovations and...
2024-03-29 (first published: 2024-03-27)
30 reads
UPDATE: This moved to Apr 9 Join me Tuesday, Apr 9 for a webinar, 10:00am CDT. You can register here and then come watch live with questions or get...
2024-04-05 (first published: 2024-03-26)
246 reads
I will be presenting Answering the Auditor’s Call with Automation at two upcoming events, one virtual and one in-person.
DBA Fundamentals Virtual User Group Tuesday, April 9 2024 at Noon...
2024-04-03 (first published: 2024-03-26)
138 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...
WA CS (08218154392) Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E,...
WA CS (08218154392) Summarecon Serpong, Perumahan Gading Serpong, Jl. Gading Serpong Boulevard Cluster Scientia...
Comments posted to this topic are about the item 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