http://www.sqlservercentral.com/Content tagged Strategies, SQL Server 2005 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Application locks aren't a well known area of locking in SQL Server, but they can be very useful for special scenarios. They work in an analogous way to the lock() construct in .Net and are basicaly user defined mutexes in SQL Server.http://www.sqlservercentral.com/redirect/articles/61919/2008/01/15http://www.sqlservercentral.com/redirect/articles/61919/Continuing on with a look at SQL Server 205 partitioning features, Andy Warren delves into archiving techniques. http://www.sqlservercentral.com/articles/Miscellaneous/3242/2007/10/08http://www.sqlservercentral.com/articles/Miscellaneous/3242/Auditing is something that almost every DBA needs to tackle at some point in his or her career. David McKinney brings a new twist on the solution by using XML and XSL to help implement auditing in your SQL Server application. http://www.sqlservercentral.com/articles/Security/3179/2007/08/20http://www.sqlservercentral.com/articles/Security/3179/This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, and more.http://www.sqlservercentral.com/redirect/articles/3073/2007/07/09http://www.sqlservercentral.com/redirect/articles/3073/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.http://www.sqlservercentral.com/redirect/articles/2620/2006/10/12http://www.sqlservercentral.com/redirect/articles/2620/In the first part of his series on SQL Server Availability, new author Kumar Parthasarathi brings us a look at Database Snapshots in SQL Server 2005. http://www.sqlservercentral.com/articles/Disaster+Recovery/2598/2006/09/21http://www.sqlservercentral.com/articles/Disaster+Recovery/2598/Learn how to use ALERTs, a SQL Agent job and a stored procedure (SP) to create a copy of your critical database backups on another physical machine as soon as the database backups are created.http://www.sqlservercentral.com/redirect/articles/2587/2006/09/08http://www.sqlservercentral.com/redirect/articles/2587/Ensuring that your disk subsystem performs well and does not run out of space is a balancing act that many DBAs learn over time through trial and "out of space" errors. New author Arindam Banerjee takes a look at some of the things to consider when capacity planning. http://www.sqlservercentral.com/articles/Administering/analyzingdiskcapacityforsqlserver/2467/2006/07/04http://www.sqlservercentral.com/articles/Administering/analyzingdiskcapacityforsqlserver/2467/Not the traditional overview here. Steve Jones takes a look at the various high availability technologies from a different perspective. http://www.sqlservercentral.com/articles/Disaster+Recovery/sqlserver2005highavailability/2421/2006/05/24http://www.sqlservercentral.com/articles/Disaster+Recovery/sqlserver2005highavailability/2421/