Thursday, February 22, 2007

SQL Server 2005 Service Pack 2: Extending the Functionality of Your SQL Server 2005 System

Download SQL Server 2005 SP2

Download SQL Server 2005 Express Edition SP2

Download the Updated SQL Server 2005 Books Online
--> Well books online.

Download SQL Server 2005 Feature Pack (February 2007)
--> The Feature Pack is a collection of standalone install packages that provide additional value for SQL Server 2005. It includes: latest versions of redistributable components for SQL Server 2005, latest versions of add-on providers for SQL Server 2005, latest versions of backward compatibility components for SQL Server 2005

Download Updated Samples and Sample Databases
--> 100 over new samples for all SQL 2005 services (Database Engine, including administration, data access, Full-Text Search, Common Language Runtime (CLR) integration, Server Management Objects (SMO), Service Broker, XML, Analysis Services, Integration Services, Notification Services, Reporting Services, Replication

Download SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies ---> this download allows you to run complete reporting functions within a SharePoint site. No need for report center site that is provided by SRS 2005 installation.
http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with-wss-3-0-and-moss-2007.aspx


Download SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007
--> Provides Excel and Visio add-in for Data Mining and Table Analysis

Two SharePoint must haves announced on the SharePoint Team Blog

The first is a cross browser compatible replacement for the rich text editor in MOSS 2007 that was mentioned on the SharePoint Team blog about 6 weeks ago.

The second is an offline reader for WSS 3.0 and MOSS 2007 sites, which is highly recommend for staying up to date with frequently updated sites such as the SharePoint Community Portal.

They are both available for free!

Monday, February 19, 2007

SQL Server on VM

In case you are wondering about running production SQL Servers on a VM (VMWare or Microsoft's Virtual Server), here is a good blog post.
http://sqlblog.com/blogs/rick_heiges/archive/2007/02/16/sql-server-on-vm.aspx

Thursday, February 15, 2007

With all the DST issues with Calendering..

Here is a good read about DTS basis.

http://www.news24.com/News24/Technology/News/0,,2-13-1443_2068994,00.html

Enterprise Search and Integrating SharePoint Server Search and Windows Desktop Search

Some interesting read at the SharePoint Team Blog and other SharePoint Blogs on SharePoint Search, Desktop Search and Internet Search.

Tips to Enable SharePoint Intranet Search using Windows Desktop Search 3.0 RTW
http://blogs.msdn.com/joelo/archive/2006/12/08/tips-to-enable-sharepoint-intranet-search-using-windows-desktop-search-3-0-rtw.aspx

Microsoft Enterprise Search 101: Technology and SKU breakdown
http://blogs.msdn.com/arpans/archive/2006/07/29/682715.aspx

Difference Microsoft Office SharePoint Server 2007 for Search, Standard vs. Enterprise, and between the MOSS 2007 Standard and Enterprise editions (search focused)
http://office.microsoft.com/en-us/sharepointsearch/FX102063541033.aspx

Tuesday, February 13, 2007

Microsoft's Business Intelligence

First there was Office Business Scorecards Accelerator from Microsoft. Then there was the Business Score Card Manager 2005 (BSM 2005). Now there is Microsoft Office PerformancePoint Server 2007. It gets bigger and better (and maybe $$: Office Business Scorecards Accelerator was free).

Q&A: Microsoft’s Business Intelligence Strategy
Microsoft Business Intelligence Blog
Chris Webb's BI Blog
Microsoft Office PerformancePoint Server 2007 Home Page

Note: The Microsoft Office Business Scorecard Manager 2005 Home Page will redirect the MS Office PerformancePoint Server 2007 Home Page

Saturday, February 03, 2007

Word works with open file styles

Microsoft has released tools that should make it much easier for users to share and save text-based files

Read more...

Version 1.0 of the Open XML Translator is now available for download from SourceForge.net, and on Microsoft's Web site here and here.