The Panjandrum Conundrum
With progress thwarted by a committee of panjandrums, will T-SQL forever remain in the doldrums? So wonders Phil Factor.
2020-03-09 (first published: 2017-07-10)
472 reads
Editorials
The Developer Arguments for Stored Procedures
Today Steve asks what reasons a developer has for using stored procedures.
2020-03-06
543 reads
Is 100% Security Possible?
A security breach at Microsoft is disconcerting, especially when they don't share details.
2020-03-05
291 reads
2020-03-04
347 reads
The Evolution of AI
Artificial Intelligence systems might dramatically change our world, but they need lots of help and work to get better.
2020-03-03
150 reads
What Happened to Hadoop?
For a time, it seemed that everyone wanted to build a Hadoop system. The world has changed, and that's not as popular an idea as it used to be. Today, Steve has a few thoughts.
2020-03-02
546 reads
Automatic Redaction of PII
Amazon is providing automatic redaction of PII data in there transcription service.
2020-02-29
281 reads
Reviewing Your Past Efforts
Today Steve starts a mid year review of his career goals and encourages you to do the same.
2020-02-28
146 reads
Data Orchestration
Steve talks data virtualization in the age of growing data sets and larger workloads
2020-02-27
329 reads
2020-02-26
298 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