Have you been keeping up with all the announcements during Microsoft Ignite? If you aren’t lucky enough to be attending, you can watch the live stream like me. One long-awaited announcement dropped today with one minor but major change:
- The SQL Operations Studio release has moved from preview to general availability (GA)
- The name SQL Operations Studio is gone and the product is now called Azure Data Studio
OK, maybe long-awaited is a little dramatic. SQL Operations Studio was released to public preview on November 15th, 2017 and the GA release is less than a year later, September 24th, 2018. If you’ve been playing along at home, you know there has been a monthly release cycle and that is not changing.
Will SQL Operations Studio upgrade automatically to Azure Data Studio?
NO! Although they’re effectively the same thing currently, you do need to install Azure Data Studio separately from your existing sqlops install. You can install the new Azure Data Studio after downloading it from here: https://aka.ms/getazuredatastudio. The docs also include a helpful section, Move User Settings, that will help you migrate any custom settings you don’t want to lose from your sqlops configuration.
Does the Azure branding mean my on-premises SQL Server is being forgotten?
NO! This was something a few people were questioning over on the SQL community Slack. Vicky Harp (B | T), the PM Lead for SQL Server tools, reassured those concerned, “All flavors of SQL Server, including on premises, cloud, and the new SQL Server 2019 big data clusters, are a part of the Azure Data group at Microsoft… On prem SQL Server is absolutely still a critical scenario for the tool.”
Can I still influence the future of Azure Data Studio?
YES! As it has been since the beginning, Azure Data Studio is maintained as an open source project on GitHub and you can vote on issues and even contribute if you’re so inclined. Now if we can just get someone to tell us which string or binary data would be truncated.
So as they say, them’s the breaks. I’d like to issue a big congratulations to the SQL Oper…….I mean, Azure Data Studio team. Your hard work is much appreciated and I look forward to what’s to come!