Over the years, servers have suffered terribly from malicious attacks that users had to take precautions now and then. Because of that, internet users need to determine how to repair a database in an ...

SQL Server database corruption is troublesome for DBAs, particularly if the situation arrives suddenly and there is no backup. This situation can lead to prolonged downtime and permanent data loss in ...

In the world of SQL Server management, page-level corruption is an issue that can strike fear into the hearts of even the most experienced database administrators. When an 8 KB unit of data storage, ...

Microsoft on Thursday released Service Pack 3 (SP3) for SQL Server 2008. The new service pack arrives about one year after the release of Service Pack 2. SP3 contains a lot of fixes to the earlier ...

New BI and reporting features in SQL Server 2008 R2 hit the mark, but other additions leave SQL Server shops wanting more With Microsoft SQL Server 2008 R2, Microsoft begins to fully realize its ...

This excerpt from the upcoming book, SQL Server 2008 Administration in Action, introduces the role of service-level agreements (SLAs) as part of a DBA's overall strategy to maintaining reliable ...