>Making a fool of your applications – File System

>An understanding of how your applications work will make it a bit easy for you to fix problems when they arise. One common scenario I have seen in most applications is the concept of application logging – creating logs using either the old-fashioned log files or storing the data in a database. Logging helps application […]

>Common Table Expressions in SQL Server 2005

>I initially wrote this article for www.adminprep.com but apparently, I myself am having difficulty trying to access the site every now and then so I decided to mirror the content in my blog. Have you ever wished that Microsoft created a feature in SQL Server 2000 that combines the capabilities of views and derived tables? […]

>Fancy up your reports – SQL Server 2005 Reporting Services:alternating colors on table rows

>I’m not a good graphics guy. In fact, I’d hire somebody to do web design if I have a web application project. For me, anything to do with aesthetics is totally out of the picture. I wouldn’t want to spend a couple of hours designing and mixing colors and pictures. In reality, anything that has […]

>Embed SQL Server 2005 Reporting Services Reports in your .NET applications using the ReportViewer control in Visual Studio 2005

>Picture this – you work with a team, you’re in charge of creating the front-end for your .NET applications and you need to have access to SQL Server 2005 Reporting Services reports that have already been developed and currently being used. What would you do? You don’t want to recreate those reports, do you? Neither […]