SQL Server Team articles

Avatar photo
SQL Server Team
Published 
1 min read

Announcing Columnstore Indexes and Query Store support in Database Engine Tuning Advisor 

The latest version of Microsoft SQL Server Database Engine Tuning Advisor (DTA) supports two new features: (a) Ability to recommend columnstore indexes in addition to rowstore indexes, and (b) Ability to automatically select a workload to tune from the Query Store. These new features are available when tuning for SQL Server 2016 Database Engine (or later) versions.
Published 
2 min read

SQL Server next version Community Technology Preview 1.1 now available 

Microsoft is excited to announce that the next version of SQL Server (SQL Server v.Next) Community Technology Preview (CTP) 1.1 is now available for download on both Windows and Linux. In SQL Server v.Next CTP 1.1, part of our rapid preview model, we made enhancements to several database engine and Business Intelligence (BI) capabilities which you can try in your development and test environments.
Published 
11 min read

SQL Server on Linux: How? Introduction 

This post was authored by Scott Konersmann, Partner Engineering Manager, SQL Server, Slava Oks, Partner Group Engineering Manager, SQL Server, and Tobias Ternstrom, Principal Program Manager, SQL Server. Introduction We first announced SQL Server on Linux in March, and recently released the first public preview of SQL Server on Linux (SQL Server v.Next CTP1) at the Microsoft Connect(); conference.
Published 
2 min read

SQL Server + Python — What’s new 

Python is one of the most popular and fastest-growing languages used today. Pyodbc (Python-SQL Server Connector) is an open source Python module maintained by Michael Kleehammer that uses ODBC Drivers to connect to SQL Server. It allows you to connect from the platform of your choice to SQL Server on-premises and in the cloud. Pyodbc is also cross platform and can be installed using pip.
Published 
<1 min read

Recognizing the top Database Systems contributors on MSDN forums! 

We are planning to launch a monthly leaderboard for the top contributors on MSDN forums. This is a pilot effort for Database Systems, including SQL Server, Azure SQL Database, Azure SQL Data Warehouse, and SQL Server VMs on Azure questions on MSDN. Read more about it on the Azure blog and send in your feedback to [email protected]. Congratulations to our October 2016 Top 10 contributors!
Published 
2 min read

Microsoft releases the latest update to Analytics Platform System 

Microsoft is pleased to announce that the appliance update, Analytics Platform System (APS) 2016, has been released to manufacturing and is now generally available. APS is Microsoft’s scale-out Massively Parallel Processing fully integrated system for data warehouse specific workloads. This appliance update builds on the SQL Server2016 release as a foundation to bring you many value-added features.
Published 
1 min read

Technical Preview: Database Experimentation Assistant 

This post is authored by Christina Lee, Program Manager – Data Group SEALS Team Overview Database Experimentation Assistant (DEA) is a new A/B testing solution for SQL Server upgrades. It will assist in evaluating a targeted version of SQL for a given workload.
Published 
3 min read

Source Control in SQL Server Management Studio (SSMS) 

This post was written by Ken Van Hyning, Engineering Manager, SQL Server Client Tools. In the latest generation of SQL Server Management Studio, we moved to the Visual Studio 2015 Isolated Shell. While this provides SSMS a modern IDE foundation for many functional areas, it also had some consequences.