2019-11-19
417 reads
Editorials
2019-11-18
231 reads
Human frailty and the custodianship of data
Until you open the box your data is, like Schrödinger's cat, both safe and breached.
2019-11-16
159 reads
Agile Job Descriptions
Steve ends his week of career thoughts with a look at the job descriptions that we often use to decide if we want to apply for a job.
2019-11-15
280 reads
Data Science, BI, and Reports
Business Intelligence and Data Science are linked, and complementary. As Steve notes, both can help your organization make better decisions based on data.
2019-11-14
411 reads
Micro Credentials
Today Steve talks about a new way of achieving some certification and education from Microsoft.
2019-11-13
267 reads
2019-11-11
348 reads
A Big Week for the Data Platform
Steve highlights a few items from a busy Microsoft and SQL Server news week.
2019-11-09
236 reads
The Network Bottleneck
Computer networks are critical for our work, but if they get clogged with new types of data, we might have a problem.
2019-11-08
241 reads
2019-11-07
226 reads
Blogs
Adding an HTTP MCP Server to VSCode
By Steve Jones
I wrote earlier this week about the SQL MCP Server using the Data API...
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...
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