This Issue Sponsored By
This email newsletter comes to you free and is supported by the following advertisers, who offer products and services that might interest you. Please take a moment to visit these advertisers' Web sites and show your support for Developer .NET UPDATE.

SQL Server Magazine
http://www.sqlmag.com/rd.cfm?code=fseu2156su

ALERT: How Hackers Launch SQL Injection Attacks
https://download.spidynamics.com/1/ad/sql.asp?cs1_ContSupRef=I-Nsql_7.1.05


1. Developer .NET Perspectives

  • TED's Excellent Profiling Tool
  • 2. Events and Resources

  • The Essential Guide to Exchange Preventative Maintenance
  • Back By Popular Demand--SQL Server 2005 Roadshow in a City Near You
  • It Just Got Easier to Network With Your IT Peers!
  • Chapter 8 Available--SQL Server Administration for Oracle DBAs
  • Congratulations to the 4th Annual Best of TechEd 2005 Awards Winners!
  • 3. Featured White Paper

  • Instant Recovery and Data Protection for SQL Servers
  • 4. Announcements

  • SQL Server Magazine Monthly Online Pass = Quick Answers!
  • Check out the SQL Server Magazine Master CD
  • 5. New and Improved

  • Avoid .NET Programming Pitfalls the Easy Way

  • Sponsor: SQL Server Magazine
    Get 2 Sample Issues of SQL Server Magazine!
    Every issue of SQL Server Magazine includes intelligent, impartial, and independent coverage of the SQL Server facets. Our expert authors deliver how-to articles and quick solutions that will help you do your job better. Try two, no-risk sample issues today, and find out why 30,000 SQL Server professionals rely on SQL Server Magazine for answers each month!
    http://www.sqlmag.com/rd.cfm?code=fseu2156su


     

    1. Developer .NET Perspectives


    by Bill Sheldon, bills@interknowlogy.com

     

    TED's Excellent Profiling Tool

    The Team Edition for Developers (TED) product suite is a collection of software-development tools from the Microsoft Team System suite of products. In my last column "Can I Call You TED?" (http://www.windowsitpro.com/sqlserver/article/articleid/46765/46765.html), I introduced you to TED's Static Code Analysis tool. This week I want to discuss TED's Profiling and Dynamic Code Analysis tool, then take a quick look at the Class Designer, which is common to all of the Team Edition products.

    The Profiling and Dynamic Code Analysis tool lets you look at the runtime behavior of an application. Unlike static code analysis, which tends to focus on source code and best coding practices, dynamic code analysis focuses on an application's use of system resources. That application might be a class library, an executable, or even an ASP.NET-based Web site. The Profiling and Dynamic Code Analysis tool lets you see your application's memory usage and other runtime characteristics so that you can manage the application's performance. Thus, in Visual Studio 2005 beta 2, you'll find the Profiling and Dynamic Code Analysis tool on the Tools menu under Performance.

    You can use the Performance tool to gain insight into the runtime environment for your managed code. However, there's a slight problem with the tool in the beta 2 version. If you're running Visual Studio 2005 beta 2 on Microsoft Virtual PC, you can start the performance wizard and set up a new performance project for your application but when you attempt to launch a test, you suddenly hit a wall. Specifically, you get an error message that says the tool won't work on Virtual PC. If you have Visual Studio 2005 Beta 2 installed on a physical machine or even a VMware machine, you won't receive that error message and you can, in fact, run the Performance tool.

    Running the Performance tool opens an additional tab in Visual Studio 2005 that's typically on the left side of the display in the same region as the Toolbox and Server Explorer. This is Performance Explorer, and it lets you group one or more performance projects under your solution. You can launch each performance project independently and gather the material you need. That material is then available from the Reports section of that project.

    When you start working with the performance monitors, you'll find two modes: Sampling and Instrumentation. Sampling mode basically monitors your application like a black box monitors an airplane. Sampling mode monitors the application's overall impact on the system but doesn't provide any insight into the details of why or how your application is using resources.

    Instrumentation mode is more akin to white-box testing. With this mode, the performance engine will insert monitoring calls around the events you have ask it to monitor. You can capture very detailed runtime information and see exactly how your application is consuming resources. Setting the necessary flags to properly gather performance instrumentation information is beyond the scope of what I can cover in this column, but suffice it to say you can retrieve everything. If you aren't careful, you can capture so much information that the file becomes almost unmanageable.

    In terms of the current documentation, an overview of the Performance tool is located on the Microsoft Developer Network (MSDN) Beta Library at http://msdn2.microsoft.com/library/84zheddz(en-us,vs.80).aspx. In addition, like for the Static Code Analysis tool, there are walkthroughs being created. Although the ASP.NET walkthrough is a little sparse, the application walkthrough is helpful. You can access that walkthrough at http://msdn2.microsoft.com/library/ms182398(en-us,vs.80).aspx. Some of the best documentation I've found related to the Performance tool is linked from the Enterprise Performance Tools Team Web page at http://blogs.msdn.com/profiler. Another good place for additional profiling links is IanWho's Blog at http://blogs.msdn.com/ianhu/default.aspx.

    Now let's take a quick look at the Class Designer, a tool designed to help you visualize architect classes and understand their relationships. As I mentioned previously, the Class Designer is common to every Team Edition. It's truly integrated into your project. To leverage the Class Designer, you need to add a new class diagram to your project. You add this diagram in exactly the same manner that you would add a new class to your project while in Solution Explorer.

    The class diagram behaves like any other source file in your project, but it's a special source file. Similar to a graphic element such as a Windows Form or User Control, double-clicking Class Diagram opens a graphic workspace. However, the class diagram has its own toolbox, which contains the tools to create a graphical representation of the classes in your project. More important, after you've placed one or more classes onto your diagram, you can have Visual Studio 2005 automatically generate the source files (including method and property stubs) based on your diagram.

    A word of warning: If you create a new class diagram in your existing class library, you don't want to start dragging new classes from the toolbox onto your drawing. Instead, grab the existing classes from Solution Explorer and drag them onto your design surface. The Class Designer was created to provide an accurate picture of your existing classes as well as help you create new classes. It makes sense to have this tool embedded with your source files in a project because it becomes tied to these classes. The key is that although the Class Designer lets you to design classes at the start of a project, which is helpful, its true value lies in the fact that it stays in sync with changes you make to your classes and hierarchy.

    The Class Designer isn't just a design tool; it also provides a real-time look at the actual implementation of your project. For a more complete overview of the Class Designer, go to http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vstechart/html/clssdsgnr.asp.


    ALERT: How Hackers Launch SQL Injection Attacks
    It's as simple as placing additional SQL commands into a Web Form input box giving hackers complete access to all your backend systems! Firewalls and IDS will not stop such attacks because SQL Injections are NOT seen as intruders. Download this *FREE* white paper from SPI Dynamics for a complete guide to protection!
    https://download.spidynamics.com/1/ad/sql.asp?cs1_ContSupRef=I-Nsql_7.1.05


     

    2. Events and Resources


    (brought to you by SQL Server Magazine)

     

    The Essential Guide to Exchange Preventative Maintenance
    Database health is the weakest link in most Microsoft Exchange Server environments. Download this Essential Guide now and find out how the ideal solution is an automated, end-to-end maintenance and management tool that provides a centralized view of the entire managed infrastructure. Get your free copy now!
    http://www.windowsitpro.com/essential/index.cfm?code=0629emailannc

    Back By Popular Demand--SQL Server 2005 Roadshow in a City Near You
    Get the facts about migrating to SQL Server 2005. SQL Server experts will present real-world information about administration, development, and business intelligence to help you implement a best-practices migration to SQL Server 2005 and improve your database computing environment. Attend and receive a 1-year membership to PASS and 1-year subscription to SQL Server Magazine. Register now!
    http://www.windowsitpro.com/roadshows/sqlserverusa/index.cfm?code=0629emailannc

    It Just Got Easier to Network With Your IT Peers!
    Windows IT Pro forums are easier to use, searchable, and complete with RSS feeds so that you'll always receive the latest discussion topics instantly! Check out the new and improved Windows IT Pro forums today.
    http://forums.windowsitpro.com

    Chapter 8 Available--SQL Server Administration for Oracle DBAs
    Databases have assumed a role of primary importance in many businesses. This highly visible role is complete with multiple responsibilities and demands. In Chapter 8, you'll discover the availability- and scalability- related features of Oracle and Microsoft SQL Server and the requirements and features that can help you increase availability and scalability. Plus--you'll learn three key backup and recovery features related to availability and scalability. Download your free copy now!
    http://www.windowsitlibrary.com/ebooks/sqlserveradminoracle/index.cfm?code=0629emailannc

    Congratulations to the 4th Annual Best of TechEd 2005 Awards Winners!
    Windows IT Pro and SQL Server Magazine presented awards to Windows and SQL technology vendors in 12 categories and one overall winner at the Best of TechEd Awards in Orlando. The field included more than 260 entries, and products were evaluated based on their strategic importance in the market, competitive advantage, and value to the customer. Click here to find out all of the Best of TechEd 2005 winners:
    http://www.windowsitpro.com/awards

     

    3. Featured White Paper


     

    Instant Recovery and Data Protection for SQL Servers
    Depending on your environment, your Microsoft SQL Server may be your most critical application. In this free white paper, learn the data protection strategies you need to really protect your database, compare the costs, evaluate alternatives, and more!
    http://www.windowsitpro.com/whitepapers/NSISoftware/SQLServerProtection/index.cfm?code=0629emailannc

     

    4. Announcements


    (brought to you by SQL Server Magazine)

     

    SQL Server Magazine Monthly Online Pass = Quick Answers!
    Sign up today for your Monthly Online Pass and get 24/7 online access to the entire SQL Server Magazine article database, including exclusive subscriber-only content. The Monthly Online Pass will help you get all the SQL Server answers you need, when you need them. Sign up now for just $5.95 per month.
    http://www.sqlmag.com/rd.cfm?code=mteu2156mp

    Check out the SQL Server Magazine Master CD
    The SQL Server Magazine Master CD goes a step further by offering portable access to the entire SQL Server Magazine article database--over 2300 articles! The newest issue includes bonus SQL Server 2005 content and if you sign up now, you'll save 25%. Subscribe now:
    http://www.sqlmag.com/rd.cfm?code=cbeu2856dc

     

    5. New and Improved


    (by Karen Bemowski, products@sqlmag.com)

     

    Avoid .NET Programming Pitfalls the Easy Way
    O'Reilly announced .NET Gotchas, a book by Venkat Subramaniam that discusses 75 pitfalls that frequently trip up even the most experienced C# and Visual Basic .NET programmers. The book is organized into nine chapters that focus on the various components and constructs of the .NET platform. Within each chapter are several pitfalls, with detailed examples, discussions, and guidelines for avoiding them. For example, in the section on Visual Studio .NET, you'll learn that not all compiler warnings are not necessarily benign. In the language and API section, you discover that enums are not type safe. The book costs $39.95. For more information, contact O'Reilly at 707-827-7000, 800-998-9938, or order@oreilly.com.
    http://www.oreilly.com

     

    Contact Us


     

     

  • About Developer .NET Perspectives -- bills@interknowlogy.com
  • About technical questions -- http://www.sqlmag.com/forums
  • About product news -- products@sqlmag.com
  • About your subscription -- Developer_dot_NET_update@sqlmag.com
  • About sponsoring an UPDATE -- contact Richard Resnick, rresnick@sqlmag.com, or Lisa Kling, lkling@sqlmag.com
  • Developer .NET UPDATE is brought to you by SQL Server Magazine, the only magazine devoted to helping developers and DBAs master new and emerging SQL Server technologies and issues. Subscribe today.
    http://www.sqlmag.com/rd.cfm?code=00ep214xeb

    View the SQL Server Magazine Privacy Policy
    http://www.winnetmag.com/aboutus/index.cfm?action=privacy

    SQL Server Magazine is a division of Penton Media, Inc. 221 East 29th Street, Loveland, CO 80538, Attention: Customer Service Department

    Copyright 2005, Penton Media, Inc. All Rights Reserved.