sql server

SQLSaturday is an annual conference devoted to SQL Server, Business Intelligence, and Analytics. Among the topics discussed this year are data store, collection, optimization, visualization, scaling, data science, machine learning, big data, security, etc. (more…)

Devart was a sponsor of SQLSaturday#660 held on August 19, 2017, in Lviv, Ukraine.

We were very glad to take part in the event, talk to visitors, make new acquaintances and support our Ukrainian SQL Server community. (more…)

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

On June 1, SQL Server 2016 was released. It brought a large number of novelties into normal development, including the long-announced Stretch Database technology that allows migrating data from SQL Server dynamically to Azure. (more…)

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

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

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

The news about Microsoft’s intention to “chum” SQL Server with Linux keeps floating around. But I haven’t heard a single word about SQL Server 2016 Release Candidate, that recently became available for download. (more…)

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