dbForge Team posts

Devart was the Gold Sponsor of SQL Saturday #616

SQL Saturday #616 was the biggest training event for SQL Server professionals and those wanting to learn about SQL Server in Ukraine. The event was held on May 20, 2017, in Kiev, Ukraine. (more…)

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. (more…)

Devart Took Part in the Kharkiv International Marathon

Devart team took part in the 3rd Annual Kharkiv International Marathon, that took place on April 9, in city of Kharkiv, Ukraine.

Gorgeous sunny weather, wonderful organization and cheerful atmosphere helped our runners to get through both, 4.2K ad 10K runs and finish with pretty good results.

(more…)

IT NonStop 2015 – Kharkiv (Ukraine)

The international IT conference IT NONSTOP was held in Kharkiv (Ukraine) on November 28, 2015 and gathered a lot of enthusiastic participants.

A speaker of the conference, Syrovatchenko Sergey (SQL Server DBA / DB Consultant from Devart) talked to the participants of the conference about the «Mortal sins in the development on SQL Server». Here is a brief of his report:

“When people start to deal with something new, they pass though thorny path of trial and error. In my report, I tried to give a list of “traps” I got in many times when I’d just started working with SQL Server. Typical errors relating to filtering values, implicit type conversion, and the proper use of indexes were briefly discussed…”

Awarding dbForge Studio license during the event was a pleasant bonus.
(more…)

How to generate SQL Linked List Data with Python Generator

In this post, we would like to show how to quickly generate table values that are based on the values of another column of same table. For this purpose, we will use the Python Generator being a part of dbForge Data Generator for SQL Server.

First, let’s create a test table using the following script:

CREATE TABLE [dbo].[TestLinkedListTable](
[id] [int] NULL,
[name] [nchar](100) NULL,
[previous_id] [int] NULL,
[next_id] [int] NULL
)
GO

(more…)

Devart was the Bronze Sponsor of SQLSaturday #416 – Odessa 2015

Devart was a Bronze sponsor of the 416th edition of SQLSaturday, that was held on July 25, 2015 in Odessa, Ukraine.

We would like to thank the organizers of the event – Anton Vidishchev, Oleg Chorny and Alex Tumanoff, and all speakers for the remarkable event! We highly appreciated the opportunity to share thoughts and ideas, discuss challenges as well as to present our software products to the professional community. (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…)

Devart was the GOLD sponsor of Annual Conference of Polish SQL Server User Group

Devart was the GOLD sponsor of the SQL Day | Annual Conference of Polish SQL Server User Group, which was held on the 11th – 13th May 2015 in Wrocław, Poland.

We would like to thank the organizers and speakers for the wonderful conference! Our special thanks to Maciej Pilecki and Katarzyna Nieradka for the assistance and warm welcome. We have had a great chance to meet new people, exchange views, and present our software products to the wide audience. (more…)

How to specify parameters in a report through the command line

dbForge Studio for SQL Server gives you an opportunity of automating the variety database management processes. One of them is specifying parameters in a report making use the command line.

The /parameters switch is used to specify values for parameters declared in a query script. To perform this task, you need only type the name of a parameter you want to assign a value to and its correspondent value, like this:

<param_name1>:<param_value1>
<param_name2>:<param_value2>

<param_namen>:<param_valuen>

(more…)

Adding Timestamp to a Filename

Summary: This article describes how to add time and date to a filename using the command line.

Sometimes it is crucial to append time and date to the name of a file. For example, we would like to have separate log files for each execution of data synchronization script. To prevent file overriding, we want to specify date and time in the name of each log file.

(more…)