Using compression with SSMS is just as easy. Simply set the compression option on the Options page of the Back up Database dialog. You may be asking yourself: How effective is this compression? The ...

Microsoft added the option of using the Azure Backup service to provide recovery support for SQL Server 2008 and SQL Server 2008 R2 when those workloads are hosted on Azure virtual machines. The Azure ...

Now in SQL Server 2008, Transparent Data Encryption allows a DBA to encrypt an entire database without the need for any application code changes. In fact, all we need to do is set a database option ...

SQL Server 2008 provides a scalable database system for many different types of workloads, from mobile devices to enterprise solutions. It also integrates with Visual Studio, and so enables developers ...

The four pillars of SQL Server 2008's enhancements are mission-critical platform, dynamic development, beyond relational data and pervasive business insight. The second and third of these pillars are ...

对于服务器来说，备份应该是最有效的保障措施，这也应该成为一项常规工作。在Windows Server 2008 R2中集成了一个非常高效的备份工具–Windows Server Backup，利用该工具管理员可以非常自由地实现对服务器上的数据的备份，而且可以创建备份计划从而实现自动备份。

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 ...

There’s some good news for IT managers deploying Windows Server 2008: Backup and Restore has been reworked in this edition to leverage the Volume Shadow Copy Service (VSS) and block-level transfers ...

Redmond removes previously free Exchange backup functionality from Server 2008, only to sell it as part of a new backup product Update to Post: We would like to thank Rui Silva for providing ...