SQL Server Magazine UPDATE—brought to you by SQL Server Magazine
http://www.sqlmag.com


THIS ISSUE SPONSORED BY

The Premier Event for DW & BI Education
http://www.dw-institute.com/education/conferences/orlando2002/m.asp

Head Back to School Online with SSMU!
http://www.sqlmag.com/sub/webinar/ssmu
(Below COMMENTARY)

Are You Wasting Time Searching for SQL Server Answers?
http://secure.duke.com/nt/sqlmag/archivecd/newsqlcdsub.cfm?code=ei282h1a
(below NEWS AND VIEWS)


SPONSOR: THE PREMIER EVENT FOR DW & BI EDUCATION

TDWI World Conference, Fall 2002—Orlando—11/3-11/8. Best-in-Class Data Warehousing and Business Intelligence Education. Hot topics include: Taking Your DW to the Next Level, Building Data Marts with Limited Resources, Analytic Applications—Build or Buy?, Rules for Data Quality Validation, and More. Register now & save!
http://www.dw-institute.com/education/conferences/orlando2002/m.asp


September 5, 2002—In this issue:

1. COMMENTARY

  • Beta Benefits

2. SQL SERVER NEWS AND VIEWS

  • Results of Previous Instant Poll: Notification Services
  • New Instant Poll: Beta Test Participation

3. ANNOUNCEMENTS

  • Mark Minasi and Paul Thurrott Are Bringing Their Security Expertise to You!
  • Get a Free Digital or Print Sample Issue Today!
  • We Have 2 Questions for You...

