Let me give a different order:
SQL Server 2008 R2 sp1
Yes, it is finally available. Check out the links below.
You can download the files based on the processor you have. In addition to bug fixes some interesting enhancements too are added to this service pack.
- sys.dm_exec_query_stats DMV is extended with additional columns to improve supportabilities over troubleshooting long-running queries. New DMVs and XEvents on select performance counters are introduced to monitor OS configurations and resource conditions related to the SQL Server instance.
- Syntax for FORCESEEK index hint has been modified to take optional parameters allowing it to control the access method on the index even further. Using old style syntax for FORCESEEK remains unmodified and works as before. In addition to that, a new query hint, FORCESCAN has been added. It complements the FORCESEEK hint allowing specifying ‘scan’ as the access method to the index. No changes to applications are necessary if you do not plan to use this new functionality.
- The new Data-tier Application (DAC) Framework v1.1 and DAC upgrade wizard enable the new in-place upgrade service for database schema management. The new in-place upgrade service will upgrade the schema for an existing database in SQL Azure and the versions of SQL Server supported by DAC. A DAC is an entity that contains all of the database objects and instance objects used by an application. A DAC provides a single unit for authoring, deploying, and managing the data-tier objects. For more information, see Designing and Implementing Data-tier Applications.
- This update introduces two new configuration settings that let you determine how long cached data stays in the system. In the new Disk Cache section on the PowerPivot configuration page, you can specify how long an inactive database remains in memory before it is unloaded. You can also limit how long a cached file is kept on disk before it is deleted.
As you may aware, SQL Server 2008 R2 is not supported on Windows XP.
On feature packs, some of the cools stuffs are added. The list below is my favourites
- Report Builder 3.0 enhancements:
Additional visualizations including maps, spark lines and data bars are introduced. It also comes with report part gallery. It means you can develop report parts and add them to the reports you want.
- Microsoft® System CLR Types for SQL Server® 2008 R2
This allows the CLR based data types of SQL Server, geography, geometry and hierarchyid to be installed outside the server. By doing so, a client application can use the same data types.
- Microsoft® SQL Server® 2008 R2 Remote Blob Store
I first heard about it as part of Denali. However, I am surprised to see it as part of feature pack. This component allows the data to be stored in an external data store. Microsoft is providing a client side DLL and SQL Server stored procedures
- Microsoft® Windows PowerShell Extensions for SQL Server® 2008 R2
How can I hide my joy to see something connected to PowerShell. In fact one of my favourite tools is PowerShell. It allows server administration, irrespective of whether it is Windows, SQL Server or Exchange, through a set of cmdlets. It eases the tasks of administrators. I hear that a couple of new cmdlets and a new provider have beed added. Need to have a look.
Denali CTP 3
Despite some earlier announcements, CTP3 was made available to public on 12th. Denali is the next version of SQL Server. Earlier references said it would be released in the second half of 2011, yes we are already there. However, Now the messages are suggesting that it will be named as SQL Server 2012 indicating the release date to end of this year, or somewhere in next year.
Let me warn you that you way start downloading files of 2.4 GB of size. Do you have the facility to do so? then go for.
Want to download? Try this link:
I’ll write about the features of Denali on a different post.
It gives a different user interface, to database developers. It allows Visual Studio to be used to create all database objects from table to stored procedures. People who are familiar with “Data Dude” or “Visual Studio for Database Professionals” can consider Juneau as the next generation of that.
There is little more on it: You can do all design in your local machine, and deploy to SQL Server or SQL Azure. you don’t need different tools to find the changes happened, it is included in Juneau. Additionally, it all in one source control..
Try this link:
There are many more internal projects, Apollo, Velocity, Crescent and many more are on the pipeline. The information we receive are exciting. Lets wait to see them too.