Patrick\’s Bytes

27, May 2007

pschmid.net – pschmid.net: Putting You & I back into Office 2007’s Ribbon UI – The Office UI Bible

Filed under: Office Business Application — patrickyong @ 3:12 pm

 

Patrick Schmid is a OneNote MVP, in his blog there is an entry called Office UI Bible will list down webpages and blog entries (mostly from Jensen Harris) about the How, What and Why of the new Office 2007 UI, especially the ribbon interface and the themes.

Source: pschmid.net – pschmid.net: Putting You & I back into Office 2007’s Ribbon UI – The Office UI Bible

Advertisements

25, May 2007

Get MS product pricing fast!!!

Filed under: Uncategorized — patrickyong @ 6:49 pm

 This site is good for partners or any ISV wants to give a ball park figure to customer for any MS products. The numbers I got for SQL Server Std Ed with 1 Proc cost around USD5000 which is near the amount I got from my local reseller of RM19000 (USD1 = RM3.70). So this is good to get quick number without waiting for your MS Acc Mgr or reseller.

Link to Microsoft Product Licensing Advisor

24, May 2007

Create a Hello World Office 2007 Ribbon and Task Pane at in about 10 lines of codes

Filed under: Office Business Application — patrickyong @ 3:32 pm

 

I been looking out for a simple demo to show how many steps and how many line of codes I need to write to demo to people a simple custom ribbon and task pane solution. To be exact I found this demo video in MSDN website which show me that I need just around 10 lines of codes to do such a demo.

Check it out, just like creating a ‘Hello World’ console app.

23, May 2007

Office 2007 development Visual How-tos

Filed under: Office Business Application — patrickyong @ 5:54 pm

Erika compiled a list of video how-tos here.  There are about 50+ of them showing you how to develop on MOSS, WSS, Office 2007 client.

Link to Erika Ehrli : New Office Visual How-tos: MOSS and WSS 3.0

Setting Up a Development Environment for the 2007 Microsoft Office System

Filed under: Office Business Application — patrickyong @ 5:51 pm

 Office Business Applications are consist of combining different components within the 2007 MS Office System such as Office 2007 client, Biztalk 2006, MOSS 2007, and SQL Server 2005. This article shows how to create a development environment for the 2007 Microsoft Office System.

Link to Setting Up a Development Environment for the 2007 Microsoft Office System

22, May 2007

Using NOLOCK and READPAST table hints in SQL Server

Filed under: Database — patrickyong @ 9:09 am

To keep SQL Server on tip top performance, all care is taken into considerations when writing application. NOLOCK is one of the common SQL hint to prevent locking on data selection in the context of transaction. Too many lockings will results into record deadlocks.  Today come across READPAST hint which is similar to NOLOCK. Below is an extraction of the article found on Tech Republic.com

The READPAST table hint example is very similar to the NOLOCK table hint example. I’ll begin a transaction and update one record in the SalesHistory table.

BEGIN TRANSACTION      UPDATE TOP(1) SalesHistory      SET SalePrice = SalePrice + 1

Because I do not commit or roll back the transaction, the locks that were placed on the record that I updated are still in effect. In a new query editor window, run the following script, which uses READPAST on the SalesHistory table to count the number of records in the table.

SELECT COUNT(*) 
FROM SalesHistory WITH(READPAST)

My SalesHistory table originally had 300 records in it. The UPDATE statement is currently locking one record in the table. The script above that uses READPAST returns 299 records, which means that because the record I am updating is locked, it is ignored by the READPAST hint.

Link to Using NOLOCK and READPAST table hints in SQL Server

Create a free website or blog at WordPress.com.