August 12, 2015: Double Header Night

It’s Time for a Change – Temporal Tables in SQL Server 2016
and
Designing a Mobile Dashboard Solution with Microsoft DataZen

 

Vern Rabe
It’s Time for a Change – Temporal Table Support in SQL Server 2016

Without temporal tables (AKA history tables), we can only see the current version of data. We can’t see rows that have been deleted or rows as they existed before the latest update. The temporal table support in SQL Server 2016 gives us the ability to create system maintained “history” tables to track all changes to the table data.

In this session, we’ll discuss why you may need temporal support in your tables, how to implement temporal support without a true period data type (since SQL Server doesn’t yet have one), and how to query such a table using the new FOR SYSTEM_TIME clause in a SELECT statement. We will also discuss and demonstrate bi-temporal design, where both valid time and transaction time are supported.

Vern Rabe Vern (LinkedIn | Twitter) is an independent SQL Server consultant and contract trainer in Portland, OR. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been working with databases since 1992, and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server skills gained from the mixture of academic and practical experiences acquired from his classroom instructing and varied consulting contracts.


Paul Turley
Designing a Mobile Dashboard Solution with Microsoft DataZen

Microsoft Datazen is a new tool from Microsoft built on a mature and time-tested foundation of enterprise services and visualization components. If you are a SQL Server Enterprise customer, you already own it. Analytic dashboards created by data professionals are available to users on desktops and practically all modern mobile device platforms. Enabling a stunning user experience requires BI solution developers to set up servers, configure services and data sources, write queries and design dashboards.
You’ll learn:
•How DataZen fits into an enterprise BI strategy & works with other Microsoft BI & reporting technologies
•How to build and configure a secure DataZen Enterprise Server
•How to apply advanced features like parameters and expressions to create dashboard navigation & drill-through capabilities

Paul TurleyPaul (Blog | LinkedIn | Twitter) is a Mentor with SolidQ and a Microsoft SQL Server MVP. He consults, writes, speaks, teaches & blogs about business intelligence and reporting solutions. He works with companies around the world to visualize and deliver critical information to make informed business decisions. He is a Director of the Oregon SQL PASS chapter & user group, the lead author of Professional SQL Server 2012 Reporting Services and 13 other titles from Wrox, Packt & Microsoft Press.

Register NowDon’t miss this meeting!

Refreshments graciously provided.

Featured Sponsor: Idera
Visit our website for more details.


We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.


 

Posted in Announcements | Leave a comment