October 2011 Entries
Windows Azure for the ITPro presentation at MCT Summit
Posted On Sunday, October 30, 2011 6:07 PM | Comments (0)
If Dr. Seuss explained the Cloud presentation at MCT Summit
Posted On Sunday, October 30, 2011 6:05 PM | Comments (0)
SharePoint LOB Development using Visual Studio LightSwitch presentation at MCT Summit
Posted On Sunday, October 30, 2011 6:02 PM | Comments (0)
A follow up to installing a Dev SharePoint 2010 environment on Windows 7: Using the Farm Configuration Wizard Part 1 of 2

Sometime ago, say around mid April, 2011 I posted about Installing SharePoint 2010 on Windows 7 by going in a different path than using the standalone installation.

This post is about what happens after the installation and initial configuration of your Windows 7 “development farm” gets the bits, and goes through the Central Admin and management perspective to get you to the first screen that says “Hi, SharePoint here, would you like to play a game of chess” (yeah, it does not really say that, but you get the idea).

There are several ways of getting to the farm configuration point, using a wizard or getting some scripting behind it (use of PowerShell).

This post is about using the Wizard.

Once you have completed the installation of SharePoint 2010, you will have the following screen welcome you. Select your choice and click OK.


Then, you are presented with the option to run the Wizard, or to cancel and configure everything yourself.  This will be discussed in the next post in this series.


Once you started the wizard to configure your farm, you will be prompted for the Service Account.  Todd Klindt has an excellent guide that gives you a summary of the service accounts you should be using. The other options you will encounter here are the services you want to run on your farm.  As a side note, when you install the standalone option, you are not prompted for this, everything you see as checked is installed. But here we can be selective about what we really need to work with, develop or just flat out discover.

10-28-2011 4-12-05 AM


10-28-2011 4-12-19 AM

Once it gets going, you will see this

10-28-2011 4-13-02 AM

You will come to a point of the Wizard completing and see the confirmation of Service Applications that were configured.

10-28-2011 4-56-20 AM

Once you clicked Finish, you will come to the Central Admin display.

10-28-2011 4-56-50 AM

Again, my focus here has been from setting up a development environment.  Many people have different opinions on how to get a dev environment on their system, using a vm or installing directly.  Each has its advantages and disadvantages.  This process works on Windows Server 2008 (R2) as well.  Getting to know your options and process is a good learning opportunity.

Posted On Sunday, October 30, 2011 8:49 AM | Comments (0)
Working with the Windows Azure Platform Training Kit–Web Installer October 2011

We have gone through several iterations of the Windows Azure Platform Training Kit in the past, and while it was not a complex process to get up and running for me, well that was not the story for many.  I had the chance of participating in a Windows Azure Bootcamp, and while the attendees were aware of the requirements on the systems, well it was not as easy to get going.

You can get the October refresh here:

I believe that is the reason for the Web Installer, it works together with the Web Platform Installer and here is what it looks like …

Initial license screen, I will accept.


Then I can select the specific content, (or all content), I can also have an idea of the size of download for the items I selected.


I then get a description of the process that needs to take place, I agree to terms again.


Then the first step will take place, and that is to configure installation options …


Then, based on our content selection (mainly driven by the Labs and Demos we picked), we get a dependency check and assistance to install the dependency (PRETTY COOL!!!)


Now, depending on the number of dependencies the process will take some time to complete and make sure your system is ready for the full experience.

Then the installation for the content starts.


Once it completes, click Next


And close


Posted On Saturday, October 29, 2011 12:14 PM | Comments (0)
Installing the AdventureWorks OLAP Sample Database

Once the installer for the AdventureWorks Community Sample Database has finished, we then need to complete the process (not mandatory, but nice to do to play with the OLAP content).

The first thing we need to do is make sure we note the location of the script files and samples.

The path if you are working with SQL Server 2008 R2 is as follows:

“C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008R2 Analysis Services Project\enterprise”

I am working with the developer edition, so the enterprise path works for both Enterprise and Developer edition.  There is also a path for Standard.

Once I get to that location I will double click on the Adventure Works.sln file.  This will open Business Intelligence Development Studio.  Take time to review the artifacts that are part of the solution.


The next step is to make sure the Adventure Works.ds file points to the correct server.  To edit, we can do a right-click and select Open, then Edit


The edit screen is as follows


Click Test Connection to make sure we have the correct server instance and have access to the database.


Now that we have validated connection information, we can proceed to deploy.  Let’s validate the correct server information is set in the deployment properties.  We will right-click the Solution name, and select Properties.  From the Configuration Properties, select Deployment, and check the values in the Target Server and Database fields.  If not pointing to the correct values, change them to read as you need them.



We are ready to deploy, once again, right-click on the Solution Name, and select Deploy.


When deployment starts, you will see a Deployment Process dialog.  It will change values as it moves along the artifacts to deploy.


Once complete you will see the following:


This means deployment has completed and it was successful.  To validate, open SQL Server Management Studio, at the logon screen, make sure your values are as follows:  (make sure it points to the information that corresponds to your deployment


We need to see the following


This confirms the deployment was successful.

Posted On Saturday, October 29, 2011 8:33 AM | Comments (1)
Installing the AdventureWorks Community Sample Database content

For a while now, if we have been around SQL Server we got used to the different sample databases that were provided.  From Pubs to Northwind to AdventureWorks.

In order to get the AdventureWorks samples we need to go to CodePlex and download the one that corresponds to the version of SQL Server we are working with.  The link to the download site here :

Now, on to the installation.

Once you download the appropriate file, double click and launch the  installation process.


Which in turn becomes this


You will need to accept the license terms to continue

Then you will select the component of the sample content to install.  The OLTP content (relational DBs, in blue) will install and be ready to go once the install completes.  The OLAP content (Analysis services content, in orange) will require some additional steps to complete the installation process.  Important to note is the option to select the Instance where the Databases will be installed to.


Installation process begins


It completes, then click Finish


This is how the content gets installed.  The next post is about getting the Analysis services content deployed.

Posted On Saturday, October 29, 2011 8:08 AM | Comments (0)
Nice to have tools for the SharePoint IT Pro

Coming from SPC a couple of weeks ago, during the keynote there was a demo on some great Visio Diagrams.  It was created using the following: 

Expect a post here in the next week or so on how to configure it.


Another great tool I came across is targeted to those who are becoming familiar with PowerShell for SharePoint, and also if you want to use PowerShell with SharePoint Online.  It is a Command Builder, you pick the verbs and nouns as you would regularly do with PowerShell and see the combination of parameters and information for that given command.

Give a try here:

More info on it:

Posted On Sunday, October 23, 2011 9:39 PM | Comments (0)
Visual Studio 11 Developer Preview Training Kit

Just in line with the release of the Visual Developer Preview and the availability of the Visual Studio Developer Preview 11 ALM virtual machine, now we have access to the Developer Preview Training kit.

Download the Training kit here:

Posted On Sunday, October 23, 2011 11:07 AM | Comments (0)
SQL Server “Denali” Virtual Labs

The SQL Server team or group of teams responsible for the learning content has done a fantastic job continually of providing great ways to work with their content.  This time it is through the Virtual Labs made available to ramp on Denali.  How to get it?

Go to the Learning Center’s Virtual Lab Link.

Posted On Sunday, October 9, 2011 10:00 PM | Comments (0)
Disclaimer: The views expressed on this blog are my own and do not necessarily reflect the views of my employer.

Creative Commons License

Check out my profile!

INETA Community Speakers Program

Follow enriquelima on Twitter
Locations of visitors to this page