After a false start a couple months back, I’m determined to get more involved in the community and start blogging daily and not let all the distractions get me away from this.  My background includes over 22 years in software development.  I am currently working for Microsoft as a Sr. Consultant working in the Department of Defense sector.  My primary areas of focus include .NET, Team System and Team Foundation Server, SQL Server and SOA and interactions with SharePoint, BizTalk, Windows Workflow, and Windows Communication Foundations.  I am also pursuing a PhD from Auburn University.  My hope is to start posting whatever I can from my work experience and academic experience.  My area of research is software automation, particularly as it is enabled through well-defined relational repositories.

Here is what I plan to post over the next few days to get things rolling

1) The Data Model Monitor – This is a tool that not only audits SQL Server database changes using a Database Definition Language trigger, but includes a schema and supporting stored procedures to capture a snapshot of a database model after each change.  Along with this, there is a replay function that allows a user to see how a database model has evolved.  The tool also supports

2) Working with Hyper-V to setup a virtual lab – Experiences from the field.  I’ll be sharing with you what I am learning as I am endeavoring to setup a virtual lab of several machines running under Hyper-V. 

3) Data and Business Layer generator – This tool generates data and business objects to help automate these aspects of an application and de-couple these layers from the UI.  I’ll be discussing the Microsoft Enterprise library as part of this exercise.

4) Basic techniques for finding bottlenecks with SQL Server.  I’ll discuss how to use the trace output, store the data in a database and then use queries to identify quickly how to find the low hanging fruit for a poorly performing database to cleanup queries and setup appropriate indexes.

5) Setting up ADFS with SharePoint and providing a SOA interface point through an Enterprise Bus.

6) Using Team Foundation Server work items with Microsoft Project integration in order to implement time tracking for a development project.

This will keep me busy for a while…

“Microsoft Bob”