MOSS Features Management Tool
Lazy to use stsadm to manage SharePoint features such as install, activate, deactivate, uninstall? Then download this tool and run it on your SharePoint Server. The tool I believe has dependency on SharePoint.dll so you can run it on the client.
Screen shot below showing a feature got uninstalled.
4 cool new features about SQL Server 2008 codename Katmai
Time Chapman, a SQL Server DBA written about the features he likes in SQL Server 2008, the 4th one in his list is my favorite too for a developer viewpoint. Change Data Capture makes it easier to create audit log components if you use of stored procedure for data tier coding.
September’s TechEd Southeast Asia 2007 features a few topics too about Katmai both for DBAs and developers.
Enterprise Data Management Track
- BI enhancement in SQL Server 2008
- Next release of SQL Server: Data Warehouse Enhancement
- SQL Server 2008: Overview
- SQL Server 2008 Manageability Overview
Sync your database to SharePoint using SSIS
Custom SharePoint lists are like tables in a traditional database; in some ways they’re even better. But as organizations adopt this new data store, they introduce additional complexities in integrating new list-based solutions with existing database applications. This article shows you how to solve the data mismatch problem by using the Extract Transform and Load (ETL) capabilities of Microsoft SQL Server Integration Services (SSIS) and Microsoft’s new Collaborative Application Markup Language (CAML).
Offline OLAP Cube browsing in Excel 2007
Just realize today that I can actually download the whole OLAP cube and browse with Excel 2007 when you offline. Below are the steps:
1. Access the .ODC file online
2. When you click Open, you will fire up Excel and the Pivot Table Field List.
Construct you Excel Pivot Table view. For example I put Reason on Row Labels, Calendar Year, Quarter and Month on Column Labels and Incidents Count on Values.
To take the cube offline, click on Options –> OLAP Tools –> Offline OLAP
Because you don’t have a Offline data file, on the Offline OLAP Settings window you will see Offline OLAP option is grayed out. Create the data file by click on Create Offline Data File.
You will be presented by a wizard, click Next on the first screen
Because a real life data warehouse is huge and you might not want every data, you can choose the level of field you want to store in the offline data file. Then click Next.
Then specify the item within the level and click Next.
Finally specify where you want to store the data file and click Finish
Now you see Offline OLAP option is enabled.
2 OBA RAPs VHD available for download
The OBA team has made Loan Origination and Public Service E-forms OBA RAP Virtual Hard Disk (VHD) available for download at http://connect.microsoft.com
 If you are in South East Asia region want to find out more about these OBA RAPs, do come to TechEd SEA 2007 and attend the follow sessions.
Office System & Messaging Track
- Microsoft Sharepoint Products & Technologies 2007: Administrative Architecture & Planning for Deployment, Part 1
- Microsoft Sharepoint Products & Technologies 2007: Administrative Architecture & Planning for Deployment, Part 2
- SharePoint Governance & Information Architecture Guidance
- Building Apps with MOSS 2007 Excel Services
- Reporting solutions in Office 2007 and SharePoint 2007
- Doc Management in SharePoint 2007
- Integrate LOB with SharePoint Business Data Catalog
Architecture Track
- Office as a Platform Architecture?
Developer Track
- Developing Real World OBA
- Open XML Architecture and Benefits
- Anatomy of OBA
- Workflow in real world
