SQL Server Tools
SQL Server 2016 CTP3.1 – What’s New for Developer?
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...
IT NonStop 2015 – Kharkiv (Ukraine)
The international IT conference IT NONSTOP was held in Kharkiv (Ukraine) on November 28, 2015 and gathered a lot of enthusiastic participants.
A speaker of...
SQL Server Typical Maintenance Plans: Automated Database Backups
There are a lot of posts appealing to one simple truth – need perform backups on a regular basis. People will always be divided...
SQL Server Typical Maintenance Plans: Automatic Statistics Update
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...
How to generate SQL Linked List Data with Python Generator
In this post, we would like to show how to quickly generate table values that are based on the values of another column of...
SQL Server Index Fragmentation In-depth
In this article, we will drill down into the SQL Server index fragmentation issue and how to tackle it. We will figure out why index fragmentation is a problem and how it affects overall performance and discuss how to detect and avoid it.
A Look Back at PASS Summit 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...
Devart was the Gold Sponsor of SQLSaturday #406 – Kharkiv 2015
Devart was the Gold sponsor of SQLSaturday #406, that was held on SEP 19, 2015 in Kharkiv, Ukraine.
We would like to thank the organizer of the event -...
Generate Meaningful Test Data with Data Generator for SQL Server
Why is meaningful test data important?
While developing an application, you need to make sure you are testing it under conditions that closely simulate a...
Devart was the Bronze Sponsor of SQLSaturday #416 – Odessa 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...
