(Chris Eaton) In my last posting I discussed the new larger rid format for tablespaces in DB2 9. This allows for more rows per page and more pages per table partition. As I mentioned any new DMS tablespace created in DB2 9 or any Automatic Storage Tablespace in DB2 9 will use the larger rid format b
Author: SSWUG Research
XML data validation using IBM DB2 Visual Studio 2005 .Net Add-in
(Farzad Farahbod) A repository, such as a relational database, provides the environment to securely share XML documents and XML schemas with authorized users. The authorized users have secure access to important XML documents and XML schemas at any time, from anywhere. By using a repository system t
Using the ASP.NET AJAX UpdatePanel, Triggers and PageRequestManager
(Dan Wahlin) Microsoft’s ASP.NET AJAX technology provides a quick and simple way to add AJAX capabilities into new or existing Web pages. In this video tutorial you’ll see how to use the UpdatePanel, refresh it using triggers and detect when it has finished updating using the PageRequestManager al
Using SQL for IIS Web Logs, Part 1
(Don Schlichting) This article explores the benefits and various methods of using Microsoft SQL Server to analyze IIS Web Server log files.
Updating a counter in different ways
(Johan Andersson) In MySQL Cluster a statement like update t1 set counter=counter+1 where pk=1 can be executed in a few different ways with great difference in performance.
Active/Active clusters in SQL Server
(Hilary Cotter) Multi-instance, Active/Active SQL Server cluster design is an involved process. To optimize high availability and performance, you must consider a number of components in ensuring both instances can run on a single node. I’ll walk you through these considerations including options fo
Comparing Partitioned Tables in Oracle and EnterpriseDB/PostgreSQL
(Lewis Cunningham) I’ve been spending a lot of time with EnterpriseDB. Because EnterpriseDB is based on PostgreSQL, my knowledge of PostgreSQL gets a little bit deeper as I use EnterpriseDB more and more.
When BizTalk Is Just What Your Business Intelligence Solution Needs
(Jeffrey Juday) Databases and reports are the flesh and bones of every business intelligence (BI) solution. With internal company database and reporting standards, often the toughest platform decision is selecting a tool to populate the reporting database. Typically, developers use an Extract, Trans
Use sitemap standards to help search engines
(Tony Patton) The goal of every Web site is to increase site visibility and user traffic. One way to increase site traffic is through search engine optimization. Another method is to use sitemaps, which allow you to specify what pages a search engine should process or index. The sitemap concept was
There is still stuff I hadn’t noticed (OBJECT_ID has a parameter for type of object)
(Louis Davidson) I was building a script to build a table I had built in my dev environment including inserts so I did a bit of hunting around and came upon Vyas’s script (http://vyaskn.tripod.com/) that is used to generate inserts from a table (script here: http://vyaskn.tripod.com/code/generate_in