This editorial that was originally published on Aug 15, 2007. It is being rerun as Steve is traveling. This editorial looks at the issues that happen in production and how you should perhaps plan for disasters.
2012-06-11 (first published: 2007-08-15)
260 reads
Database people are used to changing the hardware of the server on which a problem database resides, or making changes to indexes and database settings, but humans and their organisations are far more difficult to tune and optimise than databases.
2012-06-11
308 reads
Today we have an editorial from Aug 8, 2007 that is being republished as Steve is on holiday. This piece looks at interns and how it's a good idea for finding new employees.
2012-06-08 (first published: 2007-08-08)
110 reads
It can be very hard to find time to learn new skills and get better at your job. Today Steve Jones talks about finding a little time in the margins of your life.
2012-06-07
212 reads
Today Steve Jones talks about the need to understand code to be a good administrator. Our systems are more complex and we cannot manage multiple systems by clicking on buttons in an interface.
2012-06-06
125 reads
Managing risk is a park of business, but it also requires that we have the information to properly assess the issues. Do we prevent that in IT?
2012-06-05
138 reads
Siri is seen as a data security hole at IBM. This is something that Steve Jones thinks we might need to be more concerned about in the future, especially as more and more processing takes places outside of our walls.
2012-06-04
152 reads
This year we will see a large number of upgrades from Microsoft to much of its technology stack. Can IT Pros handle the load?
2012-06-04
108 reads
This Friday Steve Jones asks if you like your job. Are you engaged? Do you want to stay? Give us your answer today.
2012-06-01
211 reads
Today we have a guest editorial from Grant Fritchey that might surprise you. Today Grant talks about clustered indexes in your tables.
2012-05-31
976 reads
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Comments posted to this topic are about the item Symmetric Key Encryption
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Comments posted to this topic are about the item Building Your Own Software
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