Jordan Sanders

Jordan Sanders

1597848416

Top 10 exciting new features in SQL Server Management Studio 2016

For a SQL database developer, it is essential to have the necessary SQL tools in hand, which enable to reduce the development time of given functionality. The same is true for the tester. For a database administrator, it is also important to have monitoring tools.

In this article, we are going to look at some MS SQL Server development and monitoring tools, such as:

  • SQL Server Management Studio
  • dbForge SQL Tools
  • Visual Studio and Visual Studio Code
  • dbForge Studio for SQL Server if necessary
  • Notepad ++
  • DBeaver
  • ApexSQL Developer and DBA tools
  • RedGate SQL Toolbelt
  • Spotlight on SQL Server и Foglight for SQL Server
  • Zabbix
  • Prometheus

SQL Server Management Studio

Let us begin with a free SSMS application. The functionality for development can be found here.
To add, there is a convenient function of Registered Server, which allows you to add the necessary MS SQL Server instances and also group them:
This is image title
It is also possible to create subgroups, to send requests to a given group, or a subgroup, or to a certain registered configured server, to upload registered configured servers for further import between all developers, for testing and administration.

It is also important to note the possibility of multi-editing:
This is image title

In SSMS, there is also a possibility of managing the Agent and designing databases through a database diagram. But the latter isn’t very user-friendly.

What is more, in SSMS, it is also possible to see active queries using Activity Monitor, but in general, it isn’t the best option to monitor a database and a database server.

Also, to monitor performance, you can use Profiler and Extended events in SSMS.

There are a bunch of other functions in SSMS, including the following:

  • data import and export
  • performance reports
  • database engine log shipping configuration and monitoring
  • configuring and monitoring AlwaysOn availability groups
  • configuring and monitoring query store
  • and many more.

dbForge SQL Tools

dbForge SQL Tools is a multi-functional toolkit for SQL Server. The tools are useful for any Microsoft SQL Server developer because they are integrated into SSMS, expanding it with the missing functionality, to perform a lot of routine tasks. SQL Tools can be used to automate development and deploy databases with the help of dbForge DevOps Automation. The package includes:

  • SQL Complete, which is one of the most functional add-ins, used to write and format SQL queries in SSMS and VS. This utility has not only functions of SQL code IntelliSense, formatting, and refactoring, but also a huge number of useful features that simplify code writing, formatting, and refactoring. This add-in also integrates with Visual Studio, which is particularly convenient.
  • Source Control is a powerful SSMS add-in for managing SQL Server database changes via all popular source control systems.
  • Unit Test is a convenient GUI for unit automation in SSMS.
  • Schema Compare and Data Compare
  • an excellent Data Generator for generation SQL Server test data.
  • Documenter
  • Data Pump, which provides you with a convenient functionality for data export/import.
  • Index Manager, which is used for index optimization.
  • Query Builder allows users to visually build SQL queries of any complexity.
  • Search is used for a quick search for objects and data in the database.
  • Monitor for SQL Server has basic required functionality.
  • Event Profiler
  • SQL Decryptor

This is image title

This is image title

This is image title

Apart from this, the package includes dbForge DevOps Automation, whose functionality allows you to implement a comprehensive database continuous integration process for SQL Server. In this way, a user gets a full set of tools for database DevОps.

Visual Studio Editor for SQL Server

Hand in hand with SSMS goes the powerful Visual Studio editor for SQL Server Database Project projects and other types of projects for databases and T-SQL scripts:
This is image title

Visual Studio is usually used for the following main functions:

  • Viewing and editing code and the database as a whole
  • Comparing database schemas and data, and making changes to the schema if necessary
  • Database schema export and import

Among the main disadvantages of SSMS as well as Visual Studio, are the following ones:

  1. They do not have all the necessary functions for development, testing, and administration

  2. Some of the capabilities, even if present, do not allow to perform all required tasks, and the process itself is very time-consuming.

There is also Visual Studio Code, which a cross-platform analogue of Visual Studio and which has only part of its functionality:
This is image title

dbForge Studio for SQL Server

Let us now look at the dbForge Studio for SQL Server editor:
This is image title
This solution is an alternative to SSMS, which complements and expands it. On top of that, this editor has well-implemented such important functions as:

  • Database Documenter
  • Database Schema Compare and Database Data Compare
  • Unit Test
  • Code Formatting
  • Source Control
  • Database Designer
  • Index Manager
  • Data Generator
  • Search
  • Monitor
  • Backup and Restore
  • Debugger
  • Query Profiler
  • Intellisense
  • and lots more.

Unfortunately, for the present moment, dbForge Studio for SQL Server does not support multi-editing.

Notepad ++

We can not but mention a wonderful simplified and free editor which is Notepad++. You can use it to view and edit T-SQL scripts. The editor supports multiple programming languages:
This is image title
This editor is especially handy when a T-SQL query is too large and it has many thousands and dozens of thousands of code lines because SSMS can freeze even when it displays a big chunk of code. There are various extensions for Notepad++, the most frequently used ones are SQL code comparison and formatting. You can also search for files with the help of Notepad++.

We won’t name the drawbacks of Notepad++, as it is mainly used for reading and editing the content of a file, and also for searching for a fragment in files and comparing the contents of files.

DBeaver

One more free editor, DBeaver:
This is image title
There is a paid version as well.

This editor, among all other things, has useful functions such as:

  • Code formatting
  • Database design
  • Open Dashboard
  • Search
  • Transaction Log
    However, this editor does not support multi-editing and some other useful functions for development, testing, and administration.

ApexSQL Developer and DBA tools

Let’s now look at ApexSQL developer tools and ApexSQL DBA tools, which are plugged in SSMS and in Visual Studio:
This is image title

This is image title

ApexSQL developer tools are designed for development and testing. It provides, among other things, the following functions:

  • Database schema and data comparison
  • SQL code formatting
  • Database documentation
  • Synthetic test data generation
  • Unit testing
  • Database design
  • Connecting to popular version control systems
  • Search for objects and data

ApexSQL DBA tools are designed for SQL Server administration. Among others, it provides the following functionality:

  • Index optimization
  • Backup and recovery
  • Reading transaction log

Together, ApexSQL developer tools and ApexSQL DBA tools, as well as dbForge SQL Tools, allow us to fully implement continuous integration and delivery processes and to organize ci/cd pipeline.

RedGate SQL Toolbelt

Let us now look at RedGate SQL Toolbelt:
This is image title
This is image title
This is image title

This tool is designed to develop, test, and administer databases. It provides, among other things, the following functions:

 1) Comparison of schemas and database data

 2) SQL Server monitoring

 3) Search

 4) Backup

 5) Documentation of databases

 6) Index Manager

 7) Analysis and formatting of the code

 8) Continuous integration and automatic deployment of SQL Server database

 9) Data generator

and much more.

As you can see, RedGate is the most expensive of all mentioned tools and it has a wide range of functionalities, but such competitive products as dbForge SQL Tools, ApexSQL Developer and DBA tools are constantly being improved, and new functionality is added to them. Therefore, today it is safe to say that such products as dbForge SQL Tools, ApexSQL Developer and DBA tools are on the level with, and in some cases even superior to RedGate, yet they are much cheaper.

SQL Server Monitoring Tools

At the end of the overview of the SQL Server tools, we will briefly go over the most popular systems for SQL Server monitoring.

Spotlight on SQL Server and Foglight for SQL Server

Let us start by looking at Spotlight on SQL Server
This is image title

This tool is quite rich in functionality for monitoring database servers and has, among others, the following functions:

  • collect basic characteristics of both the server and each database
  • fine-tuning alerts for each performance metric
  • several ready-made templates for performance metrics and alerts
  • a possibility to create user performance metrics
  • many convenient visual reports, including database growth rate reports
  • collection and analysis of heavy queries and their performance plans in the context of the total performance duration, of CPU performance, and of the number of the records, physical and logical reads
  • analysis of index fragmentation
  • a possibility to have a detailed look into every moment of time when the messages or alerts appeared, including details on queries and their performance plans (Playback)
  • and a lot more

A more advanced solution for SQL Server monitoring is Foglight for SQL Server:

This is image title

Zabbix

Let us now look at Zabbix:
This is image title
This product for monitoring provides a wide range of performance metrics and their triggers, as well as templates for them, different graphics, dashboards, and a wide variety of functionality, most of which can be customized.

The monitor has one major drawback. Zabbix, unlike Spotlight on SQL Server, can’t show queries at the specific point in time. But Zabbix is an open-source solution that allows you to monitor much more than just a database server.

Prometheus

Let us now consider Prometheus:
This is image title
Prometheus is usually used with the client side of Grafana.

Grafana can also be used for Zabbix, but the latter has a built-in customizable client side view to display the results in the form of dashboards and graphs.

Prometheus and Zabbix work fine for SQL Server monitoring and they fully cover the needs for monitoring databases and servers without giving details of queries in chronological order. Zabbix can be used without Grafana, so it can be deployed and set up faster than other solutions. However, Prometheus is much more modular and extendable than Zabbix.

Conclusion

The main tools for working with SQL Server databases are:

  • SSMS

  • Visual Studio
    They can be extended by third-party plugins to cover all development, testing and administration needs:

  • dbForge SQL Tools

  • ApexSQL developer tools и ApexSQL DBA tools

  • RedGate SQL Toolbelt
    or other similar systems.

These solutions also allow us to fully support the DevOps process.

To monitor database servers, I usually use the following systems:

  • Zabbix
  • Prometheus и Grafana
    or other similar systems.

To monitor queries and query history, the following tools are often used:

  • Spotlight on SQL Server
  • Foglight for SQL Server
  • SQL Server Query Store
    or other similar systems.

There are also a number of additional tools that partially or completely replace SSMS depending on the tasks that are solved, working with SQL Server:

  • dbForge Studio for SQL Server
  • Visual Studio Code
  • DBeaver
    The Notepad++ editor is handy when editing content, searching, or comparing very large files.

Originally posted at https://codingsight.com/best-sql-tools-for-database-developers-and-administrators/
Author - Evgeniy Gribkov

#sql #sql-server #database

What is GEEK

Buddha Community

Top 10 exciting new features in SQL Server Management Studio 2016
Cayla  Erdman

Cayla Erdman

1594369800

Introduction to Structured Query Language SQL pdf

SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.

Models for SQL exist. In any case, the SQL that can be utilized on every last one of the major RDBMS today is in various flavors. This is because of two reasons:

1. The SQL order standard is genuinely intricate, and it isn’t handy to actualize the whole standard.

2. Every database seller needs an approach to separate its item from others.

Right now, contrasts are noted where fitting.

#programming books #beginning sql pdf #commands sql #download free sql full book pdf #introduction to sql pdf #introduction to sql ppt #introduction to sql #practical sql pdf #sql commands pdf with examples free download #sql commands #sql free bool download #sql guide #sql language #sql pdf #sql ppt #sql programming language #sql tutorial for beginners #sql tutorial pdf #sql #structured query language pdf #structured query language ppt #structured query language

Ray  Patel

Ray Patel

1625843760

Python Packages in SQL Server – Get Started with SQL Server Machine Learning Services

Introduction

When installing Machine Learning Services in SQL Server by default few Python Packages are installed. In this article, we will have a look on how to get those installed python package information.

Python Packages

When we choose Python as Machine Learning Service during installation, the following packages are installed in SQL Server,

  • revoscalepy – This Microsoft Python package is used for remote compute contexts, streaming, parallel execution of rx functions for data import and transformation, modeling, visualization, and analysis.
  • microsoftml – This is another Microsoft Python package which adds machine learning algorithms in Python.
  • Anaconda 4.2 – Anaconda is an opensource Python package

#machine learning #sql server #executing python in sql server #machine learning using python #machine learning with sql server #ml in sql server using python #python in sql server ml #python packages #python packages for machine learning services #sql server machine learning services

Brain  Crist

Brain Crist

1600347600

SCHEMAS in SQL Server -MS SQL Server – Zero to Hero Query Master

Introduction

This is part 3 of “MS SQL Server- Zero to Hero” and in this article, we will be discussing about the SCHEMAS in SQL SERVER. Before getting into this article, please consider to visit previous articles in this series from below,

A glimpse of previous articles
Part 1

In part one, we learned the basics of data, database, database management system, and types of DBMS and SQL.

Part 2
  • We learned to create a database and maintain it using SQL statements.
  • Best practice methods were also mentioned.

#sql server #benefits of schemas #create schema in sql #database schemas #how to create schema in sql server #schemas #schemas in sql server #sql server schemas #what is schema in sql server

Madyson  Reilly

Madyson Reilly

1597938518

Using SQL Server 2016 Upgrade Advisor

INTRODUCTION

SQL Server is designed to allow multiple databases on a single instance. With this model it is possible to have databases sitting on an instance which are not the same version as the instance itself. You can think of this as running the database in the “backward compatibility mode.” To break it down further, we are saying that you can have a 2008 database deployed on an SQL Server 2016 instance. In such a scenario, the database is, for instance, allowed to use certain constructs that belong to a previous version of SQL Server.

There are cases where you would like to upgrade all databases in your instance to a more recent version for security reasons or to align with your organization’s policies. When doing this it may not be safe to assume that such a database will automatically work when upgraded. Using Upgrade Advisor, you can determine whether your existing databases are suitable for upgrade to SQL Server 2016 or any other higher version.

PREREQUISITES

Download Upgrade Advisor 2016 from Microsoft’s website. In this article, we have focused on Upgrade Advisor 2016; however, the latest version of Upgrade Advisor is called Data Migration Assistant and can be downloaded here. Once downloaded, you can install Upgrade Advisor 2016 on the computer that you will execute the analysis from. Note that this need not be the computer where SQL Server is installed.

PROCEDURE

1. Launch Upgrade Advisor and select the option to ANALYZE AND MIGRATE TO SQL SERVER

Figure 1: Upgrade Advisor Splash Screen

Figure 1 shows the splash screen that is displayed when you launch Upgrade Advisor. We see that the advisor offers four options for the analysis:

  1. Migrate to Azure SQL Database
  2. Run in-memory OLTP and ColumnStore advisor
  3. Run stretch database advisor
  4. Analyze and Migrate to SQL Server

The tool offers the database administrator an opportunity to properly prepare for any of these listed steps. It is better to predict what might happen if you embark on any of the listed tasks than to simply attempt them, fail and then realize why.

In the current scenario, we are focusing on number (4) which is Analyze and Migrate to SQL Server. We want to know whether existing databases can be migrated to SQL Server 2016, what we may need to do before embarking on such a migration, and what we may need to do as additional steps after the migration.

We select the option Analyze and Migrate to SQL Server and then click the Run button.

2. Connect to the desired instance

Figure 2: Select Instance

We must then connect to the instance we wish to analyze (Figure 2) and select the databases we want to analyze (See Figure 3). Type the instance name in the field shown and click Connect. In this scenario, we are running Upgrade Advisor on the same server where our SQL Server instance is hosted, so the tool can enumerate the installed instances and allow us to select from a menu. Recall that this behavior for tools that connect to SQL Server instance is made possible by SQL Server Browser.

#sql server #sql server #sql server 2016 #sql upgrade advisor #sql

Jordan Sanders

Jordan Sanders

1597848416

Top 10 exciting new features in SQL Server Management Studio 2016

For a SQL database developer, it is essential to have the necessary SQL tools in hand, which enable to reduce the development time of given functionality. The same is true for the tester. For a database administrator, it is also important to have monitoring tools.

In this article, we are going to look at some MS SQL Server development and monitoring tools, such as:

  • SQL Server Management Studio
  • dbForge SQL Tools
  • Visual Studio and Visual Studio Code
  • dbForge Studio for SQL Server if necessary
  • Notepad ++
  • DBeaver
  • ApexSQL Developer and DBA tools
  • RedGate SQL Toolbelt
  • Spotlight on SQL Server и Foglight for SQL Server
  • Zabbix
  • Prometheus

SQL Server Management Studio

Let us begin with a free SSMS application. The functionality for development can be found here.
To add, there is a convenient function of Registered Server, which allows you to add the necessary MS SQL Server instances and also group them:
This is image title
It is also possible to create subgroups, to send requests to a given group, or a subgroup, or to a certain registered configured server, to upload registered configured servers for further import between all developers, for testing and administration.

It is also important to note the possibility of multi-editing:
This is image title

In SSMS, there is also a possibility of managing the Agent and designing databases through a database diagram. But the latter isn’t very user-friendly.

What is more, in SSMS, it is also possible to see active queries using Activity Monitor, but in general, it isn’t the best option to monitor a database and a database server.

Also, to monitor performance, you can use Profiler and Extended events in SSMS.

There are a bunch of other functions in SSMS, including the following:

  • data import and export
  • performance reports
  • database engine log shipping configuration and monitoring
  • configuring and monitoring AlwaysOn availability groups
  • configuring and monitoring query store
  • and many more.

dbForge SQL Tools

dbForge SQL Tools is a multi-functional toolkit for SQL Server. The tools are useful for any Microsoft SQL Server developer because they are integrated into SSMS, expanding it with the missing functionality, to perform a lot of routine tasks. SQL Tools can be used to automate development and deploy databases with the help of dbForge DevOps Automation. The package includes:

  • SQL Complete, which is one of the most functional add-ins, used to write and format SQL queries in SSMS and VS. This utility has not only functions of SQL code IntelliSense, formatting, and refactoring, but also a huge number of useful features that simplify code writing, formatting, and refactoring. This add-in also integrates with Visual Studio, which is particularly convenient.
  • Source Control is a powerful SSMS add-in for managing SQL Server database changes via all popular source control systems.
  • Unit Test is a convenient GUI for unit automation in SSMS.
  • Schema Compare and Data Compare
  • an excellent Data Generator for generation SQL Server test data.
  • Documenter
  • Data Pump, which provides you with a convenient functionality for data export/import.
  • Index Manager, which is used for index optimization.
  • Query Builder allows users to visually build SQL queries of any complexity.
  • Search is used for a quick search for objects and data in the database.
  • Monitor for SQL Server has basic required functionality.
  • Event Profiler
  • SQL Decryptor

This is image title

This is image title

This is image title

Apart from this, the package includes dbForge DevOps Automation, whose functionality allows you to implement a comprehensive database continuous integration process for SQL Server. In this way, a user gets a full set of tools for database DevОps.

Visual Studio Editor for SQL Server

Hand in hand with SSMS goes the powerful Visual Studio editor for SQL Server Database Project projects and other types of projects for databases and T-SQL scripts:
This is image title

Visual Studio is usually used for the following main functions:

  • Viewing and editing code and the database as a whole
  • Comparing database schemas and data, and making changes to the schema if necessary
  • Database schema export and import

Among the main disadvantages of SSMS as well as Visual Studio, are the following ones:

  1. They do not have all the necessary functions for development, testing, and administration

  2. Some of the capabilities, even if present, do not allow to perform all required tasks, and the process itself is very time-consuming.

There is also Visual Studio Code, which a cross-platform analogue of Visual Studio and which has only part of its functionality:
This is image title

dbForge Studio for SQL Server

Let us now look at the dbForge Studio for SQL Server editor:
This is image title
This solution is an alternative to SSMS, which complements and expands it. On top of that, this editor has well-implemented such important functions as:

  • Database Documenter
  • Database Schema Compare and Database Data Compare
  • Unit Test
  • Code Formatting
  • Source Control
  • Database Designer
  • Index Manager
  • Data Generator
  • Search
  • Monitor
  • Backup and Restore
  • Debugger
  • Query Profiler
  • Intellisense
  • and lots more.

Unfortunately, for the present moment, dbForge Studio for SQL Server does not support multi-editing.

Notepad ++

We can not but mention a wonderful simplified and free editor which is Notepad++. You can use it to view and edit T-SQL scripts. The editor supports multiple programming languages:
This is image title
This editor is especially handy when a T-SQL query is too large and it has many thousands and dozens of thousands of code lines because SSMS can freeze even when it displays a big chunk of code. There are various extensions for Notepad++, the most frequently used ones are SQL code comparison and formatting. You can also search for files with the help of Notepad++.

We won’t name the drawbacks of Notepad++, as it is mainly used for reading and editing the content of a file, and also for searching for a fragment in files and comparing the contents of files.

DBeaver

One more free editor, DBeaver:
This is image title
There is a paid version as well.

This editor, among all other things, has useful functions such as:

  • Code formatting
  • Database design
  • Open Dashboard
  • Search
  • Transaction Log
    However, this editor does not support multi-editing and some other useful functions for development, testing, and administration.

ApexSQL Developer and DBA tools

Let’s now look at ApexSQL developer tools and ApexSQL DBA tools, which are plugged in SSMS and in Visual Studio:
This is image title

This is image title

ApexSQL developer tools are designed for development and testing. It provides, among other things, the following functions:

  • Database schema and data comparison
  • SQL code formatting
  • Database documentation
  • Synthetic test data generation
  • Unit testing
  • Database design
  • Connecting to popular version control systems
  • Search for objects and data

ApexSQL DBA tools are designed for SQL Server administration. Among others, it provides the following functionality:

  • Index optimization
  • Backup and recovery
  • Reading transaction log

Together, ApexSQL developer tools and ApexSQL DBA tools, as well as dbForge SQL Tools, allow us to fully implement continuous integration and delivery processes and to organize ci/cd pipeline.

RedGate SQL Toolbelt

Let us now look at RedGate SQL Toolbelt:
This is image title
This is image title
This is image title

This tool is designed to develop, test, and administer databases. It provides, among other things, the following functions:

 1) Comparison of schemas and database data

 2) SQL Server monitoring

 3) Search

 4) Backup

 5) Documentation of databases

 6) Index Manager

 7) Analysis and formatting of the code

 8) Continuous integration and automatic deployment of SQL Server database

 9) Data generator

and much more.

As you can see, RedGate is the most expensive of all mentioned tools and it has a wide range of functionalities, but such competitive products as dbForge SQL Tools, ApexSQL Developer and DBA tools are constantly being improved, and new functionality is added to them. Therefore, today it is safe to say that such products as dbForge SQL Tools, ApexSQL Developer and DBA tools are on the level with, and in some cases even superior to RedGate, yet they are much cheaper.

SQL Server Monitoring Tools

At the end of the overview of the SQL Server tools, we will briefly go over the most popular systems for SQL Server monitoring.

Spotlight on SQL Server and Foglight for SQL Server

Let us start by looking at Spotlight on SQL Server
This is image title

This tool is quite rich in functionality for monitoring database servers and has, among others, the following functions:

  • collect basic characteristics of both the server and each database
  • fine-tuning alerts for each performance metric
  • several ready-made templates for performance metrics and alerts
  • a possibility to create user performance metrics
  • many convenient visual reports, including database growth rate reports
  • collection and analysis of heavy queries and their performance plans in the context of the total performance duration, of CPU performance, and of the number of the records, physical and logical reads
  • analysis of index fragmentation
  • a possibility to have a detailed look into every moment of time when the messages or alerts appeared, including details on queries and their performance plans (Playback)
  • and a lot more

A more advanced solution for SQL Server monitoring is Foglight for SQL Server:

This is image title

Zabbix

Let us now look at Zabbix:
This is image title
This product for monitoring provides a wide range of performance metrics and their triggers, as well as templates for them, different graphics, dashboards, and a wide variety of functionality, most of which can be customized.

The monitor has one major drawback. Zabbix, unlike Spotlight on SQL Server, can’t show queries at the specific point in time. But Zabbix is an open-source solution that allows you to monitor much more than just a database server.

Prometheus

Let us now consider Prometheus:
This is image title
Prometheus is usually used with the client side of Grafana.

Grafana can also be used for Zabbix, but the latter has a built-in customizable client side view to display the results in the form of dashboards and graphs.

Prometheus and Zabbix work fine for SQL Server monitoring and they fully cover the needs for monitoring databases and servers without giving details of queries in chronological order. Zabbix can be used without Grafana, so it can be deployed and set up faster than other solutions. However, Prometheus is much more modular and extendable than Zabbix.

Conclusion

The main tools for working with SQL Server databases are:

  • SSMS

  • Visual Studio
    They can be extended by third-party plugins to cover all development, testing and administration needs:

  • dbForge SQL Tools

  • ApexSQL developer tools и ApexSQL DBA tools

  • RedGate SQL Toolbelt
    or other similar systems.

These solutions also allow us to fully support the DevOps process.

To monitor database servers, I usually use the following systems:

  • Zabbix
  • Prometheus и Grafana
    or other similar systems.

To monitor queries and query history, the following tools are often used:

  • Spotlight on SQL Server
  • Foglight for SQL Server
  • SQL Server Query Store
    or other similar systems.

There are also a number of additional tools that partially or completely replace SSMS depending on the tasks that are solved, working with SQL Server:

  • dbForge Studio for SQL Server
  • Visual Studio Code
  • DBeaver
    The Notepad++ editor is handy when editing content, searching, or comparing very large files.

Originally posted at https://codingsight.com/best-sql-tools-for-database-developers-and-administrators/
Author - Evgeniy Gribkov

#sql #sql-server #database