Houston Area SQL Server User Group

HASSUG and Houston BI User Group normally meets on the second Tuesday of every month during lunch time.   Occasionally, we will meet at other time, so please watch this page for updates. 

*** MEETING LOCATION  ***

         Improving
10111 Richmond Ave
Houston, Texas 77042

Next Meeting: Tue, May 13 2014

HASSUG & H-BI Monthly Meeting - May 13, 2014

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: None

The schedule for this meeting will be:

11:30-11:40 – Announcements
11:40-12:40 – Mastering the Excel Cube Functions by Peter Myers
12:40-1:00 – Lunch\Networking – Raffle #1
1:00-2:00 – SQL Server 2014 In-Memory OLTP Overview and Key Concepts by Jos de Bruijn
2:00-2:30 – Recap Announcements – Raffle #2 - Networking

When

iCal
UTC : Tue, May 13 2014 16:30 - 19:30
Event Time : Tue, May 13 2014 11:30 - 14:30 Central Daylight Time
Your Local Time: Tue, May 13 2014 16:30 - 19:30

Where

10111 Richmond Ave, Suite 100
Houston, Texas

Direction: None

Featured Presentation

Mastering the Excel Cube Functions

Speaker: Peter Myers, BI Expert Bitwise Solutions

Summary: This presentation explores the seven CUBE functions that are natively available in Excel. Unknown to many business analysts, these useful functions can be used to retrieve data model members and values to create parameter-driven report designs. The presentation will introduce each of the seven functions. Demonstrations will range from the simple, to the more sophisticated involving dynamic expressions, MDX expressions, integration of data from multiple data models, and macro-driven layouts. This session is a must for those looking to drive more from Excel when reporting from the BI Semantic Model. Much of the content presented in this session is applicable to Excel 2007, 2010 and 2013.

About Peter: Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services. He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.

SQL Server 2014 In-Memory OLTP Overview and Key Concepts

Speaker: Jos de Bruijn, Senior Program Manager Microsoft

Summary: In-Memory OLTP is a key feature in the In-Memory offerings of SQL Server 2014. We discuss the key user scenarios and the hardware trends that prompted the development of In-Memory OLTP. We will also introduce the new memory-optimized tables and natively compiled stored procedures, as well as the key memory and storage management concepts, and we will show how In-Memory OLTP can be used to improve the performance of a sample application.

About Jos: Jos de Bruijn is a Senior Program Manager in the SQL Server Database Systems team. He works on the Hekaton project, which brings the In-Memory OLTP database technology to SQL Server. His main focus is on query processing, programmability, and transaction semantics for memory optimized tables and natively compiled stored procedures. In a previous life, he obtained a Ph.D. in knowledge representation and semantic web technology, and worked in academia for several years as an assistant professor.

Attachments

debruijn-in-mem-overview.pptx

Download

Myers_CUBEFunctions_Houston_20140513.zip

Download

PASS_Chapter_Black.png 

Global PASS Sponsors:

 

sql_micro_sm.gif 

 

Local Group (HASSUG) Sponsors:

Idera

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids