Dinesh's Blog :::: Being Compiled ::::

One of the challenges in Business Intelligence solutions is sizing the infrastructure. Many go with various calculations and assumptions and...

Business Application Research Center – BARC publishes various types of survey reports; has published “ The BI Verdict ”, the latest BI surve...

You might have already seen Microsoft Silverlight PivotViewer for Excel (see my post on it). Just like that you are going to see PivotViewe...

SQL Server 2008 SP 2 is available for downloading now. Enhancements includes; 15K partitioning Improvement Reporting S...

I used to use table variables when the resultset is smaller and want to hold it temporarily. The main reason for this selection is, data man...

Tech Insights 2010 was an event organized by Malaysia Microsoft Enthusiasts to explorer new technologies related to Microsoft. It was great ...

Although the storage cost is going down, we still think about storage optimization because once optimized, it is not only about the cost, it...

It would be better to know these features to avoid future problems. This has two tables that show features will not be supported in next ver...

This is not just about implicit conversion. This is about implicit conversion that happens without our notice, that might hinder the perform...

If you have gone through BOL for HAVING keyword, you have seen above sentence at the top of the page. What does it exactly mean? Similar qu...

If you have read the article Article: Reporting Services 2008 R2: Geospatial Visualization – Part I , then here is the part II of it. It has...

Are you seeing many “sleeping” status connections in your SQL Server? If so, have you ever thought to find out the reason for it? Is it norm...