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
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
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
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 Read more
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
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
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
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
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
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
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
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
