Microsoft is excited to announce the
release of SQL Server 2014 CTP2. The SQL Server 2014 CTP2 will ship with
following new / improved features:
Mission
Critical
|
•
Data availability
•
High Availability - SQL Server AlwaysOn
•
Online Database Operations.
•
Predictable, efficient, and flexible data backups
•
Better together with Windows Server
•
Performance and scale
•
In-memory online transaction processing (OLTP)
•
Buffer pool extension
•
Query-processing enhancements
•
Private Cloud
•
Tier-1 partitioning: Scale to 15,000 partitions
•
Scalable real-world application testing: Distributed Replay
•
Reduced database size and increased performance: Data and
backup compression
•
Proactive troubleshooting and diagnostics: Performance Data
Collector and Management Studio
•
Organizational security and compliance
•
Secure by default: Lowering vulnerability
•
Built-in tools for enabling compliance: SQL Server audit
enhancements
•
Restricted access to data at the row level: Label security
•
Controlled access to data in motion: Advanced security
•
Controlled access to data for administrators: User-Defined
Server Roles
•
Backup Encryption
•
Controlled access to data across business intelligence tools:
Microsoft SharePoint and Microsoft Active Directory
•
Virtually any data, built-in
•
Embracing unstructured data through support for complex data
types
•
High availability for unstructured data
•
Seamless connection and analysis of Big Data through Hadoop
connectors
•
Seamless connection to a variety of platforms through greater interoperability
|
Faster Insights from Any Data
|
•
Rapid data
exploration in Excel
•
Appealing interactive visualization with Power View in Excel
•
Power View support for both tabular and multidimensional
models
•
Power Query for Excel
•
Power Map for Excel
•
Self-service analysis with PowerPivot: Now in Excel
•
Managed
self-service BI
•
Governance and
compliance, insight, and oversight for IT
•
Self-service
content creation balanced with IT management
•
Ease of
administration through SharePoint
•
Credible,
consistent data
•
BI Semantic
Model
•
Enterprise
information management (EIM)
•
Data Quality
Services
•
SQL Server
Integration Services with Data Integration
•
Big Data
analytics and data warehousing
•
Massive data
warehousing
•
Next-generation
performance with in-memory technology
•
Microsoft Big
Data solution
|
Platform
for Hybrid Cloud
|
•
Hybrid cloud:
Your database virtually anywhere
|
Evolution of All Versions of SQL Servers:
COST ANALYSIS:
Comparison
of mission-critical solutions from Microsoft and Oracle
Features
|
Microsoft SQL Server
|
Oracle Database
(all options not
shown)
|
Enterprise Edition base license (includes 1-year support)
|
$27,496
|
$95,000
|
Data availability
|
Included
|
$10,000 (Active Data Guard)
$20,000 Total
|
Performance and scale
|
Included
|
$11,500 (Advanced Compression)
$23,000 (In-Memory Cache)
$11,500 (Partitioning)
$11,500 (Real Application Testing)
$5,000 (Diagnostics Pack)
$5,000 (Tuning Pack)
$135,000 Total
|
Enterprise security
|
Included
Free
Download
|
$11,500 (Advanced Security)
$11,500 (Label Security)
$46,000 Total
|
Any data, built-in
|
Included
|
$17,500 (Spatial & Graph)
$35,000 Total
|
Total cost
|
$27,496
|
$331,000
|
Note The
prices are based on estimated retail price. All Microsoft and Oracle prices are
per-processor (based on a quad core Intel Xeon processor) database pricing for
purchases within the United States and are in United States dollars. Pricing is
based on information available on vendor websites. Oracle prices are based on
the Oracle Technology Global Price List, March 15, 2013. IBM prices may vary.
Hard Disk Requirements for SQL Server 2014:
Feature
|
Disk
space requirement
|
Database Engine and data files, Replication, Full-Text
Search, and Data Quality Services
|
811 MB
|
Analysis Services and data files
|
345 MB
|
Reporting Services and Report Manager
|
304 MB
|
Integration Services
|
591 MB
|
Master Data Services
|
243 MB
|
Client Components (other than SQL Server Books Online
components and Integration Services tools)
|
1823 MB
|
SQL Server Books Online Components to view and manage help
content1
|
375 KB
|
Memory and Processor Requirements for All Editions of SQL Server 2014:
Component
|
Requirement
|
Memory
|
Minimum:
Express Editions: 512 MB
All other editions: 1 GB
Recommended:
Express Editions: 1 GB
All other editions: At least 4 GB and should be increased
as database size increases to ensure optimal performance.
|
Processor Speed
|
Minimum:
Recommended: 2.0 GHz or faster
|
Processor Type
|
|
Other Factors to be considered:
·
Traffic Between Server
(for Mirroring, Log Shipping, Backup, Remote Login, Failover Clusters)
·
Local and remote
connections between database servers
·
Firewalls
·
Antivirus applications
·
Number of SQL Server
instances
·
Instance names
·
Installed SQL services
·
Network protocols
There are numerous
other factors to be considers depends upon server to server which needs
expertise to understand and resolve. Planning and scheduling the migration or
installation MS SQL Server is utmost important once MS SQL Server version has
been selected based existing hardware, software, disk space and network.
DelveSys
|
Data, Application & IT Services
|
Server up gradation, Server / Database Migration expert from
Oracle, MySQL, MS SQL Server (older Version) to MS SQL Server 2014
|
No comments:
Post a Comment