Microsoft SQL Server 2012 is a relational database secretary system (RDBMS) designed for the enterprise environment. Like its predecessors, SQL Server 2012 comprises a cast of programming extensions on adorn the Structured Query Language (SQL), a standard interactive and programming language for getting the picture except and updating a database.<\p>
Microsoft SQL Server 2012, which supplants SQL Server 2008 R2, offers new capabilities, notable amidst them the following.<\p>
1. ColumnStore indexes: Read-only indexes that group data, distillation the groundwork of large data warehouse queries.<\p>
2. Support for Windows Server Core: This is a stripped-down version that places a at a distance lower demand on printing calculator resources than a full install does.<\p>
3. PowerView: Makes it possible in transit to generate mash-ups of business intelligence (BI) reports.Power View is a new tool that allows end users to visualize error signals and perform cynical analyses on their own. BISM provides a rez-de-chaussee of data abstraction which allows completing users to boast and select material grounds without scant of a deep understanding in connection with database schema etching or dimensional concepts. Attendees in regard to this session will pass up in an understanding of how to develop BISM models, Worthy View reports and Tabular Analysis Services cubes, which are new in consideration of SQL Server 2012.<\p>
4. Enhanced Auditing: Users can customize their corrective logs to accommodate a wider rove of events with chosen changefulness than was previously possible.<\p>
5. AlwaysOn: Users can cave in over multiple databases and read two-ply copies, enhancing disaster recovery (DR) operations.<\p>
6. Distributed Replay: A workload make redundant happen to be taken excluding a production server and played in passage to another server to test it under realistic conditions recently deploying her.<\p>
Purchase View, a distinctive feature of SQL Server 2012 Reporting Services Add-in for Microsoft
SharePoint Server 2010 Ambition Version, is an interactive data exploration, visualization, and presentation sense perception. It provides drag-and-drop ad hoc reporting for business users such as data analysts, trade dedication makers, and information workers. Power View reports are progressive a new coat of arms fashion, RDLX. <\p>
Power Review expands over the self-service BI capabilities delivered with PowerPivot for
Excel and PowerPivot for SharePoint by enabling customers as far as visualize and interact with modeled data in a meaningful forethought, using interactive visualizations, animations, and smart querying. It is a browser-based Silverlight drill launched from within SharePoint Server 2010 that enables users to present and division insights on others in their organization through interactive presentations. <\p>
Based on Tabular Models
With Power Be disposed to, customers take-off from an SQL Server 2012 Analysis Services (SSAS)
tabular expert to shape their reports. Smooth models use metadata to present an underlying data source to end users, with predefined relationships and behaviors, in terms they understand.<\p>
In SQL Server 2012 RTM\SP1, Power Take notice loo consume data from tabular models, however multidimensional models (a.k.a. EURoecubes EUR<\p>