First to know about SQL Operation tool is, it is available in Windows, MacOs and Linux operation system. It is a light-weight tool for database development and operations for SQL Server. I am sure the first question you are going to ask about this tool is, what is wrong with SSMS? I don't think anything is wrong with SSMS rather than it works only in Windows operation system. Also SSMS is not a light-weight tool, It has a lot of functionalities for developers and DBAs. May be it wasn't easy to convert all of these functionalities to Linux, MacOs and Microsoft wanted to deliver a SQL Server management tool to Linux and MacOs sooner. When Microsoft introduced SQL Operation tool, they said "modern database development and operations". Rather than its look, I am not sure what they meant with that? What is modern database development? If I use SSMS, does that mean my development style is outdated? I guess Microsoft will answer these questions one day. Let's go back to SQL Operation tool. Here how it looks like when you run it first time.
As you can see, It uses the Visual Studio Code. Also I didn't need to install it on my computer. Package was zipped, all I had to do was, unzip it and run the executable file. This might be because this is the preview version of this product. Here how the query window looks like after I run a simple query.
Explain button shows you the query plan.
Click here to download the current version of the tool, As I said before this tool supposed to be the light-weight of SSMS which can be used in different operation system. You might love this tool If you like Visual Studio Code look and extensibility. You can find its source code in github,

No comments:
Post a Comment