Cyberiafreak

"Fortunate are those who take the first steps.” ― Paulo Coelho

Life is a Journey – Enjoy It !! – 2009 long way to go.

Hi,
I wish you all a Very
Happy New Year
Birthday cake and I know already people (including myself) are
worried bit about recession, career and of course this is the
news in canteen, blogs, print media every where. Come on…Its not
going to be our dead end right ? We will be doing something,
somewhere atleast for our living so why worry…Lets think positive and work hard to over come this hard time.
Its all about how quickly we bounce back once
when we pink slipped. So lets keep our self updated as usual and be
a key player.
"Year 2008"
was a fantastic year
for me in my life both personal(got married) and professional
aspect. Skill set wise not very happy but worked on variety of non MS
tools (IReport, Postgres, Mysql ,plone etc but sadly project got scrapped
but survived me. That’s the time I decided to go with MOSS 2007
and crossed half a way. W
ish me good
luck and share your MOSS passion if you are into.
I wish 2009 would bring lot of change
around us with smile in every ones face. Lets go ahead
with great hope and luck ! 
Want to know
about 2009 Predictions.? read from here –
well explained and good predictions. what you say..?
~Mahes
Advertisements

January 6, 2009 Posted by | Computers and Internet | 1 Comment

Hack Day India, Bangalore, October 5 & 6

Hi Bangalore Hackers.Left hug.

Hacking for me – It was funny,
interestingAngel, sometimes uselessSarcastic, exploring hidden jargons, techie stuffsNerd, not
going to fill my pocket, some time etc,  I started my hacking stuff way
back in college to impress my friend Right hug who sits nearby me in lab 😉 gradually
networked via friends, books, astalavista, ankit fadia meet etc. Really I
missed my college underground network friends like gopi, vineeth and vikki.
Gudoos guys for landing in your dream job, but I become a programmer by default
and interest. I wrote a simple socket port scanner in VB, that was my first
love towards program hacking…now sits with C#  all day in office. I
don’t know what else left out still….list keeps on going and
growing..some where I read, in .NET 3.5 , they bundled 87,000 classes…oh
god give me a break to do something on our own and be relax for sometime.

Hack
Day India announcement
 

While I was checking my rss reader, I got struck with this
announcement posted by terminator blog,
hope this would be an interesting one if we get a chance to meet nice guys over
there to dirty again
J

Hack Day India: 5 October – 6
October 2007,  For registration and more info, click here . http://hackdayindia.eventwax.com/hack-day-india

Happy Hacking ! Happy Coding !!

Mahesh ~

My earlier hack post http://cyberiafreak.spaces.live.com/blog/cns!410E76C6390C7090!485.entry

September 12, 2007 Posted by | Computers and Internet | Leave a comment

web.config – Settings

Today for my salesport application[in lauchin phase], while we into testing for the past days, i have tried a lot for showing errors with approximate one. These are the web.config setting i have tried.

3 modes to display error:::::::::::::::::::::::::::

CustomErrors = Off [disable custom error and display app.error]
CustomErrors= On [ display custom page]
CustomErrors=RemoteOnly[ display the custom page in the remote but actual in the production server]

Here is the simple example for web.config structure…

Web.Config Configuration File –>

February 16, 2005 Posted by | Computers and Internet | Leave a comment

SQL Query – office ref

Here is my office query which i have written for SALESPORT appln.

————————————————

select * from PCL where ((status=91) or (call_updated=111 and status <>91 and status <>92))

select due_by_activity,due_date,clt_name from activity_due a,pcl p where a.c_id=p.clt_id and datepart(week,a.due_date)=datepart(week,dateadd(week,-2,getdate()))and a.e_id=’SMS00102′

select due_by_activity,due_date,clt_name from activity_due a,pcl p where a.c_id=p.clt_id and datepart(month,a.due_date)=datepart(MONTH,dateadd(month,-1,getdate())) and a.e_id=’SMS00102′

——————————————————

SALESPORT APPLication is in testing stage and expecting for clients installation in Kolkata or ranchi hopefully.

Mahe!!!
[ a very next day of valentine ]

February 15, 2005 Posted by | Computers and Internet | Leave a comment

My code in office – for reference

‘// FOR SALESMEET REPORT
Private Sub clt_Click()
If scope2 = "" Then
MsgBox "Select scope of the report !! ", vbExclamation, " Sales port !!"
Else
If scope2 = "B" Then
If code = "" Then
MsgBox "Please select any branch….! ", vbInformation, "Salesport!!……….Select branch… "
Else
wb.Navigate salesurl & "sales_pcl_rep_index2.asp?st=1&ac=SM&scope=" & scope & code ‘ querystring
wb.Visible = True
End If
End If

End If
End Sub

————————-
case "R"
act="sales_wo_rep.aspx"
rs.Open "select *from WORECIEPT where " & condition & " and (datepart(month,WOR_REC_DT)=datepart(month,getdate()) or datepart(month,WOR_REC_DT)=datepart(month,dateadd(month,-1,getdate())))"
head="WORK ORDER RECEIPT- LISTING REGION LEVEL "
case "A"
act="sales_wo_rep.aspx"
rs.Open "select *from WORECIEPT where datepart(month,WOR_REC_DT)=datepart(month,getdate()) or datepart(month,WOR_REC_DT)=datepart(month,dateadd(month,-1,getdate()))"
head="WORK ORDER RECEIPT – LISTING INDIA LEVEL"

—– Today lot of updation in existing salesport application. Successfully cleared 3 errors.

3-2-2005 went to dumlur for BDOTNET Seminar [ topic was asp.net caching ]

February 5, 2005 Posted by | Computers and Internet | Leave a comment

Some important facts about -asp.net

Question:
Can I still run ASP pages on a server that runs ASP.Net?

Answer:
Yes. They will run side-by-side with no adverse affects to the ASP pages at all.

Question:
Does ASP.Net still recognize the global.asa file?

Answer:
ASP.Net does not recognize the standard ASP global.asa file. Instead it uses a file named global.asax with the same – plus additional – functionality.

Question:
Can ASP pages and ASP.Net pages share session variables.

Answer:
No. Both support session variables, but the session variables are not shared across the two platforms.

Question:
What is the process-flow for ASP.Net?

Answer:

1. User requests an ASPx page in their browser

2. An HTTP requests is sent to IIS

3. The xspisapi.dll isapi filter intercepts the request and passes the request on to the XSP worker process (xspwp.exe)

4. Xspwp takes care of handing the request to the appropriate HTTPModules and finally an HTTPHandler as defined in the configuration files.

5. The ASPX page is read from the HD or cache and server code is loaded into memory and executed.

6. The server side code outputs normal HTML which is handed back through the chain of modules and eventually to IIS, which sends the response back to the client’s browser.

7. If the user clicks or otherwise acts on an HTML element (say, a textbox) that has a server side event handler, the form is posted back to the server with hidden form fields containing information as to what control and event occurred.  Some controls do not automatically post by default, but wait for a button_click event to post.  This is configurable by the developer.

8. The ASPx page is again loaded into memory using the same sequence of events as before, but this time ASP.net reads in the hidden form field data and automagically triggers the appropriate _OnChange, OnClick and other appropriate event handlers.

9. Resulting HTML is sent to the browser

10. The process continues in a continual "Post Back" cycle.

Definition of HTTP Modules:
HTTP modules are a logical replacement for ISAPI filters.  Modules are a class that can participate in every web request.  This is appropriate for code that should run on every request, such as caching, authentication or state management

Definition of HTTP Handlers:
HTTP Handlers provide the end point in the processing of a web request and are equivalent to ISAPI Extensions today.  For example, many handlers can be involved in the request for an ASPX page, but only 1 handler is invoked.  The handler runs after the HTTP modules have run.  Which handler is invoked is determined by configuration settings in the config.web file.  Handlers are assigned to handle requests based on the extension of the page requested.

February 2, 2005 Posted by | Computers and Internet | Leave a comment

What’s new in ASP.NET Whidbey ??

January 28, 2005 Posted by | Computers and Internet | Leave a comment

Update code – ADO.NET – Manually tried

 Here is the code, which i want for my appln. so for i have used only webmatrix to generate all codes. here is, manually written code for my appln.salesport

 ‘Dim ss As Integer
        ‘Dim ra As Integer
        ‘Dim con As New SqlConnection()
        ‘Dim con_str As String
        ‘con_str = Session("CS")
        ‘Try
        ‘    con.ConnectionString = con_str
        ‘    con.Open()
        ‘    Dim cmd As New SqlCommand("Update loss_of_contract Set UPDATED=’UPDATED’,agency_name=’mk’, agency_id=1,others_name=’mk1′,reason=1,rate_ss=1,rate_sg=2,rate_si=3,rate_so=4,rate_gm=5,rate_oth=6,remark=’something’ where C_ID=’1’" & cltid.Text, con)
        ‘    ra = cmd.ExecuteNonQuery()
        ‘Catch SQLExp As SqlException
        ‘    If SQLExp.Number = 1212 Then
        ‘        Response.Write("SQL Server Error 1212 Occurred: " & e.ToString())
        ‘    Else
        ‘        Response.Write("An SQL Server Error Occurred: " & e.ToString())
        ‘    End If
        ‘Finally
        ‘    con.Close()
        ‘    If (ra) Then
        ‘        Response.Write("1 ROWS AFFECTED – SUCCESSFULLY")
        ‘    End If
        ‘End Try

Mahesh kumar.R

25/1/2005 -SIS India Ltd

 

January 25, 2005 Posted by | Computers and Internet | Leave a comment

Interview Questions – for Microsoft technolofy[experienced]

Interview Questions – from groups [ .NET questions ]
=======================================
> 1 Differnt Types of Indexes and thier Diff?
> 2 Stored Procedure Adv and DisAdv?
> 3 Performance issues on DataBase(Sql server)?
> 4 Diff TSQL and ANSI SQL?
> 5 Different Tools in SQL Sever?
> 6 What is Complex Stored Procedure
> 7 Normalization
> 8 Cursors types?
> 9 What is different between EXEC and SP_ExecuteSQL
> 10 How to avoid Cursors?
> 11 Segregate Functions in SQL Sever?
> 12 what is Replication?
> 13 what is Profiler?
> 14 How do u monitor the Performance of ur Query?
> 15 Isolation levels in SQL Server?
> 16 3 Major Diff bet’n ASP and ASP.NET?

——————————–
1.Differnt Types of Indexes and thier Diff?
cluster index: The way of storing records in physically, It referes
the Primery key
nonclusterindex: The way of storing records in logically, It referes
the forginkey,we have 249 noncluster indexes
2 Stored Procedure Adv and DisAdv?
Adv: They allow modular programming.
They allow faster execution.
They can reduce network traffic.
They can be used as a security mechanism.
disadv: there is no automatically execution.

3 Performance issues on DataBase(Sql server)?
aviod the simple cursors
4 Diff TSQL and ANSI SQL?
This can reduce network traffic, because your client will not receive
the message indicating the number of rows affected by a T-SQL
statement.

5 Different Tools in SQL Sever?
6 What is Complex Stored Procedure
When used in a stored procedure, the RETURN statement can specify an
integer value to return to the calling application, batch, or
procedure. If no value is specified on RETURN, a stored procedure
returns the value 0. The stored procedures return a value of 0 when
no errors were encountered. Any nonzero value indicates an error
occurred.

7 Normalization
The process of refining tables, keys, columns, and relationships to
create an efficient database is called normalization. This should
eliminates unnecessary duplication and provides a rapid search path to
all necessary information.
Some of the benefits of normalization are:
Data integrity (because there is no redundant, neglected data)
Optimized queries (because normalized tables produce rapid, efficient joins)
Faster index creation and sorting (because the tables have fewer columns)
Faster UPDATE performance (because there are fewer indexes per table)
Improved concurrency resolution (because table locks will affect less data)
Eliminate redundancy

8 Cursors types?
Cursors allow row-by-row processing of the result sets.
Types of cursors: Static, Dynamic, Forward-only, Keyset-driven
9 What is different between EXEC and SP_ExecuteSQL
SP_ExecuteSQL : for automaticaaly executes stored procedure when SQL
server starts
EXEC : manual execution

10 How to avoid Cursors?
By tunning
11 Segregate Functions in SQL Sever?

12 what is Replication?
Replication is the process of copying/moving data between databases on
the same or different servers. SQL Server supports the following types
of replication scenarios:
Snapshot replication – It distributes data exactly as it appears at a
specific moment in time and doesn’t monitor for updates. It can be
used when data changes are infrequent. It is often used for browsing
data such as price lists, online catalog, or data for decision support
where the current data is not required and data is used as read only.
Transactional replication (with immediate updating subscribers, with
queued updating subscribers) – With this an initial snapshot of data
is applied, and whenever data modifications are made at the publisher,
the individual transactions are captured and propagated to the
subscribers.
Merge replication – It is the process of distributing the data between
publisher and subscriber, it allows the publisher and subscriber to
update the data while connected or disconnected, and then merging the
updates between the sites when they are connected.

13 what is Profiler?
14 How do u monitor the Performance of ur Query?
using Joins
15 Isolation levels in SQL Server?
16 3 Major Diff bet’n ASP and ASP.NET?
asp is not data driven,where as can
asp have only onc cache type where as three
asp is not data randring process where as can

January 17, 2005 Posted by | Computers and Internet | Leave a comment

Stored Procedures -drawbacks

 Stored Proc’s – not standard:

 The biggest drawback to Stored Procedures is that it is not currently in the ANSI SQL standard. This results in each DBMS vendor supporting a different flavor of Stored Procedures. Microsoft (and Sybase) Transact-SQL, Oracle PL/SQL, and Informix SPL, though similar, are distinct languages and not interoperable with one another. If your shop has standardized on one particular DBMS or does not need to scale applications across multiple platforms, then this may not be a problem. But, then again, how many shops does this actually describe? Not many, I’d venture to guess!

The bottom line is that scalability will suffer when applications are coded using non-standard extensions — like SQL Stored Procedures. It is a non-trivial task to re-code applications that were designed to use stored procedures and triggers written using SQL Stored Procedures constructs. If an application needs to be scaled to a platform which utilizes a DBMS that does not support SQL Stored Procedures, then exhaustive re-coding is exactly what must be done. Consider, for example, the steps necessary to move a SQL Server application, written in Transact-SQL using triggers and stored procedures, to a DB2 subsystem on a mainframe. Stored procedures must be converted from Transact-SQL into a host language such as COBOL or C. Triggers must be coded into the application programs supporting the DB2 database because DB2 does not yet support triggers. This process is a nightmare that will cause any DBA to get a headache just thinking about it.

b) Performance Degradation:

 An additional potential drawback comes in the form of the potential for performance degradation. Consider, for example, a SQL Server stored procedure. The first time this procedure is executed it is optimized.

 The optimized form of the procedure is stored in the procedure cache and will be re-executed for subsequent users. However, the procedure was optimized for the particular data request that was issued for the first execution. It is very likely that future executions of the procedure are for different amounts and types of data. If the logic were instead embedded into an application program and compiled statically, the performance would be optimized for all ranges of local variables. Of course, SQL Server provides an option to always optimize (with the recompile option), but then dynamic SQL is always used — which can cause different types of performance problems.

