Andrey Langovoy posts

PASS Summit 2016 Wrap-Up!

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

Devart was the Gold Sponsor of SQLSaturday #538 Sofia

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

Be ready to meet Devart at PASS Summit 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. (more…)

Tidy SQL with dbForge SQL Complete

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

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…)

Devart is the GOLD sponsor of SQLSaturday #508 – Kiev 2016

Devart sponsored SQLSaturday #508, that took place on May 21, 2016 in Kiev, Ukraine.

Besides databases, there were a lot of interesting sessions on the popular topics: BI, Data Science, Big Data, Machine Learning, and others. (more…)

Devart attended and sponsored SQL Day 2016 — Annual Conference of Polish SQL Server User Group Association

Devart was excited to participate and sponsor SQL Day 2016 that took place on May 16 – 18 in Wrocław, Poland. The event has ended less than a week ago and we are already looking forward to what’s next in 2017!
SQLDay is the largest Microsoft data platform summit in the East Central Europe. (more…)

SQL Server Execution Plans

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

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

Backup and Restore Databases in SQL Server

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…)