This article shows how to use DDL triggers to capture schema changes. This solutions works a little differently than most DDL triggers examples. This script captures the old object that was replaced.
If you're in the UK in October, you might want to sign up for the SQLBits Community day put on by MVP Simon Sabin.
Danny Gould has written a very interesting piece of software that gives you a view into the storage of your data inside SQL Server. And it's FREE!!! He brings us a description of this software in this short article.
This article shows how to use the SqlDataSource and AccessDataSource controls to query data from a relational database.
This article demonstrates how you can use Surface Area Configuration utility in order to modify some of the security-related settings that have been applied during installation of SQL Server 2005 Express Edition.
One of the more interesting new features with SQL Server 2005 is the native encryption built into the product. Expert SQL crpytographer, Michael Coles, brings us a look at the symmetric keys in SQL Server 2005 and how they can be used to encrypt data and be secured by a certificate.
Not the ones you think, but all good reasons to come to Denver. Read on for a bit of humor and find out how to come to the SQLServerCentral.com party!
An easy to use .NET solution for Job Scheduling, with pluggable actions, that runs on a Windows Service. Backup your SQL Server Express and much more!
SQL Server 2005 includes support for encrypting and decrypting data for storage using EncryptByCert. Let’s look at how to implement this in the SqlCredit database.
One common need that DBAs run into is building a report that returns data in some random order. Especially if you're doing some type of contest, like giving something away at your User Group meeting. Andy Warren brings us a short article on this with a look at the performance impact of randomly ordering results.
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