RSS 2.0
 Monday, October 22, 2007

I just came across this download at Microsoft. It provides an introduction to the concepts and step by step instructions for creating and customizing TFS reports.

The zip file contains instructional PDF documents as well as several sample reports.

Monday, October 22, 2007 1:05:59 PM (Mountain Daylight Time, UTC-06:00)  #    Comments [1] -
Microsoft | SQLblog | Team System
 Wednesday, October 17, 2007

Way to go Microsoft, and SQL Server 2005!

gartnersql

For the first time in the report’s history, Microsoft is positioned in the Leader quadrant in Gartner’s Magic Quadrant for Data Warehouse DBMS. The analysts say that SQL Server 2005 is expected to grow in the data warehouse space and Microsoft’s vision for SQL Server 2008 makes clear the company’s intent to become a major presence in the data warehouse market.

 

Read more about this great announcement here.

Wednesday, October 17, 2007 2:03:36 PM (Mountain Daylight Time, UTC-06:00)  #    Comments [0] -
Microsoft | SQL Server | SQLblog
 Friday, October 05, 2007

One of my students forwarded this to me this week. I thought it was hilarious.

NotABug

Friday, October 05, 2007 9:00:04 PM (Mountain Daylight Time, UTC-06:00)  #    Comments [1] -

 Tuesday, October 02, 2007

Thanks to the Team System Rangers (an elite squad of TFS experts inside Microsoft) for putting together this document, which serves as a single point of entry into the world of TFS Operations as well as Microsoft's recommended operational best practices.

tfsarch

So, start learning/mastering TFS operations by clicking here.

Tuesday, October 02, 2007 10:46:42 AM (Mountain Daylight Time, UTC-06:00)  #    Comments [0] -
Microsoft | SQLblog | Team System
 Wednesday, September 26, 2007

The Annual Banquet for the Boise Chapter of the IEEE Computer Society will be held on Wednesday, October 24, 2007 at the 8th Street Winery from 6:30 to 8:30pm.

The presenters this year are Caleb Chung and John Sosoka of Ugobe Systems and they will talk about innovation and the making of Pleo.

IEEE

Wednesday, September 26, 2007 3:18:02 PM (Mountain Daylight Time, UTC-06:00)  #    Comments [0] -
Community
 Saturday, September 22, 2007

Microsoft has released a new version of VSTS Web Access Power tool. This release is a Community Technology Preview (CTP) of what will ultimately be the 2008 version of the VSTS Web Access Power Tool.

  • Built against the TFS 2008 object model - In previous versions of Web Access you had to install Team Explorer 2005 on any machine you were installing Web Access on. With this version, you will now be installing Team Explorer 2008 instead. In some future version, Microsoft hopes to remove the requirement to install any version of Team Explorer.
  • Custom control support - added support for web based work item custom controls and have included a folder of documentation and samples on how to create them.
  • Build queuing - added UI for the new TFS 2008 feature of build queuing. You can start new queued builds and view the build queue (in addition to the preexisting abilities - like viewing build details).
  • Localization support - added support for localizing the web interface. Microsoft will also be localizing text for the final 2008 Power Tool release.
  • Bug fixes & Performance improvements - Microsoft has received a number of reports and done more testing on the current version of the Power Tool, and has fixed everything thus far.

This release (and the final 2008 release) can be used with either a TFS 2005 or a TFS 2008 server.  In either case, you will need to install a TFS 2008 Team Explorer on the machine you install Web Access on. Since TFS 2005 did not support build queuing, that functionality will not be available when this and future versions of Web Access are used with a 2005 server.

 

You can download it here and read more about it at Brian Harry's blog posting.

Saturday, September 22, 2007 10:12:57 AM (Mountain Daylight Time, UTC-06:00)  #    Comments [0] -
Microsoft | SQLblog | Team System | Visual Studio 2008
 Tuesday, September 18, 2007

Call it a code generator, software factory, or just a clever script. If you can write code that writes code - you win, even if just a small victory for humans in this contest we call software development.

For example, I've been working on an ASP.NET application which contains many data entry screens. You know the kind: very simple, table-format with a label and a textbox of a certain width, that may or may not require some validation. In other words, a whole lot of markup like this:

<tr>

  <td class="EditLabel">Number</td>

  <td class="Edit">

    <asp:TextBox ID="txtNumber" runat="Server" Width="200px" MaxLength="20"></asp:TextBox>

  </td>

</tr>

 

