|

Analyze SQL Database Table Space Usage using TreeMap Visualization in Excel 2013

One of fascinating features of Excel 2013 is “App for Office” option which exposes us to some of the great apps from Office store which you can download and install. One of such useful apps which I came across is TreeMap Data Visualization developed by Microsoft Research which allows you to represent hierarchical data of…

Ebook Review: Windows Azure SQL Reporting Succintly by Stacia Misner

I recently came across a very useful set of free ebooks and great developer resources from syncfusion which you can see it for yourself here . Being an MS BI Developer, windows azure sql reporting succintly by Stacia Misner grabbed my attention and I immediately downloaded the ebook and started reading through it. I had…

|

How to provision Power BI App to your Office 365 Enterprise portal

With an excellent passionate & energetic presentation on Power BI by Amir Netz in WPC, there has been a lot of excitement and buzz for power bi within the BI Community (In case you haven’t watched the video yet, you can find it here ).  The community is now eagerly waiting to lay their hands…

SSIS Data Flow Task with Export to Excel 2007 xlsx Destination doesn’t retain the datatype from Source

In this blog post, I would like to address one typical limitation in SSIS Data Flow task which many of us might have experienced when you export the data to Excel 2007 (xlsx) Destination which has also been reported in the following connect item https://connect.microsoft.com/SQLServer/feedback/details/477970/excel-data-types-from-ssis It is actually a limitation of ACE Provider in the…

Performance Tuning of SSRS & the use of Emptypoint with SSRS charts

I would have never realized the relevance of the EmptyPoint property in the Chart Series until I hit the issue while performance tuning of one such SSRS report for a customer. Here is the background, The SSRS report we intend to tune consists of Line graph to measure the pageviews across months for different site….

| | |

SQL Consolidation Considerations !!!

In modern times, with current focus of most organizations on saving costs by means of virtualization and consolidations., It becomes increasingly important for DBAs to ensure that help organization achieve this objective without compromising on the performance, scalability, availability & application compatibility. In this blog post, I would like to give some pointers on the…