SQL Server Team articles

Avatar photo
SQL Server Team
Published 
1 min read

Securing your data with Azure SQL Database 

The General Data Protection Regulation (GDPR) is now in effect as of May 25th, 2018.  GDPR has significant implications on the use and management of your customers’ personal data. Considerations of privacy, security, data management, and marketing practices are all top of mind. With nearly 160 new GDPR requirements, it’s clear that cloud technology can help accelerate your path to GDPR compliance.
Published 
2 min read

SSMS 17.8 is now available 

This post is co-authored by Pam Lahoud, Senior Program Manager, SQL Server. We are excited to announce the release of SQL Server Management Studio (SSMS) 17.8! Download SSMS 17.8 and review the Release Notes to get started. SSMS 17.8 provides support for almost all feature areas on SQL Server 2008 through the latest SQL Server 2017, which is now generally available.
Published 
4 min read

The June release of SQL Operations Studio is now available 

UPDATE: SQL Operations Studio is now GA and renamed to Azure Data Studio. For the most up to date information please visit our monthly Azure Data Studio blog post and download and install the latest release here. We are excited to announce the June release of SQL Operations Studio is now available. Download SQL Operations Studio and review the Release Notes to get started.
Published 
5 min read

SQL Server Automatic Tuning around the world… 

..and in the clouds…When I first saw early builds of SQL Server 2017, one of the features that caught my eye immediately was Automatic Tuning with an option called Automatic Plan Correction. SQL Server 2017 was released in October of 2017 right on the heels of one of my favorites releases, SQL Server 2016.
Published 
1 min read

Microsoft releases the latest update of Analytics Platform System 

Microsoft is pleased to announce that the Analytics Platform System (APS) appliance update 7 (AU7) is now generally available. APS is Microsoft’s scale-out Massively Parallel Processing (MPP) system based on SQL Server for data warehouse specific workloads on-premises. Customers will get significantly improved query performance and enhanced security features with this release. APS AU7 builds on appliance update 6 (APS 2016) release as a foundation.
Published 
2 min read

Cloud data and AI services training roundup May 2018 

To help you stay up to date on online training opportunities, we’re releasing a monthly list of the latest free Data and Artificial Intelligence (AI) sessions in one convenient post. SQL Database Azure SQL Database is the intelligent, fully managed relational cloud database service that provides the broadest SQL Server engine compatibility, so you can migrate your SQL Server databases without changing your apps.
Published 
7 min read

SQL Server at the Red Hat Summit 2018 

This blog post is also authored by Travis Wright, Principal Program Manager, Microsoft; and Jamie Reding, Senior Program Manager, Microsoft. A few weeks ago, developers from around the world gathered for the Microsoft Build Conference. It was an amazing display of Microsoft’s products and cloud services to meet the needs of all types of applications.
Published 
1 min read

A new update for mssql-cli, an interactive CLI, is now available 

We have released our second major update for mssql-cli since our public preview announcement in December. You can view the public preview announcement here. mssql-cli is a new and interactive command line query tool for SQL Server. This open source tool works cross-platform and is part of the dbcli community. mssql-cli auto-completion in action In this release (v0.13.
Published 
3 min read

Visualize geographic spatial data from SQL Server directly in Tableau 2018.1 

This is a partner post authored with the Tableau team. As part of Microsoft’s open and flexible platform for data and analytics, we’re always excited when partners add features that will expand customer options and extend business functionality. Business intelligence partner Tableau has recently introduced enhancements that will make it easier for their users to process spatial data stored in SQL Server.
Published 
2 min read

SSMS 17.7 is now available 

This post is co-authored by Sandy Winarko, Principal PM, SQL Server.  We are excited to announce the release of SQL Server Management Studio (SSMS) 17.7! Download SSMS 17.7 and review the Release Notes to get started. SSMS 17.7 provides support for almost all feature areas on SQL Server 2008 through the latest SQL Server 2017, which is now generally available.
Published 
3 min read

The May release of SQL Operations Studio is now available 

UPDATE: SQL Operations Studio is now GA and renamed to Azure Data Studio. For the most up to date information please visit our monthly Azure Data Studio blog post and download and install the latest release here. This post is co-authored by Karl Burtram, Senior Software Engineer, SQL Server.   We are excited to announce the May release of SQL Operations Studio is now available.
Published 
2 min read

Database scoped default online options is in preview for Azure SQL DB 

This post is authored by Mirek Sztajno, Senior Program Manager, Azure SQL Database. We are happy to announce that database scoped default options for online and resumable are now available for public preview. With this feature, you can set a default behavior for online and resumable rather than defining the option for each individual statement.