TSQL Tuesday #77 – Favorite SQL Server Feature: SQL Server Logging

As I was going thru the list of possible laptops that I could buy as a backup machine, my youngest son pointed at the latest Microsoft Surface Pro 4 device. He was very happy with his Surface 3 – great graphics, lightweight, HD webcam, touch screen and a detachable keyboard. As he continued to brag about his […]

In-Memory OLTP in SQL Server: Logging Comparison with Disk-Based Tables

In a previous blog post, I talked about Partition-Level Online Index Operations in SQL Server 2014 and how it affects high availability and disaster recovery. With more features being added in every new version of SQL Server, it’s important to understand how its implementation will affect your overall objectives. One feature that got a lot […]