by Evin C
This week I have chosen another peer-reviewed article discussing new business intelligence (BI) functionality and management features that will be or has been implemented into SQL already. Referring to the “mini-release” as code name Kilimanjaro, this release has the potential to really innovate the way businesses apporach SQL and it’s DBMS capabilities. Some of the features of this update include three exciting new features: self-service analysis, self-service reporting and Master Data Services. SQL Server Analysis Services (SSAS) allows the user from their desktop to “access, manipulate and report against managed and unmanaged data sets, including large data sets.” This allows for more freedom for information workers (IW’s) and also improves the efficiency of the IT departments in any organization. “For IT, Gemini helps keep core data secure, while freeing IT from having to spend a lot of time addressing ad hoc user requests. IT pros have the tools to manage shared Gemini solutions— including data refresh, model security, and resource utilization—and can enhance the model as more and more workers use it.”
The other two features are detailed in the article but go on to explain the new addition of report services and an update to Report Builder. As for the third feature I had listed, Master Data Services, it “provides a centralized approach to defining, deploying, and managing master data as well as a centralized portal for creating, editing, and updating that data.” This feature alone seems to almost revolutionize what users are performing with SQL and makes it even more efficient for business purposes.
Relating this to our class goes directly to the fact that we are working with SQL Server R2. This article details some of the new features that this update has to offer. I realized the article was written by Rushabh Mehta in 2009 so this update quite possibly could have been realeased already. Moving forward with our course, I hope to get the opportunity to see these features in action and really delve into the software of SQL.
Mehta, R. (2009). BI in SQL server 2008 R2: Empowering business users. Database Trends and Applications, 23(3), 24-25. Retrieved from http://search.proquest.com/docview/199277000?accountid=10357