North Texas SQL Servers Users Group

Next Meeting

Thursday,

April

17

17 APR 2014 NTSSUG Meeting

  • In-Person @ 7000 North Highway 161 Irving, Texas, United States (map)
  • 18:00 - 21:00 Central Daylight Time
  • Language: English

RSVP Here: None
6:00 - 6:20 - Welcome, Announcements & Food
6:20 - 7:20 - SQL Server 2014 In-Memory OLTP (“Hekaton”)  Overview by Fany Vargas
7:30 - 8:30 - Tips and Tricks for architecting a BI infrastructure on SQL 2012 Power View by Reinaldo Kibel

8:30 - 8:45 - Raffle and closing.

Featured Presentation:

SQL Server 2014 In-Memory OLTP (“Hekaton”) Overview

Fany Vargas, Sr. Premier Field Engineer (Dedicated Support) Microsoft

This session will introduce you to SQL Server 2014 In-Memory OLTP, code-named Hekaton. We will discuss the key user scenarios addressed by this technology, as well as the architectural components of in-memory OLTP optimization; these include SQL engine integration, optimistic concurrency control, native compilation and minimal I/O processing.

About Fany:
Fany Vargas is a Sr. Premier Field Engineer (Dedicated Support) at Microsoft. She has worked in various roles within the Microsoft SQL services and support teams throughout the past 11+ years - ranging from Support Engineer, Technical Lead, Support Escalation Engineer, and Premier Field Engineer. She graduated with a bachelor’s degree in Computer Science from Florida International University in 2002 and currently holds the MCSE: Data Platform (SQL 2012) certification.

Tips and Tricks for architecting a BI infrastructure on SQL 2012 Power View

Reinaldo Kibel, Database Strategist DELL

Analytics is changing the surface of the industry, the speed of how we sell, look at data, analyze information. Users want to see traffic data meshed with order data, supply and inventory data, and then add up financial and geographical data. Simply put it, it is a huge explosion of data, where Big Data is key. They need to analyze customer behavior, then take this information and tie in with customer 360 view, straight from Sales force to do demand generation. In this session you will see tips and tricks for setting up an enterprise infrastructure based on SQL Server 2012 Business Intelligence analytical tools Power View and PowerPivot that includes SharePoint 2013, SQL Server Engine 2012, SSIS 2012, Analysis Services Multidimensional, Tabular, and PowerPivot modes as well as SQL Reporting Services, PowerPivot and Power View. How to create OLAP cubes, PowerPivot data, and export to SSAS Tabular. Create reports with Power View based on the PowerPivot data extracted.

About Reinaldo:
With over 20 years of experience in Microsoft SQL Server technology, working in one of the largest MS SQL installation in the world at Dell and having worked at Microsoft, Reinaldo is a consultant, an architect and leader in the database technology area. Reinaldo is an advisory and provides direct feedback to Microsoft SQL Server Product team part of Technology Adoption Program with MS on versions 2005, 2008, 2008R2, 2012, 2014, 2016 and 2017 leader at Dell. Reinaldo has written case studies, white papers and videos on Data technology available at Microsoft and Dell web sites. Reinaldo has presented at Ignite, SQL Summit, SQL Saturdays, and 24HOP as well as local users group in TX.


Thank You to the 

PLATINUM

SPONSORS 

of our May 2018 

SQL Saturday!











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