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,...
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...
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...
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,...
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.
You can connect to...
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...
