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, Dec 09 2014

HASSUG & H-BI Monthly Meeting - December 9, 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 – SQL Server 2012 Analytic Functions – John Cook
12:40-1:00 – Lunch
1:00-2:00 – Integrating Hadoop with Microsoft BI (part 2) – Tyler Chessman
2:00-2:30 – Recap Announcements & Networking

When

iCal
UTC : Tue, Dec 09 2014 17:30 - 20:30
Event Time : Tue, Dec 09 2014 11:30 - 14:30 (UTC-06:00) Central Time (US & Canada)
Your Local Time: Tue, Dec 09 2014 17:30 - 20:30

Where

10111 Richmond Ave, Suite 100
Houston, Texas

Direction: None

Featured Presentation

SQL Server 2012 Analytic Functions

Speaker: John Cook Microsoft

Summary: SQL Server has three classes of windowing functions: • Ranking functions • Aggregate functions • Analytic functions Analytic functions introduce new keywords such as LAG, LEAD, FIRST_VALUE, LAST_VALUE, ROWS PRECEDING, and ROWS FOLLOWING to simplify what were formerly complex queries. This PowerPoint free demo is also sample code. Starting with simple examples, additional features are added a step at a time so you can learn new and simpler ways to do complex tasks.

About John: John was a five time Microsoft SQL Server MVP prior to joining Microsoft where he is a Technology Solution Professional for the Data Platform.

Integrating Hadoop with Microsoft BI – Part 2

Speaker: Tyler Chessman

Summary: Picking up from last month’s presentation (based on his recent article in SQL Server Pro), Tyler will continue working through an example of how to use and integrate Hadoop with SQL Server and Microsoft BI tools. • Creating a Table Definition in Hadoop • Querying Hive Tables • Using the Hive ODBC Driver • Linked Server definition in SQL Server

About Tyler: None

Attachments

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