Introduction In this post, the second in our series, I will guide you through using the new T-SQL Snapshot Backup feature in SQL Server 2022 to take a snapshot...
2024-09-18 (first published: 2024-09-01)
318 reads
Introduction Traditional SQL Server backups can struggle with large databases, resulting in longer backup times and resource contention. T-SQL Snapshot Backup, a new feature in SQL Server 2022, addresses...
2024-09-01 (first published: 2024-08-31)
162 reads
"Let me know where you get your magic pixie dust from!"
2024-08-30
37 reads
flashover – n. the moment a conversation becomes alive and real, when a spark of rust shorts out the delicate circuits you keep insulated under layers or irony, momentarily...
2024-08-30
24 reads
Redgate added Git integration to the free, Community edition of Flyway Desktop. I saw the announcement and decided to make this post to show how this can work for...
2024-08-30
42 reads
I was working on some branching and merging with a customer and they wanted to move a file from one branch to another without taking the entire commit. I...
2024-08-28
31 reads
2024-08-27
25 reads
Ever used Google Maps to find the fastest route home? That's geospatial data in action, turning physical locations into digital info so you can navigate efficiently. Spatial databases take...
2024-09-16 (first published: 2024-08-27)
321 reads
One of the new features in the August Power BI Desktop release is the updated legends that are styled to more accurately reflect the per-series formatting on the visual....
2024-08-26
52 reads
One of the new features in the August Power BI Desktop release is the updated legends that are styled to more accurately reflect the per-series formatting on the visual....
2024-08-26
66 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