L.A. SQL Server Professionals Group

Welcome to the Los Angeles SQL Server Professionals Group

Next Meeting




Understanding Query Modes in Tabular Model

  • In-Person @ 110 Westwood Plaza Los Angeles, California, United States (map)
  • 18:30 - 21:30 Pacific Daylight Time
  • Language: English

Understanding Query Modes in Tabular Model

Featured Presentation:

Understanding Query Modes in Tabular Model

Julie Koesmarno, Senior Program Manager Microsoft

SQL Server Analysis Services Tabular Model allows rapid and simplified data modelling of Business Intelligence solutions. An important aspect that is often overlooked when building a tabular model, is meeting real-time requirements. In this session you will learn how to tackle immediate (or close to) real time requirements using the different types of Data Access and Query Modes of Tabular Model and how your choice impacts your reporting options in the Microsoft BI stack. Using live demo, this session will outline advantages and disadvantages between DirectQuery and In-Memory modes. We will also highlight impersonation and partitioning differences between the two modes. Finally, we will also cover the definition of a Hybrid Tabular Model solution.

About Julie:
Julie Koesmarno, MCSE Data Platform, and MCSE Business Intelligence, MCT, is a Senior Program Manager at Microsoft, with a Bachelor’s degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her past projects include delivering a SQL Server 2012 data warehouse and BI solutions in the US and Australia. She now works with hybrid, cloud and on-prem SQL projects.

PASS Summit 2019 Discount Code



WeStaffIT, Inc.





Back to Top