dbForge Team posts

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

Posted by on July 27th, 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

Posted by on July 16th, 2015

While working on the new version of SQL Complete, we focused on adding the most needed features discussed on Devart’s uservoice site – 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

Posted by on May 19th, 2015

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

Posted by on April 23rd, 2015

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:




Adding Timestamp to a Filename

Posted by on January 23rd, 2015

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.


Devart Sponsored SQLSaturday #363 – Nashville 2014

Posted by on January 21st, 2015

Devart was excited to participate at the 363d edition of SQLSaturday as a sponsor. The event took place on January 17, 2015 at the Lipscomb University, Nashville, USA. SQLSaturday’s are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. (more…)

Analyzing SQL Server Events with help of Events Profiler

Posted by on January 12th, 2015

dbForge Studio for SQL Server provides the SQL Events Profiler tool that captures SQL Server events from a server. The events are stored in a trace file. The trace file can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem. Events Profiler shows how SQL Server executes queries internally. This allows you to see exactly what T-SQL statements are submitted to the server and how the server accesses the database to return result sets.
You can use this tool for:

  • Stepping through problem queries to find the root of the problem.
  • Finding and diagnosing slow-running queries.
  • Capturing the series of T-SQL statements that lead to a problem.
  • Monitoring the performance of SQL Server to tune workloads.
  • Correlating performance counters to diagnose problems.


Using HTTP Tunneling

Posted by on December 22nd, 2014


This article elaborates on the HTTP Tunneling connection method and explains how to configure it by means of dbForge Studio for MySQL.

Introducing HTTP Tunneling

HTTP tunneling is a method of connecting to a MySQL Server through HTTP/HTTPS protocol and via the port that is used by a web server. The method may come  in useful when a direct connection to MySQL Server, that utilizes port 3306, is problematic for certain reasons, e.g. it is closed by security reasons, or firewall blocks access from all network protocols, except HTTP. Since port 80, that is used by web server, cannot be blocked, HTTP tunneling seems to be the ultimate technique to solve a range of MySQL connection issues.


Adventures of CLR Types in .Net Framework

Posted by on November 28th, 2014

Summary: This article describes the issue occurred with execution of the a polygon instance of the geography type and the possible solution for it.

Once I stumbled upon the following query:

SET @g1 = geography::Parse(‘POLYGON ((0 0, 1 0, -1 1, 2 2, 0 0))’);

The query seemed to be quite valid and SSMS executed it smoothly, but nevertheless dbForge Studio for SQL Server failed  to execute it.

In SQL server Management Studio 2014, the query after execution returns the following binary serialized instance of the Geography data type:


During deserialization of the aforesaid value, dbForge Studio threw an exception, and I was destined to get to the bottom of the issue. Making no question of the value validity, I decided to write a test .NET application to localize the problem.


Devart Attended the Second Meeting of Lviv SQL Server User Group as a Sponsor

Posted by on October 28th, 2014

Devart gladly participated as a sponsor on the second meeting of the Lviv SQL Server User Group that took place on October 25, 2014.

About Lviv

Lviv is a cultural and economic center of West Ukraine. Rich history and a lot of old buildings make Lviv one of the most interesting and exciting places in Ukraine.

About Lviv SQL Server User Group Meeting

Lviv SQL Server User Group has a status of PASS Local Chapter (Professional Association for SQL Server) and is a part of PASS’s Global Growth for supporting of MS SQL Server professionals and connecting the community around the world. This meeting was devoted to such topics as Database Version Control and Microsoft Business Intelligence.

In the course of the event, Devart presented the product line of dbForge Tools for SQL Server. (more…)