(Gary Myers) A while back I worked on a site where the network would terminate connections that were idle too long (around 20-30 minutes). It is pretty frustrating when you’ve been working on something for a while then you go grab a coffee or have a meeting and come back to find the connection had b
Other News
Multi Byte String Generator
(Peter O’Brien) Fusion Applications uses Oracle Data Integrator as part of the data bulk import feature which includes migration and file import. While working on the Opportunity Bulk Import we had to ensure that multi byte characters were imported correctly.
Tablespace Recovery in a NOARCHIVELOG database
(Hemant K Chitale) Following up on my previous blog, I show a Tablespace Restore and Recovery for a NOARCHIVELOG mode database.
Implementing the New Skip List
(Jim Mischel) The hard work in building a better skip list was in creating the underlying data structure. Changing the original skip list implementation so that it uses the new infrastructure is pretty easy. The algorithms for adding, searching, and removing are essentially the same.
Using MySQL stored procedures with PHP mysqli
(Ulf Wendel) A couple of weeks ago a friend of mine asked me how to use MySQL stored procedures with PHP’s mysqli API. Out of curiosity I asked another friend, a team lead, how things where going with their PHP MySQL project, for which they had planned to have most of their business logic in stored
XEvent Session – System_health
(SQLZealot) Today Am going to explain something about the ring buffer which is an internal structure in SQL server that captures various information like security errors, any kind of exceptions, scheduler information, resource monitor information etc.
How to do pagination in the ListView using DataPager control?
(SheoNarayan) To list the paginated records in the ListView, we can follow this approach.
ASP.NET RedirectPermanent Method using C# and VB.NET
ASP.NET 4.0 now includes a feature that developers can easily use in their search engine optimization efforts. This is called the RedirectPermanent method. This method returns a clean 301 redirect from the origin page to the new target page.
Three monthly checks for managing database capacity
(Don Jones) In my time as a “reluctant DBA,” I managed database capacity on what I called an “exception basis.” If someone took exception to the way things were working — like, they weren’t — I took a look.
Using jQuery’s $.map() Method To Convert Data Into Detached DOM Node Buffers
(Ben Nadel) A couple of weeks ago, I blogged about the appendEach() jQuery plugin that allows you to append an array of jQuery objects to the rendered DOM tree. This plugin was created so that detached DOM (Document Object Model) nodes could be created and configured, en masse, without incurring the