HomeHow To

How To

How to retrieve data from Dynamics 365 to MS Access Using ODBC

Custom relational management is very important once you run a business. It helps to improve marketing strategy, sales and customer service. There are many...

How to import data to Excel using ODBC

In this article, we will discuss how to access data using ODBC driver in Microsoft Excel. We will examine in detail the data retrieving...

Use VirtualDataSet to Access Objects List via TDataSet Interface

TVirtualDataSet is a virtual dataset that can be used as an intermediate between data stored in an application and data-aware controls used in forms....

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...

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,...

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...

Increasing SQLite Performance

One the major issues a developer encounters when using the SQLite DBMS in his applications is its performance issue. Perhaps, a classic case everyone gets...

SQL Server Typical Maintenance Plans: Automated Database Backups

There are a lot of posts appealing to one simple truth – need perform backups on a regular basis. People will always be divided...

SQL Server Index Fragmentation In-depth

In this article, we will drill down into the SQL Server index fragmentation issue and how to tackle it. We will figure out why index fragmentation is a problem and how it affects overall performance and discuss how to detect and avoid it.

Social

Topics

Products