Dacpacs to streamline application deployment for developers.
Administrators can quickly backup and recover Microsoft SQL Server databases without taking the database servers offline.Previously code-named Project Madison, this yet-to-be-released edition of R2 focuses on scaling data warehouses over multiple physical servers.Backup Microsoft SQL Server databases to a single master backup server without impacting users and applications.The company has cut that turnaround time down yet again with R2, which arrives less than two years after SQL Server 2008 was first released to manufacturing.The first step is to understand the routine specifications of R2 before focusing on the requirements specific to the active OS, such as hardware and memory.Uses Microsofts Volume Shadow Copy Service (VSS) writer to ensure reliability during hot backups.That's not to say R2 doesn't come with its fair share of new features, though.The first, SQL Server 2008 R2 Datacenter edition, was created in the same vein as the Windows Server edition of the same name to provide high-level scalability for database environments.
Besides some minor improvements and bug fixes have been made.
The timing makes sense, too, as organizations continue to put a greater emphasis on BI, and IT professionals see it as an increasingly ultraedit 8051 word file promising career path.
Data visualization improvements for SQL Server Reporting Services (ssrs) have also received a good amount of attention.
PowerPivot aims to bring self-service BI to the masses.
With, sQL Server 2008 R2, Microsoft has certainly put its foot on the gas pedal when it comes to updating its database server platform.