SQL Server Best Practices - Microsoft SQL Server Blog

Best Practices September 28, 2017 3 min read

Enhancing query performance with Adaptive Query Processing in SQL Server 2017

This post was authored by Joe Sack, Principal Program Manager, Data Systems Group, Microsoft SQL Server 2017 and Azure SQL Database introduce a new generation of query processing improvements that will adapt optimization strategies to your application workload’s runtime conditions.

Best Practices August 31, 2017 1 min read

Six reasons to consider SQL Server 2017—especially if you’re on Linux

“Data is currency” is the rule of thumb in business.

Best Practices July 17, 2017 3 min read

SQL Server 2017 containers for DevOps scenarios

This post was authored by Tony Petrossian, Partner Group Program Manager, Database Systems Group SQL Server 2017 will bring with it support for the Linux OS and containers running on Windows, Linux, and macOS.

Announcements May 17, 2017 3 min read

Try new SQL Server command line tools to generate T-SQL scripts and monitor Dynamic Management Views

This post was authored by Tara Raj and Vinson Yu, Program Managers – SQL Server Team We are excited to announce the public preview availability of two new command line tools for SQL Server: The mssql-scripter tool enables developers, DBAs, and sysadmins to generate CREATE and INSERT T-SQL scripts for database objects in SQL Server, […]

Best Practices May 16, 2017 1 min read

Keeping freight moving in Denmark with SQL Server 2016

Efficient data management keeps goods flowing smoothly in Denmark.

Best Practices May 15, 2017 4 min read

Five reasons to run SQL Server 2016 on Windows Server 2016 – No. 5: Consistent data environment across hybrid cloud environments

Have you ever seen a tree that simultaneously bears completely different species of fruit? It’s a real thing: apples, plums, oranges, lemons, and peaches all growing on the same tree.

Best Practices May 15, 2017 2 min read

Extend your app to support SQL Server 2017 on Linux

This post was authored by Vin Yu, Program Manager, SQL Engineering Microsoft recently announced Community Technology Preview (CTP) 2.

Best Practices May 1, 2017 1 min read

A Stand Out Performance by KillaDBA

This post was authored by Nikki Thomas Two weeks ago, we welcomed special guest performer Homer McEwen (aka KillaDBA) to SQL Saturday.

Best Practices April 28, 2017 7 min read

SQL Server community-driven enhancements in SQL Server 2017

This post was authored by the SQL Server Tiger Team Although SQL Server 2016 runs faster, SQL Server 2017 promises to run even faster and empower customers to run smarter with intelligent database features like the ability to run advanced analytics using Python in a parallelized and highly scalable way, the ability to store and […]

Best Practices April 20, 2017 7 min read

Graph Data Processing with SQL Server 2017 and Azure SQL Database

SQL Server is trusted by many customers for enterprise-grade, mission-critical workloads that store and process large volumes of data.

Best Practices April 13, 2017 4 min read

Five reasons to run SQL Server 2016 on Windows Server 2016 – No. 4: Reach insights faster by running analytics at the point of creation

This is the fourth post in a five-part blog series.

Best Practices April 12, 2017 7 min read

Five ways Microsoft helps you do amazing things with data in the cloud

Microsoft can help you do amazing things with your data in the cloud! Here are five examples to help you get started.

Explore SQL Server 2025