Products
MySQL Case Sensitive Search in Entity Framework
A high level abstraction provided by Entity Framework sometimes challenges developers in accessing a full set of features available via native SQL of a...
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...
Enabling AUTO_CLOSE Is a Bad Idea?
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...
What is faster inside SUM & AVG: 0 or NULL?
There are three aggregate functions that are most often used in practice: COUNT, SUM and AVG. The first one has already been discussed previously,...
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...
How to reduce MSDB size from 42Gb to 200Mb
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,...
Increasing SQLite Performance
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...
XML, XQuery & Performance Issues
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...
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...
What is the fastest way to calculate the record COUNT?
I have always liked simple questions with lots of pitfalls. Here is the one: how do you count the total number of records in...
