SQLSaturday 370

Phoenix, United States

PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. This event will be held on Feb 28 2015 at The Black Canyon Conference Center, 9440 N 25th Ave , Phoenix, Arizona, 85021, United States

Register Now

Welcome to Phoenix SQL Saturday 2015! #370


SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Feb 28 2015 at The Black Canyon Conference Center, 9440 N 25th Ave , Phoenix, AZ 85021. Admittance to this event is FREE, but we do charge a lunch fee of 10.00 so that we can provide a lunch - not pizza! Please register soon as seating is limited, and let friends and colleagues know about the event


The schedule is now live!  Click here for the latest schedule.


We are pleased to announce 4 ALL DAY sessions on Friday February 27th from 8:30AM - 4:30pm.  These will be held at the Microsoft Office in Tempe, Arizona. Between now and January 31st, you can get this training for only $99 + Eventbrite Fees. After January 31st, you can get the training at the regular price of $125+ EventBrite Fees.
Session 1: Architecting the Modern Data Warehouse – Adam Jorgensen
Today's modern data warehouse is more than facts and measures, but the ability to empower users with data and to build analytics solutions that predict future outcomes. We'll examine the problems and solutions facing the modern data warehouse. We'll look at how to balance data loading and computing processes with the needs for the platform. Looking at how to work with both structured and unstructured data and when to continue to leverage relational databases versus file-base solutions, such as Hadoop. From on-premise to appliance to cloud solutions, this session will examine how to select the right fit for the right solution. We’ll also discuss how to augment these solutions with Big Data and Cloud technologies including automating those (and giving you the scripts to do so J ) and adding common analytic data sources such as social media.By the end of the day, you will understand what is possible in the modern data warehouse and how to architect solutions fitting your company.
Session 2: SQL Internals Deep Dive – Bradley Ball
Congratulations you’re a SQL Server DBA/Developer/BI Developer. How does SQL Server work? We have tables, views, and indexes. We write queries. How do the queries and the tables work together? Have you ever wondered? Why should you? Understanding how SQL Server works internally allows you to know how and when to use SQL Server to solve business problems. We need to understand the relational engine, index, transaction log, data, and locking internals. We need to know how these apply to business decisions that we make every day! Most importantly we need DEMOS!!! Join SQL Server MVP Bradley Ball as we dive into the SQL Server Internals spanning from the Query Processor, through the Storage Engine, the Plan Cache and in between.
Session 3: Tune Like a Guru – Kevin Boles
In this Pre-Con event we will cover a wide array of topics that form the backbone of my SQL Server performance analysis and tuning work. As a long-time relational engine consultant I have repeatedly found that the majority of clients I work with get amazing improvements by simply putting to use a fairly small collection of knowledge and tools. We will cover many topics, including: Optimization processes, Statistics usage and maintenance, Index creation, usage and maintenance, Understanding query plans, Server and database configuration, Improving design, Improving code, Profiler and trace analysis, Temporary object usage, and Waits and IO stall analysis.
Session 4: Virtualization for the SQL DBA – David Klee
Microsoft MVP, VMware vExpert, and SQL Server performance expert David Klee leads this full-day introduction to enabling and managing a virtualized SQL Server environment. The focus of the course is to help those new to virtualization and/or infrastructure concepts to become familiar with the concept and purposes of virtualization and how it can benefit them as data professionals. Participants will gain exposure to all layers of virtualization underneath SQL Server, from storage to hypervisor to the SQL Server instance, and will learn how to construct the entire stack with a strong emphasis on SQL Server
You can follow us on Twitter at @azsqlpass and via Hashtag #arizonasqlpass.  Please also visit our AZSSUG Website http://arizona.sqlpass.org.

Event Location

Event news

 Kevin Cox, Principal Program Manager at Microsoft will be delivering the keynote at Phoenix SQL Saturday 2015! Read More

 Kevin Cox, Principal Program Manager at Microsoft will be delivering the keynote at Phoenix SQL Saturday 2015! Read More


Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us

What is a PASS SQLSaturday?

PASS SQLSaturdays are local events organized by PASS community members around the world. PASS is a not-for-profit association for data professionals who leverage the Microsoft Data Platform, offering interactive learning built by community and guided by trusted data experts.

Back to Top cage-aids