Automating SQL Installs

Here’s how I do a basic silent install of SQL Server. Configuration File You can’t start this unless you have an installation configuration file from a previous install. Your Configuration File (ConfigurationFile.ini) can be found in the following location: C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\ Within this location there will be Continue Reading

Automating SQL Service Packs and Cumulative Updates

Applying Service Packs and Cumulative updates is dull, mundane work. It’s hard to keep on top of sometimes and also with some 24/7 databases, it’s hard to find an update window. Sometime it’s hard to even get the business to agree to something if they’re not exactly seeing any end Continue Reading