The solution would be to provide a form of static SQL for stored procedures that is not optimized for a particular type of request — but, of course, this option is not currently available.

Other performance drawbacks can be realized when using SQL Stored Procedures if the developer is not careful. For example, careless cursor coding can cause severe performance problems. But, this can happen just as easily when cursors are used inside a host language. The problem is more inherent to application design than it is to SQL Stored Procedures.

 c) Incomplete Functionality:

The final drawback is that even SQL Stored Procedures dialects are not computationally complete. Most dialects of SQL Stored Procedures lack programming constructs to control the user’s screen and mechanisms for data input/output (other than to relational tables).

 
MAhesh, SIS India, 9.38 AM

 

January 6, 2005 Posted by | Computers and Internet | Leave a comment

Very first Blog about .NET – BDOTNET

Hi guyz,,,:) I"M BLOOGGGGGGGing……- SIS india,b’lore

Finally i decided to blog in my space. i got some time to blog, here is the yesterdays seminar details conducted by BDOTNET, bangalore.
———————————-
Session 1: Regular expressions
Time: 7:00 PM – 8:00 PM
Speaker: Sridhar, Aditi Technologies, Bangalore.
Regular expressions are a powerful tool for searching and processing text, and even in its simplest form, can make many complex tasks easy…

Session 2: ASP.NET Tips n Tricks
Time: 8:00 PM – 9:00 PM
Speaker: Saravana K, HP India

