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 process.
Cloud technologies develop rapidly, more and more data is stored in the cloud. Read the rest of this entry »

Review Assistant Migration Issues

Starting from version 3.5, Review Assistant uses Microsoft’s SQL Server as an engine for its back-end database. The previous versions of Review Assistant have been using SQLite Read the rest of this entry »

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. TVirtualDataSet behaves the same way as any other TDataSet descendant and, therefore, it is compatible with all data-aware controls. However, it does not store data in memory. Work with TVirtualDataSet is implemented by means of events occurring during data exchange between an application and controls. As a result, you can choose a variety of entities as a data storage source: arrays, lists, records, XML files, etc. Read the rest of this entry »

PASS Summit 2016 Wrap-Up!

A look back at PASS Summit 2016

We were leaving Seattle inspired. PASS Summit 2016 has ended two weeks ago and we are already looking forward to what is next in 2017. By the way, organizers welcome you to register for PASS Summit 2017. Read the rest of this entry »

How to automatically generate SQL Server documentation

In this blog post, we will learn how to quickly create a comprehensive documentation of an SQL Server database using dbForge Documenter for SQL Server, a database documentation generator from Devart. Read the rest of this entry »

Devart was the Gold Sponsor of SQLSaturday #538 Sofia

Devart was the GOLD sponsor of SQLSaturday #538, that was held on 15 October 2016 in Sofia, Bulgaria.
Mihail Mateev, Genoveva Andreeva, and other team members and volunteers, we would like to say THANK YOU very much for organizing Read the rest of this entry »

Be ready to meet Devart at PASS Summit 2016

Where?

We are more than happy to announce that our team is going to attend PASS Summit 2016. The event will take place on October 25 – 28 in Seattle, WA, USA. Read the rest of this entry »

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 account, and provides a demo sample of retrieving QuickBooks account data using Microsoft SQL Server Management Studio.

Read the rest of this entry »

Tidy SQL with dbForge 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 from messy and unformatted code. In addition, we will talk about how to force all team members to adhere generally accepted coding standards with no efforts. Read the rest of this entry »

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 its descendant. It also allows you to connect to several data sources at a time and work with them using SQL queries as with a single data source. Thus, work in heterogeneous environment is implemented, when execution results of queries to different sources can be retrieved in a single data set. Read the rest of this entry »