Close
  • Latest News
  • Artificial Intelligence
  • 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
Logo
  • Latest News
  • Artificial Intelligence
  • 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
    Home Database
    • Database

    SQL Server 2005: I Said Be Cautious, Not Petrified

    By
    Charles Garry
    -
    November 11, 2005
    Share
    Facebook
    Twitter
    Linkedin

      In a recent article, I stated that people should be cautious in upgrading to SQL Server 2005. Some irate readers have taken that to mean that I think there is nothing worthwhile in the new release.

      I can understand why, based on the title and the initial subtitle (which was subsequently changed), a cursory glance could have given that impression.

      In any case, I thought I should make myself as clear as possible. SQL Server 2005 has a great many features that would recommend its use.

      As a former DBA, I am most excited about the new data-mirroring feature which is similar to Oracle Data Guards physical standby feature, but seemingly better at failback than Data Guard.

      /zimages/2/28571.gifThe wait for SQL Server 2005 ends. Click here to read more.

      It is an improvement over basic log shipping because it streams the active log changes. This could support both high availability or disaster recovery scenarios.

      Other HA features I like include online index builds and early restore access, which is another availability feature useful when database recovery is required.

      Other things like database snapshots or database views offer some interesting flexibility opportunities such as the offloading of reporting and analysis services.

      Suffice it to say I believe there are many excellent features in this release that DBAs will love, especially those that have supported other database platforms that already had similar functionality.

      Take data partitioning for example, which has finally been introduced for the first time. This is a key scalability enhancement and manageability enhancement for databases with very large amounts of data.

      Microsoft has taken an interesting approach to partitioning by utilizing partitioning functions which administrators can create and associate with a table or index.

      This means it is more flexible than simple range or hash partitioning. The security model seems much improved also, including a more granular permission model.

      So before any of you SQL Server fans out there get all upset, take a breath. My position is not that SQL Server 2005 is not a significant release—just that from a business standpoint there is no need to rush to it.

      Hey, its new, so its bound to have some issues as all new software does.

      /zimages/2/28571.gifDevelopers prepare to tackle SQL Server 2005 upgrades. Click here to read more.

      I am certainly not alone in this view. Check out Lisa Vaas recent article, which featured some survey results from SQL Server users and their likely plans to make the upgrade. It noted that only 13 percent of the responders plan to upgrade immediately.

      Eighty percent stated they need more time and 46 percent stated they would wait at least a year before they would trust it with their mission-critical systems.

      What does all of this mean? Simply that adoption cycles for new versions remain about the same even when it takes the vendor six years to come out with another version.

      If I wasnt clear in the previous article, let me state that the long release cycle, while undoubtedly unintended, was brilliant on Microsofts part. What can you say? Sometimes you just get lucky.

      People appreciate stability, and by George, we had that with SQL Server 2000. Lets all hope that this new version and its associated product, Visual Studio, prove to be solid, relatively stable pieces of software.

      In any case, if it were me and my IT processes were doing fine as they are, Id just assume we let that 13 percent figure out where all the problems are.

      As a general once said, “Men, Ill be right behind you all the way!”

      Charles Garry is an independent industry analyst based in Simsbury, Conn. He is a former vice president with META Groups Technology Research Services. He can be reached at cegarry@yahoo.com.

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

      Charles Garry
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.

      MOST POPULAR ARTICLES

      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
      Applications

      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
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Applications

      Kyndryl’s Nicolas Sekkaki on Handling AI and...

      James Maguire - November 9, 2022 0
      I spoke with Nicolas Sekkaki, Group Practice Leader for Applications, Data and AI at Kyndryl, about how companies can boost both their AI and...
      Read more
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      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.
      © 2022 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.

      ×