- 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 IV
    Here is the fourth part in a series from my notes taken at the Visual Studio 2005/SQL Server 2005/BizTalk 2006 launch.

    This covers one of the breakout sessions titled Visual Studio Developer Tools. It was presented by Mike Benkovich. Mike had hosted the Introduction to Web development with Visual Studio 2005 that I attended in Eden Prairie in July 2005.

    Mike has a web page: where he has posted code samples.

    Visual Studio 2005 Team System For Architects
    Mike went through the Ticket Claim application system. It was a continuation of previous demos in the Whidbey Rocks example.

    First Mike started with the creation of a new project in Visual Studio. In the example he chose a Distributed system solution and called it “Whidbey Rocks”. The next step is to jump into application designer. Distributed systems design is unique to the Team System version of Visual Studio. And the application designer is only available to Architects using the Team system.

    One side note about all versions of Visual Studio, docking of all the windows within Visual Studio is much more sophisticated. And you can select this nice option to bring back the default Visual Studio layout: Window --> Reset Window Layout.

    In the application designer, Mike was able to build the application design. He created a Web Application called “Ticket Site”. He created a Windows application called Ticket Claim. He made a database reference for the Whidbey Rocks Database and made a graphical connection of the Windows and Web applications to it. He added a Web reference to a Biztalk web server. He browsed to the web server “Contoso” to the Service.asmx file to get the external Biztalk server.

    Once Mike was done with the application design, he selected Deployment. That creates the .dd file (Data diagram). He could then go in and work on the logical data diagram. At this point he went into SQL server in depth.

    SQL Server
    Check out the SQL Server developer’s center

    SQL Server 2005 has native support for XML. This includes an XML data type. There are Native web services for SOAP/XML.
    Check out these white papers:
    Overview of Native XML Web Services for Microsoft SQL Server 2005

    What's New in FOR XML in Microsoft SQL Server 2005

    Check out all the technical articles and whitepapers in MSDN
    Servers and Enterprise Development > SQL Server > SQL Server 2005 > Technical articles.

    Mike demonstrated setting up an HTTP endpoint for a web service that a non-human application might consume.

    Setting up SQL Server as a Web Service that can listen natively for HTTP SOAP requests requires creating an HTTP endpoint and defining the methods that the endpoint exposes. When an HTTP endpoint is created, it must be created with a unique URL that it uses to listen for incoming HTTP requests. For example, if you create an endpoint with the URL "http://servername/sql," SOAP requests that are sent to http://servername/sql will be picked up by http.sys. Http.sys will then route the SOAP requests to the SQL Server instance that hosts the endpoint associated with the URL. From there, the requests will be handed off to the SOAP processing layer within SQL Server.

    There are a number of T-SQL enhancements. Here are some notable ones:
    • There are new data types VARCHAR(max) and VARBINARY(max) which allow the storage of up to 2 gigabytes of data.
    • The TOP clause is enhanced to allow an expression for the number of rows as well as being able to use with INSERT, UPDATE, and DELETE.
    • There is a new clause called OUTPUT which can be used to get the data from a DELETE or UPDATE statement, so a single trip to the server updates data and returns results.
    • The PIVOT operator provides the ability to quickly and easily generate cross tab queries. A cross tab query rotates rows data into columns data. There is a companion, UNPIVOT.
    • RANK and ROW_NUMBER functions allow you to add number columns to your data
    • EXCEPT and INTERSECT: UNION combines rows from both sets (or sides of the operator) eliminating duplicate rows. INTERSECT only gives the matching rows between the sets. EXCEPT is similar to the NOT IN operator but allows multiple columns. You could achieve similar results for single column, but if there are multiple columns NOT IN would not work.
    • Event handling with TRY CATCH in SQL and stored procedures
    • Common Table Expressions: A Common Table Expression (CTE) is a temporary result set derived from a simple query. A CTE can be used in many of the same ways you use a derived table. CTEs can also contain references to themselves. This allows database developers to write recursive queries. CTEs can also be used in place of views
    The common language runtime is also built into T-SQL to allow Visual Studio code execution. In the example, Mike showed the stringbuffer class in action. This allows string manipulation from within a stored procedure or SQL statement. The CLR is assembled into the SQL Server engine.

    Article: T-SQL Enhancements in SQL Server 2005

    SQL Management Studio is the replacement for the Enterprise manager. It can be used to create solutions and Scripts.

    In Visual Studio 2005, there are code snippets, but SQL server has templates. This is standard SQL for different functions: Create stored procedure, manage trigger, create role, create view, aggregate data and others.

    Tip: to identify your SQL server service pack version, use the SQL statement SELECT @@VERSION.
    SQL Server 2005 will report as version 9.00.1399.06

    Mike ran through an example of stored procedure debugging. You need Visual Studio 2005 professional or Team system to be able to perform this action. Database objects can now be written in T-SQL or in a common language runtime (CLR) language. In SQL Server 2005, Query Analyzer has been replaced by the SQL Server Management Studio. Because of the new capability of creating SQL/CLR database objects, debugging is done inside Visual Studio, rather than in SQL Server Management Studio, which does not include a debugger.

    Back to Part III
    Posted on Friday, January 13, 2006 @ 11:48:29 UTC by BB
    "SQL Server 2005 - Visual Studio 2005 - BizTalk Server 2006 Launch Part IV" | Login/Create an Account | 1 comment
    The comments are owned by the poster. We aren't responsible for their content.

    No Comments Allowed for Anonymous, please register

    Microsoft 400 differences web site (Score: 1)
    by BB on Tuesday, April 25, 2006 @ 08:36:34 UTC
    (User Info )
    Microsoft has launched a web site to illustrate the 400+ differences between Visual Studio 2003 and Visual Studio 2005.

    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.21 Seconds

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