This article discusses in detail the three database recovery models and how to choose the appropriate recovery model

Happy Halloween 2008!

by Steve Jones

SQLServerCentral.com

Editorial - WMV

Steve Jones is taking a break on this fine holiday, enjoy a few bloopers before you head out with the kids for trick-or-treating.

Happy Halloween 2008!

by Steve Jones

SQLServerCentral.com

Editorial - iPod

Steve Jones is taking a break on this fine holiday, enjoy a few bloopers before you head out with the kids for trick-or-treating.

A Few Good DBAs

by Shaun Tull

SQLServerCentral.com

Editorial

A parody from the movie A Few Good Men just for DBAs.

Predictable Index Fragmentation

by Craig Outcalt

SQLServerCentral.com

Indexing

This technical article provides an overview of how to produce specific levels of index fragmentation. Useful for creating test plans.

Database Mirroring adjusting the automatic failover time

by Additional Articles

MSSQLTips.com

Database Mirroring

One of the configuration options for Database Mirroring is the High Availability mode. With this option three servers are put in place the principal, mirror and witness servers. This is the only option that allows for automatic failover. One of the things that I have noticed is that when there are periodic network issues a failover occurs even though there are no issues with the Principal server. Are there any options to delay the failover?

Encryption Alternatives

by Additional Articles

SimpleTalk

Security

Databases often contain sensitive information and cell-level encryption is a very effective method to protect this information from those who should not have access to it. Although, encryption is not without its challenges.