Introduction
This article will introduce the top features and benefits of SQL Server 2008 R2 which seem to be interesting for both DBAs and Developers.
Microsoft SQL Server 2008 R2 is not a major revision that is why it is called R2 which is sort of intermediate release.
Following are some of new features available in Microsoft SQL Sever 2008 R2:
1. Powerpivot
This feature is a good news for people who want to load large amount of data in Excel and use it back of their Share point server. However to be able to use this new feature, we need Excel 2010 and if you wan to use in for Sharepoint, you will need Sharepoint 2010.
Every one who works with loading large number of records into Excel know loading data into Excel is time consuming and even with a good memory it takes a long time.
Due to using column compression, loading millions of record into Excel 2010 just takes a less of proceessing thousands of record before this feature.
2. StreamInsight
3. Master Data Services Master Data Services is a new feature which can assist businesses to create a safe guard for data validation and applying business rules before distributing them to the several systems.
Data items such as customer details and product names should be centrally managed so that all consuming applications have the same information. It provides us a database and interface which can be used to manage the central data.
4.Multi Server Monitoring
5. Data-Tier Application (DACPAC)
This article will introduce the top features and benefits of SQL Server 2008 R2 which seem to be interesting for both DBAs and Developers.
Microsoft SQL Server 2008 R2 is not a major revision that is why it is called R2 which is sort of intermediate release.
Following are some of new features available in Microsoft SQL Sever 2008 R2:
1. Powerpivot
This feature is a good news for people who want to load large amount of data in Excel and use it back of their Share point server. However to be able to use this new feature, we need Excel 2010 and if you wan to use in for Sharepoint, you will need Sharepoint 2010.
Every one who works with loading large number of records into Excel know loading data into Excel is time consuming and even with a good memory it takes a long time.
Due to using column compression, loading millions of record into Excel 2010 just takes a less of proceessing thousands of record before this feature.
The other good thing about Power pivot is that, it comes with analytical capabilities which is quite useful.
This feature lets us to handle the processing of the events in flight. For example using this component , monitoring the production server can be implemented easily. Let say we are going to monitor the CPU metrics for a server and we don't want to record every single metric, we just are interested to persist the aggregated values of the metrics to the database.
That's where StreamInsight comes handy. The engine has been implemented as a set of .Net classes. To be able to call and use these classes, the code must be written in .Net. This would be a real time system and we don't have to wait for table writing commits.
Data items such as customer details and product names should be centrally managed so that all consuming applications have the same information. It provides us a database and interface which can be used to manage the central data.
4.Multi Server Monitoring
This feature is so useful for DBAs. We can see volume storage utilisation at the drive level, file group and file (data and log) level.
5. Data-Tier Application (DACPAC)
DACPAC is an object that stores all the needed database information for a project, such as login, tables, and procedures into one package in a visual studio file. It is specially useful when the newly developed database objects want to be deployed. Instead of sending the objects (e.g: Store procedures, table definition, etc) in individual SQL files, they can be packaged in a file and sent to the DBA to deploy. It limits the human interactions and consequently mistakes.
