Delvesys

Overview of Microsoft® SQL Server® 2014 CTP2 Database Engine - It's Faster .... It's Better !!!

The new database
engine is designed for higher reliability, improved performance and handle
larger database. Many new features and enhancements have been put forward that
enhance the power and productivity of architects, developers, and
administrators who design, develop, and maintain data storage systems.

This release of Microsoft
SQL Server is one step forward to tackle the challenges of Big Data i.e. fast
and efficient way to handle huge unstructured data, and Hybrid Cloud. With this
release of the SQL Server, Microsoft tried to establish a bridge between
Microsoft SQL Server and Hadoop which add new dimensions for not only this
release of SQL Server but also for next releases of SQL Server in future.

For this, Microsoft enhanced the Database Engine in
following Areas:

·
Database Engine Feature
Enhancements

§ Memory-optimized Tables: In-Memory OLTP, a memory-optimized database
engine integrated into the SQL Server engine, is optimized for OLTP.

§ SQL Server Data Files in Windows Azure: enables users to create a
database in SQL Server running in on-premises or in a virtual machine in
Windows Azure.

§ Windows Azure Virtual Machine Wizard: to Deploy a SQL Server
Database to host a database from an instance of SQL Server in a Windows Azure
Virtual Machine

§ Backup and Restore Enhancements: SQL Server Management Studio can be
used to backup to or restore from Windows Azure Blob storage service. SQL Server Managed Backup (Windows
Azure only) to manage and schedule database and log backups. User can now
choose (AES 128, AES 192, AES 256, and Triple DES) to encrypt the backup file
during a backup operation and must use either a certificate or an asymmetric
key to perform encryption during the backup.

§ New Cardinality Estimation Logic (Cardinality Estimator): incorporates assumptions and algorithms that
work well on modern OLTP and data warehousing workloads. This logic improves
the quality of query plans as a result query performance optimized.

§ Delayed Durability: returns control of delayed durable transaction
to the client before the transaction log record is hardened to disk. The
Delayed Durability can be controlled at the database level, COMMIT level, or
ATOMIC block level.

§ AlwaysOn Enhancements: For this,

§ Migration to Windows Azure is made simpler

§ Azure Replica Wizard Added

§ Maximum number of secondary replicas is increased from 4 to 8.

§ Enhancements are made to increase the efficiency and ease of
troubleshooting.

§ Partition Switching and Indexing: The individual partition of
partitioned tables can be rebuilt in SQL Server 2014.

§ Managing the Lock Priority of Online Operations: Enhanced ONLINE =
ON option (which now contains a WAIT_AT_LOW_PRIORITY option) permits to specify
how long the rebuild process should wait for the necessary locks.

§ Columnstore Indexes: improves data compression and query performance
for data warehousing workloads that primarily perform bulk loads and read-only
queries.

§ Buffer Pool Extension: provides the seamless integration of
solid-state drives (SSD) as a nonvolatile random access memory (NvRAM)
extension to the Database Engine buffer pool to improve I/O throughput.

§ Incremental Statistics: CREATE STATISTICS and related statistic
allows or reports related statements to incremental statistics.

§ Resource Governor Enhancements for Physical IO Control: Now physical
IOs issued for user threads for a given resource pool can be governed.

§ Online Index Operation Event Class: has two new data columns:
PartitionId and PartitionNumber

·
Transact-SQL Enhancements:

§ Inline specification of CLUSTERED and NONCLUSTERED indexes is now
allowed for disk-based tables.

§ The SELECT … INTO statement is improved and can now operate in
parallel (compatibility level 110 or higher)

§ Enhanced Transact-SQL for In-Memory OLTP

·
System Table/Views Enhancements:
Enhanced sys.xml_indexes, sys.xml_indexes (Transact-SQL),
sys.dm_exec_query_profiles, sys.dm_exec_query_profiles (Transact-SQL),
sys.column_store_row_groups, and sys.column_store_row_groups

·
Security Enhancements:

§ CONNECT ANY DATABASE Permission: to a login that must connect to all
databases

§ IMPERSONATE ANY LOGIN Permission: to impersonate the account of
clients connecting to it, as it connects to databases

§ SELECT ALL USER SECURABLES Permission: a login such can view data in
all databases that the user can connect to.

·
Deployment Enhancements:
enables deployment of a SQL Server database to a Windows Azure VM.

Concise Summary: The
new Microsoft SQL Server 2014 CTP2 Database Engine is faster, better and future
ready. It is specially designed to perform large, complex structured and unstructured
data at on-premises or in a virtual machine in Windows Azure.



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, Remote Database Services, App Development, Data Processing Services.

https://delvesys.blogspot.com/2014/03/overview-of-microsoft-sql-server-2014.html MS SQL Server

delvesys.blogspot.com

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

Bigdata it's not just for google !!

EXECUTIVE SUMMARY

Big Data holds out the promise of providing businesses with differentiated competitive insights. But those insights, protected by a healthy level of technical complexity, require large-scale data consumption and an innovative approach to the analysis of large public and private data sets.

Currently, production Big Data implementations routinely process petabytes and even exabytes of data on a daily basis. Indeed, many of the technologies and implementation strategies for Big Data originated with web companies struggling with unprecedented volumes of data. At the same time, the economics of cloud computing — predicated on declines in the cost of data storage, bandwidth and computing time — point inevitably to the promise of Big Data rapidly becoming a reality for even comparatively small companies.

