I will give a long answer and a short answer:

The long answer treats your servers like pets, you need to spend time caring for each of them.  The amount of...

If your DBs are on-prem and already on at least SQL2017 a useful way to migrate to a new SQL version is to use a Distributed Availability Group (dAG).

You can...

I have been using gMSA accounts since SQL2012. I have never found a need to repeat the backup of the service master key as the gMSA password changes.

As said above, involve your legal department at each stage.

If there is any thought of doing a 'secure erase' by repeatedly overwriting your backup file, you need to look at...

There is a lot more that needs to think about before being able to give a useful answer.

# What is your desired end-game with Tabular

# Do you plan to use...

It is not clear from your original post: Do you have 1 server of 80 GB with 15 SQL instances on it, or do you have 15 servers of 80...

Kathi's article is good at highlighting one of the main frustrations that database people have with app developers, and equally one of the main frustrations app developers have with database...

I agree. If you have a good use-case for Filestream then File Tables are the best way to implement it.

Do you need to setup Delegation of Control

https://blogs.technet.microsoft.com/kaushika/2014/11/17/when-creating-a-new-resource-or-role-in-windows-server-2012-r2-failover-cluster-the-network-name-fails-to-come-online-or-failed-to-create-associated-computer-object-in-domain/

Are you installing on your own kit or using Azure. If it is your own kit and you have a SQL 2019 Enterprise Edition license with Software Assurance then you...

I am always looking forward to vNext and getting it into Production.  For me it is all about enabling the business (and IT) to take advantage of the best technology...

• This reply was modified 3 years, 7 months ago by  EdVassie.

Why do you want to uninstall SQL Server 2008. Also why do you want to install SQL Server 2016, it is now 5 years old and definitely inferior to SQL...

There is a discussion on what you can do at https://github.com/SQL-FineBuild/Common/wiki/SQL-Server-Memory-Management

The SQL db engine can be given access to more than 4gb memory via AWE even if itcannot address it...

I hope there are people out there interested in columnstore. It is a powerful indexing strategy that can give great performance. (Spoiler alert, this is a long post.)

We make good...

• This reply was modified 3 years, 10 months ago by  EdVassie.
• This reply was modified 3 years, 10 months ago by  EdVassie.

One thing I forgot to say, can this move be used as an opportunity to consolidate to fewer SQL Server instances.  As the old server is W2003 it is probably...