Product: SQL Server 2017
-
-
How to provision a Linux SQL Server Virtual Machine in Azure
You’re an existing SQL Server customer and are looking to explore the fast-growing Linux operating system. Whether on-premises or in the cloud, Microsoft has you covered. With SQL Server 2017, and now SQL Server 2019, SQL Server is available on Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and Ubuntu. For our purposes, I’m going -
Mssql extension for Visual Studio Code now has Object Explorer and IntelliCode
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 -
SQL Server Management Studio (SSMS) 18.1 is now generally available
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 -
SQL Server 2017 achieves top TPC benchmarks for OLTP and DW on Linux and Windows
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 -
SQL Server 2019 community technology preview 2.5 is now available
We’re excited to announce the monthly release of SQL Server 2019 community technology preview (CTP) 2.5. SQL Server 2019 is the first release of SQL Server to closely integrate Apache Spark™ and the Hadoop Distributed File System (HDFS) with SQL Server in a unified data platform. The CTP 2.5 preview brings the following new features -
The April release of Azure Data Studio is now available
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 -
Automated machine learning from SQL Server with Azure Machine Learning
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 -
The Cloud Database Administrator—Tech success at scale
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 -
Three reasons to choose Microsoft for your hybrid data platform
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 -
Test the latest features with SQL Server 2017 Developer Edition
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 -
The January release of Azure Data Studio
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 -
The October release of Azure Data Studio is now available
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 -
DBA essentials—SQL Server 2017 security, performance tuning, and more—inside out
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 -
Modernize your SQL Server at the PASS Summit 2018
Each year thousands of data professionals make the annual visit to Seattle, Washington for the Professional Association for SQL Server Summit. This is a community driven organization and event but Microsoft has been a major contributor, sponsor, and part of this summit since its inception. This is the second post in a series leading up to