(Frank Fillmore) At IBM’s Information on Demand (IOD) conference held in Las Vegas in October of 2011, I was awarded an iPad 2 at the IBM Champions luncheon for working on the “most significant” Oracle to DB2 migration to that date.
Other News
Converting MS Access to MySQL with relationships
(Ivan Cachicatari) I have used tools like MySQL Migration Toolkit (*) and Bullzip’s Access To MySQL utility, both do a excellent job but without relationships. We can spend a lot of hours to identifying and creating relationships until now:
LPAD and RPAD functions in SQL
(Md. Humayun Rashed) Padding is the process which adds the given data with the message to make confirm a certain length. It can be to the left side or right side of the message. Suppose your message is “rashed”, and you want to add padding to the left side and the length you need is 10, and you want
Obsolete cursors
(Timur Akhmadeev) In the previous post I wrote about strangely behaving V$SQL. For some reason there were duplicate rows leading to wrong results issue when running DBMS_XPLAN.DISPLAY_CURSOR for a particular child cursor. I tried to reproduce the issue using simple test case – and it was reproduced.
Incremental Statistics Maintenance – what statistics will be gathered after DML occurs on the table?
(Maria Colgan) Incremental statistics maintenance was introduced in Oracle Database 11g to improve the performance of gathering statistics on large partitioned table. When incremental statistics maintenance is enabled for a partitioned table, oracle accurately generated global level statistics by a
Working With Variable Data
(Craig S. Mullins) One of the key design issues that is addressed in most DB2 applications is how to implement character data that varies in size from row to row. The basic trade-off is “ease-of-use and performance” versus “storage requirements.”
Dynamic Sampling (II) – Controlling The Activity – Part 2
(Randolf Geist) In the first part of this post I’ve provided a table that summarizes the Dynamic Sampling levels on session / system level. In the “Blocks Sampled” column there were numbers in brackets for the level 3 and 4 description. In the second part of this post I’ll explain why.
Touring the Tablix in SQL Server Reporting Services
(Stacia Misner) In SQL Server Reporting Services (SSRS), there are several controls (also known as data regions) that you can use to lay out your data in a report. You can choose one of the data visualization options, such as a chart, gauge, or map, or you can choose to present the data in a table,
Export table data in XML nodes with multiplicity grater than one
(IGO) In an XML structure, the multiplicity of a node defines how many times that node can appear. In the following example the data from 4 columns in one row in a table will be exported in a XML node with multiplicity of 4. Two methods of export will be shown, both use FOR XML clause and the second
Extending the Visual Studio 11 Web Browser Chooser and Browse With Menu to include Developer Profiles
(Scott Hanselman) I talked about some new features that have snuck made their way into the free version of Visual Studio for Web. One of the more useful ones is the Browser Chooser that allows you to quickly launch debug sessions with different browsers from within VS.