- What did you expect?
  Create an account
:: Home  ::  Downloads  ::  Your Account  ::  Forums  ::
Google Adsense
  • Home
  • Downloads
  • ExpectationReviews
  • Forums
  • Group29 FAQ
  • MovieReviews
  • OtherReviews
  • Stories Archive
  • Submit News
  • Top 10
  • Topics
  • Web Links
  • New at Group29
    ·Movie Review: Eternals [15]
    ·Tuna Is Not The Favorite Pizza Topping in Minnesota
    ·UCLA vs USC preview 2021
    ·Movie Review: Godzilla vs. Kong (2021) [28]
    ·Expectation Review: Captain Marvel [25]
    ·Expectation Review: Avengers: Infinity War [24]
    ·Forum Topic: Update your Facebook property
    ·Web Link: WEP Key Converter
    ·Forum Topic: Why does my IPA file get saved as a zip file in IE?
    ·Web Link: BeyondCompare

    ·Rebelscum Breast Cancer Awareness Charity Patch
    ·BBC Interviews J.J. Abrams About Trek And Wars
    ·CEII: Jabba's Palace Reunion - Massive Guest Announcements
    ·Fathead's May the Fourth Be With You!
    ·Star Wars Night With The Tampa Bay Storm Reminder
    ·Stephen Hayford Star Wars Weekends Exclusive Art
    ·ForceCast #251: To Spoil or Not to Spoil
    ·New Timothy Zahn Audio Books Coming
    ·SDCC: Exclusive Black Series Boba Fett With Han In Carbonite Set
    ·Star Wars Art Exposition May 4th

    Hot trends

     SQL Server 2005 - Visual Studio 2005 - BizTalk Server 2006 Launch Part II
    Here is the second part in a series from my notes taken at the Visual Studio 2005/SQL Server 2005/BizTalk 2006 Launch. In Part I, I talked about the opening demos, keynote address and primary product features.

    With the opening keynote hype out of the way, I thought we would settle into the practical details of the new technology. I will try to convey what I saw based upon my copious notes. I did not exactly understand all of it, as it was a lot of information coming very quickly. Before that, let me throw out some more hype that was given to us at the end of the session.

    Microsoft has tried to address the top two security requests from developers:

    1.) “We need prescriptive guidance around security”

    2.) “We need tools that improve the security of our code”

    It is now possible with Visual Studio 2005 to generate “least privilege” applications. That means applications no longer need to be installed as administrator on the operating system and/or "sa" as the SQL server user. They emphasize that you no longer even need to be a desktop administrator to be a Visual Studio developer! This is big news for development teams at big corporations with desktop lockdown policies. 
    New security features in Visual Studio 2005

    Critical Success

    A recent survey was comissioned by Microsoft. When the participants were asked, "What software application platforms do your company's mission critical applications currently run on?" the majority of unprompted responses were .NET with 35.7% over J2EE or other Java products bringing in only 25.3%. Other application products which scored well were Mainframes, Other Microsoft tools, and UNIX, HP, Solaris, AIX.

    Another question asked was "What percentage of your mission critical applications run on..." with Windows Server receiving 42.3% with the UNIX being a distant second at 11.1%.

    The survey also shows widespread adoption of Web Services technologies with Microsoft's web service technologies leading the way at 31.3%. MSMQ also managed to squeeze out a victory over MQ Series as a messaging platform worldwide, although not in North America.

    SQL Server Transaction Power

    Microsoft has been strong in benchmarks for transactions (TPC-C) and OLAP (TPC-H) on SQL server according to the TPC foundation.

    SQL Server is a “trusted platform” for SAP. It can handle 93,000 concurrent users. 60% of all new SAP deployments are on Windows platforms.

    Team System Demonstration
    OK, now getting into the meat of the systems. Jeff Brand gave the demonstration. Jeff used the FabriKam examples as a starting point. These examples can be obtained for only the cost of shipping at

    (FabriKam: A Microsoft Office System Solutions Learning Platform)

    You can get a set of 4 CD/DVDs with examples shipped to you for less than ten dollars.

    Jeff started with a SQL Server 2005 Report Manager example. He also tied into the Dundas Software reporting package (Dundas Chart for .NET).
    He built some sophisticated charts and showed how to adjust the data.

    Jeff built a sample application demo where a database could import a flat file, then build an XML Scheme, then imports into SQL server. He used the BizTalk Flat file schema wizard (From the Contoso Entertainment sample application) to show two XML schemas side by side. This builds a BizTalk mapper file (.BTM file). Jeff also showed how data flows into the SQL server with the more advanced Data Transformation Services. The new DTS builds .DTSX files which must supersede the older .DTS files. One feature that is new to DTS is “Fuzzy Lookup”

    Here is the SQL Server magazine article:
    (A quick example that Fuzzy lookup will handle is matching “The Windows” to “Windows, The”. )

    Jeff quickly covered workflow integration of Team Foundation Server with the Personify Outlook plugin. The new Team Foundation Server Outlook Starter Kit allows an Outlook user to import, manage, track, and e-mail tasks from a Visual Studio 2005 Team System project in their Outlook Task Manager. Installation of this software will create a new to provide this functionality within Outlook.

    Next, Jeff covered the Adventure Works Agile Demo in Visual Studio 2005 Team Foundation Server. You can run through the whole walkthrough process by following it from MSDN:

    MSDN2 Library > Development Tools and Languages > Visual Studio Team System > Team Foundation > Team Foundation Walkthroughs

    He started with the Application Diagram tool in Visual Studio 2005. He then showed how BizTalk applications help you Visual Studio application consume a web service. The Visual Studio Application Designer creates the .ad files in the project.

    Jeff started in on the Getdown Digital Demo for Visual Studio 2005 team system. Supposedly, team system contains this demo client application, but I cannot find any more information about it. The Visual Studio Team system home page is a good starting place for more information.

    Jeff showed how to create class diagram files (.cd files), Logical datacenter diagrams (.ldd files), and Network diagrams (.dd files). This is the starting point for system architects before coding begins.

    Check out the new MSDN beta web site if you want to find examples for Visual Studio .NET 2005, SQL Server 2005 and BizTalk 2006. Not a lot is available yet, mostly BizTalk 2004 examples are out there now.

    Barnes and Noble Demonstration
    Another demonstration was given showning the Barnes and Noble data warehouse. They store billions of records per month of inventory and sales records. This article (Bookseller Gains Business Insights Across Sales Channels with New Data Warehouse) has more details. The programmers are UNIX converts who initially resisted Visual Studio and SQL server, but are now embracing the technology.

    .NET 2.0 ISPs
    There is an MSDN introduction call the Club Web Site Starter kit that was used in the demos. It requires an ISP that supports .NET 2.0. It includes a PayPal starter kit, (which according to those who have tried it, is buggy with return variables in the PayPal class that do not quite match.) But it will help you get something running quickly.

    Jeff Reports that .NET hosting is the exact same cost as Linus hosting!  Here are some of the ASP.NET 2.0 hosting providers I managed to scribble into my notes. (Offering a FREE Beta test site!) (United Kingdom) (Host of ASP.NET, WINDOWSFORMS.NET, CHANNEL9.MSDN.COM, and ASPALLIANCE.COM) (ASP.NET 2.0 starting at $7.95 per month)

    Visual Studio 2005 Buying Guide
    Visual Studio 2005 has been released in a number of versions. There are the (currently free) Express Editions. There are also the Standard, Professional, and Team System editions. Check out the Visual Studio comparison Guide for more information. Each version has different capabilities. It may turn out that even users of the Visual Studio .NET professional edition may be able to get by with the Visual Studio 2005 Express Editions. These are compatible with Visual Source Safe!

    SQL Server 2005 Buying Guide
    SQL Server 2005 comes in four different versions. There is the (currently free) SQL Server Express Edition, which replaces the MSDE (Microsoft Database Engine). There are also the Workgroup, Standard, and Enterprise editions. MSDN and Partner Action Pack Subscribers will get the SQL Server developer version. Purchasing SQL

    Check out the SQL Server Comparison Guide for more information on the versions. It may also turn out the the SQL Server Express Edition is sufficient for many applications with a DB maximum size of 4 GB. SQL Server is licensed in a couple of different ways, including either processor licensing, or the familiar Client Access License (CAL) model.

    Note that the Visual Studio Express Editions are FREE for download and use! Many users will find these versions sufficient for professional application development. If you are a Visual Studio 97/Visual Studio 6.0 user that has not yet taken the plunge, there should be nothing stopping you now.

    Check out the Visual Studio Project Roadmap!

    Also see the Group29 Forum Post about the .NET Framework 1.1 and 2.0 coexisting. You can use MSBUILD.EXE to build from the command line. The .NET Framework 2.0 and .NET 2.0 SDK are also free for downloading from Microsoft.

    On to Part III
    Posted on Tuesday, December 20, 2005 @ 06:09:29 UTC by BB
    "SQL Server 2005 - Visual Studio 2005 - BizTalk Server 2006 Launch Part II" | Login/Create an Account | 0 comments
    The comments are owned by the poster. We aren't responsible for their content.

    No Comments Allowed for Anonymous, please register
    Group29 Productions

    All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest (c) 2006 by Group29 Productions.

    You can syndicate Group29 Productions news with an RSS Feeder using the file backend.php

    PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
    Page Generation: 0.28 Seconds

    :: HeliusGray phpbb2 style by CyberAlien :: PHP-Nuke theme by ::