(Peter Zaitsev) I’ve been working with an application which does a lot of CREATE and DROP table for Innodb tables and we’ve discovered DROP TABLE can take a lot of time and when it happens a lot of other threads stall in “Opening Tables” State.
Other News
Understanding 4KB Sector Support for Oracle Files
(Karen Reliford) An important decision that DBAs make when they are first creating a new Oracle database is what the standard database block size should be. Once the database is created, it is virtually impossible to change the standard block size without recreating the entire database.
Re-engineering applications using optimized local adapters on WebSphere Application Server for z/OS
(James T Mulvey, Timothy Kaczynski and Frank Golazeski) IBM WebSphere Application Server for z/OS V7 introduced optimized local adapters support to provide an optimized, high performance bi-directional connector for WebSphere Application Server and applications running in external z/OS address space
Data Separation Techniques
Virtual Workshop: SQL Server 2008 Indexes – Internals and Best Practices Feb. 25, 2011 Along with a good database design I would say that Indexes are a cornerstone to good database performance. There are a lot of other skills you can develop in relational databases; but without these two skills, you’re going to find yourself in a heap of trouble. […]
Separation of Customer Data for Hosted Solutions
Virtual Workshop: SQL Server 2008 Indexes – Internals and Best Practices Feb. 25, 2011 Along with a good database design I would say that Indexes are a cornerstone to good database performance. There are a lot of other skills you can develop in relational databases; but without these two skills, you’re going to find yourself in a heap of trouble. […]
Sending Beans as XML with JmsTemplate
(Gordon Dickens) We often want to send XML via web services. We may already have the schema or annotated JAXB2 classes configured in our application.
NuGet 1.1 Released
(Scott Guthrie) This past weekend the ASP.NET team released NuGet 1.1. Phil Haack recently blogged a bunch of details on the enhancements it brings, as well as how to update to it if you already have NuGet 1.0 installed.
ADF Region Communication – Region Refresh Through Contextual Event
(Andrejus Baranovskis) I will extend previous sample application – ADF Region Communication – Data Exchange Through Shared Data Control Java Class and will describe how you can enrich it and apply contextual events. Even you would think about contextual events as about something cool, be careful – i
What is Oracle Guardian?
(Sanjit Anand) Oracle Guardian is an intuitive tool for preemptive system support. This product is used to find potential problems before they require the attention of your IT support staff or impact your operations and your customers.
Converting XML data to CLR object using XmlSerializer
(Manas Patnaik) My last Post (Consuming Webservice from Silverlight) was all about accessing a web service/API from Silverlight; there I described how to consume an external API, with a sample from GeoName web services.