SQL Server 2008 R2 Express Installation

Excel is very powerful for data analysis, data crunching, and data visualization; it also supports data storage.  We can store up to 1 million rows per worksheet and we can have multiple worksheets, over 2 GB file size (if we have Excel 2010 64 bit version), sort and filter data, and Excel has even provided us a long list of database functions DAVERAGE, DCOUNT, DSUM… etc.  We are all familiar with Excel and it works!  We open an Excel worksheet, define the column headers, then we can enter data!  Quick and simple!  And you know what the best part is?  We don’t need to bother IT department; we can do it right now on our desktop!   We all know how busy our IT department is.

However, if you have a giant Excel worksheet then you may notice it has a sluggish performance especially if your PC only has 1 – 2 GB memory. Excel also has limited multi users’ support; so if your application requires concurrent data access, then it is time to consider a proper database as data storage.

I am going to demonstrate how we can use Excel with SQL Server 2008 R2 Express edition and consolidate the benefits from both products. SQL Express is a free and feature-rich database for developing and deploying desktop, web, and small server applications.

You can download it from Microsoft website.

The installation is quite simple unless you want to do some customization.  Since this is the first time we use SQL Server, so we should keep it simple and accept all the default settings.

We start the installation by clicking New installation or add features to an existing installation.

clip_image001

  • Select I accept the license terms.
  • Click Next > buttons.

clip_image002

  • Wait until the Setup Support Files is completed, then click Install button.

clip_image003

  • Click Next > buttons.

clip_image004

  • Click Next > buttons.

clip_image005

  • Click Next > buttons.

clip_image006

  • Click Next > buttons.

clip_image008

  • Click Next > buttons.

clip_image011

  • Click Next > buttons.

clip_image012

  • Click Close > buttons.

clip_image013

Now SQL Server is installed and is ready to use.  I am going to import data to SQL Server in my next blog.

Andrew Chan is the owner and founder of ALG Inc.

We help you to make better and faster decisions!

About Andrew Chan
Andrew Chan is an Business Consultant who gives you accurate, consistent and timely information so that you can make better and faster decisions. He is an Associate of Society of Actuaries with over 20 years of IT experience. Apart from strong analytical skills and proven technical background, he was also a former system director at Manulife who had extensive project management experience. If you are looking for someone to gather, consolidate, validate, visualize and analyze data, look no further! Andrew can provide the most cost effective business analytics solution so that you can explore, optimize, predict and visualize your business. Don’t guess on any decision, no matter it is finance, operation, marketing or sales! Always ask for evidence!

2 Responses to SQL Server 2008 R2 Express Installation

  1. Pingback: Create Excel Pivot Table from SQL Server « Technologies and your business

  2. Pingback: Is Excel our only option? « Technologies and your business

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: