Hash

SQL Server clustering vs. Oracle RAC

hashfactor — Fri, 06 Nov 2009 15:01:00 +0000

I did some research on SQL Server clustering a while ago to find out what high-availability and fail-over options does SQL Server provide. Below are my findings. In short SQL Server has fail-over but no high-availability as compared to Oracle RAC. 1. SQL Server 2008 Peer-to-Peer Replication Multiple nodes running their own instances Each node has its own [...]

Deadlock Resolution: Killing Oracle Sessions

hashfactor — Fri, 12 Jun 2009 03:20:00 +0000

We usually face this situation where an Oracle session is dead and an UPDATE command freezes forever. Usually it is the fault of the programmer who messes up with his session. In such case of a deadlock, the problem session needs to be killed. Following is a query (I got from some other blog I don’t [...]

Oracle: Drop Database Command

hashfactor — Mon, 25 May 2009 08:05:00 +0000

Oracle introduced a new command in 10g to drop a database. Before that there was a set of procedures to follow in order to get rid of a database which involved deleting all data files from the file system, deleting control files, the parameter files etc. Now after this command everything is deleted by the [...]

How to detect a lie

hashfactor — Mon, 04 May 2009 06:25:00 +0000

Following is the opinion of some experts about how to detect when someone is lying to you. Technically they sound right but I dare to differ. I don’t think these are the 10 commandments of lie detection. Just use your common sense to analyze your particular situation. I personally like the “extra tip” at the [...]

Oracle Parameter File: Order of lookup

hashfactor — Mon, 27 Apr 2009 10:04:00 +0000

Oracle has two type of parameter files for initial parameter configurations: PFILE and SPFILE. The parameter file and the shared parameter file. They are used to specify parameter values at the database startup. The SPFILE is used in a RAC environment and PFILE is used in a stand alone database environment. The other day I [...]

Oracle to buy Sun Microsystems for $7.4 bn

hashfactor — Mon, 20 Apr 2009 11:58:00 +0000

In a news today by CNN, Oracle confirmed it will buy Sun Microsystems for $7.4 bn. This also strengthens the belief that Sun refused IBM because it had a better offer. Acquisition of Sun will be fabulous for Oracle because it can now enter in the servers market and that with a BANG! Sun’s powerful hardware [...]

Skype Founders want it back

hashfactor — Mon, 13 Apr 2009 14:57:00 +0000

http://www.techcrunch.com/2009/04/10/report-founders-want-to-buy-skype-from-ebay/ As the New York Times reported, Skype’s founders, Niklas Zennstrom and Janus Friis, are in talks with several private equity firms and are amassing their own financial resources to make a bid for the internet phone business. eBay bought Skype from Zennstrom and Friis for around $3.1 billion in 2005. We reported last year that [...]

SQL: Generating Series of Numbers in Oracle

hashfactor — Wed, 08 Apr 2009 09:20:00 +0000

Generating a series of numbers is a very common practice in SQL environments. The objectives are but not limited to generating testing data and constants to use in SQL statements. Oracle provides a number of ways to accomplish this but the most simple to me is using the CONNECT BY clause. 1: SELECT ROWNUM [...]

Twitter is Down due to heavy activity

hashfactor — Wed, 08 Apr 2009 06:09:00 +0000

I tried to login to twitter a while ago and it failed to load! Guess what the error was? It was unavailable due to the extra ordinary load on the servers. I believe that twitter is being bombarded heavily by the Moldovians at the moment who are trying to keep their fellows updated through internet. Keep [...]

A twitter revolution in Moldova

hashfactor — Wed, 08 Apr 2009 05:48:00 +0000

http://www.techcrunch.com/2009/04/07/student-protests-are-turning-into-a-twitter-revolution-in-moldova/ Students in Moldova are using Twitter as a tool to mobilize opposition against a communist victory in Moldovian elections. According to reports, close to 10,000 protesters gathered at Moldova’s parliament in Chisinau, Moldova’s capital and were able to eventually break through police lines to storm into the building. From looking at the tweets on the [...]

Google in late stages to buy Twitter

hashfactor — Fri, 03 Apr 2009 04:50:00 +0000

http://www.techcrunch.com/2009/04/02/sources-google-in-late-stage-talks-to-buy-twitter/ Here’s a heck of a rumor that we’ve sourced from two separate people close to the negotiations: Google is in late stage negotiations to acquire Twitter. We don’t know the price but can assume its well, well north of the $250 million valuation that they saw in their recent funding. Twitter turned down an offer [...]

Lamont Adams’ Ten Commandments of Egoless Programming

hashfactor — Thu, 02 Apr 2009 14:57:00 +0000

Accept your mistakes – the important thing is to locate and deal with them in a timely manner. Do not invest your emotions in your code – this can lead you to taking critiques of your code personally. Seek out the input of others – programming is a collective effort. Consult your colleagues before you [...]

Binding a List with DataGridView

hashfactor — Tue, 31 Mar 2009 01:08:00 +0000

You can use DataGridView to easily build updatable data presentation controls having embedded controls as well. Use a BindingList object to store your data if it is not from the database.

Using the Oracle DBMS_LOCK Package

hashfactor — Tue, 31 Mar 2009 01:05:00 +0000

As a standard DBMS practice Oracle provides all sort of row level and table level locking mechanism for data integrity. This built-in locking mechanism is strongly coupled with database transactions e.g. a lock acquired through the LOCK command is released automatically at the end of the transaction. Sometimes you need explicit locking with full control [...]

C# Winforms: Using a progress bar with Web Browser Control

hashfactor — Tue, 31 Mar 2009 01:04:00 +0000

The .NET web browser provides a number of different events including some which tells when the browser started navigating to a web page and when that navigation completed. These events are: private System.Windows.Forms.WebBrowser ItemBrowser; this.ItemBrowser.Navigating += new System.Windows.Forms.WebBrowserNavigatingEventHandler(this.ItemBrowser_Navigating); this.ItemBrowser.DocumentCompleted += new System.Windows.Forms.WebBrowserDocumentCompletedEventHandler(this.ItemBrowser_DocumentCompleted); this.ItemBrowser.Navigated += new System.Windows.Forms.WebBrowserNavigatedEventHandler(this.ItemBrowser_Navigated); This shows the functions are being called at proper events. Now let us come to [...]