Devart Blog

dbForge SQL Server

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

Getting Real Currency Exchange Rates with Data Generator for SQL Server

Posted by on July 1st, 2016

This article will demonstrate how to get live currency exchange rates with the help of Python and dbForge Data Generator for SQL Server.

Currency exchange rate is the reference information used in the translation of monetary values from one currency to another. The exchange rate expresses the value of one currency in terms of another. (more…)

SQL Server Execution Plans

Posted by on April 12th, 2016

One of the best methods to analyze the query performance is to explore the query execution plan. A query plan or query execution plan is an ordered set of steps utilized to access data in a SQL relational database management system. In this article, we will discuss the basics of the Query Execution Plan feature available in SQL Server. (more…)

Generating Related Data Elements with dbForge Data Generator for SQL Server

Posted by on April 1st, 2016

Recently we got an interesting question from our user:

The docs don’t address directly, but how can we generate three related data elements, like date of birth, age, and date of death for instance, in one script efficiently as it generates test rows/records and then populate the fields in a test database table? If docs do address this, please point me to where, if you would… Thanks!

Another user has posted the similar question on the Devart support forum. (more…)

Backup and Restore Databases in SQL Server

Posted by on February 17th, 2016

In this article, we will talk about the benefits of backing up SQL Server databases, different backup types, and backup strategies.

The immediate purpose of creating database backups is the ability to recover a damaged database and minimize the risk of catastrophic data loss. Thus, a reliable use of backup and restore for recovery requires a backup and restore strategy. (more…)

How to Build a Database from Source Control

Posted by on December 24th, 2015

There is no doubt that database developers can and should benefit from using source control systems. Regardless of the type of source control system, developers also must think over the development model. They must also consider how they wish to build and deploy databases from source control.

In this article, we will discuss several approaches of how to build databases form source control. (more…)

XML, XQuery & Performance Issues

Posted by on December 21st, 2015

In this article, we will discuss some pitfalls related to XML and XQuery that may lead to performance issues.

The following code will generate a test XML file:
(more…)

Devart was the Sponsor of Ukrainian Data Community Kyiv

Posted by on December 16th, 2015

We were more than happy to take part in the New Year meeting of Ukrainian Data Community in Kyiv on 15 Dec 2015. It was the great event, where we had a great chance to talk to the community and present our products to the wide audience of professionals.

There were two outstanding speakers that shared their knowledge to the visitors:

Alexander Kalenik: Using Columnstore indexes in MS SQL Server (2012, 2014, 2016CTP3).

Alexander Kalenik is Microsoft CIS technology lead, Senior Premier Field Engineer for areas of SQL Server and Windows Cluster. He is working for Microsoft almost 9 years. He has a big experience in SQL Server from 1991. He is author of books about SQL Server and author of 2 blogs on TechNet for areas SQL Server and Windows Cluster. Alexander is PHD in area of Computer Science.

Vitalii BondarenkoDive into Hadoop (HDInsight): common Big Data analysis scenarios on Microsoft Azure

Vitalii is a DW/BI/ETL Architect and Technical Lead experienced in OLAP and OLTP systems design, performance tuning and administration. Total professional record includes about 15 years of experience in software applications and Database design and development which contains about 8 years of experience in MSSQL Server.

We would like to thank the organizer of the event — Denis Reznik. We are looking forward to the next meetings!

Devart supports User Groups and provides sponsorship for different events. We are looking forward to your sponsorship requests! E-mail us a brief summary of your event or User Group meetup.

DSC08282_Ukrainian_Data_Community_Kyiv_Dec_2015DSC08283_Ukrainian_Data_Community_Kyiv_Dec_2015DSC08284_Ukrainian_Data_Community_Kyiv_Dec_2015DSC08259_Ukrainian_Data_Community_Kyiv_Dec_2015DSC08264_Ukrainian_Data_Community_Kyiv_Dec_2015DSC08265_Ukrainian_Data_Community_Kyiv_Dec_2015DSC08277_Ukrainian_Data_Community_Kyiv_Dec_2015DSC08278_Ukrainian_Data_Community_Kyiv_Dec_2015

Devart was the Silver Sponsor of SQL Saturday #426 at Lviv

Posted by on December 9th, 2015

Devart was a Silver sponsor of SQLSaturday #426 that was held on 5 Dec 2015 at Lviv, Ukraine.

We would like to thank the organizers: Sergey LunyakinAndrey Zrobok, and all speakers for the outstanding event! Our special thanks to Eugene Polonichko for the assistance :)

We highly appreciate the opportunity to share thoughts and ideas, discuss challenges as well as to present our software products to the professional community.

Devart supports User Groups and provides sponsorship for different events. We are looking forward to your sponsorship requests! E-mail us a brief summary of your event or User Group meetup.

1234 5678

SQL Server Typical Maintenance Plans: Automatic Statistics Update

Posted by on December 1st, 2015

Some time ago, we reviewed the automation of index defrag. Now, it is time to look at statistics.

First of all, what do we need statistics for?

During execution of any query, query optimizer is trying to build an optimal execution plan (within the limits of available information). The plan constitutes the operations sequence, by means of which you can get the result described in the query.

While selecting one or another operation, the query optimizer considers statistics, that describes value distribution for columns within a table or index, as one of the most significant input data resources.

(more…)