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.
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
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).
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.