For more details please visit www.delvesys.com

Thanks for your valuable time.

Regards

Vikas Kumar

DelveSys

https://delvesys.blogspot.com/2014/02/bigdata-its-not-just-for-google.html Big Data

delvesys.blogspot.com

Overview of Microsoft® SQL Server® 2014 CTP2 Database Engine - It's Faster .... It's Better !!!

The new database engine is designed for higher reliability, improved performance and handle larger database. Many new features and enhancements have been put forward that enhance the power and productivity of architects, developers, and administrators who design, develop, and maintain data storage systems.

This release of Microsoft SQL Server is one step forward to tackle the challenges of Big Data i.e. fast and efficient way to handle huge unstructured data, and Hybrid Cloud. With this release of the SQL Server, Microsoft tried to establish a bridge between Microsoft SQL Server and Hadoop which add new dimensions for not only this release of SQL Server but also for next releases of SQL Server in future.

For this, Microsoft enhanced the Database Engine in following Areas:

· Database Engine Feature Enhancements

§ Memory-optimized Tables: In-Memory OLTP, a memory-optimized database engine integrated into the SQL Server engine, is optimized for OLTP.

§ SQL Server Data Files in Windows Azure: enables users to create a database in SQL Server running in on-premises or in a virtual machine in Windows Azure.

§ Windows Azure Virtual Machine Wizard: to Deploy a SQL Server Database to host a database from an instance of SQL Server in a Windows Azure Virtual Machine

§ Backup and Restore Enhancements: SQL Server Management Studio can be used to backup to or restore from Windows Azure Blob storage service. SQL Server Managed Backup (Windows Azure only) to manage and schedule database and log backups. User can now choose (AES 128, AES 192, AES 256, and Triple DES) to encrypt the backup file during a backup operation and must use either a certificate or an asymmetric key to perform encryption during the backup.

§ New Cardinality Estimation Logic (Cardinality Estimator): incorporates assumptions and algorithms that work well on modern OLTP and data warehousing workloads. This logic improves the quality of query plans as a result query performance optimized.

§ Delayed Durability: returns control of delayed durable transaction to the client before the transaction log record is hardened to disk. The Delayed Durability can be controlled at the database level, COMMIT level, or ATOMIC block level.

§ AlwaysOn Enhancements: For this,

§ Migration to Windows Azure is made simpler

§ Azure Replica Wizard Added

§ Maximum number of secondary replicas is increased from 4 to 8.

§ Enhancements are made to increase the efficiency and ease of troubleshooting.

§ Partition Switching and Indexing: The individual partition of partitioned tables can be rebuilt in SQL Server 2014.

§ Managing the Lock Priority of Online Operations: Enhanced ONLINE = ON option (which now contains a WAIT_AT_LOW_PRIORITY option) permits to specify how long the rebuild process should wait for the necessary locks.

§ Columnstore Indexes: improves data compression and query performance for data warehousing workloads that primarily perform bulk loads and read-only queries.

§ Buffer Pool Extension: provides the seamless integration of solid-state drives (SSD) as a nonvolatile random access memory (NvRAM) extension to the Database Engine buffer pool to improve I/O throughput.

§ Incremental Statistics: CREATE STATISTICS and related statistic allows or reports related statements to incremental statistics.

§ Resource Governor Enhancements for Physical IO Control: Now physical IOs issued for user threads for a given resource pool can be governed.

§ Online Index Operation Event Class: has two new data columns: PartitionId and PartitionNumber

· Transact-SQL Enhancements:

§ Inline specification of CLUSTERED and NONCLUSTERED indexes is now allowed for disk-based tables.

§ The SELECT … INTO statement is improved and can now operate in parallel (compatibility level 110 or higher)

§ Enhanced Transact-SQL for In-Memory OLTP

· System Table/Views Enhancements: Enhanced sys.xml_indexes, sys.xml_indexes (Transact-SQL), sys.dm_exec_query_profiles, sys.dm_exec_query_profiles (Transact-SQL), sys.column_store_row_groups, and sys.column_store_row_groups

· Security Enhancements:

§ CONNECT ANY DATABASE Permission: to a login that must connect to all databases

§ IMPERSONATE ANY LOGIN Permission: to impersonate the account of clients connecting to it, as it connects to databases

§ SELECT ALL USER SECURABLES Permission: a login such can view data in all databases that the user can connect to.

· Deployment Enhancements: enables deployment of a SQL Server database to a Windows Azure VM.

Concise Summary: The new Microsoft SQL Server 2014 CTP2 Database Engine is faster, better and future ready. It is specially designed to perform large, complex structured and unstructured data at on-premises or in a virtual machine in Windows Azure.



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, Remote Database Services, App Development, Data Processing Services.

http://ift.tt/1f5mi7q MS SQL Server

Delvesys: Overview of Microsoft® SQL Server® 2014 CTP2 Database Engine - It's Faster .... It's...  

Are you Ready for SQL Server 2014 ??

Microsoft is going to release MS SQL Server 2014!! ...... Are you ready for MS SQL Server 2014 ??

http://ift.tt/1mP0w1C

Delvesys: Are you Ready for SQL Server 2014 ??  

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

Delvesys

Delvesys is Conducting 'Free SQL Server Health Check'. Please book your appointment at [email protected].