Recently I was involved in a migration project. Client was/is using ancient application built on Access 2.0 (yup … its…
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…
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…
SQL Server Views … to make sure others “view” what you want them to view !!!
In essence, SQL Server view can be considered as a “Virtual Table”. When we create a view, user “feel” no…
SQL Server Installation Rules and “System Reboot Required” Error
When we do installation or removing SQL Server, it always executes installation rules. And what really weird is, installer even…
Database Normalization … taming the wild horse
For any application to use database and hence data effectively it is very important that data is organized properly. The…
Trip to The Smokies … Day 7,8,9 … End of days
Well, it was really a good time at Axesh’s (that is name of friend we were visiting at Iron Station,…