Author: Dmitry Zaytsev

Dmitry started working with SQL Server back in 2010 and how has large experience in various aspects of working with SQL Server, including administration, development, migration, monitoring, performance, etc. Dmitry is the founder of

How to Analyze Activity of One Database in SQL Server

14:16 Database administation, Database Optimization & Structure

Using one SQL Server instance for many projects is not unusual. However, defining the most active...
Read More

Why Multiple JOINs are bad for Query or Do Not Get in the Way of Optimizer

08:52 Database administation, Perfomance Tuning, SQL Server

Recently, I came across an application that generated DB queries. I understand that there is nothing new about that, but when application...
Read More