Top 10 SQL 2008 Features for SharePoint IT Pros

Top 10 SQL 2008 Features for SharePoint IT Pros

  • Comments 12

This is a SharePoint blog, so let me give you my top 10 reasons why a SharePoint Administrator would want to upgrade their SQL environment at RTM.  (I say RTM since the SharePoint team plans to support SQL 2008 at it's RTM release.)  I also look at this list and think it's not a bad list for any application that uses SQL for it's database.  Look for performance, manageability, and cost savings.

  1. Backup compression (25-35% at least) - huge cost savings and hey it's native! (note SQL 2005 encryption is not supported by product support but
  2. Transparent Encryption - transparently encrypt the data without the application needing to be aware or know about it.
  3. Database Mirroring Enhancements - compressed tlogs, more automatic failover options
  4. Policy Based Administration - manage policies across databases and even across instances and servers
  5. Cluster enhancements - easier to configure and more scenarios that it supports including many in WS08 that provide more intelligence for failover
  6. Resource Governor - limit wild database resources or control one database resources from another!
  7. Easier to deploy - Easier to install, easier to configure, on and on
  8. Reporting Services in SharePoint Mode (report builder rocks!) - easy reporting solutions built to leverage SharePoint mode with more flexibility and with ease.
  9. Data compression - smaller databases with the same amount of data (compression will vary, but watch the overhead on enterprise environments or heavy used environments)
  10. Powershell integration - super extensible and super scriptable

If you don't know what these things are, you should check out the SQL 2008 site.

Leave a Comment
  • Please add 1 and 3 and type the answer here:
  • Post
  • PingBack from http://msdnrss.thecoderblogs.com/2008/03/10/top-10-sql-2008-features-for-sharepoint/

  • "Reporting Services in SharePoint Mode (report builder rocks!) - easy reporting solutions built to leverage SharePoint mode with more flexibility and with ease."

    Can someone from the SQL Server or SharePoint team send this to the TFS team so they can support this mode. :)

  • I had a couple of people ask me if the 25%-35% was 25%-35% smaller or 25%-35% of the total size.  My limited tests have shown that it's 25%-25% of the total size.  I test it with a 120 MB database.  The compressed backup size was around 20 MB.  This was the Central Admin Content site, so it will be a little different than a usual Content DB.  I plan on doing some more testing and posting the results to my blog.

    tk

  • Todd, our experience is that the blobs don't compress much, so it's 25-35% compression with 30% speed increase.  So a 100GB database would be 65-75GB after compression.

  • Will Windows Server 2008, SQL Server 2008 and SharePoint (MOSS 2007 SP1) all play nice together or will there be additional hotfixes needed for some/all of the above?  I know about the newly released MOSS 2007 SP1 combo, but what about the other players in this game?  I've built a VM of Windows Server 2008 RTM, but haven't installed any flavor of SQL Server or MOSS on it because I'm waiting on SQL 2008 support by MOSS 2007.

  • PingBack from http://drewmace.blogspot.com

  • In case you have not heard, we’ll be launching a new version of SQL Server in 2008 (in the second half

  • In meinem RSS Reader bin ich über einen Post von Namic gestolpert: http://sharepoint.namics.com/2008/08/moss_2007_auf_sql_2008_install.html Es werden Spekulationen geäußert, dass man mit Hilfe des SQL2K8 die BLOB's also die Dateien in SharePoint auf die

  • If you're a SharePoint administrator, you might be asking yourself if there is any reason to upgrade

  • If you're a SharePoint administrator, you might be asking yourself if there is any reason to upgrade

  • Thanks for sharing features of ms sql 2008 database feaures for SharePoint.

  • Uma pergunta que acabo escutando com certa frequência é quais seriam as vantagens em migrar um ambiente

Page 1 of 1 (12 items)