Tue, 15 Apr 2014
SQL Server 2014 ODBC Driver
Microsoft SQL Server 2014 provides users with more mission-critical capabilities and manageability for mission critical applications. SQL Server 2014 also provides new elements of data functionality that you might want to take advantage of.
Hence the reason why the Easysoft ODBC Driver supports them.
At Easysoft we are very proud of the fact that we take brand new functionality by database vendors and are the first third party ODBC provider to support them, enabling our clients to make full use of them within their own organisations.
So as the first ISV to enable Linux and Unix users take advantage of MS SQL Server 2014 features, what new things do we support?
SQL Server 2014 now lets organisations move specific tables (and stored procedures) into memory; this minimises I/O overheads and improves the performance of online transaction processing (OLTP) applications (Microsoft expect some applications to run 20 times faster by taking advantage of this).
Updateable Columnstore Indexes
This is another high performance in-memory technology from Microsoft. Originally introduced in SQL Server 2012 to significantly improve performance for data warehousing queries, Microsoft have enhanced the functionality with the introduction of clustered columnstore indexes. This change now makes the underlying table updateable.
In our own tests we found performance benefits both when querying and updating tables that had clustered columnstore indexes.
New Security Features
SQL Server 2014 introduces some new security permissions that allow server roles to be set up, which allows database administrators to perform their duties but not see the underlying user data.
AlwaysOn Availability Groups
Introduced by Microsoft originally in SQL Server 2012, it supported a maximum of four secondary replicas. SQL Server 2014 now supports up to eight secondary replicas.
This feature provides high availability and disaster recovery for multiple SQL Server databases without the need for a shared storage SAN.