Managing SQL Server’s Management Features (…get it?){1}


by Evin C
This week’s article has come from eWeek and details improved management capabilities that come from SQL Server 2008 R2. With Microsoft’s continued support into this software and an endless amount of possibilities for the program, I hope to see many more updates in the future. The new management capabilities the software has expanded upon included further improvement to the report system, the SQL Server Utility “which enables administrators to manage and monitor multiple database applications and server instances from a central interface called a Utility Control Point (UCP)”, and a new tool titled PowerPivot. This article details each new feature and goes into it’s application to Business Intelligence (BI).

Having only scratched the surface of SQL, I feel these features may even help us in the future with our course material. With Project 3’s deadline rapidly approaching, I feel we can use as much help as possible. Hopefully this articles, and others, can help us reach a better understanding of SQL Server 2008 R2 and it’s capabilities. I definitely recommend reading this article in it’s entirety as it may be worthwhile to some, and it will also give a better perspective on how to apply this software to other ventures outside of the classroom.

 

Reference:

Brooks, J. (2010). Sql server 2008 r2 offers new management capabilities. EWeek. Retrieved February 27, 2012, from http://0-web.ebscohost.com.opac.library.csupomona.edu/ehost/pdfviewer/pdfviewer?sid=0605de9b-4a4a-4884-92a5-f981495db2f2%40sessionmgr111&vid=2&hid=108