Close
  • Latest News
  • Artificial Intelligence
  • Video
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Subscribe
Logo
  • Latest News
  • Artificial Intelligence
  • Video
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Subscribe
    Home Applications
    • Applications
    • Database
    • Development
    • Small Business

    Developers Prepare to Tackle SQL Server 2005 Upgrades

    Written by

    John Pallatto
    Published November 7, 2005
    Share
    Facebook
    Twitter
    Linkedin

      eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More.

      SAN FRANCISCO—The prolonged SQL Server upgrade cycle and questions about Visual Studio 2005s code quality were of little concern to some of the business application developers who attended Microsoft Corp.s product launch conference here Monday, saying they were ready to start evaluating or even deploying the products.

      Many of the attendees were employed by public agencies or small and midsize companies with limited resources for upgrades. For these customers, the releases of SQL Server 2005, Visual Studio 2005 and BizTalk Server 2005 were fairly timely.

      Government agencies dont usually have the money or resources to deal with the rapid-fire product upgrades that seem to be the norm in the software industry, said Pam Sheppard, principal IT analyst with Kings County in Californias central valley.

      /zimages/1/28571.gifWhy are some developers are questioning the quality of the Visual Studio Code that Microsoft released Monday? Read more here.

      “We will migrate to the new technology because you cant afford to fall behind … But it does put a burden on development process” because of resource shortages, she said. “The industry changes very rapidly, and the upgrade process can be very difficult for us because of limited resources in staffing, training and funding.”

      Sheppard said she has already attended the Microsoft Professional Developers Conference and the SQL Server 2005 road show to learn more of the technical details of the product.

      There are valuable advances in reporting and accounting in the new edition of SQL Server 2005, and this is important in county government, where accounting is a major function, Sheppard said. Thus, a move to SQL Server and Visual Studio is a “natural progression for us,” she said.

      /zimages/1/28571.gifClick here to read about the new features in SQL Server 2005 that might tempt customers to buy the upgrade.

      Sheppard said she is also involved with Web application development for Kings County, so getting access to the latest version of Visual Studio will be useful as well. She said she is not particularly concerned about questions raised in the developer community about the quality of the Visual Studio code.

      All software products have bugs, Sheppard said, adding that she is confident that Visual Studio is stable enough to use and that Microsoft will fix the remaining problems.

      Ari Gamo, the founder and owner of Saint Ari Solutions, a six-person consulting firm here in San Francisco, said he hopes to upgrade to Visual Studio 2005 to carry out contract development work on a asset management system and a time-keeping system operated by the City and County of San Francisco.

      The key advantage in Visual Studio 2005 for Gamos work is that it separates the business logic from the visual presentation layer, which enables more efficient and reliable coding.

      Gamo said he would also like to see the San Francisco government upgrade to SQL Server 2005 to support these applications, but that would be harder to convince city officials to spend additional money on the updated server, he said.

      Next Page: Developers kick the upgrades tires.

      Developers Kick Upgrades Tires

      Gamo said he wasnt particularly concerned about the length of time Microsoft spent before it was ready to release upgrades to SQL Server 2000 or Visual Studio, but he believed “it was about time for Microsoft to come up with a replacement” for the earlier versions.

      In general, he said, he thinks the results have been worth the wait in terms of providing valuable new tools for developers, such as code life-cycle management tools.

      “Now I just want to test it and drive it for myself” to see how well it really works, he said.

      Tensoft Inc., a Microsoft Gold certified partner and a developer of specialized supply chain management and ERP (enterprise resource planning) software for the microprocessor manufacturing industry, also plans to upgrade to the 2005 server products, said Sandeep Madduri, a business analyst with the company.

      The SQL Server 2005 reporting services will be particular valuable for the products that Tensoft develops for its customers, which are “fabless” chip manufacturers that outsource their actual chip production to overseas manufacturers, Madduri said.

      Major enterprises also attended the event to discuss how they were deploying SQL Server 2005.

      Giant book retailer Barnes & Noble Inc. is deploying SQL Server 2005 to track sales and inventory at its 821 retail stores to improve business intelligence and inventory planning, said CIO Chris Troia. He was one of five corporate IT executives who participated Monday in a Microsoft-organized SQL Server 2005 user panel.

      Barnes & Noble had been a large Microsoft customer for years but mainly for small, departmental applications, he said. However, the company decided to examine the possibility of basing the companys main sales data warehouse on SQL Server.

      “Some people thought we were crazy,” Troia said. But the company did a proof-of-concept pilot application with Microsoft and was convinced that SQL Server was capable of providing the performance required to support the application.

      The bookseller has built a 3TB data warehouse that stores three years of transaction data that will soon grow to a five-year running tally. As result, the data warehouse can track daily transactions and inventory to give Barnes & Nobel analysts and buyers accurate sales and inventory reports every morning.

      “Now we are able to do real rates of sales based on what is in stock” and the previous days sales, Troia said, adding that this allows the company to do more accurate out-of-stock predictions as the basis for placing new orders with publishers.

      Check out eWEEK.coms for the latest database news, reviews and analysis.

      John Pallatto
      John Pallatto
      John Pallatto has been editor in chief of QuinStreet Inc.'s eWEEK.com since October 2012. He has more than 40 years of experience as a professional journalist working at a daily newspaper and computer technology trade journals. He was an eWEEK managing editor from 2009 to 2012. From 2003 to 2007 he covered Enterprise Application Software for eWEEK. From June 2007 to 2008 he was eWEEK’s West Coast news editor. Pallatto was a member of the staff that launched PC Week in March 1984. From 1992 to 1996 he was PC Week’s West Coast Bureau chief. From 1996 to 1998 he was a senior editor with Ziff-Davis Internet Computing Magazine. From 2000 to 2002 Pallatto was West Coast bureau chief with Internet World Magazine. His professional journalism career started at the Hartford Courant daily newspaper where he worked from 1974 to 1983.

      Get the Free Newsletter!

      Subscribe to Daily Tech Insider for top news, trends & analysis

      Get the Free Newsletter!

      Subscribe to Daily Tech Insider for top news, trends & analysis

      MOST POPULAR ARTICLES

      Artificial Intelligence

      9 Best AI 3D Generators You Need...

      Sam Rinko - June 25, 2024 0
      AI 3D Generators are powerful tools for many different industries. Discover the best AI 3D Generators, and learn which is best for your specific use case.
      Read more
      Cloud

      RingCentral Expands Its Collaboration Platform

      Zeus Kerravala - November 22, 2023 0
      RingCentral adds AI-enabled contact center and hybrid event products to its suite of collaboration services.
      Read more
      Artificial Intelligence

      8 Best AI Data Analytics Software &...

      Aminu Abdullahi - January 18, 2024 0
      Learn the top AI data analytics software to use. Compare AI data analytics solutions & features to make the best choice for your business.
      Read more
      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Video

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2024 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×