Microsoft 2008 SQL Server R2 Features{3}

by Antonio M
This author talks about the introduction of Microsoft SQL Server 2008 R2.
He says that SQL Server 2008 relies heavily on integration with Office
2010 and SharePoint Server 2010. One of the new features that comes with
SQL Server 2008 is a PowerPivot Tool. This will allow employees to
get large amount of data on spreadsheets in excel and put into
information that can be shown graphically through the use of graphs or
charts. The author also mentions how combining PowerPivot with SharePoint
workers will be able to share there analysis tools that they have prepared
with other workers through out there organization. Whats also cool is
workers in an organization can share there PowerPivot workbooks with
co-workers whose machines dont have Microsoft Office installed at all.
Another great feature that comes with SQL Server 2008 is the ReportBuilder 3.0
Application. This application is very similar to Excel 2010 and this application
will allow a user to display data in the form of a Report and show data through
the use of graphs and charts. One last nice feature that comes with SQL Server
2008 is the ability to Manage and monitor the user of multiple database
applications. This new ability can show usage charts in days,weeks,
months and even years.

I think this article was very helpful in the sense that we as students also need to know
what other things Microsoft SQL Server 2008 R2 can do aside from inserting data
through the use of SQL programming. To be honest I really dont know what else SQL Server
can do aside from the basics of putting data in a database. But I do think that it is
important that we learn all the functions that Microsoft SQL Server 2008 R2 can perform.

One of the features that I liked about Microsoft SQL Server 2008 R2 is the managing capability.
I thought that featured seemed like it could be really helpful for Database Administrators because
it can help them keep track on the performance of the database and also help them monitor
the database for any errors that may occur in the future.


Brooks, J. (2010). SQL Server 2008 R2 offers new management capabilities.
Eweek, 27(12), 18-20.