Posts

Implementing a tactical system

Anyone who worked in large scale implementation would have come across the issue of implementing a tactical system, which is either hard or never replaced. Below are my views of the potential reason. Most of the below points are apparent but often overlooked. What is a tactical system? A solution to temporarily bridge a significant technical or a business gap. Characteristics of a tactical system. 1. Cheaper to implement. 2. Easy to train. 3. Quicker to roll out. 4. The life span of a tactical system is not higher than six months. 5. Has less business benefit compared to an end state system. When a tactical system becomes an end-state system? 1. When it delivers beyond MVP.  2. When it is more flexible compared to a strategic system. 3. When its life span is more than a year. 4. When its user base is high. 5. When there is no road map and a secured business case and funding for a strategic system. 6. When deeply embedded within the business process
1 comment
Read more

Row_Number()

  Yesterday I when I was looking into the enhancements in SQL server 2005 I discovered the below cool features and thought of sharing with your all. This new features will reduce the amount of coding and drastically improve the performance of complex SQL queries.  Conventionally we generate sequence numbers using complex logic or by using temp tables or table variable with identity columns, but with this new feature “ROW_NUMBER()” will allow developers to generate sequence numbers in a single line of code. Below I have attached an example. ROW_NUMBER()returns the sequence number of a row within a partition of a result set, starting at 1 for the first row in each partition. Syntax: ROW_NUMBER ( ) OVER ( [ <partition_by_clause> ] <order_by_clause> ) Example usage: CREATE TABLE RowNumTest (Name VARCHAR(50), DOB DATETIME, Age AS (DATEDIFF(YEAR,DOB,GETDATE()))) INSERT INTO RowNumTest (Name, DOB) VALUES('Sathya', '1983-11-02') INSERT INTO RowNumTes
1 comment
Read more

Computed column

                Today when I was looking into the new features of SQL server 2005, I came across a concept of computed columns and thought of sharing with you all. Usually we use computed columns of dataset in application side with adds overhead to the application and potentially reducing the performance of the application. Computed columns in the dataset in the application side can be replaced with computed columns in the SQL server table. A computed column is not a physical column in a table but computed from an expression that uses other columns in the same table. The data’s in the computed columns will not be saved physically in the table unless it is marked as PERSISTED. When a computed column is marked as persisted index can be created on it. For example computed columns could have the definition datediff(year,[DOB],getdate()).  The expression can be a non-computed column name, constant, function, variable and any combination of their connected by one or more operators. The exp
Post a Comment
Read more

Service oriented architecture

Image
What is Service oriented architecture? Service oriented architecture, commonly called as SOA is a collection of services. Each and every service is used to achieve a functionality for example processing online credit card. These services are exposed over a network, to be used by the consumers. Any authorized consumers can consume the service. Service provider and the service consumer use a common protocol to communicate with each other one such protocol is SOAP. Above diagram shows a simple Service oriented architecture, with one service provider and one service consumer. Service consumer sends a service request to the service provider over a network accessible by both (example internet). On receiving the service request the service provider processes the request and sends the result back to the service consumer. Sometimes there are scenarios in which Service providers communicate
1 comment
Read more

Displaying alert message from server side(ASP.NET1.1)

Public Sub ShowMessage(ByVal MessageText As String) MessageText = Replace(MessageText, """", "") Dim strScript As String = " " If (Not Page.IsStartupScriptRegistered("clientScript")) Then Page.RegisterStartupScript("clientScript", strScript) End If End Sub Technorati Tags: ASP.NET , ASP.NET1.1 , asp.net serverside message box
1 comment
Read more

Setting focus on a control (ASP.NET1.1)

Protected Sub SetFocus(ByVal ctrl As WebControl) ' Define the JavaScript function for the specified control. Dim focusScript As String = " " ' Add the JavaScript code to the page. Page.RegisterStartupScript("FocusScript", focusScript) End Sub   Technorati Tags: ASP.NET1.1 , setfocus
Post a Comment
Read more

Adding delete confirmation box in ASP.net 1.1

btnDelete.Attributes.Add("onclick", "return confirm('Do you want to Delete');") Technorati Tags: ASP.NET1.1 , Delete confirmation
Post a Comment
Read more