Archive

Archive for August, 2013

Introduction to SQL 2012 Tabular Modeling

August 6, 2013 Leave a comment

3rd August, 2013

Presented a Session about SQL 2012 Tabular Server for DBA’s in an Event Organized by http://sqlgeeks.com/.

There were around 250+ attendees majorly DBA’s came with an intent of learning SQL BI, as they are from Non BI background, so I kept it basic.

PPT for your reference……

Few Pictures from event…….

20186_10200870424581755_496206351_n946334_10200870422141694_981674322_n

Advertisements
Categories: Uncategorized

SQL 2012 TABULAR: Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services

August 2, 2013 Leave a comment

Most Awaited Tabular Performance Tuning Paper is out………….

Applies to: SQL Server 2012

Summary: Tabular models hosted in SQL Server 2012 Analysis Service provide a comparatively lightweight, easy to build and deploy solution for business intelligence. However, as you increase the data load, add more users, or run complex queries, you need to have a strategy for maintaining and tuning performance. This paper describes strategies and specific techniques for getting the best performance from your tabular models, including processing and partitioning strategies, DAX query tuning, and server tuning for specific workloads

To review the document, please download the Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services Word document.

Categories: Uncategorized