man running along seashore during golden hour

Instant File Initialization – possible Performance Increasement

As part of a recurrent discussion on “How to set up a stable and performing SQL Server?” I regularly stumble over the (perhaps often underestimated) possibility of “Instant File Initialization.” I didn’t know this parameter until 1-2 years ago, but now it is part of our standard for installing SQL Server. I’ve still got a…

Renaming an MS SQL instance (MS SQL 2005 or higher) - Photo by Anya Smith

Renaming an MS SQL instance (MS SQL 2005 or higher)

Because I currently had the task …A customer wanted a new server, identical to the existing test or development environment. Background:The customer owns a server with two instances (test and development) and now wants a server for the production environment …Our VMWare colleagues suggest a one-to-one clone, the customer agrees. So what about the MSSQL…