|

SQL Server and Other Topics

rss

I got my start with SQL Server in 1997 with SQL Server 6.5 at BellSouth Cellular. From that point on I've had the opportunity to work on Versions 6.0 to 2014. I specialize in Performance Tuning, High Availability and SQL Development. Contact me through this site or through my Twitter handle @SQLDiver


Introduction

'm continuously mentoring enterprise companies in how they can simplify their lives. The worst comment I hear on a regular basis is, "doing it manually is why I have job security". ARGHHHHH! No it is why you can be replaced in a heartbeat.

So DBAs, wake up! If you do the same task, manually, over and over, you're doing it wrong. When do you have time to study and play with the new features? When do you have time to watch your Pluralsight videos? How do you improve your skills... when you have to take all of your time doing the same thing manually when you can automate it??

Over the next blog posts I'm going to give you some tips and tricks and how to's for automating your installs using PowerShell... the easy way. 

Unattended Install

There have been so many people blog about how to do an unattended install I'm not going to go into great detail. First you must go here and read this article: "Install SQL Server from the Command Prompt"

No joke, this is the best starting point for understanding the unattended install. 

Now you want to go to a friend of mine, Joey D'Antoni's blog and read this one thoroughly! "Are You Still Installing SQL Server from the GUI?"

See, I didn't really need to re-write his blog post. Short and sweet and how I have always started by unattended install process at every employer and now client since the first one. 

The rest is tweaking the passed in parameters from command line or PowerShell script. I highly recommend you pass in the passwords for install. You can save the admin groups in the configuration.ini file. 

Its what follows that takes some work and PowerShell to configure... but, if you have a few PowerShell modules installed and everything is much easier. 

 

Modules you will need to install on your "management server". Click the link for each of the following for instructions on how to install:

ActiveDirectory 

NTFSSecurity

SQLServer

dbatools

dbachecks

ReportingServicesTools

That will be enough work to get you started so I'll end this episode now. Follow the instructions and you'll be off to a good start!