Archive for May, 2012

How to achieve Parallelism in SSIS

May 20, 2012 Leave a comment

SQL Server Integration Services (SSIS) allows parallel execution in two different ways

1) MaxConcurrentExecutables : It defines how many tasks (executables) can run simultaneously. It defaults to -1 which is translated to the number of processors plus 2. Please note that if your box has hyperthreading turned on, it is the logical processor rather than the physically present processor that is counted. Read more…

Add Visual Studio 2010 HTML5 Intelligence.

How to Add Visual Studio 2010 HTML5 Intelligence.

It’s the time to use the new technologies like HTML 5. Everyone of us knew about what this is and how easy now to generate some nice and rich UI without put much effort. No complex javascript, no silverlight or flash is required most of the time and many more advantages. There are plenty of changes in CSS too. So, I believe we should start using HTML 5 in our applications. Because almost all browsers are supporting it. Read more…

Categories: HTML5, Visual Studio Tags: ,

Implement appFabric caching service to build faster ASP.NET Applications with Windows Azure

May 18, 2012 1 comment

Speed up Web Applications using the new Windows Azure AppFabric Caching service. This article will cover concepts, scenarios, and features of the Caching service through a sample code and demonstrations.

In a world where speed and scale are the key success metrics of any solution, they can’t be afterthoughts or retrofitted to application architecture. The Windows Azure AppFabric Caching service provides the necessary building blocks to simplify these challenges without having to learn about deploying and managing another tier in your application architecture. In a nutshell, the Caching service is the elastic memory that your application needs for increasing its performance and throughput by offloading the pressure from the data tier and the distributed state so that your application is able to easily scale out the compute tier. Read more…

Congratulation to Suhas Kudekar for his MCC 2012 Award..!!

May 17, 2012 2 comments


Suhas Kudekar is going to be active contributor on bi-bigdata, recently his contributions to Microsoft online technical communities have been recognized with the Microsoft Community Contributor Award 2012. Read more…

Categories: Awards, Casual Tags:

VertiPaq Engine Renamed as xVelocity in SQL Server 2012(Denali).

VertiPaq engine is currently only available to PowerPivot for Excel in SQL Server 2008 R2. After the amazing success of PowerPivot for Excel in the previous release of SQL Server 2008 R2 this engine moved to the server side with the same InMemory BI and compression and it’s called the VertiPaq Engine or the Analysis Services Tabular Mode. Data retrieval and calculations happen at a much faster rate as its entire database is in-memory.Vertipaq enables Excel to process hundreds of millions of rows with sub-second response times on desktop hardware. Read more…

Display the MDX query of an Excel 2007 PivotTable

May 16, 2012 1 comment

Most of end users navigate into Microsoft SQL Server 2008/2005 Analysis Services Cube with the help of Microsoft Excel 2007. Sometimes they may produce report while browsing Cube data.

Most of them having curiosity about MDX (Multidimensional Expressions) generated by Excel in background. Here is the way to get that MDX out of Excel Sheet. Read more…

%d bloggers like this: