database administration

The Difference Between an IDE and a Code Editor

How would you like to get your daily coding done? Fast? Obviously. In neither repetitive nor monotonous manner? Naturally. With all of the tools, you might need always at hand? Yes, definitely.

Whether you are going to get it all or not depends on where you choose to write your code. Your two primary options here are either a code editor or an IDE. Both are designed to make your coding easier—however, in different ways.


How to Switch From SSMS to dbForge Studio Effortlessly

If you are reading this, chances are that you are an active user of Microsoft SSMS. And following the title that has brought you here, you may ask us: why should you bother switching? What should dbForge Studio ever offer to make you leave the convenient familiarity of SSMS?


SQL Query Optimization: How to Tune Performance of SQL Queries

In the article, we are going to examine how to optimize SQL queries and improve query performance by using SQL query optimization tips and techniques, such as execution plans, indexes, wildcards, and many others.


How to Create Login, User, and Grant Permissions in SQL Server

In the article, we are going to examine how to create a new user account and grant/revoke permissions and roles on a database object, as well as how to check SQL Server user permissions on the database using T-SQL and dbForge Studio for SQL Server.


How to Connect to MySQL Server

In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server.


How to View MySQL Server Log Files

Sooner or later, every developer and DBA faces the necessity to find out the reasons for slow database performance. This article will take a detailed look at how to set up MySQL Server logging, what types of MySQL Server logs exist, and how to work with them.