- Rangers ship SQL load testing tool
-
The Team System Rangers have shipped again! This time they’re have built on the success of the WCF Load Testing Tool and have applied that same approach to SQL. You can find this tool on our Codeplex site: SQL Load Test. Here are the details from that site:
Project Description
This tool takes a SQL Profiler trace file and generates a unit test that replays the same sequence of database calls found in the trace file. The unit test is designed to be used in a Visual Studio Load Test. The code generated is easily modifiable so that data variation can be introduced for the purpose of doing performance testing. The tool generates code for both Visual Studio 2005 and Visual Studio 2008. The source code is a Visual Studio 2005 project. The tool is still in pre-release stage of development.
Why Load Test SQL?
There is a lot of code out there that makes load testing the application very difficult. The most common type is a client application that contains direct database calls. The application however is not structured to allow the business logic to be exercised without the GUI. Another common scenario is a legacy application written in a language such as Visual Basic 6. In cases like these, it can be difficult to load test the application without a GUI test tool, which introduces other disadvantages. GUI test tools are notoriously difficult to use, generally lead to brittle tests and also have limitations in scaling the load injectors sufficiently to exercise the servers. This tool offers one possible alternative. You start with using the client application to generate a trace of the SQL statements which typically represent a usage scenario. You can then turn the trace into equivalent ADO.NET code program that can be used in a load test.
Tool Description
The tool generates a Visual Studio 2005/2008 Unit Test from a SQL Server Profiler trace. It extracts all the SQL statements and stored procedure calls from the trace and turns them into a single Visual Studio Unit Test, which can then be configured as a Visual Studio Load Test. The tool does not interact with the database itself when it analyzes the trace and generates the test code. It can therefore be used in “offline” scenarios. The generated code needs to be customized to include a connection string to the database under test. That code also includes hooks to allow the user to customize the parameters that are passed to the SQL statements and stored procedures, so that variability can be introduced into the data to prevent caching from producing artificially high performance figures. The tool is intended to be used in conjunction with a client program that runs against a database. A trace of the client’s SQL Server activity is captured using the SQL Server Profiler. This represents a test scenario, which is then processed by the tool to produce a Unit Test that replays the scenario.
Congratulations to the various Rangers involved in this project! Please check it out and let us know what you think.
- Using Team System for SharePoint development
-
From all indications, Microsft Office SharePoint Server (MOSS) adoption is growing quickly as it provides an easy way to share information, facilitate collaboration, manage content, and implement workflow within enterprises. We use it daily here on our team to store documents, and share project details. We’ve done a bit of customization but I can tell that there are many more capabilities that we have not yet exploited. As customers adopt and customize the platform, they find that they want bring the power of Team System to managing the lifecycle of their sites just like they’ve done for their other application development efforts. To help with this, the Team System Rangers have engaged in an effort to develop guidance around the best practices for SharePoint application development. We plan to publish the guidance in the form of white papers and articles to MSDN.
As we engage on this project, we’d like your feedback on the top topics around leveraging Team Foundation Server (TFS) for MOSS application development. Please review the below list of categories that we’re planning to cover and let us know if we’re hitting the most important ones. Are there any that we’re missing?
- Implementing TFS Team Build for SharePoint Development: Customers want to use Team Build to centrally build their SharePoint application projects on demand or on an automatic schedule as well as how to extend Team Build for deployment to target SharePoint farms.
- Assembly and Artifact Development Models for SharePoint: Development teams need to reconcile the differences between artifact and assembly development, including combining these two components into a single source control repository such as Team Foundation Server. There are various team and organizational models ensure all artifacts and assembly components of a SharePoint application get packaged for farm deployment as a single unit.
- Deploying and Managing SharePoint Solutions: Development teams and administrators need strategies for deploying their application into a target SharePoint environment. Since there are various types of SharePoint applications, there are various strategies and scenarios to consider.
- Implementing TFS as an ALM Platform for SharePoint Development: Developers want advice on how to best take advantage of the collaboration capabilities of TFS to increase their ability to stay organized and focused on meeting business requirements.
- Leveraging Testing for SharePoint: Customers, given the complexity some of their customized SharePoint applications, want advice on tools and methods needed to test their SharePoint applications and how Team Foundation Server can extend these capabilities.
So, if your team is creating custom applications for SharePoint, we’re hoping that guidance on these topics will be helpful. Please let us know if we’re missing any major areas from your perspective.
Thanks!
- Guidance Explorer: enabling discovery, composition and consumption of high quality development guidance
-
Several of our MVPs just recently “discovered” the Guidance Explorer project run by our very on patterns & practices team even though it’s been released for some time now. Since this was a surprise to many of them, I figured it’d be good mention it more broadly in case others might find it useful. As you hopefully know by now, the p&p team is all about providing guidance to architects and developers interested in learning more about how to apply Microsoft’s technologies to common application development scenarios. They produce a ton of content and often times customers want to customize the organization of that guidance to make it easier to access and navigate. Enter the Guidance Explorer. This Codeplex project provides an easy way to:
- Find relevant patterns & practices guidance
- Build customized checklists for your development scenarios
- Build customized guidelines for your development scenarios
- Build custom sets of guidance and share with your team as recommended practice.
Here’s a quick screenshot of the tool:
As you can see, it provides the ability to navigate, search, filter and customize your view on all of p&p’s content. Some of the guidance you might want to navigate with the Guidance Explorer includes:
Check it out and let us know if this works for you!
jeff
- Case studies galore!
-
Sometimes I get so heads down in the business of shipping our next version that I forget for a moment about customers using the current version. Fortunately, there are plenty of folks around me who work directly with customers on a regular basis such as the Team System Rangers and our very own Team System evangelist, Brian Keller…they don’t let me forget for very long. Recently I took a look at the updated list of case studies for Team System adoption and was happy to see that the list continues to grow by the week. According to the search engine at http://www.microsoft.com/casestudies, there are currently 102 (wow!) which are related in some way to Team System. Here are a few recent ones of note:
- Chicago Bears: Football Team Connects with Fans, Drives Web Site Traffic with Desktop Application
‘The team-oriented features of Visual Studio Team System 2008 Development Edition helped us ensure that we didn’t introduce any defects while developing,” says Strawmyer. “For instance, the code profiling capabilities of the product quickly and clearly showed that there was no processor abuse or inconsistent use of memory.”’
- Merrill Lynch: Merrill Lynch Creates Development Framework for Increased Productivity
‘Merrill Lynch upgraded to Microsoft Visual Studio Team System 2008 as soon as it became available. “We opted to use Visual Studio Team System because of its tightly integrated workflow, design, and development capabilities.”’
- Starz Entertainment: Movie Provider Automates to Meet Higher Demand, Reduce Costs, Improve Brand Visibility
‘The collaboration and team features in Visual Studio Team System … make it faster and easier for a group of developers—we had eight working on MediaForge—to work together reliably.’
- Thomson Reuters: Media and Information Provider Unifies Development Processes
‘Using Team Foundation Server, the team manages more than 2,000 work items, 70,000 changesets, and 200,000 files and folders. Since Online Services implemented Team Foundation Server, four other business units either have adopted it or have begun the implementation process.’
Anyway, there are many more out there if you’re interested in learning more about how other customers are using Team System.
Enjoy!
- Welcome Grant!
-
Grant Holliday, a former Team System MVP, recently joined our team focused on adoption of TFS internal to Microsoft. Since he’s a veteran TFS user, he hit the ground running and now is a voracious force on the internal support aliases. I’m happy to see that he’s also started blogging with a similar level of energy. Looks like in the three brief weeks he’s been with us, he’s posted 15 blog entries…that’s 1/work day and he started with a handicap since the first couple days were spent in “New Employee Orientation”. I can remember when that process took < 2 hours but that’s a story for another day.
Anyway, do yourself a favor and subscribe to his blog. I certainly have.
Welcome aboard Grant…it’s great to have you here!
- Team System community update posted
-
Chuck Sterling, our Team System community lead, has posted a copy of his monthly update on community activities to his blog. In the past, these updates have been only for internal consumption but, at my behest, he posted the most recent update for all to read. This sort of transparency is a bit of an experiment and your feedback will help us decide how to proceed in the future. Do you find this update useful? What else regarding the community would you like to see in these reports?
Please take a look and let us hear from you.
Thanks!
jeff
- Localized hotfix pages now available
-
We have hit another milestone on our journey to improve our process around delivering hotfixes to customers. Now, not only will the most commonly requested hotfixes be available for download in English, but in French, Spanish, Italian, German, Traditional and Simplified Chinese, Japanese, Korean, Russian, and Brazilian Portuguese as well.
You can browse the list of Hotfixes on MSDN CodeGallery here: http://code.msdn.microsoft.com/Project/ProjectDirectory.aspx?TagName=Hotfix. MSDN Code Gallery allows the community to provide feedback on our hotfixes and they can stay informed when a new hotfixes is released by subscribing to the following RSS feed: http://code.msdn.microsoft.com/rss.ashx?behavior=bytag&TagName=Hotfix.
When you select a language, it will take you to a resource page where they can read the localized KB article content and details for the hotfix you’ve selected.
Please note: The title of the hotfix will not be localized and will appear in English.
Hope you find this improvement helpful!
jeff
- Cameron’s back
-
Cameron Skinner has recently reappeared on the blogging scene and he’s on fire! Check out a couple of his most recent posts:
I’d certainly recommend subscribing to his blog moving forward as I’m positive he’ll have more interesting news moving forward.
Welcome back Cameron!
- Tools for Agility - A white paper by Kent Beck
-
Ajoy Krishnamoorthy, a product manager on our team, recently worked with Kent Beck to publish a great white paper on tooling for the agile team. The section on transparency really resonated with me especially this passage:
A transparent team can more cheaply and effectively coordinate their efforts towards shared goals. Acting transparently sends a signal to others that they can trust you. Trust, when realized, reduces the friction of development as people focus more on what they are accomplishing together and less on avoiding blame. Just as TDD allows me to trust my code and do more with it, trust on a team allows them to be more innovative and experimental.
I like the notion that transparency makes a team more effective, innovative and experimental. I’ve certainly run into my share of teams that claim that they can’t tell me what they’re doing because to do so would slow them down. Of course we still have plenty of work to do in order to make it easier for the tools to support transparency but I’m totally convinced that this is the right direction to go.
What do you think?
- PDC2008
-
As you may have heard, registration is now open for the next Microsoft Professional Developers Conference happening in October! PDC2008 is going to be packed with all of the latest information about the future of the Microsoft development platform. For a taste of some of the sessions being offered, check out the preliminary list of sessions.
PDC2008 will be a great place to learn more about Visual Studio Team System code name “Rosario” in addition to a myriad of other Microsoft technologies and Microsoft’s software + services strategy.
I would also recommend looking at the list of pre-conferences, which are designed to train you on how to make the most of currently shipping Microsoft technologies. I am especially excited about the Visual Studio Team System 2008 pre-conference which is being delivered by Brian Randell. Brian is a Visual Studio Team System MVP who has trained development organizations around the world on how to make the most with Visual Studio Team System. If you have ever seen Brian present then you know he’s passionate about sharing best practices for software development!
To learn more about PDC2008 visit http://www.microsoftpdc.com.
- Upcoming APLN Agile Leadership Conference
-
The next leadership summit for the Agile Project Leadership network (APLN) is scheduled to be held in Seattle a couple weeks from now on July 17th and 18th. I’ve been invited to be part of their panel discussing “Leading the Agile Enterprise” which should be an interesting discussion during which I expect I’ll learn about as much as the conference attendees. If you’re there, please introduce yourself…I look forward to meeting you!
- Seattle Team System User Group meeting this week
-
Steven Borg, one of our local Team System MVPs, is scheduled to talk at the next meeting of the Seattle Team System User Group. He’ll be discussing reporting within Team System…the abstract seems pretty interesting:
You’ve paid your nickel and it’s time to ask the Zoltar Fortune Teller for your future: “Is my software development project going down the toilet? Will I be able to ship on time, with high quality? Can I hit my budget?” (Wait, three questions = three nickels.) And he says… Nothing.
Let’s face it. Traditional status reporting is about as accurate as Zoltar, and worse, it takes a whole lot longer!!! Team System can help! Its’ built in reporting capabilities provide a strong foundation for understanding the current status of your project. Not only does it provide a series of built in reports, it gathers the metrics to allow for excellent ad-hoc reports! Using these both the built in and ad hoc report capabilities, finding the current status of your project, and predicting your project’s probability of success or failure along several axis. Come learn how to predict your future! You’ll learn how to interpret the build in reports, learn what’s required to create the reports, and how to use Excel pivot tables to connect to the TFS cube for ad hoc reporting.
Anyway, if you’re in the area and can make the meeting, I’d certainly recommend it. If nothing else, watching Steven present is always a joy…he’s got boundless energy and enthusiasm when it comes to Team System.
The meeting is on Wednesday, June 25th at 6pm PDT in their new location of Lincoln Square, Bellevue. Learn more here.
Jeff
- New case study for Team Foundation & Teamprise
-
We just released a joint case study based on the success that Thomson Reuters has had using Team Foundation Server in conjunction with Teamprise in order to adopt Team System in a mixed development shop. Since the reality of many development teams is that they are dealing with some aspect of mixed development, I expect this to be a very popular case study to read. Sharing a common, integrated source control system and collaboration server across the entire development team is a very powerful tool for teams interested in the successful delivery of great software (aren’t we all?)
Here’s a great quote to whet your appetite:
“Without an integrated toolset, we had bits and pieces of information that simply didn’t mean much or make much sense,” says Mac Noland, Lead Software Configuration Management Engineer at Thomson Reuters. The lack of integration among tools made it difficult for Online Services to manage and report on projects. “Leads want transparency and easy reporting,” explains Noland. “People responsible for writing and quality checking the code want the ability to track history and associate change requests, defects, and bugs with specific lines of code. Lacking a big-picture view and the ability to drill down into the detail, we could not effectively manage the software life cycle.”
Anyway, take a look at the full details here: http://www.microsoft.com/casestudies/casestudy.aspx?casestudyid=4000002078.
- Check out good stuff from TechEd 2008
-
This was a good week for Team System at TechEd 2008 in Orlando. I would recommend that you check out the TechEd 2008 Online site (http://msdn.microsoft.com/en-us/events/teched/default.aspx) to learn about much of what was covered. In particular, you should check out the BillG keynote in which our very own Brian Harry demonstrated some exciting new features of Rosario (you can even read more about it here). In addition, you should watch the Team System panel when you can watch an interactive session with Brian, Gert Drapers, Neelesh Kamkolkar, Peter Provost, Habib Heydarian and Norman Guadagno.
Enjoy!
- early release of Database Edition updates
-
Gert Drapers, group manager for the team responsible for the Team System Database Edition, recently announced an early release (Community Technology Preview) of some updates to that product. The biggest motivation behind these updates was to fully support the upcoming release of SQL Server 2008 later this summer. But, while we were making these updates, we also made a whole bunch of other changes in anticipation of supporting different database providers. If you’re interested in learning more, you should certainly review Gert’s announcement.
