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

SQL Server 2008 introduced GROUPING SETS as an extension to the GROUP BY, facilitating us to combine more than one group into a single resul...

Result set can be filtered in many ways. Most common ways is, using the 3rd primary property of the SQL SELECT statement which is the WHERE ...

Almost all engineers have used the AVG aggregate function, but have you ever checked whether the result is correct? This was discussed while...

Microsoft has published "SQL Server 2008 R2 - Training Kit for Developers" that contains presentations, demos, videos and hands-on...

I will be doing a Hands-On labs session tomorrow (10th Wednesday) at TechEd Sri Lanka 2010, on Authoring Reports with Reporting Services 200...

It is happening..... It started yesterday and continues till Wednesday. It seems that a lot of good sessions have been scheduled, will blog...

2010, My first public presentation for the year, going to start with exciting features of Reporting Services 2008 R2. I will be doing a se...

I am fortunate enough to continue my IT career with MVP title again! Microsoft has awarded the title me for the 5th time, thanks for Micr...

Wish you all a very Happy and Prosperous New Year 2010! Wish you all a very Happy and Prosperous New Year 2010! Wish you all a very Happy an...

Worth to read... http://jahaines.blogspot.com/2009/12/sql-server-2005-how-to-move-10-millions.html

No more errors with SharePoint 2010 prerequisites installation, and good thing is, no manual installation of any components. If you refer ...

I have been trying to install SharePoint 2010 Beta on Windows 2008 R2 (64-bit) for a day but not successful yet.... Initially, I got four ...

This was my third visit to Peradaniya University, we ( Wela , Prabath , Susantha , Tharindu, and me ) did set of sessions on .NET, C#, and S...

Thought to make a post on this, may help you to brush up your computer history knowledge too :) • The name of the first computer is ENIAC (...

I was not in the know, if you too, read this Merill's post , it is about the history of Microsoft Office Web Apps.

Recently, I had to create couple of Reporting Services 2008 reports by using Oracle 10g as the data source. I had to use one machine as the ...

It hit me again, this is the second time I experienced this problem. My VPC with Windows 2008, SQL Server 2008 and MOSS 2007 was working f...

If you are unaware of SP3, here is the link, x86 and x64 .

It hit again, this time it is with Reporting Services 2008. PerformancePoint allows to connect with Reporting Server and lets to browse rep...

When we discuss, when I teach, the mostly discussed SQL Server related languages are DML and DDL. But do you know that there are few more ca...

This held our work for few hours. When we tried to make a connection to SQL Server 2008 server with “Native OLE DB\SQL Server Native Client ...

I used to use Char data type for character data types of variable length columns, if the maximum number of characters that will set for the ...

Last week, two batches, one for 2780B (SQL 2005) and another for 6231A (SQL 2008) were successfully completed and will be starting my next c...

Sometimes, we switch the execution context to different account when required. One of requirements when connected in such a manner may be, f...