Additional Articles

Keep Your Data Secure with the New Advanced Encryption Standard

by Additional Articles

Microsoft MSDN

Security

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.

2007-10-19

2,427 reads

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.

2007-10-19

2,740 reads

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.

2007-10-18

2,137 reads

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.

2007-10-18

5,547 reads

Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4

by Additional Articles

Database Journal

This installment illustrates how to use PowerShell script to loop through the content of the file and connect to different servers.

2007-10-16

2,744 reads

Restore your SQL Server database using transaction logs

by Additional Articles

Builder.com

SQL Server 2005

Most DBAs dread hearing that they need to restore a database to a point in time, especially if the database is a production database. However, knowing how to do this is of the utmost importance for a DBA's skill set. I'll walk you through the steps of how to restore a SQL Server database to a point in time to recover a data table.

2007-10-15

4,024 reads

Are key performance indicators a true measure?

by Additional Articles

Builder.com

Strategies

Some managers love to look solely at numbers when assessing performance, and key performance indicators (KPIs) are right up their street. But how useful are they in the context of software development

2007-10-12

3,591 reads

Build a Green Datacenter

by Additional Articles

TechNet Blogs

Hardware

Green is the hot topic these days, and the concept is having an impact on the way people think about datacenters. Companies around the world are announcing ways to save energy and reduce

2007-10-11

1,178 reads