Tracking Illicit Users

Longtime SQL Server guru David Poole brings us a look at one of the thorny problems a DBA faces: tracking down illicit users.

Basic SQL Server security principles you can't afford to miss

Learn how using basic SQL Server security practices of least privilege, delegated administration and separation of duties will protect SQL Server databases.

SQL Server 2005 Encryption types

SQL Server 2005 provides four methods of encryption. Part one of this article covers encryption and decryption by passphrase.

SQL Server encryption vs. hashing for data security

Study encryption and hashing algorithm options for data security in SQL Server 2005 and use symmetric/asymmetric keys to encrypt and decrypt SQL Server data.

OpenRowset Security

Reorganize permissions in SQL Server 2005 step by step

Learn how to reorganize permissions in SQL Server 2005 in a multiple database environment.

Server Login/Role And DB User/Role Script

This script will produce the server login/role and db user/role in all databases in the server.It is best advised that you first delete/recreate orphaned users for best results

OpenRowset Security

GrantExecAllUserAllSpandfunctions.sql

Grant permits execution to all user on all sp and functions

Keep Your Data Secure with the New Advanced Encryption Standard

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.