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


THIS ISSUE SPONSORED BY

I HATE CHANGING MY SERVICE ACCOUNTS, HOW ABOUT YOU?
http://www.lanicu.com/cgi-bin/sql53002.cfm

SQL Server Magazine — No Risk Offer!
http://www.sqlmag.com/sub.cfm?code=sf
(below COMMENTARY)

FREE SQL Tool from NetIQ
http://www.netiq.com/f/form/form.asp?id=530
(below NEWS AND VIEWS)


SPONSOR: I HATE CHANGING MY SERVICE ACCOUNTS, HOW ABOUT YOU?

Ever ask yourself if there's a tool that will let you EASILY change your Administrator accounts on Exchange and SQL Server at the same time? Need a tool to restart leaking services or need to reboot your servers on a regular basis while you're home sleeping, resting, or watching a ball game? Trying to automatically manage off-line machines? Want to change services on hundreds or thousands of machines at the same time? Want to see ALL services on ALL machines in a single list? Try Lieberman & Associates' SERVICE ACCOUNT MANAGER and save yourself hundreds to thousands of hours each year.
FREE TRIAL:
http://www.lanicu.com/cgi-bin/sql53002.cfm


May 30, 2002—In this issue:

1. COMMENTARY

  • SQL Server Shines in Database Market Report

2. SQL SERVER NEWS AND VIEWS

  • Spida Worm Infects SQL Server Systems
  • Results of Previous Instant Poll: SQL Server Security
  • New Instant Poll: RDBMSs in Use

3. ANNOUNCEMENTS

  • Nextech 2002
  • Immediate Access to T-SQL Solutions!

4. HOT RELEASE (ADVERTISEMENT)

  • Free Technical Poster — "DTS Object Model"

5. RESOURCES

  • What's New in SQL Server Magazine: The Data Is Job One
  • Hot Thread: Problems Linking a Sybase Database to SQL Server 2000
  • Tip: Appending an IDENTITY Column to a Temporary Table

6. NEW AND IMPROVED

  • Compare and Sync Databases
  • Perform Light-Duty Management of Database Servers

7. CONTACT US

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

