May 2010 Entries

SQL Server Connectivity Portal

We all love one stop portals :-)

Browsing around MSDN I came across this for connectivity, yes, a one stop portal, find info on connecting using a variety of technologies and good guides.

http://msdn.microsoft.com/en-us/sqlserver/connectivity.aspx

One of my VMs went boom using Virtual Box and how it got fixed

I am running an HP Envy 15, 16GB and 500GB (7200 RPM) Hard drive. Had a VM configured from another environment, created the virtual machine config file on Virtual Box, everything seemed ok. Fired it up, and it was s l o w, it took close to 10 minutes for it to load, and about 5 more to see Windows was in the process of loading before the BSOD. Thought, maybe, just maybe it will not happen again … oh was I wrong. Frustration had already hit an all time high with this configuration and the number of ......

Excellent source of info if you are taking exam 70-573

Becky Bertram has posted a great study resource.  She mapped the exam objectives to sources of information to focus on building the skill.

Great guide!  Thanks, Becky.

http://blog.beckybertram.com/Lists/Exam%2070573%20Study%20Guide/AllItems.aspx

Learning Resources for SharePoint

SharePoint 2010 Reference: Software Development Kit SharePoint 2010: Getting Started with Development on SharePoint 2010 Hands-on Labs in C# and Visual Basic SharePoint Developer Training Kit Professional Development Evaluation Guide and Walkthrough SharePoint Server 2010: Advanced Developer Training Presentations ......

How do I Series: Connecting an Expression Blend Project to Team Foundation Server

I have heard of people wanting and needing to add projects created in Expression Blend to Team Foundation Server. Here is the recipe: 1) Create your project in Expression Blend … click OK 2) Select the option to open your recently created project in Visual Studio. Once that option is selected, your solution will open up in Visual Studio, close Expression Blend at this point. Now, I want to add this project to Source Control … Next, I connect to my TFS environment, and pick the location to save my ......

SharePoint 2010: Architecture and Planning information

Recently I have been delivering Design and Planning Sessions at client sites, and as of recent SharePoint 2010 has been part of that mix. After the activity that goes on during those sessions getting towards the end of them is always a cross roads for clients. Why? Because it is time to kick the wheels. Remind them, and remember, this is not a 1 or 4 weeks ordeal. This has to be very well planned. If I am looking for information that is worth while and a great conversation starter, my landing point ......

TFS 2010 and SSL Configuration:The sequence list

Now, we have discussed about bringing in a certificate into our web server. One thing I noticed that was a requirement, is the assignment of a certificate throughout the App Tier and the Build Server. I understand they are not necessarily cheap, but wildcard certs are a good option here. On to the list we go: SharePoint: Modify the mappings SharePoint has so it points to https, the path to do this is from the Operations section, in Global Configuration, look into Alternate Access Mappings. The changes ......

Site Directory in SharePoint 2010

Sometimes there are so many changes to the environment in which we work and live in that something will escape our attention. In discussing functionality with a client today, the topic of Site Directory came up and the comment of “well, we use it but it is too bad it is not available in 2010” was made … and huge sense of huh?!? came to me. Well, the item that escaped me came to light (and I know there are others). So researching about it was not only an option it was/is my duty. Found an excellent ......

SharePoint 2010 Information Worker VM available for download

If you interested in a test drive of the technologies around the Wave 14 launch, take look at the VM made available from Microsoft. It is a very well rounded option to explore the new products. 2010 Information Worker Demonstration and Evaluation Virtual Machine Note: It is important to understand you will need a system with Hyper-V to import this VM and get it off and working. Also, make sure you keep a copy of the original unpacked VM as this is based on a trial version of the OS (time bombed) ......

SharePoint 2010 and SQL Server 2008 R2

Recently participated in a conversation that asked about what thoughts were around the advantages of SharePoint 2010 and SQL Server 2008 R2.

I guess we can really dive in by exploring a document on TechNet by the name of SQL Server 2008 R2 and SharePoint 2010 Products: Better Together (white paper)

