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

Content with tags Security, Worst Practices Rss

   Items 1 to 5 of 5   
 

Worst Practice - Bad Connection Strings and Bad Info in Sysprocesses

Andy returns to the Worst Practice series this week with a short article looking at how connection strings in applications affect what you see in sysprocesses. Perhaps less controversial (in our opinion) that some of the other worst practices, this is something easy to fix and definitely worth fixing! Read the article and post a comment - explore other points of view! Readers posting a comment will be entered in a drawing for a copy of the SQL Server 2000 Resource Kit.   Read more...
By Andy Warren 2003/08/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,025 reads

SQL Server Encryption Best and Worst Practices

In this article by Neil Weicher, he talks about encryption of data and files for SQL Server.   Read more...
By Neil Weicher 2002/01/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,561 reads

Worst Practices - Encrypting Data

Continuing with the Worst Practices Series: Steve Jones examines why encryption in the database is a bad idea.   Read more...
By Steve Jones 2002/01/08 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 8,378 reads

Worst Practices - Depending on the GUI

One of the strengths of SQL Server is its ease of management and administration over other systems. Oracle, DB2, even early versions of SQL Server required command line mastery to make many types of changes. But should you really be using the GUI for most of your tasks?   Read more...
By Steve Jones 2001/12/04 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 6,210 reads

Worst Practices - Assigning Users Rights

Continuing with Andy Warren's series on Worst Practices for a DBA, Steve Jones joins in this week with his worst practice.   Read more...
By Steve Jones 2001/11/06 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 7,184 reads
   Items 1 to 5 of 5   
 
Tags
best and worst practices (5)    
sql server 7 (3)    
strategies (3)    
administration (2)    
miscellaneous (2)    
ado (1)    
configuring (1)    
programming (1)    
sql server 6.5 (1)    
visual basic 6 (1)