Andrey Langovoy posts

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

How to Build a Database from Source Control

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

Devart was the Sponsor of Ukrainian Data Community Kyiv

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

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

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

SQL Server Index Fragmentation In-depth

There is no way to avoid index fragmentation in any SQL Server environment. It does not depend on your SQL Server version or I/O subsystem you have, or your hardware. In this article, we will drill down into SQL Server index fragmentation issue. We will figure out why index fragmentation is a problem and how it affect on overall performance, discuss how to detect and avoid it. (more…)

A Look Back at PASS Summit 2015

PASS Summit 2015 has ended a little more than a week ago and we are already looking forward to what’s next in 2016.

PASS Summit is the world’s largest conference for Microsoft SQL Server and BI professionals where participants have a great chance to attend a wide variety of technical sessions presented by world-recognized experts and industry leaders. Also, it is a great opportunity to have a face to face talk with developers from leading software development companies and get the latest news from the first hand. (more…)

Devart was the Gold Sponsor of SQLSaturday #406 – Kharkiv 2015

Devart was the Gold sponsor of SQLSaturday #406, that was held on SEP 19, 2015 in Kharkiv, Ukraine. (more…)

Generate Meaningful Test Data with Data Generator for SQL Server

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

Capturing SQL Server Trace Data

One of the best ways to gather information about SQL Server workloads is to capture trace information. In this article, we will look at how to use SQL Trace and Server Events Profiler for tracing SQL Server activity. You can use this information for auditing, monitoring and troubleshooting SQL Server performance. This article is intended for DBAs who need to collect information about workloads running on SQL Server for analytic purposes. (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.

(more…)