(Nikhil Kothari) Hopefully everyone had a good few days off. Before the holiday break, I did some app-building on top of the ASP.NET MVC framework. Actually rather than building some sort of fancy app, instead I was prototyping some features on top of the framework bits slated for an initial release
Other News
IBM beefs up DB2 with encryption from Vormetric
(Lawrence Dietz) Vormetric, Inc. announced that it has partnered with IBM to deliver database encryption capabilities for DB2 on Windows, Linux, and UNIX. IBM will offer Vormetric’s data security solution as part of its data server portfolio, addressing customer demand for increased protection of se
Open Source Virtualization: Oracle VM enters the Virtualization arena
(Tarry Singh) Oracle OpenWorld was exciting. The virtualization arena is getting hotter than ever. Oracle unveiled its Oracle VM hypervisor, which is based on Xen open source hypervisor. As of 14 November 2007, SUN’s CEO Jonathan Schwartz unveiled their virtualization strategy with xVM platform; thi
Multiple scripts in MySQL Proxy
(Giuseppe Maxia) MySQL Proxy is being beefed up, to make it ready for prime time. New features are being added, and old ones are improved and tested. Testing the Proxy is an adventure in its own right. It’s a tool that was designed to get in the middle of the scene and change things. Testing its fe
Oracle BI EE – Catalog Reports
(Venkatakrishnan J) One of the very good features of the catalog manager is its ability to export Catalog related reports. For example, if you would like to have a detailed report containing the frequently accessed reports, last accessed time etc of the reports within a folder you have in the catalo
Debugging with the APEX repository
(Anthony Rayner) I was recently working on an APEX application on a familiar ‘Form on a Table’ wizard-built page and encountering a ORA-00957 Duplicate Column Name error, meaning that a column name must be specified more than once in the INSERT.
How To Create an Alert Using SQL Server Agent
(Mike Chapple) SQL Server allows you to automatically notify database administrators when unusual circumstances occur. This powerful alerting mechanism enables 24-hour monitoring of your database performance without staffing a 24-hour operations center.
Change Management
(Buck Woody) All technical professionals are concerned with performance, usability, maintenance and so on, but among technical professionals DBAs area some of the most paranoid, or at least they should be. We are entrusted with the data that runs a company or organization. The other team-members in
Filegroups Part I – Dividing Data for Performance
(James Luetkehoelter) It never fails to surprise me how rarely filegroups are leveraged in client installations. I’m also surprised at how many SQL Server DBAs are new to the concept of filegroups whenever I teach or give a presentation that includes them. For many of you, this may seem simplistic,
XML Indexes in SQL Server 2005
In our previous posts, we had covered some of the new features of XML in SQL Server 2005. You can search for XML on this site and get those posts. Since the XML data-type can hold up-to 2GB worth of data and since in the code might be querying portions of that XML document, it is important to be abl