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.
Read the rest of this entry »How to Restore a MySQL Database with Command Line or Restore Tools
The article gives a deep insight into how to restore MySQL database from a backup file using the mysqldump utility and third-party backup and restore tools, such as dbForge Studio for MySQL, MySQL Workbench, and phpMyAdmin.
Don’t Miss the Latest Maintenance Update of SQL Complete 6.9
Here comes the maintenance update of dbForge SQL Complete, your favorite SSMS and Visual Studio add-in for context-sensitive code autocompletion, formatting, and refactoring.
Read the rest of this entry »How to Automatically Track Database Schema Changes With PowerShell Scripts
In the article, you will find a detailed guide on how to automatically monitor a SQL Server database for schema changes and automatically create a report and log file. The examples of scripts to set up the process are provided.
Read the rest of this entry »How to Export SQL Server Data to an Excel File
If you are in search of the optimal way to export data from SQL Server to Excel spreadsheets, look no further. Just check this article. Here we tried to gather together different methods—any of them could turn out to be useful for your particular case. Without further ado, let’s get started!
Read the rest of this entry »PostgreSQL 14 Support in dotConnect for PostgreSQL
Devart is glad to announce support for the latest PostgreSQL version — PostgreSQL 14 — in dotConnect for PostgreSQL 7.22. Now you can connect to PostgreSQL 14, work with stored procedures, returning data via OUT parameters, and multirange data types in your .NET projects.
Read the rest of this entry »Understanding a SQL Schema
The article describes the basics of a database schema, the advantages of using schemas, and covers how to create, modify, and delete them in the SQL Server database.
Read the rest of this entry »PostgreSQL ADD COLUMN Statement to Add One or Multiple Columns To a Table
If you have been looking for a tutorial on the ALTER TABLE command in Postgres, your search ends here. This statement changes the definition of an existing table. In this article, we will be focusing on the ALTER TABLE ADD COLUMN syntax, which narrows down the functionality of ALTER TABLE to a single action: adding a column. We will walk you through different ways of adding a column using the command line, and also, a convenient GUI tool for PostgreSQL.
The Industry Leader Again: Devart ODBC Drivers are Awarded the G2 High Performer and GetApp Category Leader 2021
Fall is the time to reap the rewards!
The Devart team has been hard on bringing you the best-in-class ODBC connectors. We are delighted to announce that our ODBC drivers were highly recognized by the software review websites – G2 and GetApp – based on rates and reviews from real users.
Read the rest of this entry »MySQL Performance Monitoring Tools and the Most Important Metrics to Monitor
The article covers the key performance metrics available in MySQL that can help users improve and optimize query performance in MySQL databases. In addition, there is a brief overview of some MySQL performance monitoring tools.
Read the rest of this entry »