What You’re Missing If You’re Not Using SQL Windowing Functions
We’ll explain and demo techniques you are missing out on that you can use to solve difficult sql problems using sql windowing functions including:
• Merging separate fiscal calendars with differing periods and different granularities (month vs. day, etc.)
• Finding equivalent fiscal days or calendar days in previous or future years.
• Calculating percentiles on data to be used for Analytic tools.
• Determining how many stops a sport-band user made during a day and how long their average stop was, adjusting for altitude and position using both windowing functions and sql spatial functions.
Steve is a Solution Architect for Data and Business Intelligence in Slalom Portland’s Information Management and Analytics practice.
He’s passionate about data quality, the performance of data systems, and delivering enterprise solutions for data architecture. He’s on the National Thought Leader Team for Master Data Management/Data Governance at Slalom Consulting. He has over 16 years experience in SQL Server including roles as DBA Manager, Data Architect, Sr. DBA, Analysis Services Architect and SSIS architect.
Stretch Databases in SQL Server 2016
In this introductory session, I’ll show you how easy it is to start using the new Stretch Database feature in SQL Server 2016. With this feature you can partition select tables and put the less accessed rows in Azure, thereby taking advantage of the lower cost of Azure only where you deem appropriate.
Vern (LinkedIn) 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.
Refreshments graciously provided.
Featured Sponsor: Red Gate
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.