ADO.NET is a part of .NET Framework that provides access to different types of data sources. ADO.NET supports relational, XML and application data. ADO.NET...
If you are using any dbForge tools for SQL Server, MySQL, Oracle, and/or PostgreSQL, please make sure you have read this post.
Recently, Microsoft released...
SDLC (Software Development Life Cycle) is a series of steps for developing, improving, and sustaining a software system. Learn more about the stages and best practices.
Sometimes we cannot...
Microsoft Visual Studio plugins continuously compete to empower users with extended capabilities. Free tools have the most obvious advantage — while you don't have...
Most modern websites and applications ground on data collection, storage, and analysis. Databases take an active part in building the entire Web environment. That’s...
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...
Every single year new products and new versions of the leading tools enter the market. Their providers compete, offering database specialists more and more...
The overwhelming popularity of MySQL means that people need convenient database tools to work with it. Software providers compete to produce the best MySQL...
This article explains how to establish an SSL connection to MySQL from Delphi with UniDAC and SecureBridge.
UniDAC has had MySQL SSL (using certificates) connection...
Maintenance of databases or servers is quite often performed by database administrators at night. But these routines sometimes get blocked by long-running queries...
This article will outline two approaches to performing regular database backups. The first method involves backing up databases specified in a list, while the second entails bulk backing up of all databases. These procedures can be executed on both Linux and Windows platforms using dbForge Studio for MySQL.
Recent versions of MySQL and PostgreSQL databases provide JSON functionality support. They introduced special data types, storing JSON data - json data type in...
A high level abstraction provided by Entity Framework sometimes challenges developers in accessing a full set of features available via native SQL of a...
Summary
This article elaborates on the HTTP Tunneling connection method and explains how to configure it by means of dbForge Studio for MySQL.
Introducing HTTP Tunneling
HTTP...
Entity Framework v5 and v6 support spatial data types. They are represented as two DbGeometry and DbGeography data types from System.Data.Entity.dll in .NET Framework...
Introduction
MySQL database supports an advanced functionality of full-text search (FTS) and full-text indexing described comprehensively in the documentation:
Full-Text Search Functions (MySQL 5.5 stable...
Merry Christmas and Happy New Year!
As Christmas holidays are drawing closer, we offer you to get 20% off any product license order.
Don’t think twice,...
With Database Designer database can be created from a sketch without using any external image-viewers. Database Designer tool available in dbForge Studio for MySQL serves for creating database diagrams visually.
Devart made it to the final of 2010 DevProConnections Community Choice Awards. The awards recognize the best products and services in the industry by...