Previously we looked at some of the most common native Azure tools for SQL databases. These included Data Studio, Powershell, SSMS, Explorer, and more. Today, we will go through some common tools offered by dbForge Studio. dbForge Studio was created by Devart, and its tools are supported by Azure for…

In the previous article, we discussed the top ApexSQL tools used in the Azure SQL database. In this one, I will be taking you through the top native Azure tools used for database management. So let’s get into it. Azure Data Studio The Azure Data Studio is a rich environment for coding. One…

If you are already familiar with other SQL databases but new to PostgreSQL, then this article is perfect for you. It will help you understand the nuances and get started with PostgreSQL. Note: Most comparisons in this article are targeted towards MySQL since it is the closest open source database…

If you find yourself reading this post, there are very good chances that you find yourself in the shoes of a MySQL database administrator, a database-savvy developer, or even a sysadmin. …

Microsoft Azure has a robust set of SQL database tools to cover you for every operation you may need. These include fundamental tasks such as creating and managing databases or allowing you to automate database-related tasks, test data generators, and more. What truly makes the Azure family user-friendly is its…

Count queries are probably the most-used aggregate queries in a relational database. Counting is a fundamental operation required for many CRUD applications like sorting, pagination, and searching. But counting records can become terribly slow as your dataset grows. Fortunately, there are strategies for dealing with this problem. …