Lesson Learned #2 Linked Server from SQL 2008 R2 to Azure SQL Managed Instance

You should know by now that the SQL 2008 and 2008 R2 is at end of support on 2019-07-09 and mainstream support also ended a long time ago https://www.microsoft.com/en-us/sql-server/sql-server-2008 https://support.microsoft.com/en-us/lifecycle/search?alpha=SQL%202008 The best path to do this migration would be to use DMA (Data Migration Assistant) and DMS (Azure Database Migration Service), however in some scenario […]

Incremental statistics… How to Update Statistics on 100TB Database

I’ve recovered this post using (Google cache) from a post I made a long time ago from retired blog of brasilian SQL PFEs https://blogs.msdn.microsoft.com/pfebrasilsql/2016/03/18/estatisticas-incrementais-ou-como-atualizar-estatisticas-em-base-de-100tb-vldb/ And the english version also retired, translated by (Chris Lound / Alexandre Mendeiros) https://blogs.technet.microsoft.com/dataplatform/2016/04/03/incremental-statistics-how-to-update-statistics-on-100tb-database/ Find below this article I really like the idea of Incremental Statistics and what it can offer […]