(Sheeri Cabral) So, you are going to Collaborate (or thinking of going) and you saw my blog post about what to go to if you are a beginner with MySQL. But what if you are more experienced with MySQL? There is plenty of content for you too! I have put together this list of what I would recommend to a
Other News
DBPITR with a rman archival backup
(Harry Dragstra) One of our customers had this request:
Getting More From The REPORT Utility
(Shalom Momi Sabag) It has been way too long since my last post. In the past weeks I have been taking part in the DB2 Got Talent contest on the DB2 Night Show (www.db2nightshow.com).
DB2 returns errors if the connection string used by the BizTalk Adapter for DB2 does not include a Default Schema
(Stephen_R_Jackson) If you use the BizTalk Adapter for DB2 to connect to a DB2 system, you may see errors similar to the following in the application event log if you use a connection string that does not include a Default Schema:
Implicit datatype conversion in the parsing phase – something new I learned today!
(Tanel Poder) Wow, I wasn’t aware that Oracle can also do an implicit datatype conversion for literal strings during parsing phase!
Registering Database with OID : Directory does not contain the required Oracle Schema or Schema version is not correct
(Atul Kumar) In my previous post, I discussed about Enterprise User Security , This post covers issue I faced during Oracle Database Registration with LDAP Server (Oracle Internet Directory – OID)
Log Shipping in MS SQL Server 2008
(Amaresh Patnaik) Your users expect your systems will stay up as much as possible. This would be in the face of unexpected events such as system failures as well as planned downtimes such as maintenance or upgrades.
Adding Column to a SQL Server Table
(Dinesh Asanka) Adding a column to a table is common task for DBAs. You can add a column to a table which is a nullable column or which has default values. But are these two operations are similar internally and which method is optimal?
Using Table-Valued Functions in SQL Server
(Mika Wendelius) Table-Valued Functions have been around since SQL Server version 2005. Basically a Table-Valued Function is a function that returns a table, thus it can be used as a table in a query.
Using B2B processing policy to route messages in the WebSphere DataPower XB60 Appliance: Part 1
(Bala Gopalan) B2B processing policy is a powerful new feature in the WebSphere DataPower B2B Appliance XB60. It enables you to assign a processing policy to each business partner profile to perform authentication, validation, filtering, routing, and transformation on B2B messages.