(Flavio Casetta) My first close encounter with the brand new Oracle XE11 returned the following error upon importing a dump that a customer sent me for preparing a demo.
Other News
Using Autoextend to Increase Oracle Database File Sizes
(David Fitzjarrell) Autoextend can be very helpful to busy DBAs by allowing Oracle to automatically increase file sizes to a pre-determined limit when necessary, which can make the workday a bit easier by minimizing the effort expended to monitor disk space. In a heavily used system where inserts an
What does Avoid non SARGable where clause mean?
(Vadivel) SARGable is the short form of “Search ARGument able”. A condition in the SQL Query is said to be SARGable if the database engine can take advantage of an available Indexes and do an INDEX SEEK instead of Table Scan / Index scan to speed up the execution of that query.
Replacement for SDO_GEOM.RELATE – JTS Relate
(Simon Greener) Even old dogs like me forget things and have to learn them again. You know, I am sure that I knew that SDO_GEOM.RELATE was a Spatial licensed feature and not available in Locator, but I clean forgot until a situation with a customer required me to look at an alternative.
Integrate DISQUS For Comment Management In MVC
(Prashant Khandelwal) I have been working on a MVC project which I will be using to save and manage all my code snippets. I get this plan in my head when my 160GB of HDD got crashed which holds most of my work and code. I started writing the web application in web forms and almost got it completed,
Seeing the SQL Generated by LINQ to Entity Queries
(Peter Vogel) Sometimes you really, really, really want to see the SQL that LINQ generates when working with the Entity Framework. For instance, in a comment to a recent tip, a reader mentioned that a LINQ to Entities query generated a SQL statement that joined more than 40 tables.
Checking on the Progress of Large DML Commands in MySQL Using Perl – Part One
(Tony Darnell) Part One of Two: Checking on database activity when running a large DML (Data Manipulation Language) statement – such as INSERT, DELETE, UPDATE or SELECT.
ASP.NET MVC3 JQuery inline editor
(Jovan Popovic) In this article I will explain how you can implement inline editing functionality in the ASP.NET MVC3 application using the JQuery. For inline editing will be used JEditable plugin. JEditable plugin enables you to create click and edit field as it is shown in the following figure:
Introduction to HTML5 for ASP.NET Developers
(Bipin Joshi) More and more web applications are harnessing the power of client side features of a browser. To that end HTML5 has many features to offer web developers. HTML markup, JavaScript and CSS have become more powerful and flexible than ever before. ASP.NET Developers must be well-versed wit
Model View Presenter Design Pattern
(John Charles Olamendy) Model View Presenter is the new kid on the block in the Enterprise Architecture design patterns which has derived from the classic model-view-presenter.