SQL Server 2008 Installation Strategies and Best Practices Part 2 of 5 Greetings, last week I initiated this blog series which focuses on best practices and installation strategies when deploying ...

Despite its importance, many IT admins don’t have a solid SQL Server backup and restore plan in place. This guide from Virtualization Review is the first step in developing that plan.

You can create a Full Backup to restore database in SQL Server using the SQL Server Management Studio (SSMS). For this, open SSMS, right-click the database, and select Tasks > Back Up.

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

How to Restore a SQL Database From a .MDF File. Computer database software such as Microsoft's SQL Server benefits all types of businesses, as it makes recordkeeping fast, flexible and secure.

One configures SQL Server for high availability (HA) in anticipation of some event that will cause a critical application to go offline unexpectedly-a software glitch that causes an app to freeze or a ...

Microsoft is having a re-think about its SQL Server strategy and in particular about what it wants to do with SQL Data Services.Part of the company’s Azure services platform, SQL Data Services ...

Joey on SQL Server How To Be a Better DBA: 4 Strategies To Improve SQL Server Performance There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version.

SQL Server 2005 provides an integrated data management and analysis platform that helps organisations manage mission-critical information and confidently run complex business applications.