A Security Regression
Marriott has had another security breach. Does this mean they aren't taking security seriously? Steve has a few thoughts.
2020-04-30
113 reads
Editorials
Where AI Shines
Artificial Intelligence hasn't always worked well, but there is one place that is seems to have lots of potential.
2020-04-29
145 reads
Keeping Unique Aliases
Steve prefers having standards, and today notes that aliases should be included in your standards document.
2020-04-28
145 reads
Encryption Gets Broken All the Time
There are contests to break encryption algorithms taking place all the time. Another one was completed recently.
2020-04-27
201 reads
2020-04-25
136 reads
A Remote Work Guide
This week Steve talks a bit about working remotely, which is something more of us are doing these days.
2020-04-24
216 reads
2020-04-23
186 reads
The Next Data Decade
There are lots of predictions that people make at the start of every year. I've written quite a few over the years, but in 2020 I decided not to make any. After all, there are plenty of other people making them. One person that did make some was Jeff Clarke, COO of Dell. He wrote […]
2020-04-22
134 reads
2020-04-21
264 reads
The SQL Community Steps up in Time of Need
Healthcare workers are some of the many heroes working bravely in the face of the Covid-19 pandemic. To protect themselves and their patients, they must wear face masks during their entire shifts. This causes a great deal of ear irritation, so a strap was designed to make wearing the masks easier and alleviate pressure on […]
2020-04-18
139 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