Using the OLE DB Provider for SQL Server/Analysis Services, the end-user can connect to a Data Source directly and build a Pivot Table or PivotChart using standard Excel functionality.

For the newly announced SQL Server 2014, it was about optimized backup and “always-on” integration with the Windows Azure cloud. With System Center, Microsoft has also taken steps toward managing ...

This has been driving me crazy. Can anyone help me understand how I can dynamically create a sort of calendar view for a promotional schedule? I can't seem to get anything to work My table ...

I was once asked what I thought Microsoft's overall product trajectory for SQL Server was, in light of Oracle's rather obvious trajectory of acquiring multiple application vendors who will, in turn, ...

You poured data into a pivot table. Now what? Make them smarter. Here's how to use Summarizing Data and Calculated Fields in order to get a different perspective on your marketing data through the ...