Free Newsletters
Technology & Business Daily

InfoWorld
Log-in | Register

Microsoft rolls public beta for SQL Server reports

Tool helps developers build reports that use the SQL Server database

By James Niccolai, IDG News Service
October 10, 2003
 

Microsoft Corp. on Friday released the first public beta of a product that should allow developers to build and manage reports using its SQL Server 2000 database. It also disclosed pricing for the product and pegged it for release by the end of the year.

Free IT resource

TechNet: More ways to know it, share it, and keep it running.

Sponsored by Microsoft

Free IT resource

Attend the SOA Executive Forum: Breaking SOA Bottlenecks SOAExecForum.com/may2007

Sponsored by InfoWorld

Called SQL Server 2000 Reporting Services, the software will be offered as an add-on for Microsoft's database and fills a hole in Microsoft's server line-up that customers have been asking it to fill, said Stan Sorensen, director of product management for SQL Server. Databases from Microsoft rivals such as IBM Corp. and Oracle Corp. have long supported reporting capabilities.

"It allows you to pull information from a variety of backend systems -- including SQL Server, of course, as well as Oracle, Sybase and other databases -- put that information into a single schema, and then be able to generate, distribute and manage reports based on that data," he said.

A closed beta of the software was released in May to more than 1,000 customers, Sorensen said. This is the first public beta and Microsoft expects to get tens of thousands of testers for it, he said.

Its availability will be announced at Microsoft's Worldwide Partner Conference in New Orleans Friday, where Microsoft executives will also discuss pricing for the finished product, which is due out by the end of the calendar year, Sorensen said.

Customers will need a SQL Server 2000 license for each server on which they run the reporting software, so if they run it on the same server as their Microsoft database they won't have to pay extra for it, Sorensen said. To run it on a separate server they'll have to buy a separate SQL Server license for that box, he said. SQL Server licenses start at US$5,000 per processor.

Third-party vendors are also using the reporting services software to build add-on products for Microsoft's database. For example, Cizer Software Corp. is building a product called Report Writer that will allow end users to design and generate reports from a Web browser using an XML (Extensible Markup Language) schema that Microsoft is introducing with its reporting software, according to a statement from Cizer.

Microsoft calls its schema the Report Definition Language and is trying to get partners in the reporting space, such as Crystal Decisions Inc., to support it as well, Sorensen said. Microsoft is in the process of deciding whether to submit the schema to a standards body, he said.

Microsoft also hopes to license its reporting software to vendors who want to use it in their own products. MaxQ Technologies Inc., of Norwalk, Connecticut, plans to embed it in a suite of business intelligence tools it sells, Sorensen said.

The next major upgrade to SQL Server, codenamed Yukon and due out in the second half of next year, will have more advanced reporting services built in, Sorensen said. Yukon is currently in a closed beta; Microsoft expects to offer a second, public beta in the first half of 2004, Sorensen said.

Microsoft hadn't planned originally to offer the reporting capabilities with SQL Server 2000, but since customers were keen to get their hands on it Microsoft decided to offer it as a SQL Server 2000 add-on, he said.





 

TOP NEWS:


»  Despite financial losses, Microsoft looks to increase investment in online services
Steve Ballmer says that the $488 million loss for the fourth quarter that the online services division reported is insignificant compared to the its potential

»  Think small with Linutop 2 PC
The tiny, energy-efficient Linux-based Linutop 2 is a low-cost, minimalist PC that is eerily quiet to use

»  Sun technologist: SOAP stack a 'failure'
Tim Bray, co-inventor of XML, prefers REST mechanism over SOAP

»  Software piracy hurts the open-source community too
Many nations are beginning to see stolen proprietary software as a lost opportunity for open source software, whose development can encourage innovation and job growth

»  Intel readies slew of embedded chips based on Atom core
Intel is trying to increase performance and drop power consumption in more than 15 system-on-chips that use the Atom core

