![]() ![]() SQL Server 2008 R2 (formerly code named as SQL Server “Kilimanjaro”) contains certain added features to SQL Server 2008, Analysis Services – Data Mining Integration Services.Analysis Services – Multidimensional Data.Basically SQL server 2008 has the following features: SQL Server 2008 can be a data storage backend for different varieties of data: XML, email, time/calendar, file, document, spatial, etc as well as perform search, query, analysis, sharing, and synchronization across all data types. This version supports the use of structured and semi structured data, including digital media formats (pictures, video, audio, etc…). SQL Server 2008 aims to make the data management self organizing, self maintaining and self-tuning. ![]() By using analysis services, dimensions and mining structures in business intelligence development studio user can develop business intelligence solutions User can develop and manage SQL server database engine and notification solutions in Management studio. SQL server has two “studios” to do development tasks and management tasks. Both versions provide projects (SQL server scripts, Analysis server scripts) that are organized into solutions. User experienced in Containers and Visual elements established in SQL 2005, can work in SQL Server 2008 and SQL Server 2008 R2 also. SQL Server has two integrated environment for server administration and business objects creation. SQL Server 2008 and SQL Server 2008 R2 are used to implement data management and business intelligent projects.
0 Comments
Leave a Reply. |