Delvesys

Are you ready for Microsoft SQL Server 2014 CTP2 ?



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:

x86 Processor: 1.0 GHz

x64 Processor: 1.4 GHz

Recommended: 2.0 GHz or faster

Processor Type

x64 Processor: AMD Opteron,
AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV
with EM64T support

x86 Processor: Pentium
III-compatible processor or faster

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

www.delvesys.com

[email protected] ; [email protected]

Server up gradation, Server / Database Migration expert from
Oracle, MySQL, MS SQL Server (older Version) to MS SQL Server 2014

https://delvesys.blogspot.com/2014/03/are-you-ready-for-sql-server-2014.html MS SQL Server

delvesys.blogspot.com

Find our latest Blogs at:
http://delvesys.blogspot.in/

Delvesys