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 Database
    • Database
    • Networking

    SQL Server 2005 SP1 Arrives with Production-Ready Mirroring

    Written by

    Chris Preimesberger
    Published April 20, 2006
    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.

      The long wait for the production version of database mirroring is finally over for SQL Server 2005 fans.

      Microsoft on April 19 introduced Service Pack 1 for SQL Server 2005, the servers first major update since its launch Nov. 7, 2005. SP1 encompasses several new features besides database mirroring, including SQL Server Management Studio Express and additional, flexible options for independent software vendors.

      The SP1 release is the first result of a new SQL Server “customer-collaboration model” Microsoft has instituted, which uses customer feedback as the company formulates feature and security updates.

      Key new features include the production-ready version of database mirroring, in which the primary production server is mirrored at all times by a standby server. “This allows for automated, seamless failover between primary and standby server, if the primary server needs to come down,” SQL Server Senior Product Manager Carol Dullmeyer told eWEEK. “Its a really critical feature.”

      SP1 also includes the new SQL Server Management Studio Express. This express management tool offers management dialogs, graphical designers for databases, tables, views and queries, and graphical query execution plan display, all delivered in user interfaces that are now seamless across SQL Server management tool offerings.

      “We understood [through the customer-collaboration model] that for customers theres great benefit of continuity across SQL Server for [using] management tools,” Dullmeyer said. “We reshaped the plans a bit and delivered something tailored for the Express community. Before, there wasnt continuity. Part of our business is providing support for the breadth of customers we have, [so we need] a complete, rich data platform. If you have a certain experience using Express management tools, one of your partners might use another rendition [of the server tools]. So now its the same experience: similar interfaces and tools.”

      /zimages/2/28571.gifClick here to read eWEEK Labs review of SQL Server 2005.

      SP1 also entails a new, second option for Express users that will enable them to download lightweight or full-force versions. Thus, customers can choose between the standard Express download or one that includes Reporting Services and Full-text Search.

      “Within the Express community, there are distinct needs for how customers and partners might use technology,” Dullmeyer said. “For example, an ISV might want to put a trial application on CD; their priority is a very compact, lightweight footprint that can fit on a CD. In another scenario, an ISV is building an application with SQL Server Express, but they have other applications [separately] in a portfolio. And they also want continuity: reporting services, full-text search, other features like that. So the Express customer has the ability to use some advanced technology [as needed].”

      SP1 also has increased SAP business intelligence support. “Forty percent of new SAP deployments are using SQL Server, and 60 percent are also using Windows,” Dullmeyer said. Two new components in SP1—a Microsoft .Net provider for SAP NetWeaver Business Intelligence and a new MDX Query Designer—make SQL Server Reporting Services better equipped to support SAP NetWeaver Business Intelligence. This enables all SAP customers to use enterprise reporting provided by SQL Server.

      “All these updates tie back to our vision of end-to-end business insight—whether its small-business projects leveraging Express up to mission-critical solutions—including SAP solutions,” Dullmeyer said.

      Earlier in April, Paul Flessner, senior vice president of the Data and Storage Platforms Division at Microsoft, outlined the companys new data platform vision, titled “Your Data, Any Time, Any Place.”

      /zimages/2/28571.gifMicrosoft sketches its database road ahead. Click here to read more.

      This strategy includes investments in four core areas: Continuous Availability and Automation, including the announcement of SQL Server Always On Technologies; End-To-End Business Insight, enabling better business decisions; Dynamic Applications, delivering higher developer productivity and support for occasionally connected applications; and Beyond Relational, with support for current and emerging data types.

      Flessner also detailed the upcoming SQL Server Everywhere Edition, a new offering for a local store on clients of all types, which will provide a lightweight, compact subset of the capabilities found in other SQL Server editions. The first CTP is expected this summer, with the full release to manufacturing by the end of 2006.

      The SP1 (252.7MB to 909.4MB, depending upon which components are selected) can be downloaded here.

      /zimages/2/28571.gifCheck out eWEEK.coms for the latest database news, reviews and analysis.

      Chris Preimesberger
      Chris Preimesberger
      https://www.eweek.com/author/cpreimesberger/
      Chris J. Preimesberger is Editor Emeritus of eWEEK. In his 16 years and more than 5,000 articles at eWEEK, he distinguished himself in reporting and analysis of the business use of new-gen IT in a variety of sectors, including cloud computing, data center systems, storage, edge systems, security and others. In February 2017 and September 2018, Chris was named among the 250 most influential business journalists in the world (https://richtopia.com/inspirational-people/top-250-business-journalists/) by Richtopia, a UK research firm that used analytics to compile the ranking. He has won several national and regional awards for his work, including a 2011 Folio Award for a profile (https://www.eweek.com/cloud/marc-benioff-trend-seer-and-business-socialist/) of Salesforce founder/CEO Marc Benioff--the only time he has entered the competition. Previously, Chris was a founding editor of both IT Manager's Journal and DevX.com and was managing editor of Software Development magazine. He has been a stringer for the Associated Press since 1983 and resides in Silicon Valley.
      Linkedin Twitter

      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.