One consistent SQL: The launchpad from legacy to innovation
One consistent SQL delivers the agility and consistency needed to modernize data systems and unlock new innovation opportunities.
Microsoft SQL Server Blog
How the Microsoft SQL team is investing in SQL tools and experiences
Microsoft is modernizing SQL tools with AI, SSMS, Visual Studio Code, and DevOps features to boost productivity and future-proof development.
Innovation spotlight: How 3 customers are driving change with migration to Azure SQL
Learn how Microsoft Azure SQL Managed Instance helps organizations move from legacy constraints to a scalable and secure AI-ready foundation.
Two SQL Server Jump Starts, Live on December 3rd and 4th
If you haven’t yet, be sure to check out the SQL Server 2014 CTP2? Essentially feature complete, this second public community technical preview enables you to
The Modern Data Warehouse
In recent surveys by TDWI Research, roughly half of respondents report that they will replace their primary data warehouse (DW) platform and/or analytic tools within
Evolving your SQL Server Data Warehouse to the Next Generation, High Performance Solution, the SQL Server Parallel Data Warehouse (PDW)
Last week, we highlighted a whitepaper that focused on the performance benefits of SQL Server PDW and how it differs from traditional SQL Server. We’ve
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
SQL Server 2014 In-Memory OLTP: Memory Management for Memory-Optimized Tables
Memory-optimized tables must fully reside in memory and can’t be paged out. Unlike disk-based tables where insufficient memory can slowdown an application, the impact to
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
SQL Server 2014 In-Memory OLTP: Nonclustered Indexes for Memory-Optimized Tables
SQL Server 2014 CTP1 introduced hash indexes for memory-optimized tables. Hash indexes are very efficient for point lookups, when you know exactly the value you
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
Get to Know the SQL Server that’s Purpose Built for High Performance Data Warehousing and Big Data Analytics – the SQL Server Parallel Data Warehouse Appliance
If your business relies on data, you know that it is a constant challenge to store, manage, and analyze it effectively as your data continues
In-Memory OLTP: High Availability for Databases with Memory-Optimized Tables
Starting with SQL Server 2012, the new offering of AlwaysOn Availability Groups and AlwaysOn Failover Cluster Instances (FCI) suite of features have enabled Tier-1 customers
Revolutionizing City Planning in the 21st Century with Windows Azure, HDInsight, and SQL Server
If you’ve ever played a video game where you manage a virtual city, you understand how real-time insight into services including emergency response teams and