ClevelandDotNet

Listed below are click-by-click instructions for creating a document library, making it a trusted location, and using it to display an Excel 2007 spreadsheet via Excel 2007 web part. Create Document Library (with Excel as the default type) 1. Open the Home page to your site collection (i.e. http://moss101/Pages/Default.aspx ) 2. Click “View All Site Content” 3. Click "Create" 4. Click "Document Library" 5. Specify all the settings for the library, using Excel 2003 as the default type. For the sake of this example, the document library will be called “Warehouse Documents”. 6. A document library called "Warehouse Documents" is now created, accessible at http://moss101/Warehouse%20Documents/Forms/AllItems.aspx Make it a trusted location 1. Click "Central Administration" 2. Click "Shared Services Administration" 3. Click the Shared Service (i.e. "SharedServices1(Default)" ) 4. Click "open Shared Service Administration" 5

For those with projects utilizing SQL Server 2000, Microsoft issued End of Life dates for support. Mainstream Support End of Life - April 8, 2008 Extended Support End of Life - April 9, 2013 End of "free" support Hot fixes (non-security related) will require an extended hot fix support agreement to be purchased Microsoft will not support warranty support, new features, or design changes Security updates will continue to be provided Microsoft Support Lifecycle: http://support.microsoft.com/lifecycle/ MS SQL 2000 Lifecycle: http://support.microsoft.com/lifecycle/?LN=en-us&p1=2852&x=9&y=11 With the retirement of SQL Server 2000 around the corner, this brings up an interesting question for MCAD/MCSD candidates: Will this impact certification Exam 70–229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition? When will the exam be retired? Given Microsoft is still promoting the MCDBA certification on their site, I'm guessing 70-229

Office 2007 presented users with a new easy to UI, utilizing the new ribbon interface. However, not all users are comfortable with the new UI. A new ribbon customizer tool is available for Office 2007 providing a similar look and feel as previous versions of Office. To preview the ribbon customizer, go to http://pschmid.net/office2007/ribboncustomizer/featuretourpart3.php . A trial download version is also available.

This is an interesting article on debugging stored procedures, showing click-by-click directions. To view the full article, click here . In addition, another link was posted on this blog previously at http://clevelanddotnet.blogspot.com/2007/05/follow-up-questions.html .