2020-01-27
223 reads
Editorials
Towards an efficient interface between application and database
As JSON documents becomes increasingly widely used, as the interface between application and database, Phil Factor reckons it's about time JSON Schema was built-in to SQL Server, alongside XML Schema.
2020-01-25
313 reads
2020-01-24
311 reads
2020-01-22 (first published: 2019-01-31)
403 reads
How Do We Prove Expertise?
Today, Grant Fritchey talks about the two paths to expertise for database professionals and why it’s hard to really know if someone is an expert.
2020-01-17
419 reads
Why I’m Learning Git via the Command Line Interface
Today Kendra discusses the advantages of using a command line interface for Git.
2020-01-16
424 reads
Let's Fix a Password Problem
Grant discusses the need for password managers to help prevent security issues between different accounts.
2020-01-15
276 reads
Two Important ‘ONLINE’ Column-Level Operations in SQL Server
Today Kendra talks about two of the online options used when working with indexes.
2020-01-14
351 reads
2020-01-13
271 reads
2020-01-11
289 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