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

SQL Agent and AlwaysON Availability Groups

So we all know that SQL Agent isn’t part of an availability group and therefore (like logins, operators, alerts, linked servers etc) your SQL jobs won’t sync. But even when they are synced, I’m sure there are plenty that should only run on the Primary Node and therefore shouldn’t run Continue Reading