Catching Up On SQLOrlando
Somehow two years have elapsed since my last update; hopefully it won’t be that long before the next one. My last post was about SQLSaturday Orlando 2023. Since then,...
2026-01-16 (first published: 2026-01-03)
185 reads
Somehow two years have elapsed since my last update; hopefully it won’t be that long before the next one. My last post was about SQLSaturday Orlando 2023. Since then,...
2026-01-16 (first published: 2026-01-03)
185 reads
When you must rollback a deployment of changes, is that a failure of the process? The development effort? Or something else?
2025-10-08 (first published: 2014-03-04)
308 reads
Today we have a guest editorial where Andy Warren asks you if you know how to ask for things at work. Many IT works struggle to ask for resources, but read on to understand how Andy might help you get more done at your job.
2024-01-29
121 reads
How do you determine if you're at the top of your profession? Andy Warren has a few thoughts today.
2024-01-19
121 reads
Is there a reason to upgrade your SQL Server in place instead of building a new instance? Andy Warren has a few thoughts today on why this might be the right choice.
2023-12-20
6,053 reads
A lesson learned when trying to restore backups with standby. You can't upgrade versions.
2023-09-25
9,980 reads
Today we have a guest editorial from Andy Warren as Steve Jones is on vacation. Today Andy looks at the ways we can cope when we have been working too much.
2023-09-13 (first published: 2012-02-16)
385 reads
Most of us want more autonomy at work, but it isn't given out without effort. Today Andy Warren has a few thoughts on how to get more freedom from your boss.
2023-07-24
139 reads
Quick notes on the event this year: Overall a good event and now I have a few months until SQLSaturday in Orlando in October.
2023-07-21 (first published: 2023-07-06)
167 reads
The call for speakers is open! We’re always excited to have experienced and past speakers return (Rob Volk!), but if you’re a first time or relatively new speaker just...
2023-07-07
46 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