Category Archives: “Technical” Series
My first introduction to Java Applets
Welcome to CodeSpread!What is it? An applet is a class file that is written to display graphics in web browser. We embed applets using <APPLET> HTML tags. When run in a web page, java applets are downloaded automatically and run by the web browser. Now we will see how applet works using AWT(Abstract Windowing Toolkit)…..
SQL : Transactions and ACID properties.
There are always two point of views of transactions. First, the user point of view, for example, customer went to an ATM to retrieve some amount. For him, the transaction might look like, For a developer or admin, the transaction will be, But did we estimate any failure condition in both of the cases shown…..
SQL : Clustered and NonClustered Index
We read about SQL indexes in our previous post, We will dive into the topic and learn the different types of indexing possible in SQL. We have clustered and non-clustered index in SQL, let’s see the difference, their operation and advantages each one have. We have a basic understanding that indexes are created on columns…..
SQL: Story of Indexes
I know many people know everything about this topic but as this is one of my favorite topics, I will make sure that I will give you some additional information or knowledge. My first thought about Indexes is that ‘It is a solution’. I assume that you will ask me ‘What was the problem behind…..
SQL: Common Table Expression called CTE
I remember somebody talked about CTE or Common Table Expression with me and tried helplessly to make me understand it. Honestly, I listened very peacefully but was not able to figure out the exact behavior of CTE.Then i went my usual way, which is try to understand the dictionary meaning of CTE or Common Table…..
C#: Singleton Design Pattern SlideShow and ScreenCast
Here is a slide show and screencast of Singleton Design Pattern . This slide show is also available for download. You can also check the screencast on our youtube channel.
