If you have done any sort of development in database you might be familiar with IDENTITY column. It basically gives you a column which increments it self to a given value (aka Seed and Increment). General syntax for IDENTITY is, IDENTITY [ ( seed , increment ) ] It is basically a “Plan B” for
Using Cookie in ASP.NET to store temporary data
Today’s post is about how we can use Cookie to store data temporarily. While working on one project for frontend application my client told me that they need some sort of functionality so that user somehow can temporarily store some of the form data and can use the same data when they run the application
Handling NULL DATES in .NET and SQL Server
I think no matter how solid is your application development skills and application testing skills … the end users always find ways to make your application do things which it not suppose to do and so eventually it crash. Or worse, they can generate inconsistency in your database. Being both as application developer and a
SQL Server 2011 CTP is here !!
Well, I wouldn’t believed it when I read it on few of my favorite sites like SSC and SQLBlogs … but it is actually here !! MSFT has released CTP for next version of SQL Server Code name “Denali”. From initial reading it looks like the next generation of SQL Server will have more enterprise
WordPress and Database Connection Error …
This week, I changed my WP Blog password and DB Password for that blog as well. And I did it using control panel provided by my hosting service provider. It went all well without any sort of error or so. But just today when I was trying to access my blog for some past reference,
64 bit System and Debugging in SSIS
It has been always confusion between whether we should use 32bit OS or 64bit system… and in present time it has been quite common to have 64 bit system specially in an enterprise environment or even servers. I think the main reason for that is memories are getting cheaper and processing power of processors increasing
ASP.NET and Page Not Found Error while debugging !
Being sunny weekend today, with full of energy I began to work on making some prototype application which I have to present to my client sometimes during next week. It been a while since I worked on ASP.NET on my application (@ 2 weeks) since I installed Sharepoint Server 2010 demo in my machine. So,