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


THIS ISSUE SPONSORED BY

FREE SQL Tool from NetIQ
http://lists.sqlmag.com/cgi-bin3/flo?y=eM6i0E3SUn0BRZ0q250AZ

6 FREE MONTHS OF SQL SERVER MAG-DIGITAL DELIVERY
http://lists.sqlmag.com/cgi-bin3/flo?y=eM6i0E3SUn0BRZ02ZI0AW
(below COMMENTARY)

Trend Micro Enterprise Protection Strategy
http://lists.sqlmag.com/cgi-bin3/flo?y=eM6i0E3SUn0BRZ035i0AS
(below NEWS AND VIEWS)


SPONSOR: FREE SQL TOOL FROM NETIQ

Need to know what's going on in your database environment? Quickly and accurately identify and investigate specific SQL Server problems with NetIQ's diagnostic dashboard, SQLcheck. This FREE tool organizes and explains critical information about your database server hardware, its operating system and SQL Server. Get the information you need for efficient database management today. Download SQLcheck now!
http://lists.sqlmag.com/cgi-bin3/flo?y=eM6i0E3SUn0BRZ0q250AZ


August 15, 2002—In this issue:

1. COMMENTARY

  • Oracle Provider Might Boost .NET Success

2. SQL SERVER NEWS AND VIEWS

  • Results of Previous Instant Poll: Curtailing Software Bugs
  • New Instant Poll: Data Provider for Oracle

3. ANNOUNCEMENTS

  • Why Pay When You Can Get In-Person Security Expertise at No Charge?
  • Need to Keep Your Servers Running 24/7?

4. HOT RELEASES (ADVERTISEMENTS)

  • A Faster, Smarter Data Recovery Solution
  • New! - Distributed SQL Server Cluster
  • NetOp Remote Control - CrossTec
  • Microsoft ASP.NET Connections

5. RESOURCES

  • What's New in SQL Server Magazine: Top Online Discussion Forums
  • Hot Thread: Missing Performance Monitor Counters
  • Tip: Using QUERYOUT with Bcp

6. NEW AND IMPROVED

  • Solve Application Performance Bottlenecks
  • Make SQL Server Available to Any Client

7. CONTACT US

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

