Devart Blog

dbForge SQL Server

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

How to generate SQL Linked List Data with Python Generator

Posted by on November 30th, 2015

In this post, we would like to show how to quickly generate table values that are based on the values of another column of same table. For this purpose, we will use the Python Generator being a part of dbForge Data Generator for SQL Server.

First, let’s create a test table using the following script:

CREATE TABLE [dbo].[TestLinkedListTable](
[id] [int] NULL,
[name] [nchar](100) NULL,
[previous_id] [int] NULL,
[next_id] [int] NULL
)
GO

(more…)

A Look Back at PASS Summit 2015

Posted by on November 5th, 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

Posted by on September 21st, 2015

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

Devart was the Bronze Sponsor of SQLSaturday #416 – Odessa 2015

Posted by on July 27th, 2015

Devart was a Bronze sponsor of the 416th edition of SQLSaturday, that was held on July 25, 2015 in Odessa, Ukraine.

We would like to thank the organizers of the event – Anton Vidishchev, Oleg Chorny and Alex Tumanoff, and all speakers for the remarkable event! We highly appreciated the opportunity to share thoughts and ideas, discuss challenges as well as to present our software products to the professional community. (more…)

SQL Complete Enhanced Functionality

Posted by on July 16th, 2015

While working on the new version of SQL Complete, we focused on adding the most needed features discussed on Devart’s uservoice site – devart.uservoice.com. Here, users leave their feedbacks regarding any of the Devart’s products as well as vote for new features to be added. Thus, we do our best to address user needs for most desirable functionality. This is an early preview of the upcoming functionality that will be available in SQL Complete v5.0!

In this article, we will discuss newly added features that will speed up and simplify SQL code writing. (more…)

How to specify parameters in a report through the command line

Posted by on April 23rd, 2015

dbForge Studio for SQL Server gives you an opportunity of automating the variety database management processes. One of them is specifying parameters in a report making use the command line.

The /parameters switch is used to specify values for parameters declared in a query script. To perform this task, you need only type the name of a parameter you want to assign a value to and its correspondent value, like this:

<param_name1>:<param_value1>
<param_name2>:<param_value2>

<param_namen>:<param_valuen>

(more…)

Devart Sponsored SQLSaturday #363 – Nashville 2014

Posted by on January 21st, 2015

Devart was excited to participate at the 363d edition of SQLSaturday as a sponsor. The event took place on January 17, 2015 at the Lipscomb University, Nashville, USA. SQLSaturday’s are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. (more…)