Let's get one thing straight: database administration isn't the most glamorous tech job out there. You won't be building flashy user interfaces or trendy AI models. But if you...
2024-05-01 (first published: 2024-04-17)
701 reads
I know if you are a SQL Server DBA using Azure SQL DB, you’ve been sorely missing the agent. Enter Elastic Jobs to help you schedule jobs more easily...
2024-04-29 (first published: 2024-04-16)
344 reads
Full documentation on the Undercover Catalogue can be found HERE It’s been a while since the Undercover Catalogue last received an update but having had a few of those...
2024-05-01 (first published: 2024-04-16)
294 reads
Yesterday was a long day in London. I arrived late in the am, and as I was walking from the plane to the border check, I went down the...
2024-04-16
34 reads
It was awesome to see the Kentucky data community come out for the first Derby City Data Days in Louisville, KY! Bringing together communities from Ohio, Tennessee, and Kentucky,...
2024-04-16
29 reads
Tomorrow, April 16, 2024, I will be giving another webcast; this one will be on SQL Server security. It’s scheduled for 1 PM EDT / 5 PM UTC. Sign...
2024-04-15
31 reads
the wends– n. the frustration that you’re not enjoying an experience as much as you should, which prompts you to try plugging in various through combinations to trigger anything...
2024-04-12
39 reads
The world runs on data, and SQL is the key to unlocking its secrets. If you're ready to level up your SQL game, online training is a power move....
2024-04-26 (first published: 2024-04-10)
1,314 reads
This post looks at updating the patch information for SQL Monitor/Redgate Monitor without using the automated process. I have other posts on SQL Monitor as well. I heard from...
2024-04-10
62 reads
We’ve been on a Redgate tour this year, running lots of events to interest, educate, and inspire customers. We know that there are challenges in building and operating database...
2024-04-10
26 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