Azure SQL Auditing to a storage account destination behind a Virtual Network or a Firewall
We are pleased to announce that Auditing for Azure SQL Database and Azure Synapse Analytics supports writing database events to an Azure Storage account behind a virtual network and firewall. We have been listening to customers around the need to store …
Announcing mssql-cli is now generally available on macOS and Linux
We are excited to announce that mssql-cli is now generally available on macOS and Linux.mssql-cli is an open source and cross-platform command-line tool (CLI) to manage SQL Server on-prem and on the cloud. We are a proud member of the dbcli family of o …
Released: Microsoft.Data.SqlClient 2.0 Preview 3
The SqlClient team is moving forward with continuous updates and improvements to the Microsoft.Data.SqlClient data provider for SQL Server. Our plan is to provide GA releases twice a year with two preview releases in between. This cadence should provid …
The April 2020 release of Azure Data Studio is now available
The April release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started.Note: After downloading Azure Data Studio, say Yes to enabling preview features so that you can use extensions.Azure Data St …
Enabling customer choice, agility, and performance with SQL Server on Red Hat
Since the release of SQL Server 2017 on Red Hat Enterprise Linux, the industry-leading SQL Server database has been available on Red Hat Linux technologies. Microsoft and Red Hat continue to jointly engineer SQL-related offerings on Red Hat and provide …
Released: Public Preview for Azure SQL Database Managed Instance Management Pack (7.0.21.0)
We are releasing a public preview for Azure SQL Database Managed Instance Management Pack for SCOM. If you have a hybrid data environment and SCOM is your preferred monitoring solution, you can now use it to monitor your Azure SQL DB managed instances …
Load data from Azure Blob storage into Azure SQL | New Data Exposed episode
Curious how loading data in Azure SQL Database is different than SQL Server? In this short episode, I walk through loading a single file (located in Azure Blob storage) into Azure SQL Database. This is all done using a SQL Notebook in Azure Data Studio …
Open sourcing the Java language extension for SQL Server
With over 20 years of existence, Java is still one of the most popular programming languages and is used in many enterprise applications.In SQL Server 2019, we added a Java language extension, which enables secure execution of Java programs in the cont …
New Data Exposed episode: Updating connection policies for Azure SQL
Ever wondered which connection policy you should use for Azure SQL, and what the performance impacts might be? In the latest episode of Data Exposed, we walk through how to set the policy with PowerShell Notebooks in Azure Data Studio, and run a …
Released: Microsoft.Data.SqlClient 1.1.2
We recently released an update to Microsoft.Data.SqlClient, version 1.1.2. The update addresses a few issues that are important to our customers. Updates in Microsoft.Data.SqlClient 1.1.2 are: AddedAllowed passing username with Active Directo …
Hotfix Release: Microsoft Drivers 5.8.1 for PHP for SQL Server
We recently released an update for the Microsoft Drivers for PHP for SQL Server. Version 5.8.1 of the SQLSRV and PDO_SQLSRV drivers only applies to Linux and macOS platforms and adds production support for Alpine Linux. Notable items about this …
SQL Server 2017 adds support for Red Hat Enterprise Linux 8 and Ubuntu 18.04
SQL Server team has been adding support for « current » Linux distributions at fast clip last few months. The team announced support for RHEL 8 and Ubuntu 18.04 for SQL Server 2019 over last quarter. The team is happy to announce that SQL Server 2017 has …
An update from Data Exposed: New episodes and more
Many of us have been practicing #StayAtHome, but we’re working hard on Data Exposed to keep bringing you videos to continue learning from wherever you are. Fortunately for us (and for you, if you’re interested!), we recorded quite a few vid …
Cumulative Update #20 for SQL Server 2017 RTM
Cumulative Update #20 for SQL Server 2017 RTM The 20th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. …
SQL Server Management Studio 18.5 is now generally available
Today, we’re sharing the release of SQL Server Management Studio (SSMS) 18.5. We have some feature updates as well as important behind the scenes updates.You can download SQL Server Management Studio 18.5 today and review SSMS Release Notes for f …