SQL Saturday Atlanta 2024
Hey there happy coders! Last weekend I had the pleasure of speaking at the SQL Saturday Atlanta event in Georgia! It was an awesome time of seeing data friends...
2024-04-30
35 reads
Test Data Management – 2024 is your year to do it
This blog post is about Test Data Management – or my take on it. I just saw that a video I did for my good mates at Redgate is...
2024-05-01 (first published: 2024-04-30)
87 reads
The Redgate Seminar – Brisbane
On Thursday, May 2, we have the Redgate Seminar in Brisbane. I’ll be at there along with fellow Redgate engineers, account executives, Octopus Deploy engineers, fellow Microsoft MVPs, and...
2024-04-29
29 reads
Microsoft Fabric Training and Tutorials
Microsoft Fabric is the new data offering in Microsoft Azure and there is a great deal of interest in it. How do you get started? Where are the tutorials?
2024-12-23 (first published: 2024-04-29)
843 reads
DBA and Developer: Allies or Adversaries?
In the expansive landscape of software development, the relationship between Database Administrators (DBAs) and Developers has been a subject of intrigue, debate, and occasional drama. Do they collaborate harmoniously...
2024-05-10 (first published: 2024-04-29)
319 reads
dataMinds Saturday 2024 – Session Materials
It was great being at dataMinds Saturday 2024 this past weekend. A great crowd of data enthusiasts was present to learn from a bunch of local speakers (both old...
2024-04-29
28 reads
New Pluralsight Course - Certified Kubernetes Administrator - Working With Your Cluster
We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight!
The next course “Certified Kubernetes Administrator: Working With Your Cluster” in the updated series is now...
2024-04-28
45 reads
Friday Basics: the CIA Triad
In information security (INFOSEC), there several foundational concepts and principles. One of the ones that’s introduced almost immediately is called the CIA triad or the Information Security Triad. While...
2024-05-13 (first published: 2024-04-26)
251 reads
A New Word: the standard blues
the standard blues– n. the dispiriting awareness that the twists and turns of your life feel new and profound, but are not unique – marked by the same coming-of-age...
2024-04-26
33 reads
How Redgate Flyway Can Boost Your DevOps Journey
A brief introduction to the tool and its advantages for database migrations DevOps is a culture and a set of practices that aim to deliver software faster and more...
2024-05-08 (first published: 2024-04-25)
200 reads
Blogs
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Forums
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
Question of the Day
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