14 July 2020
14 July 2020

Reading Books

Books are usually meant to be read in an analogue fashion. Start at page one and keep on going until the book is done. Some people take an early peek at the end of mysteries to see how they turn out, but isn’t that cheating? In today’s digital world, it isn’t easy – at least … Read more
26 June 2020
26 June 2020

Will We Still be Talking About DevOps in Two Years?

While individual buzzwords will come in and out of fashion, the ideas at the heart of DevOps aren’t going anywhere.  Like any good buzzword, DevOps may mean different things to different people. There are several good definitions of DevOps out there. My favorite definition comes from @IanColdwater, who defined DevOps in terms a teenager would understand: Devops … Read more
22 June 2020
22 June 2020

Storage 101: Cloud Storage

Throughout this series, I’ve discussed a range of storage-related topics, some of which I mentioned only briefly. One of those is cloud storage, which now plays a vital role in today’s data management strategies. Organizations of all types and sizes now employ cloud storage to varying degrees, either to supplement their on-premises systems or to … Read more
02 June 2020
02 June 2020

Too Much Stuff

We’ve lived in our current home for 30 years and have managed to accumulate a lot of possessions. We have closets, drawers, cabinets and a storage shed filled with things, many of which we don’t remember buying or receiving in the first place. I haven’t quite gotten into the Marie Kondo way of organizing yet, … Read more
26 May 2020
26 May 2020

Improve Row Count Estimates for Table Variables without Changing Code

Table variables can cause performance issues with joins when they contain a large number of rows. In SQL Server 2019, Microsoft has improved how the optimizer works with table variables which can improve performance without making changes to your code. In this article, Greg Larsen explains how this feature works and if it really does make a difference.… Read more
21 May 2020
21 May 2020

Hands-On with Columnstore Indexes: Part 1 Architecture

Microsoft introduced Columnstore with SQL Server 2012 and have improved the feature in every version since then. You may be wondering why they are different than traditional indexes and how they work. In this series, Edward Pollack explains the architecture of Columnstore indexes. In future articles in the series, he will describe best practices for Columnstore.… Read more