What Do You Want from SQL in the City?
After the SQL in the City tour wrapped up this week in Seattle, Steve Jones looks back and asks a question. What type of training would be best for you.
2012-11-09
142 reads
Editorials
More Than One Way to Skin a Cat
There are many ways to accomplish a task in SQL Server, and almost every technology. But too much choice might not be the best thing for beginners.
2012-11-08
212 reads
Savvy Managers
Data quality is everyone's business and it takes some work. Steve Jones talks about some hints for you and your manager to make things better in your data systems.
2012-11-07 (first published: 2007-11-27)
169 reads
Unprotected Queries
There are over half a million database servers out on the Internet without protection. How can this happen?
2012-11-06 (first published: 2007-12-04)
488 reads
Working Your 40
Will the 40 hour work week change anytime soon? A survey seems to think so, and Steve Jones (somewhat) agrees.
2012-11-05 (first published: 2007-12-03)
325 reads
A Welcome Delay
An open letter to Microsoft from the CEO of Mandriva Linux might not have been the best idea.
2012-11-02 (first published: 2007-11-30)
376 reads
2012-11-01
118 reads
Software Teams
Building a team when you are developing software of any size is important and Steve Jones shares one of the most important things you need.
2012-10-31 (first published: 2007-12-10)
183 reads
Keeping Your Job
A few thoughts from Steve Jones on how you can help increase your own job security in IT.
2012-10-30 (first published: 2007-11-26)
377 reads
2012-10-29 (first published: 2007-11-20)
224 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