Mssql extension for Visual Studio Code now has Object Explorer and IntelliCode 

3 min read

Today we’re introducing a new release for the mssql extension for Visual Studio Code which is now available! The mssql extension for Visual Studio Code is the official SQL Server extension that supports connections to SQL Server and rich editing experience for T-SQL in your favorite developer tool, Visual Studio Code. You can download the Read more

SQL Server Management Studio (SSMS) 18.1 is now generally available 

1 min read

We’re excited to announce the release of SQL Server Management Studio (SSMS) 18.1. It’s been just over a month since we released SSMS 18.0. While we brought in many fantastic capabilities, we also regressed some functionality for some of our users. We are happy to share that we’ve fixed those and are also bringing in Read more

8 Comments

SQL Server 2017 achieves top TPC benchmarks for OLTP and DW on Linux and Windows 

2 min read

Once again, SQL Server 2017 has led the pack with three new TPC benchmarks published in April 2019, ranking SQL Server 2017 as the fastest database for online transaction processing (OLTP) and data warehouse (DW) workloads on Windows and Linux. Together with our partners, SQL Server continues to innovate with high-performing, enterprise-ready solutions that deliver Read more

The April release of Azure Data Studio is now available 

5 min read

We are excited to announce the April release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studio and review the Release notes to get started. Please note: After downloading Azure Data Studio, say Yes to enabling preview features so that you can use extensions. Azure Data Studio is Read more

2 Comments

Automated machine learning from SQL Server with Azure Machine Learning 

2 min read

This post was co-authored by Jeff Shepherd, Deepak Mukunthu, and Vijay Aski. Recently, we blogged about performing automated machine learning on SQL Server 2019 big data clusters. In today’s post, we will present a complementary automated machine learning approach leveraging Azure Machine Learning service (Azure ML) invoked from SQL Server. While the previous post dealt Read more

The Cloud Database Administrator—Tech success at scale 

3 min read

As a database administrator (DBA), I’ve always known what the role involved. Developers swing by my desk requesting a new database, a data refresh, or help with challenges they’re facing. They sometimes get frustrated with me when their database or data isn’t ready, even if it’s really the server admin who hasn’t allocated the storage Read more

Three reasons to choose Microsoft for your hybrid data platform 

2 min read

Companies today are faced with the trade-off of the security of having an on-premises solution and the convenience of moving their data to the cloud. With Microsoft, companies no longer have to make the choice. SQL Server and Azure SQL Database provide the most consistent hybrid data platform with frictionless migration across on-premises, cloud, and Read more

Test the latest features with SQL Server 2017 Developer Edition 

1 min read

Are you curious how new capabilities in SQL Server will impact your applications? Download and test SQL Server 2017 Developer Edition, a full-featured free edition, licensed for use as a development and test database in a non-production environment. You can browse and access SQL Server code samples at GitHub, and when you’re ready, check out Read more

The January release of Azure Data Studio 

8 min read

We are excited to announce the January release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studio and review the Release Notes to get started. Note: If you are currently using the preview version, SQL Operations Studio, and would like to retain your settings when upgrading to the Read more

2 Comments

The October release of Azure Data Studio is now available 

6 min read

We are excited to announce the October release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studio and review the Release Notes to get started. Note: If you are currently using the preview version, SQL Operations Studio, and would like to retain your settings when you upgrade Read more

DBA essentials—SQL Server 2017 security, performance tuning, and more—inside out 

3 min read

Whether you’re an experienced DBA with multiple certifications or just starting on your SQL Server DBA journey, you face challenges constantly for putting your organization’s data to work. To turn the next-to-impossible into the practical, you need a comprehensive resource at your fingertips: SQL Server 2017 Administration Inside Out, by William Assaf, Randolph West, Sven Read more

2 Comments