(Scott Hayes) In 2010, the “DB2 LUW Performance Analysis and Tuning Workshop” drew top attendance numbers in North America, Australia, and EMEA. In 2011, this IDUG Ed Seminar has been updated and is being offered again as session 1900. Click Here for Details.
Other News
Indexing A Column With Just One Distinct Value (All The Madmen)
(Richard Foote) When one thinks about a column that might benefit from being indexed, one generally considers columns with lots of different values so that the selectivity of the column is such that relatively few rows get selected, making the index appealing to the cost based optimizer.
Rolling Upgrade with Transient Logical Standby
(Uwe Hesse) We want to upgrade to a new Database Release with Minimum Downtime. We have a Physical Standby Database in place already. Starting with 11gR1, this Physical Standby can be used for a Rolling Upgrade, becoming a Transient Logical Standby only during that operation. This posting shows a de
Union, Intersection, Xor and Difference for Oracle Locator
(Simon Greener) Both the OGC and SQL3/MM Spatial standards for Simple Features include four standard geoprocessing operations as part of the basic type. Here is an extract from the OpenGIS’s Simple Features Specification for SQL, Revision1.1:
Animation in VB.NET, Part 3
(Richard Newcombe) In this article we are going to look at Bitmap Animations in VB.NET. In VB6 we had to make extensive use of API’s in order to load and initialize large quantities of smaller images. Now in .NET we have the GDI+ dynamic library that has a large selection of graphic classes and func
Microsoft SQL Server 2008 Reporting Services : Creating an Analysis Services Dataset (part 1) – Creating an Analysis Services Data Source & Building a Query
Before you can create an Analysis Services dataset, you must define a data source that stores the connection information for the Analysis Services server and database. Then, when you create the dataset, you provide an MDX query either by using a graphical interface to construct the query or by typin
Encrypt QueryString in ASP.NET 3.5 using VB.NET
This tutorial will show you how you can encrypt query strings in ASP.NET using the VB.NET programming language.
Convert Numbers to Words in VB.NET
(Sourabh Sharma) This project is about How to Convert any Number to Words. You can Convert any Decimal Number to Word using VB.NET.
SharePoint 2010 User Profile Properties Disabled when editing from Profile Page
(TRam Gopinathan) his one is a bit overdue post. I came across following error when editing profile properties from the profile page. This error is quite known and there many blog posts and forum threads out there that talks about this issue, but there is one bit of information that is missing and h
SQL Server Deadlocks Due to Character Data Type Conversion When Using SQL Server JDBC drivers
(Harsh Chawla) Recently, I worked on a case with one of my clients wherein SQL Server was encountering several deadlocks when they were running Stress Tests from application. They had tried several techniques to resolve this issue including forcing an index on the query, disable lock escalations and