1. COMMENTARY

  • SQL SERVER SHINES IN DATABASE MARKET REPORT

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

    Gartner recently released its summary of 2001 relational database management system (RDBMS) market share and revenue numbers. Many of the trends are similar to those the research company reported last year, which I wrote about in "Database Wars Heat Up"
    http://www.sqlmag.com/articles/index.cfm?articleid=21431 ).

    I encourage you to read the Gartner report, "DBMS Software Market: Flat but Not Calm," which is available free at http://www.gartner.com/reprints/microsoft/106576.html. The article is only three pages long and contains detailed breakdowns of DBMS market share and revenue numbers for 2000 and 2001 for all major vendors. Here are some interesting points I observed about this data.

    • The Windows platform is the unquestionable sweet spot in the database market. The Windows RDBMS market grew overall by 11 percent, whereas the UNIX RDBMS market shrunk overall by 1.4 percent. At this rate, the total worldwide market for Windows-based RDBMSs will be within less than 10 percent of the total market for UNIX-based RBDMSs within 1 year and new Windows-based RDBMS sales will exceed UNIX sales in less than 2 years.
    • IBM and Microsoft are both doing well, whereas Oracle's fortunes seem to be declining. IBM's 2001 market share increased by a respectable 6.2 percent. Microsoft's 2001 market share increased by an amazing 25.3 percent. Oracle's 2001 market share shrunk by 4.9 percent.
    • SQL Server has finally become the dominant RDBMS on the Windows OS in terms of revenue and is the only Windows RDBMS platform with more than $1 billion in revenue. SQL Server claims 39.9 percent of the Windows RDBMS market, which is almost 6 percent higher than Oracle and is almost double IBM's third-place finish. In other words, SQL Server is the leading RDBMS on the world's fastest-growing RDBMS platform.

    What accounted for SQL Server's rapid growth in an otherwise tepid market? Sheryl Tullis, SQL Server product manager, said, "Customers are deploying their new projects on SQL Server 2000 because it's a data management and analysis platform—not just a database like our competitors offer. Customers see the value of the integrated BI and development tools, low cost of ownership, and tight integration with the .NET platform."

    The Gartner report's findings probably won't surprise anyone. These trends have been developing for several years, and I predicted their acceleration in my market share commentary last year when I wrote: "Windows RDBMS growth will accelerate while growth on the UNIX platform slows. Why? Because dot-com implosions have made people much more careful about how they spend their money, and Windows RDBMS solutions tend to be more cost-effective than UNIX solutions."

    Those market dynamics haven't changed, and I expect both the SQL Server and Windows RDBMS markets to continue to grow rapidly while the UNIX RDBMS market continues to contract.

    CORRECTION: In my May 16 SQL Server Magazine UPDATE commentary "Staying Ahead in the Security Game" ( http://www.sqlmag.com/articles/index.cfm?articleid=25248), I stated that you need to apply the patch in Microsoft Security Bulletin MS02-020 (SQL Extended Procedure Functions Contain Unchecked Buffers) to SQL Server 2000 Service Pack 2 (SP2) and SQL Server 7.0 SP4. However, SQL Server 7.0 SP4 includes the patch. So, you need to apply the patch only if you're running SQL Server 7.0 SP3 or earlier. You don't need to apply the patch if you're running SQL Server 7.0 SP4.


    SPONSOR: SQL Server Magazine — No Risk Offer!

    Hands-on, how-to articles covering Database Modeling, ADO.NET, XML, Performance Tuning, Security and all of the issues database developers and administrators need to know to manage SQL Server. Subscribe to SQL Server Magazine with this NO RISK offer, and if for any reason you are not satisfied with your first issue, just write cancel on the invoice and return it to us. Keep the first issue with our compliments — no questions asked. Subscribe today at:
    http://www.sqlmag.com/sub.cfm?code=sf


    2. SQL SERVER NEWS AND VIEWS

  • Spida Worm Infects SQL Server SYSTEMs
    (contributed by Mark Joseph Edwards)

  • SQL Server DBAs can apply third-party software or review their system settings to guard against the Spida worm, which affects SQL Server systems. Spida, first detected last week, infects SQL Server machines that have a blank systems administrator (sa) account password. The worm's primary action is to obtain a copy of the system's SAM database, which stores sensitive account information such as usernames and password hashes, and email the database to a recipient. The worm is written in JavaScript, batch files, and compiled executables and contains a scanner that searches for other SQL systems to infect. The scanner can create large amounts of network traffic because it can spawn up to 100 threads during its scanning operations.

    Antivirus software vendors have updates available to clean the worm from infected systems. Networks with firewalls that guard against intrusion to SQL Server machines (port 1433) are protected against infection from external systems. Users need to check that their SQL Server systems don't have blank passwords related to any user account, including the sa account. In addition, Microsoft has an online document that helps users secure their SQL Server installations. Users need to review the document for any relevant configuration settings that might help protect their systems. The online document is available at http://www.microsoft.com/sql/techinfo/administration/2000/security.asp.

  • RESULTS OF PREVIOUS INSTANT POLL: SQL SERVER SECURITY

  • The voting has closed in SQL Server Magazine's nonscientific Instant Poll for the question, "Do you spend more or less time managing SQL Server security protocols than you did two years ago?" Here are the results (+/- 1 percent) from the 130 votes:
    • 15% Significantly more time
    • 35% Somewhat more time
    • 22% About the same amount of time
    • 12% Less time
    • 15% Don't know or doesn't apply

  • NEW INSTANT POLL: RDBMSs IN USE

  • The next Instant Poll question is, "Which relational database management systems (RDBMSs) are in use at your company?" Go to the SQL Server Magazine Web site and submit your vote for 1) SQL Server, 2) Oracle and SQL Server, 3) DB2 and SQL Server, 4) Oracle, DB2, and SQL Server, or 5) Other.
    http://www.sqlmag.com

    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://www.netiq.com/f/form/form.asp?id=530


    3. ANNOUNCEMENTS


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

  • Nextech 2002

  • Nextech 2002 is the new event for the next generation of IT covering storage, Web services, outsourcing, and networking. This FREE conference and exhibition runs June 11-13, 2002 at Earls Court, London. Register now!
    http://www.nextecheurope.com

  • Immediate Access to T-SQL Solutions!

  • Exclusive, in-depth articles, tips, tricks, and code samples all at your fingertips. Content you can't get anywhere else—brought to you by the SQL Server experts you trust such as Kalen Delaney, Itzik Ben-Gan, and others. Increase your productivity today! Go to the following URL.
    http://www.tsqlsolutions.com

    4. HOT RELEASE (ADVERTISEMENT)

  • Free technical poster — "DTS Object Model"

  • --Log Explorer: Audit data changes — without triggers

    --Recover lost data and dropped tables — while your database remains online!

    --Request free poster — or download free trial:

    http://www.lumigent.com/go/sqmg05

    Be sure to visit us next week for an exciting announcement.

    5. RESOURCES

  • WHAT'S NEW IN SQL SERVER MAGAZINE: THE DATA IS JOB ONE

  • Protecting and managing corporate data is a DBA's top priority. In "The Data Is Job One," Michael Otey encourages readers to avoid getting sidetracked by day-to-day troubleshooting problems that might undermine responsible data-management practices. The article appears in the June 2002 issue of SQL Server Magazine and is available online at the following URL:
    http://www.sqlmag.com/articles/index.cfm?articleid=24969

  • HOT THREAD: PROBLEMS LINKING A SYBASE DATABASE TO SQL SERVER 2000

  • Dgangi is having problems linking a Sybase database to a SQL Server 2000 machine. He can see the Sybase database's schema objects in Enterprise Manager, but queries to the linked server fail. 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=8&threadid=6416

  • TIP: APPENDING AN IDENTITY COLUMN TO A TEMPORARY TABLE

  • (contributed by the Microsoft SQL Server development team)

    Q. I want to append an IDENTITY column to the temporary table that the following SELECT INTO statement returns:

    SELECT * INTO #tmp FROM Products
    ALTER TABLE ADD columned INT IDENTITY

    Although I currently use ALTER TABLE, I suspect I'm making the query more complicated than I need to. How can I append the IDENTITY column another way?

    A. We don't recommend using ALTER TABLE to append an IDENTITY column because it logs an update on a row-by-row basis. And in the absence of the appropriate fill factor, ALTER TABLE also causes page splits. Using SELECT INTO with the IDENTITY(type, seed, increment) clause is a more efficient method because SQL Server has to pass through the data only once and SELECT INTO uses the FAST BULK LOAD APIs to copy the data. To see an example of how to use SELECT INTO with the IDENTITY clause and a Bulk-Logged Recovery model to ensure minimal logging, click Listing 2 in the online version of the article "Appending an IDENTITY Column to a Temporary Table" at the following URL:
    http://www.sqlmag.com/articles/index.cfm?articleid=24506

    Send your technical questions to questions@sqlmag.com.

    6. NEW AND IMPROVED


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

  • COMPARE AND SYNC DATABASES

  • Red Gate Software announced SQL Compare 2.0.1, software that lets DBAs compare and synchronize the structure and contents of SQL Server 2000 and 7.0 databases. The new release supports data-type changes and dependencies. The software graphically displays differences between the development and production databases. SQL Compare costs $195 as a standalone product. Contact Red Gate Software at 866-498-9946.
    http://www.red-gate.com

  • PERFORM LIGHT-DUTY MANAGEMENT OF DATABASE SERVERS

  • TechRev announced SQL Server Web Explorer (SSWE), software that lets you perform light-duty management of SQL Server 2000 database servers. The software lets multiple users create and delete databases; create, modify, and delete tables, fields, and views; and view and add data. The software complements SQL Server Enterprise Manager. Pricing is $49.95 for unlimited users through August 2002. After that date, the pricing will be $49.95 for one Web user and $299.95 for an unlimited number of Web users. Contact TechRev at chris@techrev.net.
    http://www.techrev.net/sswe

    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.winnetmag.net/forums
    • PRODUCT NEWS — products@winnetmag.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