4. HOT RELEASE (ADVERTISEMENT

  • ProClarity Free Web Seminar
  • SQL Server Magazine LIVE!

5. RESOURCES

  • What's New in SQL Server Magazine: The T-SQL Banker
  • Hot Thread: Displaying a Timestamp
  • Tip: New Behavior of SQL:StmtCompleted

6. NEW AND IMPROVED

  • Generate Database Code
  • Determine What Objects You're Using

7. CONTACT US

  • See this section for a list of ways to contact us.

1. COMMENTARY

  • BETA BENEFITS

  • (contributed by Brian Moran, news editor, brianm@sqlmag.com)

    Do you have a passion for technology? Do you enjoy helping the technical community you work in? Have you wanted to participate in a SQL Server beta program but don't know how to get involved? You can serve your passion and your community by nominating yourself for consideration as a beta tester for one or two of the SQL Server beta programs currently seeking participants. Just visit the SQL Server beta registration page. These beta programs are slated to close in September, so get cracking if you're interested in beta testing SQL Server 2000 Service Pack 3 (SP3) or SQL Server 2000 64-bit Beta 2 (code-named Liberty).

    A SQL Server beta coordinator tells me that these betas are shaping up to be some of the best Microsoft has offered. These programs offer better interaction with the product team, access to detailed technical information about the product that might not otherwise be publicly available, and of course, freebies to the most active beta participants.

    Michael O'Connor, a program manager with the SQL Server beta team, is especially excited about the SP3 beta, scheduled to start in mid- to late September. "It's almost time for the newest service pack for SQL Server 2000, and you don't want to be caught unprepared for this one," O'Connor says. "In addition to the normal QFE fixes, the top service pack requests from our PSS organization, and the latest security fixes, this service pack will be shipping with MDAC 2.7 SP1."

    If you're more interested in beta 2 of the 64-bit version of SQL Server 2000, Microsoft, which released beta 1 last February, has some information for you. Liberty Beta 2, scheduled to start in late September, will incorporate all the updates of SQL Server 2000 SP3 and will be optimized for the newest addition to Intel's Itanium processor family: the Itanium 2 processor. If you've been considering moving to the 64-bit platform, the 64-bit version of SQL Server 2000 is what you need to begin building and testing your mission-critical applications on.

    The SQL Server development team relies on feedback from beta testers to ensure a quality release, so your participation in beta-testing programs can make a significant difference in a product's development. Not feeling philanthropic? How about this for motivation: Regular and active beta testers have many opportunities to develop personal relationships with senior members of the SQL Server development teams. Contacts in Redmond can be worth their weight in gold when you've got a problem to solve. Need a bit more icing on the cake? The most active beta testers for current SQL Server beta programs will be first on the list to participate in beta testing for the Yukon beta when it ships sometime next year.


    HEAD BACK TO SCHOOL ONLINE WITH SSMU!

    Introducing SQL Server Magazine University - a virtual classroom environment where you receive quality technical training - on your schedule. Microsoft Certified Trainers help you acquire practical SQL Server skills and prepare for your certification exam at the same time. 24/7 access to our Virtual Computer Lab allows the flexibility to learn new applications while keeping up with your day-to-day job duties. Our virtual computers are specifically configured for each training session - no need to set up the programs on your personal system - saving you valuable time. Move to the head of the class - enroll today!
    http://www.sqlmag.com/sub/webinar/ssmu


    2. SQL SERVER NEWS AND VIEWS

  • RESULTS OF PREVIOUS INSTANT POLL: NOTIFICATION SERVICES

  • The voting has closed in SQL Server Magazine's nonscientific Instant Poll for the question, "Are you using Notification Services for SQL Server?" Here are the results (+/- 1 percent) from the 234 votes:
    • 17% Yes
    • 13% Not yet, but I plan to
    • 55% No, but I'm interested in learning more about it
    • 15% No, and I'm not interested

  • NEW INSTANT POLL: BETA TEST PARTICIPATION

  • The next Instant Poll question is, "Which SQL Server beta tests are you planning to participate in?" Go to the SQL Server Magazine Web site and submit your vote for 1) SQL Server 2000 Service Pack 3 (SP3), 2) SQL Server 2000 64-bit Beta 2, 3) Both of the above, or 4) None of the above.
    http://www.sqlmag.com

    SPONSOR: ARE YOU WASTING TIME SEARCHING FOR SQL SERVER ANSWERS?

    The SQL Server Magazine Master CD gives you real-time, high-speed access to all the articles, code, and expertise from every issue of SQL Server Magazine ever published. Unique search features let you find what you need fast. Order your copy today!
    http://secure.duke.com/nt/sqlmag/archivecd/newsqlcdsub.cfm?code=ei282h1a


    3. ANNOUNCEMENTS


    (brought to you by SQL Server Magazine and its partners)

  • MARK MINASI AND PAUL THURROTT ARE BRINGING THEIR SECURITY EXPERTISE TO YOU!

  • Windows & .NET Magazine Network Road Show 2002 is coming this October to New York, Chicago, Denver, and San Francisco! Industry experts Mark Minasi and Paul Thurrott will show you how to shore up your system's security and what desktop security features are planned for Microsoft .NET and beyond. Sponsored by NetIQ, Microsoft, and Trend Micro. Registration is free, but space is limited so sign up now!
    http://www.winnetmag.com/seminars/roadshow

  • GET A FREE DIGITAL OR PRINT SAMPLE ISSUE TODAY!

  • SQL Server Magazine is the premier independent resource for SQL Server database solutions—packed with hands-on, how-to articles to keep your database running at peak performance. This technical handbook is now available in two convenient formats. Select your free digital or print sample issue at:
    http://www.sqlmag.com/sub.cfm?code=sfei212hdu

  • WE HAVE 2 QUESTIONS FOR YOU...

  • Will you take 30 seconds and answer two questions for us? Your feedback is much appreciated and will help us shape the vendor offerings that fund this newsletter. The survey is quick and VERY easy—just click here:
    http://www.zoomerang.com/survey.zgi?116GBPQ659DLWRPWWBVYNAS3

    4. HOT RELEASES (ADVERTISEMENTS)

  • PROCLARITY FREE WEB SEMINAR

  • During this free, one-hour seminar, ProClarity and Memorial Healthcare will discuss how analytics can be used to drive the efficiency and effectiveness of healthcare organizations.
    http://www.proclarity.com/health.html

  • SQL SERVER MAGAZINE LIVE!

  • SQL Server Magazine LIVE! will co-locate with Microsoft ASP.NET Connections and VS.NET Connections this October. Early Bird discount expires soon; register today to save $2,990 and access all three events (over 160 sessions) for the price of one!
    https://secure.win2000mag.com/events/sql_register.asp

    5. RESOURCES

  • WHAT'S NEW IN SQL SERVER MAGAZINE: THE T-SQL BANKER

  • A couple of SQL Server programming students tackled an interesting puzzle recently. In their production system, the students work with various financial applications that must apply interest rates or indexes to monetary values such as deposits. The students had a specific problem relating to this system and wondered whether it had a set-based T-SQL solution. The answer is: of course! In "The T-SQL Banker," Itzik Ben-Gan explores a generalized version of the problem the students presented so that you can adjust the solution to your organization's needs. This article appears in the September 2002 issue of SQL Server Magazine and is available online at
    http://www.sqlmag.com/articles/index.cfm?articleid=25914

  • HOT THREAD: DISPLAYING A TIMESTAMP

  • Reena has a text field in which users can add new data but can't modify existing data. She wants to add a timestamp each time a user enters data into the field, but in her current setup, the timestamp doesn't always display in the same area. For example, sometimes the timestamp appears above the newly added case history, and sometimes it appears at the top of the entire case-history list. Offer your advice and read other users' suggestions on the SQL Server Magazine forums at the following URL:
    http://www.sqlmag.com/forums/messageview.cfm?catid=5&threadid=8416

  • TIP: NEW BEHAVIOR OF SQL:StmtCompleted

  • (contributed by Brian Moran, brianm@sqlmag.com)

    Q. My SQL Server Profiler doesn't seem to be correctly processing SQL:StmtCompleted events. SQL Server Books Online (BOL) says that SQL:StmtCompleted will capture SQL statements as they execute within the body of a stored procedure. However, my system isn't capturing SQL statements within a procedure. What's wrong?

    A.The behavior of SQL Server 2000's SQL:StmtCompleted event capture changed when Microsoft released Service Pack 1 (SP1). Without SP1, the SQL:StmtCompleted event captures execution of SQL statements within a procedure, and you don't need to set the SP:StmtCompleted event. SQL Server 2000 SP1 and later require you to set the SP:StmtCompleted event to capture the execution of individual statements within a procedure, and the SQL:StmtCompleted event no longer captures execution of statements within a procedure. For a complete explanation of this change, see the Microsoft article "FIX: Incorrect Behavior in SQL Server Profiler Event Generation" at http://support.microsoft.com/default.aspx?scid=kb;en-us;q286119. Also, the updated version of BOL, which is available at http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp, correctly says that in SQL Server 2000 SP1 and later, you have to set SP:StmtCompleted to capture events within a procedure.

    Send your technical questions to questions@sqlmag.com.

    6. NEW AND IMPROVED


    (contributed by Carolyn Mader, products@sqlmag.com)

  • GENERATE DATABASE CODE

  • Digital Lenz announced Code Storm, software that can produce SQL code and program source code. To implement all the tasks required to maintain a database object, a developer can quickly produce native database code and Visual Basic (VB) code. You can use Code Storm's integrated Script Manager to manage your scripts. You can arrange your scripts in a structured way and store them on a network drive so the whole development team can access them. Code Storm supports SQL Server 2000 and 7.0. Pricing starts at $314. To use Code Storm, you need VB 6.0. Contact Digital Lenz at info@digital-lenz.com.
    http://www.digital-lenz.com

  • DETERMINE WHAT OBJECTS YOU'RE USING

  • LockwoodTech Software announced SQLClean 2.0, software that helps you determine which tables and views in your database you're using. SQLClean also analyzes the database to see what internal references exist between SQL objects. The software can then generate a file of SQL DROP statements to clean your database of useless objects. You can create file-search patterns to analyze all files of a particular language or project. Part of the SQL Developer Pack, which also includes Proc-Blaster, Auto-Audit, and Auto-Inserts, SQLClean starts at $958. Contact LockwoodTech Software at sales@lockwoodtech.com.
    http://www.lockwoodtech.com

    7. CONTACT US


    Here's how to reach us with your comments and questions:

    • ABOUT THE COMMENTARY — brianm@sqlmag.com
    • ABOUT THE NEWSLETTER IN GENERAL — mcrockett@winnetmag.com
      (please mention the newsletter name in the subject line)
    • TECHNICAL QUESTIONS — http://www.sqlmag.com/forums
    • PRODUCT NEWS — products@sqlmag.com
    • QUESTIONS ABOUT YOUR SQL SERVER MAGAZINE UPDATE SUBSCRIPTION?
      Customer Support — sqlupdate@sqlmag.com
    • WANT TO SPONSOR SQL SERVER MAGAZINE UPDATE?
      More than 102,000 people read SQL Server Magazine UPDATE every week. Shouldn't they read your marketing message, too? To advertise in SQL Server Magazine UPDATE, contact Beatrice Stonebanks at bstonebanks@sqlmag.com or 800-719-8718.

    SQL Server Magazine UPDATE is brought to you by SQL Server Magazine, the only magazine completely devoted to helping developers and DBAs master new and emerging SQL Server technologies and issues. Subscribe today.
    http://www.sqlmag.com/sub.cfm?code=ssei211x1y

    Receive the latest information about the Windows and .NET topics of your choice. Subscribe to our other FREE email newsletters.
    http://www.winnetmag.net/email