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 ofContinue reading “A tail of a DMS bug and the curious case of the Endpoint setting ForceLobLookup”
Tag Archives: database
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 forContinue reading “MS SQL Server Page Storage”
AWS DMS Hidden Gotcha’s Part II
Back in March 2022 I wrote a Blog post AWS DMS Hidden Gotcha’s Part I, todays post is a continuation of this outlining some more quirks of DMS that I have become aware of from working with it on a daily basis. Index creation locking system table causes DMS Task to fail: Ok, so thisContinue reading “AWS DMS Hidden Gotcha’s Part II”
The Front-line Database Blog 