Install SQL Server in 5 minutes

sql server 2014 logo

You know this everybody – you need to install a whole new SQL Server on the customers Windows Server.
And the customer doesn’t have the time or money to wait for you to click around the GUI and sit around and watch the progress-bar move every second. You can actually install SQL Server in 5 minutes.

So why not do this in a fully automatic way and in the same time save both effort and expensive time doing so?

Using the command prompt

There is a command line util that gives you the ability to write a very very very long command and in that way install the SQL Server from there. But I personally do not want to sit around and write these commands every time.

Using config files

A very more efficient and reusable way is to make your own configuration file and use this every time you need to install a new SQL Server.

When you click your way through the UI to install the SQL Server the UI actually make a config file and then use this file to install using a very small commandline:

setup.exe /configurationfile=config.ini (if ‘config.ini’ is your config-file).

The configurationfile is easy to model around with and in that way you can have your own personal config-file that can be adapted to every environment and every customer. And if the customer for some reason needs to reinstall the server again, they just need the media and the config-file.

The upside

When you use configurationfiles and the command line the installation can be done in, for my example on my laptop, in aprox. 5 minutes.

2014-11-04 21_18_27-Summary.txt - Notepad

How long do you normally wait for the installation to finish?

Downsides…

I really can’t find any. Once you’ve got the config-file up and running, it’s easy-peasy to install a new SQL Server. You can also reuse the config-file for a newer version of SQL Server – just add or modify the file to fulfill the needs for that version and that environment.

If you have encountered any downsides that I haven’t seen – then please leave a comment and I’ll get back to you.

Further reading

Microsoft has good documentation for this:

Command prompt installation

Configuration file installation

Power Query – October 2014 update

power bi for office 365

The Power Query tool has just been updated and there are some pretty neat features rolled out:

  1. New Transfomation: Use Headers as First Row.
  2. Column Name field in Merge Columns dialog.
  3. Quick Access Toolbar in Query Editor dialog.
  4. Warning for stale data previews in new queries.
  5. Function Invocation from Search.
  6. Preserve Excel Number formats in the worksheet on query refresh.

Microsoft has posted a video containing a brief overview of the update:

Along side this update – there is also an updated Salesforce connector for Power Query which you need to install after installing the above update.

There is a MSDN blog with more info here: MSDN

Downloads:

Power Query update

Salesforce connector

en_USEnglish
da_DKDanish en_USEnglish