Devart Blog

dbForge SQL Server

How to automatically generate SQL Server documentation

Posted by on November 2nd, 2016

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.

There are a lot of benefits you get when generating database documentation automatically using dbForge Documenter for SQL Server. You don’t have to spend hours retrieving and writing technical information from scratch. Documenter builds an accurate and error-free documentation in just a few minutes. Besides, the documentation tool from Devart provides a rich set of features for customizing documentation output to meet your specific requirements.

Documenter presents documentation in an easy to view format, so you can share it with your boss or clients, other developers, DBAs, testers, project managers, business executives or other related persons.

The following example demonstrates how to generate documentation for the AdventureWorks2012 sample database.

(more…)

Devart was the Gold Sponsor of SQLSaturday #538 Sofia

Posted by on October 18th, 2016

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 this amazing conference.

We had a great time while communicating with the audience and demonstrating our tools for SQL Server. We also had a great opportunity to share thoughts and ideas, discuss challenges with the community professionals and our friends from Poland, Slovenia, Bulgaria and Ukraine! (more…)

Be ready to meet Devart at PASS Summit 2016

Posted by on October 11th, 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.

What?

Whether you are a data novice or a professional, PASS Summit is the place to find industry-leading speakers, in-depth training, technical tips and tricks, and connections to take your career to the next level. (more…)

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