Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Advanced Querying, Security Rss

   Items 1 to 6 of 6   
 

Encrypting Data With the Encrypt Function

One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer.   Read more...
By Brian Knight 2006/05/29 (first published: 2001/07/17) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 32,991 reads

Save Your Password

Storing passwords in SQL Server for authentication by your application is a common practice. But not always a good one. Someone with access could easily see all passwords and perhaps cause mischief inside your application. Imagine the office gossip getting access to your HR application as the HR director! Not a good thing. Dinesh Asanka has written a short piece on how you can use a built in function in SQL Server to encrypt these passwords and use them with a minimum of effort.   Read more...
By Dinesh Asanka 2004/07/12 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 13,146 reads

Auditing Your SQL Server Environment Part II Auditing Your SQL Server

In this article by Randy Dyess he shares with you the script on how he audits his environment and outputs reports of the permissions that users have.  Read more...
By Randy Dyess 2002/05/30 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 9,534 reads

Auditing Your SQL Server Environment Part I

Ever been placed into a new environment and couldn't find an ounce of documentation? This article is the first in a series that will help you make an audit of your new environment and determine if any SQL Server login does not have a password, has a password the same as the login name or a password that is only one character long.  Read more...
By Randy Dyess 2002/04/02 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 10,367 reads

Using Java to Encrypt Passwords

Lots of applications store user names and passwords in the database. This article presents a method for encypting this information using Java.   Read more...
By Les Smith 2001/07/19 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 13,395 reads

Encrypting Data With the Encrypt Function

One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer.   Read more...
By Brian Knight 2006/05/29 (first published: 2001/07/17) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 32,991 reads
   Items 1 to 6 of 6   
 
Tags
t-sql (5)    
sql server 7 (4)    
monitoring (1)    
sql server 6.5 (1)    
strategies (1)