»  Microsoft surprise reorganization aimed at online woes
Microsoft's online troubles hint at larger vulnerability; the company is facing challenges in areas that have been a lock for many years




Remote Access: Maintain Security and Decrease the Burden on IT
Join this interactive webcast to discover how IT Managers can control access rights, end-user security settings and end-point authorization. Sponsor: Citrix(R) GoToMyPC(R) Corporate

»  Click here to view this Webcast
  Zombie PCs Are Attacking Your LAN
A recent study showed that malware-infected zombie PCs are now a bigger threat to ISPs and Web infrastructure than DoS attacks. As this brand new IT Strategy Guide explains, an increased use of peer-to-peer techniques by the attackers has made it harder to fight back. Download now, compliments of Verio:

»  Click here to download now

- Special Advertising Partners -
WHITE PAPERS
 

» Technology White Papers Library

Technology White Papers by Topic

Technology White Papers E-mail Alert

Find out when the latest white paper is available:
 
 
INFOWORLD MARKETPLACE
 
» BUY A LINK NOW
 

FIND PRODUCTS AND COMPANIES
» COMPLETE PRODUCT GUIDE



TECHNOLOGY INDEX
• Applications
• Application Development
• Security
• Networking
• Wireless
• Platforms
• Hardware
• Data Management
• Storage
• Web Services
• Business
• Telecom
• Professional Services
• Standards

TECH WATCH 


What's the 411 on GOOG-411?
Just as Google has become synonymous with "performing a Web search," 411 is understood to mean "information" -- as in "what's the 411?" I was thus surprised to discover, from a billboard, no less, that the king of search is taking on the ...

Apple HTML source reveals 'iPhone Extreme'
"This one's a stretch..." reports AppleInsider. Um, yeah. Reporting on HTML code sightings of product names could be called a stretch, but iPhone Extreme has a ring to it. Now, that sounds like the product Apple should have released first, rather ...

COLUMNISTS

Unified under law
Ephraim Schwartz's Column and Blog (InfoWorld) - In the litigious world we live in, deploying a unified communications platform in your enterprise could...
» MORE COLUMNISTS

MORE INFOWORLD BLOGS


Open Sources 
Product Management
When I joined MySQL four years ago, there was quite a lot of debate about product management. We didn't actually have ...

Zero Day 
Botnet herders tending smaller flocks
New research backs up the theory that botnet operators are keeping their networks smaller in a continued effort to keep ...



• Advice Line
• Database Underground
• The Deep End
• Enterprise Mac
• Geeks in Paradise
• Grid Meter
• The Gripe Line
• InfoWorld Daily
• Inside IT
• IT Troubleshooter
• ITXtreme
• Open Sources
• ProdBlog
• Real World SOA
• Reality Check
• Security Adviser
• SMB IT
• The Storage Network
• Tech Watch
• Virtualization Report
• Zero Day

ADVERTISEMENT


RESOURCE CENTERadvertisement 

GOVERNMENT IT & POLICY
'If you don't go after the network, you're never going to stop these guys. Never.'
From the State Department, All the News for Inquiring Minds
TechPresident, the Internet Citizenry's New Consensus Taker



Sponsored Technology Links

 
 
 HOME  NEWS  BLOGS  PODCASTS  VIDEOS  TECHNOLOGIES  TEST CENTER  EVENTS  CAREERS   About | Advertise | Awards | RSS | Contact Us 

Copyright © 2008, Reprints, Permissions, Licensing, IDG Network, Privacy Policy, Terms of Service.
All Rights reserved. InfoWorld is a leading publisher of technology information and product reviews on topics including viruses,
phishing, worms, firewalls, security, servers, storage, networking, wireless, databases, and web services.

CIO :: ComputerWorld :: CSO :: Demo :: GamePro :: Games.net :: IDG Connect :: IDG World Expo
Industry Standard :: IT World :: JavaWorld :: LinuxWorld :: MacUser :: Macworld :: Network World :: PC World :: Playlist