1. COMMENTARY

  • ORACLE PROVIDER MIGHT BOOST .NET SUCCESS

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

    Several weeks ago, Microsoft released the .NET Framework Data Provider for Oracle (available at the first URL below), which provides native .NET access to Oracle databases. I work primarily with SQL Server, but I've heard rumors that a few people in the world still use Oracle . Microsoft is protecting its interests by fully embracing all major database platforms, which the company needs to do to ensure the .NET Framework's success. The recent release of the managed .NET provider for Oracle helps Microsoft promote the .NET Framework for two important reasons.

    First, benchmark tests show that the new provider is up to 200 percent faster than the non-managed OLE DB provider for Oracle when you use it from a .NET-based application. Features are nice, but performance is king in the land of database development, and a 200 percent performance boost is a compelling reason to use this new provider. Developers might have been hesitant to use the .NET Framework Data Provider for Oracle unless performance was top-notch. You can check out benchmark results for the Oracle driver test run, which used the Nile 3.0 application benchmark suite, at the second URL below.

    Second, but perhaps even more important to .NET developers, the new .NET managed provider for Oracle uses a programming model that's similar to SQL Server's native .NET managed provider. So, .NET developers can use their database-development skills to work with data on a SQL Server or Oracle back end. In addition, Microsoft made great effort in designing the .NET Framework Data Provider for Oracle to fully support Oracle9i data types and other native Oracle functionality. Lack of full support for native Oracle data types was a small problem with the Oracle drivers that Microsoft provided in the past.

    Microsoft knows that it needs to provide compelling interoperability tools for customers who have heterogeneous environments. Microsoft needs to make rolling out .NET-based technology simple and painless. Customers shouldn't have to rip and strip their existing database infrastructure. And I'm sure it's just a coincidence that the SQL Server and Oracle managed .NET provider programming models are so similar. Microsoft would never consciously roll out a migration strategy for moving Oracle customers to SQL Server after they've written their applications in the .NET Framework. Would it?

    http://www.msdn.microsoft.com/downloads/sample.asp?url=/msdn-files/027/001/940/msdncompositedoc.xml&frame=true

    http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/manprooracperf.asp


    6 FREE MONTHS OF SQL SERVER MAG-DIGITAL DELIVERY

    Register for your next Microsoft exam with VUE and get a FREE 6-month subscription to SQL Server Magazine - delivered digitally to your desktop!

    Plus, you'll enjoy convenient real-time scheduling, on-time exam delivery and your results will be quickly and accurately returned to Microsoft. Try VUE's same-day testing! Find out more at
    http://lists.sqlmag.com/cgi-bin3/flo?y=eM6i0E3SUn0BRZ02ZI0AW


    2. SQL SERVER NEWS AND VIEWS

  • RESULTS OF PREVIOUS INSTANT POLL: CURTAILING SOFTWARE BUGS

  • The voting has closed in SQL Server Magazine's nonscientific Instant Poll for the question, "What's the best way to curtail the escalating number of bugs in software?" Here are the results (+/- 1 percent) from the 280 votes:
    • 4% Government regulation
    • 36% Unbiased software bug reports from a watchdog agency
    • 14% Fewest-bugs competition regulated by a standards organization
    • 38% More publicity about unacceptable bug levels in software
    • 9% Other

  • NEW INSTANT POLL: DATA PROVIDER FOR ORACLE

  • Sponsored by BMC
    SQL-Backtrack - a faster, smarter data recovery solution.

    Click for BMC Software's complimentary white paper.
    http://ad.doubleclick.net/clk;4503855;7273592;q?http://www.bmc.com/offers/sqlbacktrack_oracle/whitepaper/

    The next Instant Poll question is, "Are you interested in the new .NET Framework Data Provider for Oracle?" Go to the SQL Server Magazine Web site and submit your vote for 1) Yes—I'm already using it, 2) Yes, but I haven't used it yet, or 3) No.
    http://www.sqlmag.com


    SPONSOR: TREND MICRO ENTERPRISE PROTECTION STRATEGY

    SPAM IS A THREAT, NO MATTER HOW YOU SLICE IT

    If you've used a computer, you've been spammed. While we're all used to cleaning up with a few hits of the Delete button, few actually stop to consider the hidden dangers of spam. Spam can cause productivity to plummet, network storage to evaporate, and email system costs to skyrocket. It can even contribute to a network crash. Your mission is clear: stop spam NOW! Learn from Trend Micro how to stop spam from infiltrating your enterprise. Free offer below.
    http://lists.sqlmag.com/cgi-bin3/flo?y=eM6i0E3SUn0BRZ035i0AS


    3. ANNOUNCEMENTS


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

  • WHY PAY WHEN YOU CAN GET IN-PERSON SECURITY EXPERTISE AT NO CHARGE?

  • Windows & .NET Magazine Network Road Show 2002 is coming this fall 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. Registration is free, but space is limited so sign up now!
    http://lists.sqlmag.com/cgi-bin3/flo?y=eM6i0E3SUn0BRZ03lK0Ar

  • NEED TO KEEP YOUR SERVERS RUNNING 24/7?

  • Join Morris Lewis for SQL Server Magazine's next Web Seminar, "Planning Highly Available Database Server Environments," on August 27. This seminar will explain methods for achieving high availability and detail the criteria you must evaluate to determine which options will best suit your tolerance for risk and your budget. Register today!
    http://lists.sqlmag.com/cgi-bin3/flo?y=eM6i0E3SUn0BRZ03qd0AN

    4. HOT RELEASES (ADVERTISEMENTS)

  • A FASTER, SMARTER DATA RECOVERY SOLUTION

  • Don't wait for a disaster to realize the importance of protecting your data. Read more about the increasing importance of efficient 100% recovery. FREE white paper, compliments of BMC Software.
    http://ad.doubleclick.net/clk;4503865;7273592;r?http://www.bmc.com/offers/sqlbacktrack_oracle/whitepaper/

  • NEW! - DISTRIBUTED SQL SERVER CLUSTER

  • SQL-UP! ensures uptime and disaster-protection of SQL Server databases. The software clusters databases over LAN or WAN without a shared storage device. Clustered databases are automatically synchronized in realtime. For free download and more information:
    http://lists.sqlmag.com/cgi-bin3/flo?y=eM6i0E3SUn0BRZ03tL0A1

  • NETOP REMOTE CONTROL - CROSSTEC

  • NetOp, PC Magazine Editor's Choice, provides fast & secure remote support & management. Control PCs over the Internet, LANs or modems as if you were in front of them. Click to download a FREE evaluation!
    http://lists.sqlmag.com/cgi-bin3/flo?y=eM6i0E3SUn0BRZ03VC0AN

  • MICROSOFT ASP.NET CONNECTIONS

  • Microsoft ASP.NET Connections and VS.NET Connections will co-locate with SQL Server Magazine LIVE! this October. Early Bird discount expires soon, register today to save $2,990 and access all three events for the price of one!
    http://lists.sqlmag.com/cgi-bin3/flo?y=eM6i0E3SUn0BRZ03kX0A4

    5. RESOURCES

  • WHAT'S NEW IN SQL SERVER MAGAZINE: TOP ONLINE DISCUSSION FORUMS

  • Has a SQL Server problem got you stumped? You can often get valuable technical advice—or at least commiseration—from online discussion forums and newsgroups. Michael Otey gives his picks for the best online SQL Server discussion groups in his article "Top Online Discussion Forums," which appears in the August issue of SQL Server Magazine and is available online at
    http://www.sqlmag.com/articles/index.cfm?articleid=25729

  • HOT THREAD: MISSING PERFORMANCE MONITOR COUNTERS

  • Ric recently opened the performance monitor on a SQL Server machine and discovered that the SQL Server counters were missing. 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=7974

  • TIP: USING QUERYOUT WITH BCP

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

    Bulk copy program (bcp) lets you copy data out of SQL Server based on the result set of a query that's specified on the bcp command line. The Q&A "Does the SQL Server 7.0 version of bulk copy program (bcp) let you create an output file from a query without having a VIEW to put the result set in?" ( http://www.sqlmag.com , InstantDoc ID 5867) explains how you can use the QUERYOUT option to accomplish this kind of data copying. But a SQL Server Magazine reader recently told me about a bug in bcp that forces the query specified in QUERYOUT to execute twice. (For a full description of this bug, see the Microsoft article "BUG: Bcp.exe Executes Query Twice When QueryOut Argument Used" at http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;q309555 .)

    Of course, executing a query twice is inefficient, especially when you're dealing with large data sets. You can still selectively bcp out data by defining a view in SQL Server that encapsulates the query you'd otherwise specify with the QUERYOUT option. You'll get the same output data set, but the query won't run twice.

    Send your technical questions to savvy@sqlmag.com.

    6. NEW AND IMPROVED


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

  • SOLVE APPLICATION PERFORMANCE BOTTLENECKS

  • Precise Software Solutions released Precise/Indepth for SQL Server, software that lets DBAs detect and resolve the root causes of application performance degradation in SQL Server production databases. Precise/Indepth for SQL Server lets you capture, measure, and correlate performance metrics from system components. For pricing, contact Precise Software Solutions at 781-461-0700.
    http://www.precise.com

  • MAKE SQL SERVER AVAILABLE TO ANY CLIENT

  • ecommerce.cz released WebSQL Console 3.0, software that makes SQL Server available to any client through a Web browser. The software lets you back up databases, restore databases, change user passwords, and configure reports. For pricing, contact ecommerce.cz at mail@ecommerce.cz.
    http://www.websqlconsole.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@sqlmag.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

    Thank you for reading SQL Server Magazine UPDATE.