![]() That does not mean that DBAs will not find interesting uses for Azure Data Studio, but for now the environment is ripe for use by those developing solutions for the Microsoft Data Platform, versus those administering instances of SQL Server on premises or administering one of the many Microsoft Azure offerings.Īzure Data Studio has a very low learning curve. Currently, backup and restore functionality exists in Azure Data Studio as one of the sole DBA-focused features, which means SQL Server Management Studio (SSMS) is by far still the de-facto tool for SQL Server database administration (along with the Azure data portal for all Azure-based SQL experience administration). But the company has a long road in front of it. Those preview-class features include:īased on this combination of features, one can draw the conclusion that Microsoft is now shifting toward closing the gap between Azure Data Studio and SQL Server Management Studio, making it a viable alternative for developers and DBAs alike. Microsoft will continue to release preview-class features as the platform evolves and receives new monthly updates through Microsoft’s commitment to continuous integration and delivery in its management tools for the data platform. Additional high-value administrative features such as backup, restore, agent job management, and server profiling are also available as extensions in Azure Data Studio.”Īzure Data Studio has gone GA with a rich set of developer and DevOps-centric features. At present, Azure Data Studio is tightly focused on the experiences around query editing and data development. Over the course of time, all of the management features of SQL Server Management Studio will be made available in Azure Data Studio and the two products will integrate smoothly with each other. “Azure Data Studio shares a heritage and a roadmap with SQL Server Management Studio, which has been a phenomenally successful and well-liked tool in its own right. ![]() The platform's features have evolved rapidly, and the plan is for it to be eventually on par with the established-yet-aging SQL Server Management Studio.Īccording to Vicky Harp, Principal Program Manager Lead, for SQL Server tooling: SQL Operations Studio developed from that need.Īzure Data Studio continues to be a cross-platform solution that comes in three flavors: Windows, Linux and Mac OS. The push to Linux was ambitious, and it was critical for Microsoft to provide a gateway for the audience that didn’t frequently interact with Microsoft products-particularly Windows. It hadn't been long since the release of Microsoft SQL Server 2017, which ushered in an entire new audience and market for SQL Server due to the scale-out of availability to Linux after nearly 25 years of exclusivity to the Windows ecosystem. At the time, the name of the product was SQL Operations Studio, and its feature set was small and aimed squarely at the developer persona. I first introduced you to Azure Data Studio when the public preview for it was announced in December 2017.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |