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,
Month: October 2010
Access to SQL Server migration … and Compatibility Issues !!
Recently I was involved in a migration project. Client was/is using ancient application built on Access 2.0 (yup … its 2.0) … I think it was started as a small app for just couple of users and with time it grew larger and soon it became mission critical application which still is built on old
SQL Server Views … gotcha while using sp_refreshview
Last week I blogged about use of Views in SQL Server. We also saw different types of view and best practices for designing new view and limitations that may prevent us creating a view too. As a part of best practice while designing we should always include keyword, WITH SCHEMABINDING which prevents any accidental changes
Oracle 11g R2 and Windows 7 … dealing with Enterprise Manager Troubles
So, this weekend I thought to refresh my experience with Oracle. And in that attempt, I decided to install latest of Oracle DBMS family, Oracle 11g. Now, it’s been a while since I used oracle, it was version 10g. And they have been significantly improved in version 11g, so I wanted to try them. But