News

SQL 2K SP1 Hits Web

Microsoft Corp. will publicly unveil its first service pack for SQL Server 2000 on Monday at the Microsoft TechEd 2001 developer show in Atlanta.

The service pack, which comes 10 months after SQL Server 2000 was released to manufacturing, is not considered a required upgrade. "I can't point to one thing where we say we recommend this is something to fix," says Jeff Ressler, lead product manager for SQL Server 2000. "It's not something that we insist that all customers install."

The service pack includes 240 fixes. About 60 of those address bugs in SQL Server 2000 Analysis Services, the portion of SQL Server 2000 for OLAP and data mining.

Microsoft broke the service pack into three components. A core database component is a 45 MB download, an Analysis Services component is 38.2 MB and a Microsoft Data Engine component is 22.5 MB.

Some tuning in the service pack is specifically for the greater-than-eight-processor machines provided by Unisys Corp., Ressler says. The issue was documented several months ago when SQL Server 2000 achieved certified application status in the Windows 2000 Datacenter Server 2000 certification program. (See story).

The final code for the service pack was posted on Microsoft's TechNet Web site earlier this week, and on Microsoft's SQL Server page late Wednesday.

However, full descriptions for many of the fixes included in SP1 aren't expected to be posted on the site until Monday, Ressler said.

About the Author

Scott Bekker is editor in chief of Redmond Channel Partner magazine.

Featured

  • An image of planes flying around a globe

    2025 Microsoft Conference Calendar: For Partners, IT Pros and Developers

    Here's your guide to all the IT training sessions, partner meet-ups and annual Microsoft conferences you won't want to miss.

  • Google To Acquire Cloud Startup Wiz for $32 Billion

    Google has announced a pending agreement to acquire Wiz Inc., a cloud security platform, in an all-cash deal worth $32 billion.

  • FTC Expands Microsoft Antitrust Investigation Under Trump Administration

    The Federal Trade Commission (FTC) is pressing ahead with a broad investigation into Microsoft's business practices, an inquiry that began in the final weeks of the Biden administration.

  • Microsoft to Shut Down Skype Services

    Microsoft will discontinue its Skype telecommunications and video calling services on May 5, 2025, marking the end of the platform's decades-long run.