TechNet Express

We must return what we got… so Let`s Talk

Pages

  • Blogs List
  • Best Practices
  • My Site
  • My Projects
  • About

Tuesday, May 1, 2012

MS SQL Server 2012 RTM Released (What is New)

Key features of this release are 
Sequence Object,Column Store, Column Store Index, File Tables , Property search ,BISM, DSQ, SSDT, Proximity Search, Semantic Search, Active Secondaries,Connection Director and DB Recovery Advisory .

This page consolidate the Bullets point for new features added to SQL Server 2012


1 Programming Enhancement
  1. 1.1 Sequences
  2. 1.2 Column Store (“Apollo”)
  3. 1.3 Columnstore index
  4. 1.4 FileTables
  5. 1.5 Circular arc segment support for spatial types
  6. 1.6 Table Partitioning up to 15,000
  7. 1.7 Extended Events enhancements
  8. 1.8 Property-scoped full-text search (Extended Properties Index)
  9. 1.9 Statistical semantic search
  10. 1.10 Customizable proximity search
2 High Availability
  1. 2.1 SQL Server AlwaysOn
    1. 2.1.1 Failover Availability Group
    2. 2.1.2 Failover Cluster Instances
    3. 2.1.3 Active Secondries
    4. 2.1.4 Connection Director
    5. 2.1.5 AutoStat
  2. 2.2 Windows Server Core Support
  3. 2.3 Database Recovery Advisor:
  4. 2.4 StreamInsight Enhancement
3 BI Enhancement
  1. 3.1 BI Semantic Model (BISM).
  2. 3.2 Ad-hoc Reporting (Crescent)
  3. 3.3 Data Quality Service (DQS)
  4. 3.4 SharePoint 2010 share service
  5. 3.5 SQL Server Data Tools (SSDT)
Posted by ashwini47 at 7:53 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: MSSQL, MSSQL2012, What is New

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Search This Blog

Hit Counter

It`s Me

It`s Me

Subscribe To My Feed

Posts
Atom
Posts
Comments
Atom
Comments

Popular Posts

  • Top 20 Programming tips for Performance Improvement (Java/C#)
  • How to bypass server certificate error (underlying connection was closed)
  • How to : Redirect root '@' domain to www (namecheap.com)
  • How to Parameterized Query Interceptor in WCF Data Service
  • WCF Error : HTTP could not register URL..... Your process does not have access rights to this namespace
  • Be a lazy programmer , do not jump to write code.
  • Functional and Load Testing Tools for WCF Data (OData) Services
  • [AZURE 70-534 Cheat Sheet and Exam Notes Part-4]Design advanced applications
  • [AZURE 70-534 - Cheat Sheet and Exam Notes Part-7] Architect an Azure Compute infrastructure
  • WCF Service Error :The communication object, System.ServiceModel.ServiceHost, cannot be used for communication because it is in the Faulted state

Labels

Architecture General (3) ASP.Net WebAPI (2) Azure Certification (70-534) (7) Base64 (1) Best Practices (3) C# (10) Certificates (3) Cloud Computing (2) CodeSamples (8) Devart (6) DNS (1) Domain (1) DotNet (7) EF (1) FAQ (4) How To (5) HTML5 (3) HttpWebRequest (2) IT News (3) LightSwitch (1) MSSQL (2) MSSQL2012 (1) MVC5 (1) Node.JS (1) ORM (1) Performance (1) Pex (1) Power Tools (1) Reporting Services (1) Troubleshooting (4) Unit Testing (1) VS2010 (1) VS2011 (2) VS2012 (1) WCF (5) WCF Data Service (22) What is New (13) Windows8 (2)

Contact Me

Dear Readers
If you need more information about a particular post please feel free to contact me either by leaving comment on the page or emailing me at ashwini47@gmail.com.

Ashwini

Followers

Picture Window theme. Powered by Blogger.