SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Strategies, SQL Server 2005 Rss

   Items 1 to 9 of 9   

Application Locks (or Mutexes) in SQL Server 2005

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.  Read more...
By Additional Articles 2008/01/15 | Source: SQLTeam.com | Category: strategies
Rating:  Rate this |   Briefcase | 3,860 reads

Partitioning - Part 2

Continuing on with a look at SQL Server 205 partitioning features, Andy Warren delves into archiving techniques.   Read more...
By Andy Warren 2007/10/08 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,986 reads

An Auditing Solution with XML And XSL

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.   Read more...
By David McKinney 2007/08/20 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 5,056 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 | 4,453 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,420 reads

Database Snapshots

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.   Read more...
By Kumar Part 2006/09/21 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 10,446 reads

Copying Database Backups to an Alternative Location

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.  Read more...
By Additional Articles 2006/09/08 | Source: Database Journal | Category: administration
Rating:  Rate this |   Briefcase | 4,813 reads

Analyzing Disk Capacity for SQL Server

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.   Read more...
By Arindam Banerjee 2006/07/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,491 reads

SQL Server 2005 High Availability

Not the traditional overview here. Steve Jones takes a look at the various high availability technologies from a different perspective.   Read more...
By Steve Jones 2006/05/24 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 16,428 reads
   Items 1 to 9 of 9   
administration (3)    
disaster recovery (dr) (3)    
miscellaneous (3)    
security (3)    
sql server 7 (3)    
development (2)    
high availability (ha) (1)    
t-sql (1)    
xml (1)    
xsl (1)