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

Content with tags Security, SQL Server 7, Strategies Rss

   Items 1 to 20 of 20   
 

SQL 2000 DBA Toolkit Part 1

SQL Server 2005 builds some great encryption tools into the product, but what if you are stuck with SQL Server 2000? SQL Server expert Michael Coles brings us the first part of a series along with a free toolkit to manage encryption and keys.   Read more...
By Michael Coles 2007/06/22 (first published: 2006/04/13) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 30,265 reads

Anticipate the worst when developing SQL Server databases

Arthur Fuller advises DBAs to try to break their software in order to make sure their SQL Server databases can withstand potential attacks. See if your code can hold up to his suggested tests.  Read more...
By Additional Articles 2006/10/12 | Source: Builder.com | Category: security
Rating:  Rate this |   Briefcase | 3,174 reads

SQL 2000 DBA Toolkit Part 1

SQL Server 2005 builds some great encryption tools into the product, but what if you are stuck with SQL Server 2000? SQL Server expert Michael Coles brings us the first part of a series along with a free toolkit to manage encryption and keys.   Read more...
By Michael Coles 2007/06/22 (first published: 2006/04/13) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 30,265 reads

Conducting a SQL Server Operational Audit

Auditing, analyzing and documenting your SQL Server installation is becoming more important all the time, especially as more and more attention is being paid to the security of your environment. Chad Miller brings us a look at a framework and a sample document you can use in your environment to conduct an audit.   Read more...
By Chad Miller 2005/10/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,160 reads

10 Steps to Securing your SQL Server

Securing your SQL Server can be an arduous task, but very rewarding. This article covers 10 steps to properly protecting your data.   Read more...
By Brian Knight 2005/05/27 (first published: 2003/04/03) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 43,769 reads

SQL Server Alerts

SQL Server Alerts provide a great way for the server to notify a DBA that some event has occurred, usually something bad that they need to fix. However alerts can also be used to drive business logic processes and enable some types of actions to be safely performed without requiring extraordinary rights by a user. Author Leo Peysakhovich brings us some ideas on how we can use alerts to implement business logic processing.   Read more...
By Leo Peysakhovich 2004/08/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 20,532 reads

Fixing broken logins and transferring passwords

When transferring a database to a new server, you are bound to experience a user problem. In this article by Neil Boyle, he shows you how to transfer passwords and accounts seamlessly to a new server.   Read more...
By Neil Boyle 2004/07/05 (first published: 2002/08/14) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 23,925 reads

Fixed Database Roles

This article covers four of the fixed database roles (db_datareader, db_datawriter, db_denydatareader, and db_denydatawriter). If you're new to SQL security (and maybe even if you're not) this article is worth reading.   Read more...
By Andy Warren 2003/10/10 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 10,017 reads

SecureWave's SecureStack 3.0 Release

SecureWave forwarded us this link to some info about their product - they claim to be the only product capable of protecting SQL Server from buffer overflow attacks. You can download a free eval from their site. We have not reviewed this product.  Read more...
By Additional Articles 2003/04/29 | Source: Other | Category: security
Rating:  Rate this |   Briefcase | 926 reads

10 Steps to Securing your SQL Server

Securing your SQL Server can be an arduous task, but very rewarding. This article covers 10 steps to properly protecting your data.   Read more...
By Brian Knight 2005/05/27 (first published: 2003/04/03) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 43,769 reads

The Case for SQL Logins - Part Two

In this follow up to one of our most popular articles, Andy responds to comments posted by readers and discusses how to manage SQL logins effectively in your applications.   Read more...
By Andy Warren 2002/08/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,769 reads

Fixing broken logins and transferring passwords

When transferring a database to a new server, you are bound to experience a user problem. In this article by Neil Boyle, he shows you how to transfer passwords and accounts seamlessly to a new server.   Read more...
By Neil Boyle 2004/07/05 (first published: 2002/08/14) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 23,925 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,379 reads

Enforcing Security in Multi-Tier Applications

The major part of the article, however, is dedicated to a topic that often confuses people and leads to some of the strongest disagreements among IT professionals and developers: the benefits and drawbacks of enforcing security in the middle (or business) tier versus the data tier.   Read more...
By Additional Articles 2001/12/25 | Source: Microsoft MSDN | Category: security
Rating:  Rate this |   Briefcase | 1,448 reads

Microsoft Announces a New Security Program

Microsoft has announced a new security program to help system administrators secure their sites. Worth a read.   Read more...
By Additional Articles 2001/10/19 | Source: Microsoft SQL Home | Category: security
Rating:  Rate this |   Briefcase | 3,660 reads

SQL Server Security Best Practices

Learn how to secure your data by implementing SQL Server security best practices.   Read more...
By Additional Articles 2001/09/20 | Source: Other | Category: security
Rating:  Rate this |   Briefcase | 3,230 reads

Security Alerts and Information

A new security alert affecting SQL Server was released on June 12, 2001   Read more...
By Steve Jones 2001/06/14 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 3,576 reads

Security Alerts and Information

Security information for SQL Server in one place.   Read more...
By Steve Jones 2001/05/25 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 3,751 reads

Securing Your SQL Server

Poorly managed SQL Server Security can not only leave your SQL Server vulnerable, but also leave your NT Server and network open to attacks.   Read more...
By Brian Knight 2001/05/14 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 6,426 reads

Using the Public Role to Manage Permissions

This article by Andy Warren discusses both how to use the Public Role and how using Public may cause you more problems than it's worth. Great examples!   Read more...
By Andy Warren 2001/05/10 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 17,261 reads
   Items 1 to 20 of 20   
 
Tags
administration (4)    
miscellaneous (4)    
sql server 6.5 (3)    
best and worst practices (2)    
programming (2)    
best practices (1)    
configuring (1)    
disaster recovery (dr) (1)    
news (1)    
sql server 2005 (1)    
t-sql (1)    
worst practices (1)