Microsoft Visual Studio Code vs. SQL Server Management Studio (SSMS)

As a general workhorse IDE, Microsoft Visual Studio Codee is unmatched. Building on the early success of applications such as Atom, it has long been the standard for electron based IDEs. It can be outshone using IDEs that are dedicated to particular platforms, such as Microsoft Visual Studio Code for .net and the Jetbrains IDEs for Java, Python and others. For remote collaborative development, something like Zed is ahead of VSCode live share, which can be quite flakey.

Incentivized

The tool is excellent for managing virtually all aspects of SQL Server - multiple servers, databases, hundreds of tables and procedures, dozens of SQL Agent jobs. We have not encountered any situations where it is not appropriate.

Incentivized

• Integrate with the git repository very well.
• Integrated copilot chat is very helpful to write code snippets and helps beginners to start with coding and development.
• Great library of available extensions is one of the best features in Microsoft Visual Studio Code.
• Dedicated Testing option to configure pytest and others are quite handy to use.

Incentivized

• Database queries
• Database management
• Table design

Incentivized

• The customization of key combinations should be more accessible and easier to change
• The auxiliary panels could be minimized or as floating tabs which are displayed when you click on them
• A monitoring panel of resources used by Microsoft Visual Studio Code or plugins and extensions would help a lot to be able to detect any malfunction of these

Incentivized

• Sorting of executed queries not available
• Quality of life improvements on folders and managment
• Some outdated tools that need revamping

Incentivized

Solid tool that provides everything you need to develop most types of applications. The only reason not a 10 is that if you are doing large distributed teams on Enterprise level, Professional does provide more tools to support that and would be worth the cost.

Incentivized

Microsoft Visual Studio Code earns a 10 for its exceptional balance of power and simplicity. Its intuitive interface, robust extension ecosystem, and integrated terminal streamline development. With seamless Git integration and highly customizable settings, it adapts perfectly to any workflow, making complex coding tasks feel effortless for beginners and experts alike.

Incentivized

It's very user friendly. If you know T-SQL then you can use this. Really even if you don't it's not that hard to figure out. You can create things visually as well.

Incentivized

Overall, Microsoft Visual Studio Code is pretty reliable. Every so often, though, the app will experience an unexplained crash. Since it is a stand-alone app, connectivity or service issues don't occur in my experience. Restarting the app seems to always get around the problem, but I do make sure to save and backup current work.

Incentivized

Microsoft Visual Studio Code is pretty snappy in performance terms. It launches quickly, and tasks are performed quickly. I don't have a lot of integrations other than CoPilot, but I suspect that if the integration partner is provisioned appropriately that any performance impact would be pretty minimal. It doesn't have a lot of bells and whistles (unless you start adding plugins left and right).

Incentivized

Active development means filing a bug on the GitHub repo typically gets you a response within 4 days. There are plugins for almost everything you need, whether it be linting, Vim emulation, even language servers (which I use to code in Scala). There is well-maintained official documentation. The only thing missing is forums. The closest thing is GitHub issues, which typically has the answers but is hard to sift through -- there are currently 78k issues.

Incentivized

Visual Studio Code stacks up nicely against Visual Studio because of the price and because it can be installed without admin rights. We don't exclusively use Visual Studio Code, but rather use Visual Studio and Visual Studio code depending on the project and which version of source control the given project is wired up to.

Incentivized

SSMS is very efficient and aids to do multiple tabs easily

Incentivized

It is easily deployed with our Jamf Pro instance. There is actually very little setup involved in getting the app deployed, and it is fairly well self-contained and does not deploy a large amount of associated files. However, it is not particularly conducive to large project, multi-developer/department projects that involve some form of central integration.

Incentivized

• Saves money by replacing suites of tools such as Visual Studio, IntelliJ, etc.
• Speeds development time and developer environment setup time
• Strengthens code quality with integrated autoformatting and linting
• Strengths Git practices by keeping version control tightly connected with the code

Incentivized

• SQL Server Management Studio is our go-to tool for almost everything we do with SQL Server. Highly efficient and flexible.
• Compared to other alternatives, I would say we save at least 25% of the overall time we need to spend working in SQL Server.

Incentivized