What’s New

SQL Server 2016 RC0

The news about Microsoft’s intention to “chum” SQL Server with Linux keeps floating around. But I haven’t heard a single word about SQL Server 2016 Release Candidate, that recently became available for download. (more…)

SQL Server 2016 CTP3.1 – What’s New for Developer?

Not that long ago, I remember Microsoft’s CEO Satya Nadella has been announcing a new version of SQL Server 2016. And all of a sudden fresh Community Technology Preview versions started appearing one by one (currently the latest version is CTP3.1). Having tested the new version, I would like to share my impressions.

I will now review the new T-SQL syntax features of SQL Server 2016: JSON, GZIP, DROP IF EXISTS, TRUNCATE TABLE by partitions… (more…)

Using Batch Updates in Delphi Data Access Components

Data amount processed by modern databases grows steadily. In this regard, there is an acute problem – database performance. Insert, Update and Delete operations have to be performed as fast as possible. Therefore Devart provides several solutions to speed up processing of huge amounts of data. So, for example, insertion of a large portion of data to a DB is supported in the Loader. Unfortunately, Loader allows to insert data only – it can’t be used for updating and deleting data.

The new version of Devart Delphi Data Access Components introduces the new mechanism for large data processing — Batch Operations. The point is that just one parametrized Modify SQL query is executed. The plurality of changes is due to the fact that parameters of such a query will be not single values, but a full array of values. Such approach increases the speed of data operations dramatically. Moreover, in contrast to using Loader, Batch operations can be used not only for insertion, but for modification and deletion as well.

(more…)

Generate Meaningful Test Data with Data Generator for SQL Server v3.5

Why meaningful test data important?

While developing an application, you need to make sure you are testing it under conditions that closely simulate a production environment. Most tests rely on sample data for testing. If you manually enter data into a test environment, one record at a time using the UI, most probably, you will never build volume and variety of data that your app will accumulate in a few days in production. It is obviously that the behavior will differ. Most likely, the data you insert into a test database will be based on your own usage patterns and will not match real-world usage, leaving significant bugs untested. (more…)

SQL Complete Enhanced Functionality

While working on the new version of SQL Complete, we focused on adding the most needed features discussed on Devart’s uservoice site – devart.uservoice.com. Here, users leave their feedbacks regarding any of the Devart’s products as well as vote for new features to be added. Thus, we do our best to address user needs for most desirable functionality. This is an early preview of the upcoming functionality that will be available in SQL Complete v5.0!

In this article, we will discuss newly added features that will speed up and simplify SQL code writing. (more…)

Support for RAD Studio XE7 is added to all the Devart components for Delphi!

Dear users,
DAC Team claims its products to be up-to-date and feature-rich solutions for Delphi developers. We are always trying our best to remain at the edge of programming technologies and cross-platform application development. Support for RAD Studiio XE7 was one of those high-priority tasks… And now we are happy to announce the new versions of already beloved products for Delphi programmers with support for the cutting-edge IDE:

Devart is grateful for your choice and won’t short-sell you.

Thank you for staying with us!

Best wishes!

DAC Team

Oracle 12c Support and More New Features in New Versions of Devart Products

Devart releases new versions of its products: LinqConnect ORM solution, dotConnect ADO.NET data providers, and ORM designer – Entity Developer. The main new feature in dotConnect for Oracle, LinqConnect, and Entity Developer is the support for the latest release of Oracle Database – Oracle 12c. Additionally, dotConnect data providers offer you Sync Framework support, improved PgSqlDump component, load balancing support in dotConnect for MySQL, and other features. This article describes the new features in details.
(more…)

Tweak for ‘Simple Review Workflow’

Summary: In Review Assistant 2.0 we have modified the simple review workflow. Now it is possible to add a code-related comment and accept author’s changes, and at the same time leave the review open.

 

This is the fifth article in the series of What’s New in Review Assistant 2.0

How does simple review workflow work?

There are three review roles by default:

  • Author — the person who creates code.
  • Reviewer — the person who inspects code.
  • Moderator — the person who double checks a review and settles disputes.

Here is how it looks like in the application:

(more…)

Iterative Code Review 2.0

Summary: This article describes improvements we have introduced into the iterative code review process — the distinctive Review Assistant feature.

This is the fourth article in the series of What’s New in Review Assistant 2.0

What is iterative code review?

Iterative code review refers to the situation when a single piece of work is reviewed more than once by the same reviewer.
In fact this is a regular case. None of major changes in code will pass without reviewers comments. They find bugs and faults which an author should fix, and then show the code over again.
The Review Assistant documentation contains more detailed description of the iterative code review.
Not all code review tools support repetitive code inspections within a single review. Review Assistant has been providing this feature since the first release. In Review Assistant 2.0 we have significantly improved this process.
(more…)

Reviewing Code from Multiple Repositories in One Review

Summary: This article describes new Review Assistant features, namely: the possibility to work with several repositories within a single review, and also the possibility to add nested repositories into a project.

This is the third article in the series of What’s New in Review Assistant 2.0

While working on a large scale projects it is not uncommon that the source code is stored in more than one repositories. Devart’s own projects are not an exception.

From the very first release of Review Assistant there was the possibility to associate several repositories with a single project. However, while creating a new review there was only the possibility to add files from one repository.
(more…)