SQL Server 2005
An update to my previous post on storing SQL BLOBs in SharePoint. Since MOSS SP1 it seems that you can do this in a supported way by implementing the ISPExternalBinaryProvider COM Interface. More info can be found in the WSS SDK. Limitations around using BLOB store provider (EBS) should be noted. Thanks to Itay for blogging about this! More info on EBS: http://blogs.msdn.com/husse...
Posted On Friday, March 21, 2008 10:20 PM | Feedback (1)
Donn Felker has wrote a good step-by-step article on how to access and search SQL BLOB Data from MOSS 2007. SharePoint can already search Office file formats stored in the database, this article can be used as a starting point for developing a separate database that hosts binary data readable by SharePoint. In large enterprises there is always a need to put in SLAs for various data contents, it is good practice to have a separate database containing BLOBs that could amount to significant storage...
Posted On Sunday, May 06, 2007 11:48 PM | Feedback (6)
Interesting article on how SPS 2003 was configured to work with SQL Server 2005: Guide to Reinstall - Migrate SPS 2003 to SQL 2005 There is also a useful link in the article on how to secure your SPS 2003 Portal
Posted On Thursday, January 19, 2006 9:01 AM | Feedback (2)
SQL Server 2005 Enterprise edition is now available for download for MSDN Universal subscribers More details on SQL Server 2005 Features Comparison The following table outlines the pricing and benefits for each edition of the Microsoft SQL Server 2005 product line. Pricing & licensing of Microsoft SQL Server 2005 Edition Pricing Benefit Size Key Features Express Free Fastest way to learn, build and deploy simple data-driven applications. 1 CPU1-GB RAM4-GB DB size 4-GB DB sizeSimple ReportingReplication...
Posted On Wednesday, November 02, 2005 6:32 AM | Feedback (1)
Ryan Stonecipher points out a new blog maintained by the Microsoft SQL Server Development Customer Advisory Team (what a mouthful!). The goal of their blog is to make entries of best practices and lessons learned from the most demanding SQL Server implementations in the world
Posted On Tuesday, November 01, 2005 6:03 AM | Feedback (1)
In this webcast the Vice Presidents of the soon to launch products: Visual Studio 2005, SQL Server 2005 and BizTalk Server 2006 talks about and answers questions from customers and partners whilst they play blackjack against each other to win a free trip to the San Francisco launch for a partner that they have selected. Examples of questions discussed in this webcast:Why are the 3 products being launch together?What is the difference between Windows Workflow Foundation and Biztalk...
Posted On Saturday, October 29, 2005 6:53 AM | Feedback (1)
TRY/CATCH blocks can be used to help resolve a deadlock. SQL Essentials: Using TRY/CATCH to Resolve Deadlocks in SQL Server 2005
Posted On Wednesday, October 26, 2005 1:43 PM | Feedback (1)
Davide Mauri has found a bug in SQL Server 2k5.....now how did they let this slip through... http://weblogs.sqlteam.com/
Posted On Wednesday, October 26, 2005 11:28 AM | Feedback (1)