The Advanced Encryption Standard (AES) is a National Institute of Standards and Technology specification for the encryption of electronic data. It is expected to become the accepted means of encrypting digital information, including financial, telecommunications, and government data. This article presents an overview of AES and explains the algorithms it uses. Included is a complete C# implementation and examples of encrypting .NET data. After reading this article you will be able to encrypt data using AES, test AES-based software, and use AES encryption in your systems.

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 7

by Additional Articles

Database Journal

This installment of the series illustrates how to use PowerShell in conjunction with SMO to display SQL Server Objects.

Suggestions for PASS

by Andy Warren

SQLServerCentral.com

User Groups

PASS is the global users group for SQL Server DBAs, but there are a number of people who have never heard of it. Longtime author Andy Warren has a few suggestions for PASS and encourages you to submit your own.

Working with PASS

by Steve Jones

SQLServerCentral.com

Editorial

I joined PASS in 1999 and attended the inaugural Summit in Chicago. It was in the lower level of a hotel just on the river, I went to the last White Sox game of the year, and got to see Kalen Delaney speak about this newly released SQL Server 7.

SQL Server 2005 Express Edition - Part 6 - Post Installation Configuration Tasks (Encryption)

by Additional Articles

Database Journal

SQL Server Express

In our new article, we will continue coverage of this topic by describing other activities that alter default connectivity settings applied during standard installation, focusing in particular on encryption.

Understanding the Difference between Owners and Schemas in SQL Server

by Additional Articles

SQLTeam.com

SQL Server 2005

SQL Server 2005 introduces the concept of schemas as opposed to object owners found in previous versions. This article will explain the differences between the two and, hopefully, clear up some of the confusion that still exists about schemas.

An Hour in Time

by Steve Jones

SQLServerCentral.com

Editorial

Daylight Savings time switches a little later this year. In fact it's November 4th this year, after having been in October for all of my life. In case you don't remember which way we move the clocks, here's a saying: Spring forward, fall back.