Microsoft presented some huge upgrades in SQL Server
2014—particularly with In-Memory OLTP. Notwithstanding, as you may expect after
such a short discharge cycle, not each subsystem has been redesigned; there are
no real changes to SQL Server Integration Services (SSIS), SQL Server
Replication Services, or SQL Server Reporting Services (SSRS). In any case,
there are a lot of critical improvements. Here are 10 new components in SQL
Server 2014.
1.
In-Memory OLTP Engine
SQL Server 2014 empowers memory improvement of chose
tables and put away strategies. The In-Memory OLTP motor is intended for high
simultaneousness and uses another hopeful simultaneousness control system to
dispense with locking deferrals. Microsoft states that clients can anticipate
that execution will be up to 20 times superior to with SQL Server 2012 when
utilizing this new component. For more data, look at "Rev Up Application
Performance with the In-Memory OLTP Engine."
2.
AlwaysOn Enhancements
Microsoft has upgraded AlwaysOn combination by
extending the most extreme number of auxiliary imitations from four to eight.
Discernable optional copies are currently additionally accessible for read
workloads, notwithstanding when the essential imitation is inaccessible.
Moreover, SQL Server 2014 gives the new Add Azure Replica Wizard, which offers
you some assistance with creating nonconcurrent auxiliary copies in Windows
Azure.
3.
Support Pool Extension
SQL Server 2014 gives another strong state plate
(SSD) mix capacity that gives you a chance to utilize SSDs to grow the SQL
Server 2014 Buffer Pool as nonvolatile RAM (NvRAM). With the new Buffer Pool
Extensions highlight, you can utilize SSD drives to grow the support pool in
frameworks that have maximized their memory. Cushion Pool Extensions can give
execution increases to peruse overwhelming OLTP workloads.
4.
Updateable Columnstore Indexes
At the point when Microsoft presented the
columnstore list in SQL Server 2012, it gave enhanced execution to information
warehousing inquiries. For a few inquiries, the columnstore lists gave a
tenfold execution change. Be that as it may, to use the columnstore file, the
fundamental table must be perused just. SQL Server 2014 kills this confinement
with the new updateable Columnstore Index. The SQL Server 2014 Columnstore
Index must utilize every one of the sections in the table and can't be
consolidated with different records.
5.
Capacity I/O control
The Resource Governor gives you a chance to restrict
the measure of CPU and memory that a given workload can expend. SQL Server 2014
develops the span of the Resource Governor to oversee stockpiling I/O
utilization too. The SQL Server 2014 Resource Governor can confine the physical
I/Os issued for client strings in a given asset pool.
6.
Force View for Multidimensional Models
Force View used to be restricted to plain
information. On the other hand, with SQL Server 2014, Power View can now
utilized with multidimensional models (OLAP shapes) and can make an assortment
of information representations including tables, lattices, air pocket diagrams,
and land maps. Force View multidimensional models likewise bolster inquiries
utilizing Data Analysis Expressions (DAX).
7.
Power BI for Office 365 Integration
Power BI for Office 365 is a cloud-based business
knowledge (BI) arrangement that gives information route and perception
capacities. Power BI for Office 365 incorporates Power Query (once in the past
code-named Data Explorer), Power Map (in the past code-named GeoFlow), Power
Pivot, and Power View. You can take in more about MSBI Online Training.
8.
SQL Server Data Tools for Business Intelligence
The new SQL Server Data Tools for BI (SSDT-BI) is
utilized to make SQL Server Analysis Services (SSAS) models, SSRS reports, and
SSIS bundles. The new SSDT-BI underpins SSAS and SSRS for SQL Server 2014 and
prior, however SSIS ventures are restricted to SQL Server 2014. In the
pre-discharge rendition of SQL Server 2014, SQL Server Setup doesn't introduce
SSDT-BI. Rather, you must download SSDT-BI independently from the Microsoft
Download Center.
9.
Reinforcement Encryption
One welcome expansion to SQL Server 2014 is the
capacity to scramble database reinforcements for very still information
assurance. SQL Server 2014 backings a few encryption calculations, including
Advanced Encryption Standard (AES) 128, AES 192, AES 256, and Triple DES. You
must utilize a testament or an unbalanced key to perform encryption for SQL
Server 2014 reinforcements.
10.
SQL Server Managed Backup to Windows Azure
SQL Server 2014's local reinforcement underpins
Windows Azure reconciliation. Despite the fact that I'm not so much persuaded
that I would need to rely on upon an Internet association with restore my
reinforcements, on-premises SQL Server 2014 and Windows Azure virtual machine
(VM) cases bolster going down to Windows Azure stockpiling. The Windows Azure
reinforcement mix is likewise completely incorporated with SQL Server
Management Studio (SSMS)
