SQLServerCentral: Content tagged SQL Server 2005

SQL Server 2005 Logins

Security was a major focus of SQL Server 2005 during its development, both in terms of making the product secure as well as enhancing the options. Security expert Brian Kelley brings us a look at how the paradigm of logins has changed and what you need to look for in SQL Server 2005. Read more...

By Brian Kelley 2008/04/11 (first published: 2006/07/05) | Source: SQLServerCentral.com | Category: sql server 2005 - security

Rating:

|

Discuss |

Briefcase | 105,974 reads

Understanding DDL Triggers in SQL Server 2005

SQL Server 2005 includes a number of new security enhancements to aid the DBA in managing their SQL Server. DDL triggers allow you to trap all kinds of DDL events that occur on your server. S. Srivathsani brings us a look at these new events. Read more...

By S. Srivathsani 2007/07/04 | Source: SQLServerCentral.com | Category: sql server 2005 - security

Rating:

|

Discuss |

Briefcase | 13,214 reads

Securing the SA Account in SQL Server 2005

SQL Server 2005 has greatly changed the security paradigm for SQL Server DBAs. The sa account still exists, but for many tasks you can now avoid using it. New author Ken Johnson brings us some ides for properly securing this highly privileged account. Read more...

By Ken Johnson 2007/03/14 | Source: SQLServerCentral.com | Category: sql server 2005 - security

Rating:

|

Discuss |

Briefcase | 14,260 reads

Setting Up Delegation for Linked Servers

Learn how to set up delegation on your SQL Server instances, so you can use the impersonate options when setting up the security properties of linked server definitions. Read more...

By Additional Articles 2007/09/11 | Source: Database Journal | Category: administration

Rating:

Rate this |

Briefcase | 2,171 reads

SQL 2005 Symmetric Encryption

One of the more interesting new features with SQL Server 2005 is the native encryption built into the product. Expert SQL crpytographer, Michael Coles, brings us a look at the symmetric keys in SQL Server 2005 and how they can be used to encrypt data and be secured by a certificate. Read more...

By Michael Coles 2007/08/24 (first published: 2007/05/11) | Source: SQLServerCentral.com | Category: sql server 2005 - security

Rating:

|

Discuss |

Briefcase | 45,543 reads

Data Security: Stop SQL Injection Attacks Before They Stop You

This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, Using .NET features to prevent attacks, Importance of handling exceptions Read more...

By Additional Articles 2007/08/09 | Source: MSDN Communities | Category: sql server 2005 - security

Rating:

Rate this |

Briefcase | 2,805 reads

A Simple Approach to SQL Server 2005 Encryption

SQL Server 2005 has added encryption capabilities to the platform, much to the delight of many DBAs. However setting up encryption can be confusing and difficult for most DBAs. New author Mike Good brings us a perspective from someone who is brand new to this set of features and has spent time working through the functions and documenting them for the rest of us. Read more...

By Mike Good 2007/08/02 | Source: SQLServerCentral.com | Category: sql server 2005 - security

Rating:

|

Discuss |

Briefcase | 15,452 reads

SQL Server Password Management:

Improving SQL Server password management includes thorough password testing and securing SQL Server installations beyond the main database server. Read more...

By Additional Articles 2007/07/31 | Source: SearchSQLServer | Category: sql server 2005 - security

Rating:

Rate this |

Briefcase | 2,277 reads

You have just removed the builtin/Administrators group from...

By Steve Jones 2007/07/23 | Category: sql server 2005 - security

Rating: (not yet rated) |

Discuss |

Briefcase | 1,434 reads

Temporarily Changing an Unknown Password of the sa Account

You are asked for the sa password for a SQL Server in order to perform a software upgrade. You, the DBA, don't know the password and it's not documented. Rodney Landrum provides a way out of this dilemma, demonstrating two techniques for temporarily changing the password, and then returning it to its previous unknown value. Read more...

By Additional Articles 2007/07/18 | Source: SimpleTalk | Category: sql server 2005 - security

Rating:

Rate this |

Briefcase | 3,893 reads

Scripting permissions using catalog views in SQL Server 2005

A nice How-To from one of the most respected SQL Server MVPs. Read more...

By Additional Articles 2007/07/13 | Source: Other | Category: sql server 2005 - security

Rating:

Rate this |

Briefcase | 2,264 reads

Stop SQL Injection Attacks Before They Stop You

This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, and more. Read more...

By Additional Articles 2007/07/09 | Source: MSDN Communities | Category: security

Rating:

Rate this |

Briefcase | 3,967 reads

Understanding DDL Triggers in SQL Server 2005

SQL Server 2005 includes a number of new security enhancements to aid the DBA in managing their SQL Server. DDL triggers allow you to trap all kinds of DDL events that occur on your server. S. Srivathsani brings us a look at these new events. Read more...

By S. Srivathsani 2007/07/04 | Source: SQLServerCentral.com | Category: sql server 2005 - security

Rating:

|

Discuss |

Briefcase | 13,214 reads

The SQLCLR permission sets are actually enforced via...

By Steve Jones 2007/06/26 | Category: sql server 2005 - security

Rating: (not yet rated) |

Discuss |

Briefcase | 1,011 reads

What is the strongest level of encryption you...

By Steve Jones 2007/06/12 | Category: sql server 2005 - security

Rating: (not yet rated) |

Discuss |

Briefcase | 1,169 reads

Which fixed database roles can execute the BACKUP...

By Steve Jones 2007/06/11 | Category: sql server 2005 - security

Rating: (not yet rated) |

Discuss |

Briefcase | 1,313 reads

In SQL Server 2005, how can you create...

By Steve Jones 2007/06/07 | Category: sql server 2005 - security

Rating: (not yet rated) |

Discuss |

Briefcase | 1,178 reads

SQL 2005 Symmetric Encryption

One of the more interesting new features with SQL Server 2005 is the native encryption built into the product. Expert SQL crpytographer, Michael Coles, brings us a look at the symmetric keys in SQL Server 2005 and how they can be used to encrypt data and be secured by a certificate. Read more...

By Michael Coles 2007/08/24 (first published: 2007/05/11) | Source: SQLServerCentral.com | Category: sql server 2005 - security

Rating:

|

Discuss |

Briefcase | 45,543 reads