Now, if you have to type the above more than once or twice, you will go insane (been there, gone there). More importantly, you will probably introduce a bug or two. So, I opened up SQL Server 2005 Management Studio and wrote the following T-SQL code:

USE SomeDB

GO

 

DECLARE @Table  varchar(128)

DECLARE @Column varchar(128)

DECLARE @Width  varchar(10)

DECLARE @Length int

DECLARE @Type   int

 

SET @Table = 'Employer' -- Pass this as a parameter

 

DECLARE ColumnCursor CURSOR FOR

   SELECT C.Name, C.Max_Length, C.User_Type_ID FROM Sys.Columns C

   INNER JOIN Sys.Tables T ON C.Object_ID = T.Object_ID

   WHERE T.Name = @Table

   ORDER BY Column_ID

 

OPEN ColumnCursor

 

FETCH NEXT FROM ColumnCursor INTO @Column, @Length, @Type

WHILE @@FETCH_STATUS = 0

BEGIN

  IF @Type <> 36 -- No GUIDs

  BEGIN

    IF @Length < 0 SET @Length = 100

    IF @Length < 10

      SET @Width = '50px'

    ELSE IF @Length < 20

      SET @Width = '100px'

    ELSE IF @Length < 50

      SET @Width = '200px'

    ELSE IF @Length < 100

      SET @Width = '300px'

    ELSE

      SET @Width = '400px'

 

    PRINT '<tr>'

    PRINT '  <td class="EditLabel">' + @Column + '</td>'

    PRINT '  <td class="Edit">'

    PRINT '    <asp:TextBox ID="txt' + @Column + '" runat="Server" Width="' + @Width + '" MaxLength="' + CONVERT(varchar(10),@Length) + '"></asp:TextBox>'

    PRINT '  </td>'

    PRINT '</tr>'

  END

  FETCH NEXT FROM ColumnCursor INTO @Column, @Length, @Type

END

 

CLOSE ColumnCursor

DEALLOCATE ColumnCursor

 

You get the picture. Feel free to customize this code to introduce additional formatting, a slick UI, or other business rules to the mix.

Tuesday, September 18, 2007 4:02:47 PM (Mountain Daylight Time, UTC-06:00)  #    Comments [4] -
SQL Server | SQLblog

Microsoft's Patterns & Practices group recently released the final version of the “Team Development with Team Foundation Server” Guide. This guide has been in beta for the last couple of months.

 

It shows you how to get the most out of Team Foundation Server to help improve the effectiveness of your team-based software development. Whether you are already using Team Foundation Server or adopting from scratch, you’ll find guidance and insights you can tailor for your specific scenarios. It's a collaborative effort between patterns & practices, Team System team members, and industry experts.

 

TFSGuide

 

Some quick facts:

  • 496 – Total number of pages
  • 18 – Total number of chapters in this guide
  • 11392 – Total number of downloads of the Beta version of this guide
  • 8 – Number of attempts to get the Adobe build to work to generate the guide in .pdf format
  • 60 – Number of external and MSFT contributors and reviewers

Download the guide from CodePlex.

Tuesday, September 18, 2007 10:36:03 AM (Mountain Daylight Time, UTC-06:00)  #    Comments [0] -
Community | Microsoft | Team System

Microsoft's Patterns & Practices group recently released the final version of the “Team Development with Team Foundation Server” Guide. This guide has been in beta for the last couple of months.

 

It shows you how to get the most out of Team Foundation Server to help improve the effectiveness of your team-based software development. Whether you are already using Team Foundation Server or adopting from scratch, you’ll find guidance and insights you can tailor for your specific scenarios. It's a collaborative effort between patterns & practices, Team System team members, and industry experts.

 

Some quick facts:

  • 496 – Total number of pages
  • 18 – Total number of chapters in this guide
  • 11392 – Total number of downloads of the Beta version of this guide
  • 8 – Number of attempts to get the Adobe build to work to generate the guide in .pdf format
  • 60 – Number of external and MSFT contributors and reviewers

Download the guide from CodePlex.

Tuesday, September 18, 2007 10:30:34 AM (Mountain Daylight Time, UTC-06:00)  #    Comments [0] -
Community | Microsoft | SQLblog | Team System
 Friday, September 14, 2007

Yesterday, Microsoft released a tool to migrate from IBM ClearCase to TFS.

Find more information on TFS migration topics, keep an eye on this blog.

