As Telerik announced a few months ago in their blog, they deprecated visual designer and Visual Studio tools for their Data Access ORM (formerly, OpenAccess ORM) – a very popular and p… Read 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… Read More

A high level abstraction provided by Entity Framework sometimes challenges developers in accessing a full set of features available via native SQL of a particular database server. This artic… Read 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… Read More

From a personal perspective, allowing a production database to run with AUTO_CLOSE option is not the best practice. Let me explain why you should not enable AUTO_CLOSE and the consequences o… Read More

There are three aggregate functions that are most often used in practice: COUNT, SUM and AVG. The first one has already been discussed previously, while the other two have interesting perfor… Read More

DBA has a number of duties that are primarily targeted at supporting of database performance capabilities and data consistency. The administrator can use the CHECKDB command to easily verify… Read More

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… Read More

Recently I’ve got a spare minute to see why an old test server was running too slow… I had nothing to do with this, but I was very anxious to find out what was wrong with the se… Read More

One the major issues a developer encounters when using the SQLite DBMS in his applications is its performance issue. Perhaps, a classic case everyone gets into when using SQLite for the firs… Read More

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: USE AdventureWorks2012 GO… Read More

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… Read More

I have always liked simple questions with lots of pitfalls. Here is the one: how do you count the total number of records in a table? At first sight, it’s a snap, but if you dig a litt… Read More

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 Lunyakin, Andrey Zrobok, and a… Read More

Not that long ago, I remember Microsoft’s CEO Satya Nadella has been announcing a new version of SQL Server 2016. And all of a sudden fresh Community Technology Preview versions starte… Read More