Giving Computers Ethics
There is a need to ensure we decide what ethics a computer system ought to have.
2020-02-10 (first published: 2019-03-27)
258 reads
Editorials
Personal Power
Because of my job with Redgate (which I love and will never leave even after I’m dead), I spend a lot of time learning about compliance and all the new laws and regulations coming out of things like the GDPR and the CCPA (they changed the name evidently). However, I’m a nerd. I’m not a […]
2020-02-08
150 reads
2020-02-06 (first published: 2019-02-28)
387 reads
Staying Safe when Traveling
Today, Grant talks about keeping your laptop and phone safe while traveling.
2020-02-05
259 reads
How to Get Started with Version Control for Databases
Today, Kendra talks about why version control for databases is important and how to get started.
2020-02-04
509 reads
2020-02-03
171 reads
Why Getting Data Right Matters
An InfoWorld article from 2017 suggests that 80 percent of a data scientist’s job is cleaning and transforming data, and I believe this is probably only true for organizations that spend at least an average effort in designing and implementing their data storage. These persons who have trained to analyze data using complex math formulas […]
2020-02-01
189 reads
2020-01-30
233 reads
Why A Query May be Faster the Second Time it Runs
Today, Kendra Little explains why a query may run faster the second time you run it.
2020-01-29
2,534 reads
2020-01-28 (first published: 2018-12-06)
633 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