Venue: ThoughtWorks India.
5th Floor, Tower D, Corporate Block, Diamond District,
Airport Road, Bangalore, INDIA
(Opposite to TGIF Restaurant & near Domlur flyover construction)

***************First Session
ϛ i reached there @ sharply 6.58 and had snacks b4 the session. First was about REgular expression, its really big issue when we parse using normal code. But gudoos to .NET team, yes we already have name space called System.Text.RegularExpressions.
ϛ And he shared about the History and Geography of Regular expression, in which he mentioned KleeneStar, who invented the (*) in computing.
ϛ .NET comes with the unique feature of comparison, i mean rigth to left comparison.
ϛ Here is the some syntax and methods for performing regular expressions.

Regex r;
r. IsMatch;
r.Match;…..
ϛ here is the link they suggested for regular expression, http://www.regexlib.com, http://www.regexpression.net
**********************Second Session
ϛ Tips and Tricks using ASP.NET by Sarvan
1.path resolving using ~ symbol for path
2.runat =server for automatic path traversaal
3.Httprequest.currentExecutionFilePath –
HTTPRequest.Rawurl – =—————–
context.RewritePath – =—————–

4.RegisterclientScript –
5.

tag for datagrid , overflow =auto
6. Button.Attributes.add("onclick","return java()")
7. REgisterhiddenField("__scrs","0")
8. thebody.scrolltop; to retain the datagrid scroled positiion..
9. How 2 transfer the redirection to intermediate page until query is processed…
|—————————— |
| Page 1 ::: submittin query |
| (redirecting to 2.aspx | -> page load of 2 we are writing location.href ="

December 24, 2004 Posted by | Computers and Internet | Leave a comment

   

%d bloggers like this: