(Pas Apicella) Here is some code I used to insert/read BLOB images in an 11g database using 11g JDBC driver with JDK 1.6. In these tests I uploaded 30K images which was lighting fast as you would expect.
Other News
MySQL: delay_key_write is good
(Mark Robson) If you’re using MySQL with the MyISAM engine for a high-writes application, delay_key_write is usually very good.
Creating an XML Writer
(Jim Mischel) To create an XmlWriter object instance, you call the static XmlWriter.Create method, passing it the stream or other data store to which you want to write, and an optional XmlWriterSettings object that specifies how you want the writer to behave. Overloads of the Create method let you s
Build the next generation application using DB2 9 and ASP.NET 2.0
(Anil Mahadev) The purpose of this tutorial is to help newcomers to IBM DB2 9 learn how to use ASP.NET. It acts as a quick, interactive guide that teaches you to develop RAD Web Applications using the powerful IBM data platform DB2 9 and ASP.NET v2. After following the steps presented in this tutori
Importing Data into SQL Server
(William R. Vaughn) I can’t count the number of times I’ve answered questions in the newsgroups, forums, and from the attendees at the tech conferences that imply that developers think ADO.NET (or any of the data access interfaces) are designed to handle “bulk” operations. The question often sounds
Preparing for the M70-444 Exam
(Gregory A. Larsen) Are you considering becoming a Microsoft Certified DBA? Where do you start? How do you prepare for getting certified? There are lots of different methods to prepare for the exams. You can read some books, obtain hands on experience, or go to an instructor led class. In addition t
What if null if null is null null null is null?
(Hugo Kornelis) In this fourth and final part in my series about NULL, I’ll discuss some well-known and some less well-known functions and keywords that are specifically created to deal with NULL values. And I will, of course, explain why null if null is null null null is null. In case you have not
A Really New Approach – But I Need Your Advice
I Need Your Help! Please – if you have a minute or two – we have a new concept we’d like to first explain to you, then get your feedback on. I need to know what you think of it, what you’d like to see, what type of experiences you’ve had, etc. I’ve created a short video explaining the idea, […]
PHP and SQL Server, SQL-Geek Humor
Watch the Latest: SQLonCall: Security and SQL Server – Best Practices SelectViews: Software + Service, Book Look and More Featured Article(s) Who do you Hire: The Decision You Need to Make I was talking to a director that I know and he mentioned to me that he has a scale that he measures prospective employees on. If you evaluate these […]
DOM Trees
(ibuckley) What is the DOM? With JavaScript you can restructure an entire HTML document. You can add, remove, change, or reorder items on a page.
