Author Archives:
Short Note on HTTP-GET, HTTP-POST and SOAP
Welcome to CodeSpread!Web service/WCF services/Rest Services may support HTTP-GET, HTTP-POST or SOAP protocols, which is the underlying way, where request-response communication happens between a client and server. HTTP-GET: Client requests a resource from server. Server sends the resource to the client as a response. HTTP-POST: Client submits a resource to the server. Server sends the…..
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: Bitwise Operator SlideShow and ScreenCast
Here is a slide show and screencast of Bitwise Operator . This slide show is also available for download. You can also check the screencast on our youtube channel.
SQL: Common Table Expression called CTE SlideShow and ScreenCast
Here is a slide show and screencast of Common Table Expression called CTE . This slide show is also available for download. You can also check the screencast on our youtube channel.
