Patrick’s Bytes

Techie for the past 30 years…

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.

image

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

  1. BI enhancement in SQL Server 2008
  2. Next release of SQL Server: Data Warehouse Enhancement
  3. SQL Server 2008: Overview
  4. 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).

http://www.devx.com/dotnet/Article/35070?trk=DXRSS_DOTNET

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

image

2. When you click Open, you will fire up Excel and the Pivot Table Field List.

image

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.

image

To take the cube offline, click on Options –> OLAP Tools –> Offline OLAP

image

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.

image

 You will be presented by a wizard, click Next on the first screen

image

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.

image

Then specify the item within the level and click Next.

image

 Finally specify where you want to store the data file and click Finish

image

Now you see Offline OLAP option is enabled.

image

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

  1. Microsoft Sharepoint Products & Technologies 2007: Administrative Architecture & Planning for Deployment, Part 1
  2. Microsoft Sharepoint Products & Technologies 2007: Administrative Architecture & Planning for Deployment, Part 2
  3. SharePoint Governance & Information Architecture Guidance
  4. Building Apps with MOSS 2007 Excel Services
  5. Reporting solutions in Office 2007 and SharePoint 2007
  6. Doc Management in SharePoint 2007
  7. Integrate LOB with SharePoint Business Data Catalog

Architecture Track

  1. Office as a Platform Architecture?

Developer Track

  1. Developing Real World OBA
  2. Open XML Architecture and Benefits
  3. Anatomy of OBA
  4. Workflow in real world
Older Posts »