Home

Latest from the Blog

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…

Fun with AWS Availability Zone Names and RDS Cloning Across Accounts

Well the above is some mouth full for the title of the blog, but hey, it best describes what I’m going to talk about today. One of the very 1st things I remember learning about when I started my cloud journey into AWS way back in 2018 was about how AWS splits the world up…

Get new content delivered directly to your inbox.