Monday Monitor Tips: VLF Alerts
A recent change made to Redgate Monitor to add a new alert for VLF count. This post looks at the change. This is part of a series of posts...
2025-03-03 (first published: 2025-02-24)
327 reads
Using T-SQL Snapshot Backup - Seeding Availability Groups
In this post, the fifth in our series, I want to illustrate an example of using the T-SQL Snapshot Backup feature in SQL Server 2022 to seed Availability Groups...
2025-02-24
140 reads
A New Word: Tangency
tangency– n. a fleeting glimpse of what might have been. I tend to live in the real world as it is, not too dreamy or wishful that things were...
2025-02-21
17 reads
Join me at the Microsoft Fabric Community Conference with a discount code
I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which takes place March 31 through April 2 in Las Vegas, Nevada. I will be co-presenting...
2025-02-20
12 reads
Join me at the Microsoft Fabric Community Conference with a discount code
I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which takes place March 31 through April 2 in Las Vegas, Nevada. I will be co-presenting...
2025-02-20
9 reads
Join me at the Microsoft Fabric Community Conference with a discount code
I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which takes place March 31 through April 2 in Las Vegas, Nevada. I will be co-presenting...
2025-02-20
17 reads
Join me at the Microsoft Fabric Community Conference with a discount code
I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which takes place March 31 through April 2 in Las Vegas, Nevada. I will be co-presenting...
2025-03-05 (first published: 2025-02-20)
145 reads
Is Your Business Truly Ready for AI?
The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial intelligence into their operations, eager to unlock efficiency, automation, and data-driven decision-making. But while AI...
2025-03-10 (first published: 2025-02-20)
243 reads
Data Governance: The Invisible AI Accelerator
Introduction Do you remember the effort of tidying up your BI and reporting systems, only to find yourself facing a labyrinth of inconsistent data, missing values, and unclear ownership?...
2025-03-05 (first published: 2025-02-20)
223 reads
Making a PostgreSQL Backup in a Container
I needed to back up a PostgreSQL database as a part of the repro for an issue I had. I hadn’t ever made a backup of PostgreSQL, so this...
2025-02-19
145 reads
Blogs
Adding an HTTP MCP Server to VSCode
By Steve Jones
I wrote earlier this week about the SQL MCP Server using the Data API...
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...
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