Introduction
Microsoft has announced SQL Server 2014 as a part of a wave of updates to our key enterprise products. Microsoft SQL Server 2014 builds on the mission-critical capabilities delivered within the previous release by providing breakthrough performance, availability and flexibility for your mission crucial applications. SQL Server 2014 provides new in-memory capabilities built into the core database for OLTP and data warehousing that support our existing in-memory data and figures warehousing and BI capabilities for the most comprehensive in-memory database solution in the market.
You can download SQL Server 2014 from Click Here For Download SQL Server 2014.
Hardware and Software requirements for installing SQL Server 2014
http://msdn.microsoft.com/en-us/library/ms143506(v=sql.120).aspx
The Power of SQL Server 2014 and the Data Platform
MISSION CRITICAL PERFORMANCE
In-Memory Built in
- In Memory OLTP
Average 10 x and up to 50xx performance gains.
- Enhanced In-memory ColumnStore for DW
Updatable, faster, better compression.
- In memory BI with PowerPivot
Fast insights.
- Buffer Pool Extension to SSds
Faster paging.
- Enhanced Query processing
Faster performance without the app changes.
Enhanced Security and Scalability
- Redefined engineering security processes
Least vulnerable DB
- CC certification at High Assurance Level
Improved Compliance.
- Enhance separation of duty
Improved Compliance and security.
- Transparent Data Encryption
Better data protection.
- Encryption Key Management
Store key on a separate server.
- Support for Windows Server Code
Reduce surface area for attack.
- Resource Governor adds IO governance
Predictable performance.
- SysPrep at cluster level
Faster deployment.
- Windows Server 2012 R2
Predictable performance with tiering of computer network and storege.
High Availability
- SQL Server 2014
Enhanced Always on, 8 secondary's Replica Wizard
greater HA, easier to mange and deploy
- Windows Server 2012 R2
Clustered Shared volume support
Enterprise HA with tiered storege.
- VHDX support
Resize VM without downtime
FASTER INSIGHTS FROM ANY DATA
Easy Access to Data, Big and Small
- Project Code name "Data Explorer"
Easy aceess to internal and external data.
- Windows Azure Market Place
Enhance with 3rd party data.
- Windows Azure HDInsight Services and Microsoft HdInsight Server
Access big data with the simplicity of windows..
- Parallel Data Warehouse with Ploybase
Query big data with T-SQL.
Powerful Insight with Familiar Tools
- Excel in Office
Faster insights.
- Project Codename
Richer insights with 3D visulation.
- Data Mining Add-ins for Excel
Predictive analytics.
Complete BI solution
- Stream Insight Data Quality Services
Access streaming data in near real time.
- Data Quality Services
Cleanse data.
- Master Data Services
One source for the truth.
- BI Semantic Model
Simplify BI model deployment.
PLATFORM FOR HYBRID CLOUD
Hybrid Cloud Solutions
- Simple Cloud Back-UP
Reduce CAPEX and OPEX.
- Cloud Disaster recovery
Reduce CAPEX and OPEX and improve business countinuity.
- Extended On-Premises app to the Cloud
Gain cloud scale on demand.
Easy on Ramp to Cloud
- New Cloud Migration Wizard
Easily move on-premises SQL Server to Windows Azure.
- SQL Server in a Window3 Azure Virtual Machine
Reduce CAPEX and OPEX with full SQL Server functionality.
- Windows Azure SQL Database Services
Develop new variable demand cloud apps quickly with HA built-in.
Starting Process Image of SQL Server 2014
![sql-server-2014.jpg]()
The Evolution Of SQL Server
![evalution-of-sql-server-2014.jpg]()
Image Ref- http://blogs.technet.com/