Upcoming Meetings  

Wednesday, August 5, 2015 - Dealing with Time - Ben Taylor 

Wednesday, September 2, 2015  - SQL Server Encryption Edmund Poillion

We meet at Omni Resources, 4351 W College Ave, Appleton WI 54914. This is the Concordia College building just west of Hwy 41. 

PASS Summit 2015 

Summit is the world’s largest gathering of SQL Server & BI professionals. Take your SQL Server skills to the next level by learning from the world’s top SQL Server experts, in over 190 technical sessions. Register today, and save an extra $150 by using FoxPASS's discount code, LC15KZW5

Next Meeting: Wed, Aug 05 2015

FoxPASS August 2015 Meeting

Language: English
Event Type: In-Person & Online
Online Meeting URL: https://meet.lync.com/sqlpass365-sqlpass/fox/DG74KTXI
RSVPURL: http://fox-pass-sql.eventbrite.com

In August, we have local speaker Ben Taylor talking about...time! 


Event Time : Wed, Aug 05 2015 17:30 - 19:00 Central Daylight Time
Your Local Time: Wed, Aug 05 2015 22:30 - 00:00


4351 W College Ave
Appleton, Wisconsin

Direction: None

Featured Presentation

Dealing With Time

Speaker: Ben Taylor, Consultant Omni Resources

Summary: Tomorrow, today will be yesterday. The point is, time is constantly moving. Mining data based on time is a common problem. In a data warehouse it is so significant, most designs include a TIME dimension. There are lots of issues with time, such as reporting across time zones. A specific second is a part of a minute, hour, day, week, quarter, and year. Throw in fiscal years, and time becomes even more complicated. This presentation addresses the need to calculate aggregates of time across multiple decision points in an easy to understand implementation, utilizing standard transact SQL commands you can take home and use tomorrow. Watch how a single SSRS report presents pivoted time across multiple levels of aggregation of hours, days, weeks, months, quarters and years, including fiscal periods if we have time. Get a handle on time, before it runs out.

About Ben : None