Latest from the Blog
Meta-Data Only Changes Weirdness
So today’s blog is just a summary of something that I came across out there in the wild and to be honest I’m a bit confused by the whole thing, so this blog won’t be going into why this happened, because basically I don’t fully get why, ok enough mystery, lets get into it. We…
A tail of a DMS bug and the curious case of the Endpoint setting ForceLobLookup
So this is a very interesting case that we came across in one of our AWS accounts recently. We are replicating data between a MS SQL Server source to a Aurora PostgreSQL cluster using AWS DMS. The one table being replicated is fairly basic, just some integer and string columns. Below is the definition of…
MS SQL Server Page Storage
So MS SQL Server stores all data in rows that fit onto 8kb pages.There are many different types of pages in MS SQL Server but for this blog we are mainly concerned with three, these are:1. Data Pages2. Text/Image Pages, sometimes referred to as LOB pages.3. Index Pages The names are fairly self-explanatory but for…
Get new content delivered directly to your inbox.
