Features Supported by the Editions of SQL Server 2012

http://msdn.microsoft.com/en-us/library/cc645993.aspx

2012-05-26_11162

11 Management Tools

111 SQL Management Objects (SMO)
is a collection of .NET objects that are designed for programming all aspects of managing Microsoft SQL Server. SQL Server Replication Management Objects (RMO) is a collection of objects that encapsulates SQL Server replication management.
EE BI STD MSDN Other
112 SQL Configuration Manager EE BI STD MSDN Other Visual
113 SQL CMD (Command Prompt tool) EE BI STD MSDN Other Visual
114 SQL Server Management Studio EE BI STD MSDN Other Visual
115 Distributed Replay – Admin Tool EE BI STD MSDN Other Visual
115 Distributed Replay – Client EE BI STD MSDN Other Visual
115 Distributed Replay – Controller EE BI STD MSDN Other Visual
116 SQL Profiler EE BI STD MSDN Other Visual
117 SQL Server Agent EE BI STD MSDN Other Visual
118 Microsoft System Center Operations Manager Management Pack EE BI STD MSDN Other Visual
119 Database Tuning Advisor (DTA) EE BI STD MSDN Other Visual

12 Development Tools

121 Microsoft Visual Studio Integration EE BI STD MSDN Other Visual
122 SQL Server Developer Studio EE BI STD MSDN Other Visual
123 Intellisense (Transact-SQL and MDX) 1 EE BI STD MSDN Other Visual
124 SQL Server Data Tools (SSDT) EE BI STD MSDN Other
125 SQL query edit and design tools1 EE BI STD MSDN Other Visual
126 Version control support1 EE BI STD MSDN Other Visual
127 MDX edit, debug, and design tools1 EE BI STD MSDN Other Visual

13 Security

14

15 Integration Services

16 Analysis Services

161 BI Semantic Model (Multidimensional) EE BI STD MSDN Other Visual
162 BI Semantic Model (Tabular) EE BI MSDN Other Visual
163 PowerPivot for SharePoint/td> EE BI MSDN Other Visual
164 Data Mining EE BI STD MSDN Other Visual

17 Reporting Services

171 Report Server
the core engine that drives Reporting Services (The Report Server database stores report definitions)
EE BI STD MSDN Other
172 Report Designer
a developer tool for building complex reports
EE BI STD MSDN Other
173 Report Manager
a Web-based administrative interface for Reporting Services
EE BI STD MSDN Other Visual
174 Role based security EE BI STD MSDN Other Visual
Word Export and Rich Text Support
Enhanced gauges and charting
Export to Excel, PDF, and Images
Custom authentication
Report as data feeds
Model support
Create custom roles for role-based security
Model Item security
Infinite click through
Shared component library
175 Email and file share subscriptions and scheduling EE BI STD MSDN Other Visual
176 Report history, execution snapshots and caching EE BI STD MSDN Other Visual
177 SharePoint Integration EE BI STD MSDN Other Visual
Remote and non-SQL data source support1 EE BI STD MSDN Other Visual
Data source, delivery and rendering, RDCE extensibility EE BI STD MSDN Other Visual
Data driven report subscription EE BI STD MSDN Other Visual
Scale out deployment (Web farms) EE BI STD MSDN Other Visual
178 Alerting2 EE BI STD MSDN Other Visual
179 Power View2 EE BI STD MSDN Other

18 Business Intelligence Clients

181 Report Builder
a simplified end-user tool for building reports.
EE BI STD MSDN Other
182 Data Mining Addins for Excel and Visio 2010 EE BI STD MSDN Other Visual
183 PowerPivot for Excel 2010 EE BI MSDN Other
184 Master Data Services Add-in for Excel EE BI MSDN Other
1. PowerPivot for Excel is an Excel addin and does not depend on SQL Server. However PowerPivot for SharePoint is required for sharing and collaborating with PowerPivot workbooks in SharePoint and this capability is available as part of SQL Server Enterprise and Business Intelligence editions.
2. The above table identifies the SQL Server editions that are required to enable these client tools; however these features can access data hosted on any edition of SQL Server.

19 Other Components

191 Data Quality Services EE BI MSDN Other  
StreamInsight EE BI STD MSDN Other
StreamInsight HA EE BI STD MSDN Other Visual
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s