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…
Read More >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 ,…
Read More >A quick guide to help you compare certain data warehouse options.
Read More >Alejandro Cordero, Lead Database Consultant at Pythian, explains minimally logged operations.
Read More >Alejandro Cordero, Lead Database Consultant at Pythian, discusses historical trends in tech, spinoff vertical companies, and the phenomenon and challenges surrounding Pokemon Go.
Read More >Alejandro Cordero, Lead Database Consultant at Pythian, discusses the rising importance in business data, and how is adds value to an organization.
Read More >Alejandro Cordero, Lead Database Consultant at Pythian, discusses the importance of lifelong learning in the IT industry.
Read More >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. …
Read More >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…
Read More >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…
Read More >