Using Natively Compiled Stored Procedures in SQL Server 2014
The new In-Memory OLTP feature in SQL Server 2014 greatly optimizes the performance of certain OLTP applications.
Data platform
Updates
Product updates, including new feature releases
-
-
New Article: Application Patterns and Development Strategies for SQL Server in Windows Azure Virtual Machines
We are very happy to announce that a new guidance for SQL Server in Windows Azure Infrastructures Services is now available online. -
Windows Azure HDInsight Supporting Hadoop 2.2 in Public Preview
Earlier this week, we announced at the O’Reilly Strata Conference that Windows Azure HDInsight now supports Hadoop 2. -
Making Big Data Work for Everyone
This has been a really exciting week for the Microsoft data platform. -
Hortonworks Makes HDP 2.0 for Windows Server Generally Available
Today, Hortonworks announced the general availability of the Hortonworks Data Platform (HDP) 2. -
SQL Server 2014 In Memory OLTP: Memory-Optimized Table Types and Table Variables
SQL Server 2014 In-Memory OLTP introduces two new widely advertised kinds of database objects: memory-optimized tables for efficient data access, and natively compiled stored procedures for efficient query processing and business logic execution. -
SQL Server 2014 Hybrid Cloud Scenarios: Migrating On-Premises SQL Server to Windows Azure Virtual Machines
Those of you who have tried the new version of SQL Server Management Studio might have noticed already that it has a couple of new wizards added. -
Boosting Transaction Performance in Windows Azure Virtual Machines with In-Memory OLTP
With the release of SQL Server 2014 CTP2, you can now significantly boost the performance of your OLTP workloads in Windows Azure Virtual Machines. -
How Does SQL Server Parallel Data Warehouse (PDW) Deliver the Performance that it Does?
Last week, we introduced you to SQL Server PDW, the version of SQL Server built specifically for high performance data warehousing that delivers performance gains of up to 50x compared to traditional data warehouses. -
Microsoft SQL Server Data Tools Update
With the release of SQL Server 2014 Community Technology Preview 2 (CTP2) and the commercial release of Visual Studio 2013, we are excited to announce new preview releases of SQL Server Data Tools to support both database and business intelligence projects. -
New In-Memory OLTP Sample for SQL Server 2014 CTP2
To help you get started with the new In-Memory OLTP feature, we created a sample around sales order processing based on the AdventureWorks sample database. -
IO Resource Governance in SQL Server 2014
Resource Governor was introduced in SQL Server 2008 to achieve predictable performance in a multi-tenant environment, to support mixed workload patterns, to provide mechanisms and tools to deal with runaway queries, and to enforce resource limits for CPU and memory.
Explore SQL Server 2025
Accelerate your AI application’s time to market by harnessing the power of your data and the built-in AI capabilities of SQL Server 2025, the enterprise database with best-in-class security, performance, and availability.
Connect with us on social