Archive

Author Archive

SQL Azure Database Take Offline

May 23, 2012 1 comment

As everyone knows that database administrator can take SQL Server Database offline for maintenance purpose with following command Read more…

Small Defination of Big Data?

May 22, 2012 2 comments

Big data is BIG NEWS in Industry today. Big data is nothing but characteristics of data then bigness of data. Big data really implies different analytics, different data structures and different diversity to the analytics.

And diversity of application was never exists before which is driven by different variety of applications. Currently applications are dealing with this kind of data and ready to present analytics with it. Read more…

User Account Control (UAC) and SSRS

May 21, 2012 3 comments

In SQL Server 2008 R2 Reporting Services people are facing error as “User ‘DomainName\UserName’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed”. I have seen people struggling with this Issue. Here is more light on how to fix this & get your SQL Reporting Services Report Server URL working. Read more…

Convert Number Value Into Words using SSRS

May 21, 2012 1 comment

For Display Amount Value into Words with SQL Reporting Services 2008, we can implement the same with following two ways.

· Database Function

· Custom Assembly 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

Guys,

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:

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…

SSRS Expressions

January 18, 2011 Leave a comment

Very practical expressions, when you create SSRS Reports in your day to day development.

1. Lets start with the easiest of the expressions i.e. To get Today’s date

=Today Read more…

Connect Analysis Services 2008/2005 from Different Domain Use

January 15, 2011 Leave a comment

In one of my project I was working with Remote client. Basically, SQL Server 2008 Analysis Services Objects were available at Remote server. Me & my team were developing Reports on that SSAS with SQL Server 2008 Reporting Services. Read more…