(Grant Zhang) A SharePoint site and its contents can not only be created and updated manually, but also programmatically. Microsoft has provided SharePoint class libraries and web services for this purpose. I was involved in programmatically creating SharePoint sites, adding and updating web parts,
Other News
UNPIVOT, Normalization, SQL Server 2000 and SQL Server 2005
(Dennis Forbes) I’ve come across this question quite a few times. I have rows with lots of columns, and would like to split it out so that each column is a row.
Quick Visual Studio .NET Tips
(Karl Moore) The Task window in VB.NET is a great way of keeping track of tasks that are related to your project. For example, if you have code issues or compile errors, VB.NET will automatically list them here.
DB2 Data – Test Data Generation and Archiving: Two Underappreciated Arts
(Susan Lawson) There are many facets to a DBA’s work and responsibilities. We give focus to the most apparent and critical such as backup, recovery and data integrity. But what about the other parts of the job? Tasks such as creating accurate test data for proper application testing and the ability
Extending Oracle’s High Availability Framework with 10g Cluster Ready Services (CRS)
(Richard Stroupe) Previously in Oracle 9i RAC, customers who purchased the RAC option also had to depend on third-party venders such as Sun, Veritas and HP for cluster management support. Using multiple vendors for any high availability (HA) solution is very problematic and could introduce many obst
Tuning and Optimizing Red Hat Enterprise Linux for Oracle 9i and 10g Databases
(Werner Puschitz) This article discusses Red Hat Enterprise Linux optimizations for x86 (32 bit) and x86-64 (64 bit) platforms running Oracle 9i R2 (32bit/64bit) database, and Oracle 10g R1 and R2 databases (32bit/64bit). This guide covers Red Hat Enterprise Linux Advanced Server 2.1, 3, and 4.
Handling Cursor-Friendly Problems in T-SQL: Running Totals Example
(Mirko Marovic) By design, the SQL programming language works with data sets, so it is not surprising that for most problems, row by row processing is not nearly as efficient as data set processing. There is a class of problems, however, that is much easier to solve using cursors. A typical “cur
Developing spatial applications using Oracle Spatial and MapViewer
(Liujian (LJ) Qian) This white paper introduces briefly the main features of the up coming Oracle Spatial database 10g and Oracle Application Server MapViewer 10g. Through a case study we also show that these off-the-shelf products can serve as effective building blocks for large-scale spatiotempora
DB2 Content Manager for iSeries, Part 4: Client for Windows
(Jack Boswell) This article is a simplified user’s guide for the DB2 Content Manager Client for Windows on iSeries. It addresses the high-level functions of the Window’s Client. This information should be used in conjunction with the installation manuals and online help. The client application for W
Recommended reading list: DB2 UDB for Linux, UNIX, and Windows database administration
(Cindy Wong and Samuel Poon) This article provides a list of online learning resources for DB2 UDB for Linux, UNIX, and Windows. The DB2 UDB Information Center is also a good source of information. Many of the items listed below are published as articles on IBM developerWorks or as IBM Redbooks. Thi