SQL Server Execution Plan Visualization

SQL Server Execution Plan Visualization

Recently I had to support a team I was not part of in troubleshooting some performance issues while querying data from SQL Server. Being an external person I also did not have any access to the project infrastructure. Not being from Microsoft background, I haven’t worked on SQL Server in a long time. So, I applied my experience of working with Oracle and requested for […]

Read Me

How the stock markets story is scripted – Part 2

How the stock markets story is scripted – Part 2

In last week’s blog we discussed the role of institutional investors on the price movement of the stock market using the subprime mortgage crisis as the reference time-period. We will continue our analysis but with respect to the current market situation. Before we start drawing parallels between the current stock market crash with the 2008 crash we should understand that no two events are the same. How […]

Read Me

How the stock markets story is scripted – Part 1

How the stock markets story is scripted – Part 1

Indian stock market crashed by around 40% from the highs of January to the lows of March this year. After that we have seen a rally of over 20%. Investors are in a dilemma and split between the two kinds of fears, the fear of missing out but at the same time they have the fear of the market going back to the previous lows […]

Read Me

Spring Integration – Channels

Spring Integration – Channels

Spring Integration is a framework providing implementation of enterprise integration patterns. To get started on Spring Integration framework we need to first understand some basic constructs. Since Spring Integration framework’s primary job is providing architecture plumbing, following are the building-blocks of any SI solution: Message: This is the payload which moves between various nodes which are integrated by the framework End-point: These are the nodes […]

Read Me

Spring Boot with In-memory ActiveMQ

Spring Boot with In-memory ActiveMQ

The in-memory ActiveMQ can be used to quickly test any message broker specific functionality when we don’t have an external message broker readily available. In the given example we will submit a string to a RESTful web service which will save the message string in the queue on message broker. Then we will implement a listener to read the message from the queue and display […]

Read Me

Spring REST Error Handling

Spring REST Error Handling

Spring framework provides three ways to handle error response while processing a request in the controller class Locally in the method handling a specific request Specific controller method level Global controller level Locally using @ResponseEntity The following code only updates the Person if it already exists otherwise responds with a HTTP Status Code 400 that is Bad Request. The ResponseEntity takes the object of response […]

Read Me

Is your bank still shouting from roof-top?

Is your bank still shouting from roof-top?

Traditionally banks have relied mainly on the conventional mediums like print, television, radio and postal mails for marketing. With shift in the focus of banks to go digital, banks have also started direct marketing which is reaching customers mainly through SMS, emails, mobile or web channels but still the strategy followed is mainly of broadcast marketing. As per the 2015 Gartner CMO spend survey, the […]

Read Me