CLOB: "CLOB
A CLOB (character large object) value can be up to two giga-characters long. A CLOB is used to store unicode character-based data, such as large documents in any character set.
The length is given in number characters for both CLOB, unless one of the suffixes K, M, or G is given, relating to the multiples of 1024, 1024*1024, 1024*1024*1024 respectively.Length is specified in characters (unicode) for CLOB."
Friday, March 4, 2011
Thursday, March 3, 2011
Web Content Extractor flash demos:
You can watch the flash demos which will demonstrate how easy it is to configure a data extraction task in Web Content Extractor.
Shows how to extract the best feature films from the IMDB website:
Video 1 (1280x1024 or higher resolution)
Video 2 (1024x768 or higher resolution)
Shows how to extract the best feature films from the IMDB website:
Video 1 (1280x1024 or higher resolution)
Video 2 (1024x768 or higher resolution)
Wednesday, March 2, 2011
Query Tool for ODBC
In order to connect to SQL Server DB one has to have the following details
1) Database server / machine name e.g. DBServer001
2) Database name e.g EcommerceDB or WBUFFDB
3) Credential:
This can be a Sql Server credentials (e.g. SomeUserName, somePWD) or windows credentials (Domain\USerNAme, Pwd)
___________________________________________________________________
Using Query Tool Query Tool is a standalone SQL query tool created by George Poulose, and is an ideal utility for testing SQL statements against ODBC Data Sources. (There's an ADO version too).
Obtaining Query Tool Query Tool can be down- loaded from the Web. To obtain a copy follow the link at the book's Web site: http://www.forta.com/books/ 0672321289/ .
To use Query Tool, do the following:
1. Query Tool uses ODBC to interact with databases, so an ODBC Data Source must be present before you can proceed (see the earlier instructions).
2. Before you can use Query Tool, it must be installed on your computer. Browse your program groups beneath the Start button to locate it.
3. A popup dialog will prompt you for the ODBC Data Source to be used. If the Data Source you need is not listed, click New to create it. After you have selected the correct Data Source, click the OK button.
4. Type your SQL statement in the upper right window.
5. Click the Execute button (the one with the blue arrow) to exe- cute the SQL statement and to display any returned data in the lower pane. (You can also click F5 or select Execute from the Query menu.)
1) Database server / machine name e.g. DBServer001
2) Database name e.g EcommerceDB or WBUFFDB
3) Credential:
This can be a Sql Server credentials (e.g. SomeUserName, somePWD) or windows credentials (Domain\USerNAme, Pwd)
___________________________________________________________________
Using Query Tool Query Tool is a standalone SQL query tool created by George Poulose, and is an ideal utility for testing SQL statements against ODBC Data Sources. (There's an ADO version too).
Obtaining Query Tool Query Tool can be down- loaded from the Web. To obtain a copy follow the link at the book's Web site: http://www.forta.com/books/ 0672321289/ .
To use Query Tool, do the following:
1. Query Tool uses ODBC to interact with databases, so an ODBC Data Source must be present before you can proceed (see the earlier instructions).
2. Before you can use Query Tool, it must be installed on your computer. Browse your program groups beneath the Start button to locate it.
3. A popup dialog will prompt you for the ODBC Data Source to be used. If the Data Source you need is not listed, click New to create it. After you have selected the correct Data Source, click the OK button.
4. Type your SQL statement in the upper right window.
5. Click the Execute button (the one with the blue arrow) to exe- cute the SQL statement and to display any returned data in the lower pane. (You can also click F5 or select Execute from the Query menu.)
Tuesday, March 1, 2011
SharePoint Replication - ROSS Overview
SharePoint Replication - ROSS Overview: "RepliWeb Operations Suite for SharePoint"
ROSS enables organizations to more effectively manage Content and Application Lifecycles within SharePoint® 2007 and 2010, resulting in an acceleration of release cycles and a reduction in administrative and operating expenses.
ROSS provides selective or comprehensive replication of functional elements and content throughout multi-stage (Development, Staging, Production) and multi-site (distributed) environments. ROSS manages the deployment and replication of sites, site collections, content, solutions, sandbox solutions, workflows (SharePoint and Nintex), structure, look & feel, navigation, features, content types (including Hubs), taxonomies, record centers, document sets, templates and galleries, themes, and so on. Recognized for its ability to accelerate deployment timelines, ROSS ensures production readiness of sites and invokes 'best practices' for change control processes.
N.B. Explored for one the client's need.
ROSS enables organizations to more effectively manage Content and Application Lifecycles within SharePoint® 2007 and 2010, resulting in an acceleration of release cycles and a reduction in administrative and operating expenses.
ROSS provides selective or comprehensive replication of functional elements and content throughout multi-stage (Development, Staging, Production) and multi-site (distributed) environments. ROSS manages the deployment and replication of sites, site collections, content, solutions, sandbox solutions, workflows (SharePoint and Nintex), structure, look & feel, navigation, features, content types (including Hubs), taxonomies, record centers, document sets, templates and galleries, themes, and so on. Recognized for its ability to accelerate deployment timelines, ROSS ensures production readiness of sites and invokes 'best practices' for change control processes.
N.B. Explored for one the client's need.
Subscribe to:
Posts (Atom)
Posts
