How to make SQL Server 2005 database empty using cursor & sys.objects (Delete All Tables, stored procedures, views & UDF’s)
Understanding sys.objects: Sys.objects is a system VIEW in SQL Server 2005, for each SQL database there is a separate sys.object view which gets stored within databse itself. Using Sys.objects returns...
How to take Outlook 2007 data file backup
Step 1: Open outlook 2007, Go to menu and chose… Tools > account settings > data files You will find the screen like shown below: Now select the 1from the...
Quick DBMS reference: Single line definitions of important SQL Server terms
Normalization: is a process of organizing data and minimizing redundancy De-normalization: is a technique to move from higher to lower normal forms of database modeling in order to speed up...
Understanding asp.net MVC (Model View Controller) architecture
This article is intended to provide basic concept and fundamentals of asp.net MVC (Model View Controller) architecture workflow for beginners. Introduction: "M" "V" "C" stands for "MODEL" "VIEW" "CONTROLLER" ,...
Dot Net framework 3.5, C#, VB.Net Language Improvements: Automatic Properties, Object initializers, Collection Initializers, Lambda expression, Anonymous type
The new .net 3.5 has significant improved features. This feature makes the .net programming concept more sophisticated. You will now be able to write less code and build more dynamic...
Why do we engineer web?
Introduction: To understand the necessity for web engineering, we must pause briefly to look back at the recent history of computing. This history will help us to understand the problems...
India Celebrating 61st Republic Day – HAPPY REPUBLIC DAY
Republic Day, celebrated on January 26th every year, is one of India’s most important national events. It was on January 26th, 1950 that the constitution of India came into force...
How to Create Your’s First Iphone Application Using Xcode Development tool
This sample demonstrates many of the typical behaviors of an iPhone application, including: Initializing the application Displaying a window Drawing custom content Handling touch events Performing animations Objective-C defines a...
Hardware Requirements For i-Phone Application Development
IPhone application development has minimum hardware requirements without which iPhone programming cannot begin. This small guide lists the essential hardware needed for iPhone development and also mentions the alternatives wherever...
Recommendation for developers
Generally, and most often many developer ask following normal questions: “What do I do so I can become a full time web developer?” Experienced developers often ask what I would...