<\/p>\n
1. SQL Server Management Studio(SSMS)<\/strong><\/h4>\nSSMS I would say is the DBA tool I have used the most! It is used for configuration, management and administration of Microsoft SQL Server databases. You can use it to design tables, views, stored procedures and other database objects.<\/p>\n
It provides both scripting and GUI features<\/p>\n![\"SQL](\"https:\/\/i0.wp.com\/www.kindsonthegenius.com\/mssql\/wp-content\/uploads\/sites\/11\/2020\/12\/SQL-Server-Management-Studio.png?resize=300%2C183&ssl=1\")
<\/a>SQL Server Management Studio<\/figcaption><\/figure>\nDownload SQL Management Studio here for free<\/a><\/p>\n <\/p>\n
2. Dataedo<\/strong><\/h4>\nThis is a very important DBA tool for creating database documentation. With this tool you can import your database and then it reads your\u00a0 data schemas and then lets you provided description for data elements such as tables, columns, views and stored procedures.<\/p>\n
Get Dataedo here.<\/a><\/p>\n <\/p>\n
3. Sportlight<\/strong><\/h4>\nThis tool created by Quest, helps you monitor and optimize your SQL server database performance. According to their website, you can do this from any device. Some of the benefits are:<\/p>\n
\n- efficiently diagnose real-time issues with your server<\/li>\n
- improve database performance<\/li>\n
- gain insight into all aspects of your database<\/li>\n
- achieve high availability(HA)<\/li>\n<\/ul>\n
![\"Spotlight](\"https:\/\/i0.wp.com\/www.kindsonthegenius.com\/mssql\/wp-content\/uploads\/sites\/11\/2020\/12\/Screenshot-2020-12-04-at-00.58.27.png?resize=300%2C163&ssl=1\")
<\/a>Spotlight on SQL Server Enterprise<\/figcaption><\/figure>\nGet Sportlight trial version here<\/a><\/p>\n <\/p>\n
4. SQL Server Data Tools(SSDT)<\/strong><\/h4>\nAccording to the SSDT documentation, this tools helps you to build SQL Server relational databases, Analytics Services(AS) data models, Integration Services(IS) packages and Reporting Services (RS) reports. To be used, SSDT is added as an extension to MS Visual Studio.<\/p>\n
Read more here<\/a><\/p>\n <\/p>\n
5. SolarWinds Database Performance Analyzer (DPA)<\/strong><\/h4>\nThis is a performance monitoring and analysis tool developed by SolarWinds. It provides interface for visualising various aspects of the system including execution plans, SQL statements, blocking, deadlocks etc. It also provides realtime and historical analysis. According to their website, the features include:<\/p>\n
\n- query performance analysis<\/li>\n
- real-time and historic monitoring<\/li>\n
- blocking and deadlock analysis<\/li>\n
- anomaly detection<\/li>\n
- intuitive performance analysis<\/li>\n<\/ul>\n
You can try DPA for free here<\/a><\/p>\n <\/p>\n
6. Microsoft Visual Studio(VS)<\/strong><\/h4>\nThis is a very powerful IDE(Integrated Development Environment) from Microsoft that used for building applications.\u00a0 It includes code which supports intellisense and code refactoring. VS can easily be used to managed MS SQL server databases.<\/p>\n
Download Visual Studio for free here<\/a><\/p>\n <\/p>\n
7. Longitude for Database Monitoring<\/strong><\/h4>\nLongitude is a database monitoring tool developed by Heroix for monitoring databases including Oracle, MS SQL and MySQL. According to their website, it proactively monitors for problem areas by evaluating key performance and availability metrics ensuring the at databases perform optimally. Some of the features include:<\/p>\n
\n- automatic collection of database performance metrics<\/li>\n
- generates comprehensive performance reports<\/li>\n
- generates alerts on performance problems<\/li>\n<\/ul>\n
Get free trial here<\/a><\/p>\n <\/p>\n
8. Database Migration Assistance (DMA)<\/strong><\/h4>\nDMA provides the features for upgrade of a database by detecting potential compatibility issued that may impact the functionality of the new SQL Server version.\u00a0 It also recommends peformance and reliability improvements for the target environment. Then it allows you to efficiently move both your data and schema to the new platform.<\/p>\n![\"Database](\"https:\/\/i0.wp.com\/www.kindsonthegenius.com\/mssql\/wp-content\/uploads\/sites\/11\/2020\/12\/Database-Migration-Assistant.png?resize=300%2C180&ssl=1\")
<\/a>Database Migration Assistant<\/figcaption><\/figure>\nGet DMA for free here<\/a><\/p>\n <\/p>\n
9. SQL Web Data Administrator (SqlWebAdmin)<\/strong><\/h4>\nThis is one of the oldest tools for DBAs. SQLWebAdmin enables you to easily manage you SQL database server from\u00a0 anywhere via a browser interface. It allows you to perform the following from a web interface:<\/p>\n
\n- create, edit and manage databases in SQL Server<\/li>\n
- perform ad-hoc queries against databases and save them locally<\/li>\n
- import and export database schema and data<\/li>\n
- manage users and roles<\/li>\n
- create, view and edit stored procedure<\/li>\n<\/ul>\n
Download SqlWebAdmin from here<\/a><\/p>\n <\/p>\n
10. MySQL WorkBench<\/strong><\/h4>\nJust like the name suggest, MySQL Workbench is used for managing MySQL databases. It is a unified tool for both developers and DBAs. It can be used for data modelling, SQL development and database administration.<\/p>\n![\"MySQL](\"https:\/\/i0.wp.com\/www.kindsonthegenius.com\/mssql\/wp-content\/uploads\/sites\/11\/2020\/12\/MySQL-Workbench.png?resize=300%2C190&ssl=1\")
<\/a>MySQL Workbench<\/figcaption><\/figure>\n
<\/a>Download SQL Management Studio here for free<\/a><\/p>\n <\/p>\n This is a very important DBA tool for creating database documentation. With this tool you can import your database and then it reads your\u00a0 data schemas and then lets you provided description for data elements such as tables, columns, views and stored procedures.<\/p>\n Get Dataedo here.<\/a><\/p>\n <\/p>\n This tool created by Quest, helps you monitor and optimize your SQL server database performance. According to their website, you can do this from any device. Some of the benefits are:<\/p>\n Get Sportlight trial version here<\/a><\/p>\n <\/p>\n According to the SSDT documentation, this tools helps you to build SQL Server relational databases, Analytics Services(AS) data models, Integration Services(IS) packages and Reporting Services (RS) reports. To be used, SSDT is added as an extension to MS Visual Studio.<\/p>\n Read more here<\/a><\/p>\n <\/p>\n This is a performance monitoring and analysis tool developed by SolarWinds. It provides interface for visualising various aspects of the system including execution plans, SQL statements, blocking, deadlocks etc. It also provides realtime and historical analysis. According to their website, the features include:<\/p>\n You can try DPA for free here<\/a><\/p>\n <\/p>\n This is a very powerful IDE(Integrated Development Environment) from Microsoft that used for building applications.\u00a0 It includes code which supports intellisense and code refactoring. VS can easily be used to managed MS SQL server databases.<\/p>\n Download Visual Studio for free here<\/a><\/p>\n <\/p>\n Longitude is a database monitoring tool developed by Heroix for monitoring databases including Oracle, MS SQL and MySQL. According to their website, it proactively monitors for problem areas by evaluating key performance and availability metrics ensuring the at databases perform optimally. Some of the features include:<\/p>\n Get free trial here<\/a><\/p>\n <\/p>\n DMA provides the features for upgrade of a database by detecting potential compatibility issued that may impact the functionality of the new SQL Server version.\u00a0 It also recommends peformance and reliability improvements for the target environment. Then it allows you to efficiently move both your data and schema to the new platform.<\/p>\n Get DMA for free here<\/a><\/p>\n <\/p>\n This is one of the oldest tools for DBAs. SQLWebAdmin enables you to easily manage you SQL database server from\u00a0 anywhere via a browser interface. It allows you to perform the following from a web interface:<\/p>\n Download SqlWebAdmin from here<\/a><\/p>\n <\/p>\n Just like the name suggest, MySQL Workbench is used for managing MySQL databases. It is a unified tool for both developers and DBAs. It can be used for data modelling, SQL development and database administration.<\/p>\n2. Dataedo<\/strong><\/h4>\n
3. Sportlight<\/strong><\/h4>\n
\n
<\/a>4. SQL Server Data Tools(SSDT)<\/strong><\/h4>\n
5. SolarWinds Database Performance Analyzer (DPA)<\/strong><\/h4>\n
\n
6. Microsoft Visual Studio(VS)<\/strong><\/h4>\n
7. Longitude for Database Monitoring<\/strong><\/h4>\n
\n
8. Database Migration Assistance (DMA)<\/strong><\/h4>\n
<\/a>9. SQL Web Data Administrator (SqlWebAdmin)<\/strong><\/h4>\n
\n
10. MySQL WorkBench<\/strong><\/h4>\n
<\/a>