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
Automation
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
SQL and PowerShell
I’m no PowerShell expert. I wish I was. One day I hope to be better at it. This resource has helped me no end recently: DBATools.IO is a PowerShell module specifically designed for SQL Server and DBAs. It has helped me no end with New Builds, Migrations, Best Practices, Automation, Continue Reading