Regarding managing databases in the cloud, security should never be an afterthought. That’s where Azure Vulnerability Assessments, officially named Microsoft Defender, come in—they help you spot weak spots in...
2025-05-26 (first published: 2025-05-07)
445 reads
In a couple of weeks, I’ll be in New York City for the Redgate DevOps Devour Hour Lunch and Learn. This is at the Industrious office at 730 3rd...
2025-05-07
30 reads
Early Warnings of a Meltdown (and How to Catch Them) Most SQL Server crashes don’t come out of nowhere. They leave breadcrumbs – red flags that something’s not right....
2025-05-07
102 reads
Can you restore multiple differential SQL Server backups
The post Can You Restore Multiple Differential Backup Files? appeared first on Tim Radney.
2025-05-07
68 reads
I wrote not too long ago about planning out downtime, but I found a great article from the Harvard Business Review about the importance of doing so. The article...
2025-05-06
32 reads
As discussed in my blog and book “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh” (Amazon), organizations are often challenged with...
2025-05-28 (first published: 2025-05-06)
794 reads
After missing last year, SQL Saturday New York City is back in 2025. I’m excited to go to the event and honored to speak there. I love visiting New...
2025-05-06
128 reads
This month, I am hosting T-SQL Tuesday for the very first time. T-SQL Tuesday is a monthly blog party originally created by Adam Machanic in 2009 and currently curated...
2025-05-06
21 reads
I had a customer recently that was asking about Linked Servers and some development advice. I was going to show them a few things and realized I hadn’t created...
2025-05-05
306 reads
Now that I’ve completed both TOGAF 9 tests, I am putting up a couple of quick posts on how I prepared for these Enterprise Architecture exams.
2025-05-05
37 reads
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
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