To that end, it’s announcing the availability of a new SQL Database service hosted on its Azure cloud platform to replace SQL Server 2008 and AQL Server 2008R2.

In this white paper, we investigate the SQL Server database backup options in Azure Virtual Machine. We start by explaining the uses and importance of backing up databases. We continue by discussing ...

Microsoft this week announced various Azure SQL Database improvements, including migration, high-availability and information protection options, plus some open source workload additions. Most ...

Now, just a simple BACKUP DATABASE statement will use compression. To run a backup without compression when it's the server default, simply use the WITH NO COMPRESSION option. SQL Server 2008 finally ...

A notable disadvantage with application-specific options like Always On Availability Groups is the need for administrators to implement other HA or DR solutions for all non-SQL Server applications.

Microsoft’s support for SQL Server 2005 ends in April and just like with Server 2003, you should take the end-of-life announcements from Microsoft seriously.