Migrate databases from SQL Server to SQL Managed Instance

Zero or Hero?

Index fragmentation on all databases

The script returns all the fragmented indexes on all databases on the instance you run it. Can be run on multiple instances in the same time using central management capability.

Types of indexes available in SQL Server 2019

Database snapshots

Space allocated to the databases by disk letters

Found this useful for database migrations. This helps to identify how much space will need to be allocated for a new server and how a SQL Sever instance is using discs currently. Note. This won't show correct information on Linux instances and if you use mounting points in Windows.

Offline R Services installation and patching

The R Services installation package is not included in the MS SQL Server installation package. When you install MS SQL Server with R Services the installer actually download the package from the Internet.

Primary keys for an OLTP database

OLTP database performance with different clustered indexes.

Logshipping to SQL Server on Linux

An example of a database migration from SQL Server 2016 on Windows to MS SQL Server 2017 on Linux.

Memory-Optimized Table Truncation