Microsoft 2008 SQL Server R2 Features

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.

References:

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

3 thoughts on “Microsoft 2008 SQL Server R2 Features”

  1. This article is pretty cool. I think it's good to know that Microsoft SQL Server 2008 has so many features available for the users to use. Since we are just starting out and learning how to use SQL Server, it's nice to know that there is so much more we can do with this program. Thanks for sharing!

  2. Good article. I think it is interesting that they are moving towards integration with office products. It is good to know that are many different aspects to SQL Server and may different uses for it. It seems like we have barely scratched the surface of the program so far in this class.

  3. Having only scratched the surface of SQL in our course, it's interesting to see how else we can apply this software. These extra features give SQL a unique business application that can improve certain aspects of any business using DBMS. Good find! I enjoyed finding out what SQL can really do.

Comments are closed.