Author: Vitor Fava

Vitor Fava, SQL Server Database Consultant at Pythian, explains the database options for AutoClose.

Vitor Fava, SQL Server Database Consultant at Pythian, explains how to optimize text searches in SQL Server 2014 by using Full-Text Search.

  In my previous post I talked about how create and use a policy against your SQL Server Instance (don’t forget to check our part 1 in this series too). Now we will talk about the Data Collector and how configure it on…

  In my previous post we talked about the architecture of Policy-Based Management. In this post we will create and run a policy against some SQL Server Instances. Creating a Policy In SQL Server 2014 you are allowed to create a…

  This article will address the main techniques for the efficient management of multiple instances in a SQL Server database 2014 using the Tools Data Collector and Policy-Based Management. In addition, it will be demonstrated in a practical way how…