Friday, September 14, 2007 9:51:30 AM (Mountain Daylight Time, UTC-06:00)  #    Comments [0] -
Microsoft | SQLblog | Team System
 Thursday, September 13, 2007

My students this week told me about the new version. I remember using the original XML Notepad, and it was great, very simple.

For the longest time, I couldn't find it on Microsoft's site to download, and then a newer version showed up on CodePlex.

Thursday, September 13, 2007 10:01:54 AM (Mountain Daylight Time, UTC-06:00)  #    Comments [0] -
Community | Microsoft | SQLblog
 Tuesday, September 11, 2007

Plant to attend the MSDN event on October 4, 2007 (a Thursday). Products to be discussed: ASP.NET, Office, Visual Studio, and Windows Vista.

  • times: 1:00 to 5:00 (welcome Time: 12:00 PM)
  • Theater - Edwards Boise Stadium 21, 7701 Overland Road, Boise Idaho 83709

You can find out more, and register here.

MSDN Events are free, live sessions designed to enhance your coding skills and make your life a little easier. By attending you'll get up-to-the-minute technology delivered by seasoned developers and have lots of time to network and ask questions. Chat with your fellow developers get the latest coding tools and tips and learn how to create rich new applications.

Tuesday, September 11, 2007 1:40:15 PM (Mountain Daylight Time, UTC-06:00)  #    Comments [0] -
Community | Microsoft
 Thursday, August 30, 2007

Ah yes, late August, time to go back to school - even for us adult geeks.

Fortunately, David Starr has provided us an exhaustive list of must-read books, organized by developer, tester, project manager, and executives.

... nothing specifically on VSTS however. I'll have to bug him about that.

Thursday, August 30, 2007 9:10:52 AM (Mountain Daylight Time, UTC-06:00)  #    Comments [1] -
Community | Team System
 Monday, August 20, 2007

The great news just keeps on coming from Microsoft. After a flurry of Team System announcements and downloads recently, we have yet another set of Power Tools to play with.

These tools are designed specifically for the Visual Studio Team Edition for Software Architects and provide the following capabilities:

  • View class library projects on the Application Diagram (AD)
  • View references to class library projects as connections on the Application Diagram
  • Create class library projects from the Application Diagram
  • Create references to class library projects from the Application Diagram
  • Synchronize properties between class library projects and their representative applications on the Application Diagram
  • Create and use class library applications and references on the System Designer (SD)

Fantastic. We haven't seen much out of the Architect tools, except for the SDM SDK in quite some time. I'm looking forward to it.

Download the CTP here. Note: you will also need to download Visual Studio 2008 Beta 2.

If you have any feedback on these tools, please visit the Architecture & Design forum.

Monday, August 20, 2007 1:38:31 PM (Mountain Daylight Time, UTC-06:00)  #    Comments [0] -
Team System | Visual Studio 2008
 Friday, August 10, 2007

Microsoft has published a detailed KB article about the problems fixed by SR1. The article includes a link to download the update.

Aside from many fixes, there are three major improvements found in this release:

  • Cross-database references - support is improved so that you can reference objects within different databases by using database project references or by referencing a database metafile (.dbmeta). This support reduces or eliminates the cross-database reference warnings within a database project
  • Improved file support within SQL Server file groups - you can define files within file groups as database project properties instead of having to create files and file groups within the pre-deployment storage script.
  • Variables - a Variables page is added to the database properties. This new page enables you to define setvar variables for use in the deployment scripts.
Friday, August 10, 2007 9:55:44 AM (Mountain Daylight Time, UTC-06:00)  #    Comments [0] -
SQL Server | SQLblog | Team System
 Thursday, August 09, 2007

My friend Jeff Prosise has taken John Conway's mathematically-based Game of Life, automated it and given it a slick UI using Microsoft Silverlight 1.1. I'm sure Jeff had fun writing this, all the while learning the new environment.

You can read more about SilverLIFE at this blog post, and then play with it here. (You will be prompted to download Silverlight 1.1 Alpha Refresh).

image

Thursday, August 09, 2007 9:32:57 AM (Mountain Daylight Time, UTC-06:00)  #    Comments [0] -

Archive
<October 2007>
SunMonTueWedThuFriSat
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910
About the author/Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2008
Richard Hundhausen
Sign In
Statistics
Total Posts: 690
This Year: 26
This Month: 0
This Week: 0
Comments: 479
Themes
Pick a theme:
All Content © 2008, Richard Hundhausen
DasBlog theme 'Business' created by Christoph De Baene (delarou)