Originally published April 2022; substantially updated July 2026. This post is a complete replacement for and update to my April 2022 post, Power BI Performance Features. That post focused...
2026-07-23
575 reads
At the Redgate Summits this year, we’ve highlighted a few things in the Flyway solution that help developers improve their ability to get work done safely and quickly. While...
2026-07-22 (first published: 2026-07-13)
209 reads
My old Dell XPS that I used for personal stuff started to degrade; well, it's old, and it has already served past its useful life. So, a few months...
2026-07-22 (first published: 2026-07-13)
185 reads
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about GRC and different audits and other important information, later we will discuss each audit frameworks...
2026-07-21
64 reads
Fabric has CI/CD built in, but if you've tried to use it for database deployments, you've probably already run into its limits. It's still very much in its infancy....
2026-07-20 (first published: 2026-07-10)
186 reads
A cryptic message, a book cipher hidden in art provenance records, and a trail of clues leading to the leader of a shadowy cyber organization.
2026-07-20 (first published: 2026-07-09)
83 reads
Thanks to everyone for attending my talk today at Day of data Baton Rouge 2026 (formerly SQL Saturday Baton Rouge). The slides are here: Building an API with DAB...
2026-07-18
71 reads
I wrote about learning today for the editorial: I Can’t Make You Learn. I sure hope you want to learn. It’s been great for my career and it will...
2026-07-17 (first published: 2026-07-10)
170 reads
When I'm looking at a query, I bet it's bad if I see... a shopping list of red flags I've learned to spot, from AI-generated code to SSMS map...
2026-07-17 (first published: 2026-07-07)
1,423 reads
We are product focused at Redgate Software. Here is another of our values that focused on this: The text on the next page is: Shipping something amazing is better...
2026-07-17
39 reads
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
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