How To
Installation & Configuration of Devart ODBC Driver for QuickBooks
The article describes installation and configuration of Devart ODBC Driver for QuickBooks on Windows, as well as authorization and connection to a QuickBooks...
Tidy SQL with SQL Complete
In this article, we will talk about how to keep SQL code clean and highly readable. We will also discuss how to stop suffering...
How to Combine Data from Several Sources Using SQL and VirtualQuery
The VirtualQuery component allows executing SQL queries to sources that are not a database, but a TDataSet or any of its descendants. It also...
Getting Real Currency Exchange Rates with SQL Server Data Generator
This article will demonstrate how to get live currency exchange rates with the help of Python and dbForge Data Generator for SQL Server.
The currency...
Migrating Entity Framework 6 projects to Entity Framework Core 1 (EF7)
For the purpose of this tutorial, we will use a test project from the "Entity Framework 6 Support for Oracle, MySQL, PostgreSQL, SQLite, DB2,...
Generating Related Data Elements with SQL Data Generator
Recently we got an interesting question from our user:
The docs don't address directly, but how can we generate three related data elements,...
MySQL Case Sensitive Search in Entity Framework
A high level abstraction provided by Entity Framework sometimes challenges developers in accessing a full set of features available via native SQL of a...
Backup and Restore Databases in SQL Server
In this article, we will talk about the benefits of backing up SQL Server databases, different backup types, and backup strategies.
The immediate purpose of...
Enabling AUTO_CLOSE Is a Bad Idea?
From a personal perspective, allowing a production database to run with AUTO_CLOSE option is not the best practice. Let me explain why you should...
What is faster inside SUM & AVG: 0 or NULL?
There are three aggregate functions that are most often used in practice: COUNT, SUM and AVG. The first one has already been discussed previously,...