Free Learning Resources for Visual Studio 2010 and SharePoint Server 2010

Visual Studio Resources From the Microsoft Press blog: http://blogs.msdn.com/micro... Keybinding Cards: http://www.microsoft.com/do... SharePoint Resources From the Microsoft Office site on Training courses for End Users http://office2010.microsoft... ......

Performing an upgrade from TFS 2008 to TFS 2010

I recently had to go through the process of migrating a TFS 2008 SP1 to a TFS 2010 environment. I will go into the details of the tasks that I went through, but first I want to explain why I define it as a migration and not an upgrade. When this environment was setup, based on support and limitations for TFS 2008, we used a 32 bit platform for the TFS Application Tier and Build Servers. The Data Tier, since we were installing SP1 for TFS 2008, was done as a 64 bit installation. We knew at that point ......

So, BizTalk 2010 Beta is out … wait, no it’s not … wait

Over the last couple of days we have seen posts and “rumors” of the Beta availability. There was a link to the bits from the Download Center, but then they were not. Documentation for it is available now at: BizTalk Server 2010 Documentation – Beta Microsoft BizTalk Server 2010 ESB Toolkit Documentation – Beta BizTalk RFID Server 2010 and BizTalk RFID Mobile 2010 Documentation – Beta But what about the bits?!? From the Biztalk Server Team blog: “We will be announcing the public Beta of BizTalk Server ......

Something about Property Management or … the understanding of SharePoint Admins/roles ?!?

When I talk about SharePoint, for some reason it comes to my mind as if it were property management and all the tasks associated with it. So, imagine you have a lot ( a piece of land of sorts), you then decide there is something you want to do with it. So, you make the choice of having a building built. Now, in order to go forward with your plan, you need to check what the rules/regulations are. Has is it been zoned residential, commercial, industrial … you get the idea. This to me sounds like Governance. ......

The Road to New Orleans: IT Grand Prix

Four teams race for charity. They need your help. Four teams of MCPs are racing to TechEd in New Orleans on a quest to win $10,000 for the charity of their choice. But they can't win without your help--pick a team, join their pit crew, and earn them points toward victory! While they're on the ground, they need your help in the cloud--pick a team, join their virtual pit crew, and earn them points by meeting online challenges. Join us, be part of this amazing drive to raise awareness and help out by ......

Cumulative Update Package 1 for SQL Server 2008 R2

From the KB Article ID: 981355 “Cumulative Update 1 for Microsoft SQL Server 2008 R2 RTM contains only hotfixes that were released in Cumulative Update 5, 6, and 7 for SQL Server 2008 Service Pack 1 (SP1). Cumulative Update 1 for SQL 2008 R2 RTM is only intended as a post-RTM rollup for Cumulative Update 5-7 for the release version of SQL Server 2008 SP1 customers who plan to upgrade to SQL Server 2008 R2 and still keep the hotfixes from Cumulative Update 5-7 for the release version of SQL Server ......

Scrum for Team System v3 RTM available

If you are using the Scrum for Team System (aka Conchango Scrum Template), it has hit RTM and it is available for download. First you will need to register and then you will ne able to access the goods. There is also a very well laid out Getting Started with v3 guide, put together by Crispin Parker. Note: Very important to know and consider, is the fact there is no upgrade or migration strategy laid out from v2.2. So you are left to your own devices on that one. There are plenty of discussions going ......

Connecting Visual Studio 2008 SP1 to TFS 2010

Introduction You have installed Team Foundation Server 2010, you are ready to go. Your client is Visual Studio 2008 SP1, and need to connect to TFS 2010. Here is the story, the steps to configure Team Explorer are almost the same … meaning, you will open Visual Studio, then go to Team Explorer. At that point you will Add an Existing Project, this where we connect to TFS. Except, we get this: Now what?!? We need to install the Visual Studio Team System 2008 Service Pack 1 Forward Compatibility Update ......

