Author: Alejandro Cordero

Introduction Every new version of SQL Server ships with exciting new features. One of the simplest but important features is Automatic Tuning. Before covering this new feature, let’s analyze the old ways so we can understand what is really automated…

The Feature: SQL Server 2016 SP1 introduced direct seeding for Always ON Availability Groups. This is a short guide to understand what it is and some warnings when using it. The Problem: In previous versions than SQL Server 2016 ,…

A quick guide to help you compare certain data warehouse options.

Alejandro Cordero, Lead Database Consultant at Pythian, explains minimally logged operations.

Alejandro Cordero, Lead Database Consultant at Pythian, discusses historical trends in tech, spinoff vertical companies, and the phenomenon and challenges surrounding Pokemon Go.

Alejandro Cordero, Lead Database Consultant at Pythian, discusses the rising importance in business data, and how is adds value to an organization.

Alejandro Cordero, Lead Database Consultant at Pythian, discusses the importance of lifelong learning in the IT industry.

Objective To Test the delayed durability feature with mirroring in high performance and high safety mode. The idea is to confirm what the performance improvement is of the transaction and if it has any benefit in high latency networks.  …

There is a time in every SQL Server DBA career where a mail came in with a “replication is not working, please check” message. This article is intended to provide with quick tips on how to handle common replication errors…

The idea of this blog post is to describe what the delayed durability feature is in SQL Server 2014 and to describe a use case from an application development perspective. With every new SQL Server release we get a bunch…