Devart Blog

Review Assistant Migration Issues

Posted by on November 18th, 2016

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 for this purpose. This article describes the problems you may encounter when migrating from SQLite to SQL Server and how to solve them.

Read the rest of this entry »

Use VirtualDataSet to access objects list via TDataSet interface

Posted by on November 18th, 2016

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!

Posted by on November 8th, 2016

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

Posted by on November 2nd, 2016

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.

There are a lot of benefits you get when generating database documentation automatically using dbForge Documenter for SQL Server. You don’t have to spend hours retrieving and writing technical information from scratch. Documenter builds an accurate and error-free documentation in just a few minutes. Besides, the documentation tool from Devart provides a rich set of features for customizing documentation output to meet your specific requirements.

Documenter presents documentation in an easy to view format, so you can share it with your boss or clients, other developers, DBAs, testers, project managers, business executives or other related persons.

The following example demonstrates how to generate documentation for the AdventureWorks2012 sample database.

Read the rest of this entry »

Devart was the Gold Sponsor of SQLSaturday #538 Sofia

Posted by on October 18th, 2016

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 this amazing conference.

We had a great time while communicating with the audience and demonstrating our tools for SQL Server. We also had a great opportunity to share thoughts and ideas, discuss challenges with the community professionals and our friends from Poland, Slovenia, Bulgaria and Ukraine! Read the rest of this entry »

Be ready to meet Devart at PASS Summit 2016

Posted by on October 11th, 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.

What?

Whether you are a data novice or a professional, PASS Summit is the place to find industry-leading speakers, in-depth training, technical tips and tricks, and connections to take your career to the next level. Read the rest of this entry »

Installation & Configuration of Devart ODBC Driver for QuickBooks

Posted by on August 3rd, 2016

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

Posted by on August 1st, 2016

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

Posted by on July 28th, 2016

The VirtualQuery component allows to perform SQL queries to sources, that are not a database, but a TDataSet or any its descendant. It also allows 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 »

SQL Server 2016 Stretch Database

Posted by on July 12th, 2016

SQL Server 2016 Stretch Database

On June 1, SQL Server 2016 was released. It brought a large number of novelties into normal development, including the long-announced Stretch Database technology that allows migrating data from SQL Server dynamically to Azure.

From the marketing point of view, Stretch Database has been well promoted. Reasonable arguments were stating that with the growth of historical data the complexity and cost of its maintenance grows as well. As a rational solution to the problem, the automatic migration of obsolescent archival data to the cloud was introduced. Frankly speaking, I enjoyed the idea.

As from SQL Server 2016 RC0, I began testing the Stretch Database technology on two projects I’m helping to develop. The first one is TMetric, a free time tracker with OLTP load, and the second one is an internal project with DW load.
Read the rest of this entry »