Arizona SQL Server Users Group

Next Meeting: Wed, May 11 2016

It's May in the Valley already!

Language: English
Event Type: In-Person
Online Meeting URL: None

Hope you can join us in the air conditioned rooms at Microsoft. It should be a good talk and fun to see everyone.


UTC : Wed, May 11 2016 23:30 - 01:30
Event Time : Wed, May 11 2016 16:30 - 18:30 (UTC-07:00) Arizona
Your Local Time: Wed, May 11 2016 23:30 - 01:30


1720 West Rio Salado Pkwy
Tempe, Arizona

Direction: None

Featured Presentation

DataSets, making the perfect DataSet effecient in SQL Server 2016!

Speaker: Joseph Barth, Senior Consultant II Neudesic

Summary: I will teach you the world of making DataSets. The use of T-SQL in SQL Server provides many ways to utilize the data you already have. In this 60 minute session we will go through the progression of useful techniques to manipulate a record set. Whether you use tables,temp tables, CTE's and/or Table variables, we will find the right situation for each one. We will also take a look at 2016's SQL Server's new Columnstore indexes on temp tables if and when they are useful. Trying to get that impossible result set for that report or extract, then please make it to this intermidiate session on how to resolve your dataset woes!

About Joseph: An eight year Microsoft SQL Server Specialist in SQL Server 2005-2016, Azure SQL DB, he has held many development positions, including SQL query tuner, SSIS and SSRS . Joseph's early focus as an SQL tuning professional, fixing long running queries by techniques; join order,use of temporary object, also implementing Index optimization, maintenance and design to fix slowness. Joseph has focused on ETL solutions using SSIS for the last 4 years, data warehousing and cloud architecture using Azure. Currently working on a Modern Data Warehouse project involving Azure Data Lake and Azure SQL DW using external tables. MCSE Data Management and Analytics 2016 MCSA: SQL Server 2012 Co-found CASSUG Albany NY 2 yrs AZSSUG Chapter Leader 3 yrs


Supplementary Materials

The following event attachments are available to you:

Meeting Archive

Back to Top