After Microsoft published Service Pack 1 for SQL Server 2014 on 15 April 2015 and recalled it very quickly, Microsoft also quickly reacted, improved and revised Service Pack 1, and now it is republished again. As you can read in the corresponding MSDN-Post, steps have been taken to resolve those problems and issues with the…
Analyzing SQL Server User Roles and Permissions: Who Has Access? We often receive inquiries from our customer service team regarding needing an overview of all configured SQL users and their permissions on an SQL Server. When acquiring new servers, relying solely on scripts from experts like Brent Ozar may not always suffice. To address this…
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…
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…
