Albuquerque SQL Server User Group

What's Happening?

Next Meeting: Fri, Aug 11 2017

August Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/Albuquerque-SQL-Server-User-Group/events/242197377/

August Meeting: Two For The Price Of One! - with Ron Beatty and Dave Justice

The Albuquerque SQL Server User Group (ABQSQL) will be having its next meeting on Friday, August 11th from 11:30 AM to 1:00 PM at Hospital Services Corporation, 7471 Pan American Freeway NE.

It's a special two-for-one meeting, as Ron Beatty will be presenting “Querying Temporal Tables: A Primer” followed by Dave Justice bringing "PowerPivot To The Rescue!" Ask Ron and Dave your questions, get to know your peers, and have lunch on us!

First presentation description: "System-versioned temporal tables, first introduced with SQL Server 2016, make it possible to not only query current data, but to also query the data as it was at a particular point in time. First, a temporal table is a type of table where the current version of the data is stored in the temporal table while previous versions of the data are stored in an associated “history” table. Together, the temporal table and its related history table store a full history of the data as it changes over time. Second, the new FOR SYSTEM_TIME clause is available in SELECT … FROM constructs for querying temporal tables at either a precise moment in time or during a specific period of time with one of four sub-clauses: AS OF, FROM TO, BETWEEN AND, and CONTAINED IN (,). In this presentation, the schema of a temporal table and its corresponding history table will be explored to gain an understanding of how SQL Server stores temporal data. This will be followed with queries demonstrating how and when to use the different sub-clauses of the new FOR SYSTEM_TIME clause for point in time analysis of temporal data."

Second presentation description: "It seems like it's PowerBI everywhere these days, or maybe it's just marketing.  Regardless, my company hasn't managed to get PowerBI deployed yet.  So, it's PowerPivot to the rescue!  We'll do a quick demo using the new Wide World Importers demo database to look at performance measurement over time, specifically, Year-over-Year sales performance.  We'll build a simple cube, and demonstrate the power that's available using PowerPivot today." 

Attend this FREE SQL training event!

Kindly RSVP so we know how much pizza we should buy!

 



 

When

iCal
UTC : Fri, Aug 11 2017 17:30 - 19:30
Event Time : Fri, Aug 11 2017 11:30 - 13:30 Mountain Daylight Time
Your Local Time: Fri, Aug 11 2017 17:30 - 19:30

Where

7471 Pan American
Albuquerque, New Mexico

Direction: None

Featured Presentation

Querying Temporal Tables: A Primer

Speaker: Dave Justice, Business Intelligence Analyst Mr.

Summary: irst presentation description: "System-versioned temporal tables, first introduced with SQL Server 2016, make it possible to not only query current data, but to also query the data as it was at a particular point in time. First, a temporal table is a type of table where the current version of the data is stored in the temporal table while previous versions of the data are stored in an associated “history” table. Together, the temporal table and its related history table store a full history of the data as it changes over time. Second, the new FOR SYSTEM_TIME clause is available in SELECT … FROM constructs for querying temporal tables at either a precise moment in time or during a specific period of time with one of four sub-clauses: AS OF, FROM TO, BETWEEN AND, and CONTAINED IN (,). In this presentation, the schema of a temporal table and its corresponding history table will be explored to gain an understanding of how SQL Server stores temporal data. This will be followed with queries demonstrating how and when to use the different sub-clauses of the new FOR SYSTEM_TIME clause for point in time analysis of temporal data."

About Dave: Twenty year veteran of using Microsoft SQL Server to deliver innovative database solutions for healthcare, insurance, wholesale and retail businesses.

PowerPivot To The Rescue!

Speaker: Ron Beatty

Summary: Second presentation description: "It seems like it's PowerBI everywhere these days, or maybe it's just marketing. Regardless, my company hasn't managed to get PowerBI deployed yet. So, it's PowerPivot to the rescue! We'll do a quick demo using the new Wide World Importers demo database to look at performance measurement over time, specifically, Year-over-Year sales performance. We'll build a simple cube, and demonstrate the power that's available using PowerPivot today."

About Ron: Ron Beatty is currently a Business Intelligence Developer. Ron has been in the trenches developing software solutions with Microsoft technologies for over 12+ years, with 9 years spent as a SQL Server developer. Ron has been working with the Microsoft BI Stack since SQL Server 2005, specializing in SQL Server Analysis Services, data warehousing, and MDX. Ron has a Bachelor’s degree from UNM in mathematics and a Master’s degree from UT in Biomedical Sciences.

Attachments

Please be sure to check out our Meetup.com page, and RSVP there for our monthly meetings.

PASS membership is not a prerequisite to attend this or any other monthly meeting of the Albuquerque SQL Users Group, however, you can enjoy many benefits of being a member by signing up for a FREE PASS membership at http://www.pass.org/.

Sponsors

PASSChapterLogo100.jpg  

 

 


 

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