Welcome to Phoenix SQL Saturday 2015! #370
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
schedule is now live! Click here for the latest
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.
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.
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.
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.
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
follow us on Twitter at @azsqlpass and via Hashtag #arizonasqlpass.
Please also visit our AZSSUG Website http://arizona.sqlpass.org.