SQL Server 2014 Edition Comparison (features and limitations)

Features Supported by the Editions of SQL Server 2014
Click here for the list of features and limitations of SQL Server 2014.

SQL-Server-2014-Feature-Comparison



Join us at LinkedIn!
Don’t forget to join the SQL Server 2014 group on LinkedIn and stay updated!:
linkedin-sql-server-2014-group








Advertisements

OPENQUERY() – Query timeout expired, really?

Did you receive this error while using an OPENQUERY() statement?:

OLE DB provider “SQLNCLI10” for linked server “[LinkedServerName]” returned message “Query timeout expired”.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider “SQLNCLI10” for linked server “[LinkedServerName]” reported an error. Execution terminated by the provider because a resource limit was reached.
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query ”

You might want to try helping the SQL Engine a little bit, because it’s confused by your query 😀
Try adding a TOP-clause, like for example:
SELECT TOP 3000000 *

If that didn’t help, you can always increase the timeout settings in the Server Properties window or Linked Server Properties window:

Server-Properties-Remote-Query-Timeout


Linked-Server-Properties-TimeOuts








SSIS 2012 Custom Components

Have a look at these SQLIS SSIS custom components for SSIS 2008 R2 and SSIS 2012:

Trash Destination Adapter
http://www.sqlis.com/post/Trash-Destination-Adapter.aspx

TrashDestination

Data Generator Source Adapter
http://www.sqlis.com/sqlis/post/Data-Generator-Source-Adapter.aspx

DataGeneratorEditor-SourceAdapter

Regular Expression Transformation
http://www.sqlis.com/sqlis/post/Regular-Expression-Transformation.aspx

Checksum Transformation
http://www.sqlis.com/sqlis/post/Checksum-Transformation.aspx








SQL Server Data Tools – Business Intelligence for Visual Studio 2013 (SSDT BI)

Microsoft released SQL Server Data Tools – Business Intelligence for Visual Studio 2013 (SSDT BI) for SQL Server 2014. With this release you can use SSDT BI in Visual Studio 2013 and it includes the Visual Studio Project Templates for Analysis Services, Integration Services, and Reporting Services. The project templates in this release generally work with down level versions of the server (with the exception of SSIS). See the image below for details.

SSDT-VisualStudio

They have also retired the CTP version that was based on VS 2012.

The setup for these tools is now available from the web and can be downloaded in multiple languages right here: http://www.microsoft.com/en-us/download/details.aspx?id=42313








SQL Server 2014 now Generally Available!

sqlserver2014logo


Microsoft today released Microsoft SQL Server 2014, the foundation of our cloud-first data platform. SQL Server 2014 delivers breakthrough performance with new and enhanced in-memory technologies to help customers accelerate their business and enable new, transformational scenarios. In addition, SQL Server 2014 enables new hybrid cloud solutions to take advantage of the benefits of cloud computing with scenarios such as cloud backup and cloud disaster recovery for on-premises SQL Server installations. SQL Server 2014 continues to offer industry-leading business intelligence capabilities through integration with familiar tools like Excel and Power BI for Office 365 for faster insights.

We will also soon make generally available the SQL Server Backup to Microsoft Azure Tool, a free tool that allows customers to backup older versions of SQL Server to Azure storage.

Try SQL Server 2014 release today

Download and try the generally available release of SQL Server 2014 today on premises, or get up and running in minutes in the cloud.



Join us at LinkedIn!
Don’t forget to join the SQL Server 2014 group on LinkedIn and stay updated!:
linkedin-sql-server-2014-group