Microsoft BI Indexing Connector Announced

Wait? More awesome stuff released. With Microsoft’s acquisition of FAST, the options for content being indexed increased. That’s not all that happens, but for the purpose of this post, since we focus on Business Intelligence content … that is where we see that benefit at this time. Here is the link to the SharePoint Insights: BI In Action blog. You will find guidance and components to download ......

What is PowerPivot?

Let’s start with it is a great way to be able to visualize data and transform to information. It is intended to be a self-service business intelligence tool provided as an add-in for a tool we already know … Microsoft Excel ... 2010. If you have been wondering where to go? what to do? and how do I? I am including links that will help you be on your way to better understanding of the topic and tool. (Links to TechNet documentation) Introduction to PowerPivot Walkthrough: Create your first PowerPivot ......

New stuff on Windows Live … Hotmail and Messenger to start

Where to start? First, I would recommend you visit the Preview at http://windowslivepreview.c... Then Start Exploring, here you will find the information on Hotmail and Messenger. Why would this be exciting? The Hotmail offering is having the following pieces integrated: ActiveSync Office Web Apps integration SkyDrive integration Head on over, check it out ......

Configuring SQL Server Management Studio to use Windows Integrated Authentication … from non-domain systems

Did you know you can pass your Windows credentials to SQL Server even when working from a workstation that is not joined to a domain? Here is how … From Start, then click All Programs, find Microsoft SQL Server (version 2005 or 2008). Once there, do a right-click on SQL Server Management Studio, then click on Properties Now, follow below to modify the entry for Target: Now the real task (we will be using the runas command) … Modify the shortcut’s target as follows, and remember to replace <domain\user> ......

TechEd North America 2010

I will be working in the Certification area this year.   I will be there, will you?

Creating a new project for Team Foundation Server Basic.

We have installed and configured TFS, we have connected to it using Visual Studio. Now it is time to get a project created. From Team Explorer, we will right click on the servername\Collection item in the tree to select New Team Project. Once selected, this will open the New Team Project dialog. Provide a name, then click Next. The next step is to select a Project Template. By default you will have 2 available (but there are many downloadable options). It is important to understand what the templates ......

Connecting to a new installation of TFS 2010

When the installation and configuration for TFS 2010 is completed, the next step is to connect and use TFS. There is a Web Access component, but in order for it to serve useful you need to create a project into the Team Project Collection. This is where Visual Studio 2010 comes in. Open Visual Studio 2010, then click on the Team Explorer Tab (red arrow pointing to it) or go to View > Team Explorer. Once there, click the Connect to Team Project toolbar button This will open up the Connect to Team ......

Configuring Team Foundation Server Basic on Home Server.

For the installation I selected only the Team Foundation Server role. Then, I opened the Team Foundation Server Administration Console (which I think is a great addition and improvement over the way TFS was configured in the past) to proceed with the configuration of the pieces. Once I selected the Configure Installed Features, the Configuration Center opened up. Now, the choices … In my implementation here I just want to take advantage of Source Control primarily. I want to be able to store my code ......

Understanding the SQL Server 2008 R2 Installation Center

What is available to us through those links? Have you taken the time to explore and identify what could be useful to you? One of many gems that has come to my attention is the possibility of provisioning SQL Server to work in an image based environment (hint: Virtualization Template perhaps?!?). Planning: Includes requirements information, documentation, how to guides, online documentation installation and other tools. Among the other tools you will find the System Configuration checker and The Upgrade ......

A great option for those of us who live by virtual environments, SQL Server 2008 R2 sysprep

For a long time when creating images for my development environment, I had to install the OS and then sysprep. Only after that would I then create a differencing drive/image that would have SQL Server. So, the thought of having a base/core image for SQL Server as a template was not easily done. Well, how do things change? SQL Server 2008 R2 gives us the option now. Check this HOW TO provided on the library docs at TechNet. http://technet.microsoft.co... ......