May 18-21, 2015

Fairmont Scottsdale Princess

Scottsdale, AZ (Phoenix)

Picture

Scott Guthrie

Microsoft

Executive Vice President, Microsoft Cloud and Enterprise group

Picture

Steve Guggenheimer

Microsoft

Corporate Vice President of Microsoft's Developer & Platform Evangelism (DPE) Group

Picture

Brent Ozar

Brent Ozar Unlimited

Picture

Tim Chapman

Microsoft

Dedicated Support Engineer (PFE)

Picture

Paul Randal

SQLskills.com

CEO / Owner

Picture

Erin Stellato

SQLskills

Principal Consultant

Picture

Kevin Kline

SQL Sentry, Inc.

Director of Engineering Services

Picture

Tim Radney

SQLskills

Principal Consultant

Picture

Kimberly L. Tripp

SQLSkills.com

President, Founder, and Owner

Picture

David Pless

Microsoft

Senior Premier Field Engineer (PFE)

Picture

Allen White

Upsearch

Practice Leader

Picture

Richard Campbell

Picture

Aaron Bertrand

SQL Sentry, Inc.

Sr. Consultant

Picture

Shep Sheppard

Microsoft

Senior Program Manager ,,AzureCAT

Workshops 05/17/2015

Very Large Tables: Optimizing Performance and Availability through Partitioning

Kimberly L. Tripp

PRECONFERENCE Workshop
5/17/2015 9:00:00 AM

Partitioning is really just a concept. In implementation there are many ways to “partition” a very large table (VLT). You can use table partitioning (introduced in 2005) and you can use partitioned views (introduced in 7.0). Of course, the table partitioning option must be better because it’s newer, right? Actually, not always! However, PVs aren’t always the best architecture either. To be honest, “partitioning” large data sets can be complicated. There are many pros and cons to each approach (individually) but combining these strategies can often yield phenomenal gains. We’ll start by discussing workloads, architectures, limitations, and design considerations. Is your database more OLTP-focused with management wanting more and more analysis done *real-time* (and, you’re keeping more and more data around longer)? Or, is your system split – where data is regularly moved from OLTP to a purely relational data warehouse? Have you optimized these regular loads from production? Once we’ve categorized your system, then we can really dive into the appropriate architecture and how to get it right! In this full-day, fast-paced workshop, Kimberly will show you the pros and cons to each architecture as well as the best architecture to solve all of the deficiencies in each individual approach to partitioning.

Manage SQL Server Efficiently with PowerShell

Allen White

PRECONFERENCE Workshop
5/17/2015 9:00:00 AM

Whether you manage two servers or two thousand, more and more is expected of us in our daily jobs and the only way to keep on top of the demand is to automate. PowerShell allows you to do that across your Windows Server environment, including SQL Server. In this workshop we'll introduce you to PowerShell and then cover how you can use it to manage your servers. We'll spend the first half of the day focusing on PowerShell itself, covering objects (which are just encapsulated data), how to use the pipeline to get the information you need in a way that makes sense, how to write your own functions and modules, how to access and manage Azure VMs and how to use PowerShell remoting to run scripts against thousands of servers. The second half of the day we'll cover how you can use PowerShell to manage SQL Server, covering SMO (Server Management Objects, the Management API for SQL Server), the SQL Server Provider, which allows you to navigate SQL Server as though it were a file system, the SQL Server-specific cmdlets which allow you to query, backup and restore SQL Server as well as the cmdlets you'll use to set up and manage Azure SQL Databases.

Workshops 05/18/2015

Performance Troubleshooting using Waits and Latches

Paul Randal

PRECONFERENCE Workshop
5/18/2015 9:00:00 AM

One of the first things you should check when investigating performance issues are wait and latch statistics, as these can often point you in the right direction for further analysis. Unfortunately many people misinterpret what SQL Server is telling them and jump to conclusions about how to solve the problem - what is often called 'knee-jerk performance tuning'. In this full-day workshop, you'll learn how to investigate and interpret wait and latch statistics - practical techniques you can take home and start using immediately. You'll also learn what a myriad of wait and latch types actually mean and how you can investigate lightly-documented types to gain insight into what causes them. Don't waste time when it comes to performance troubleshooting; wait statistics are the fastest route to understanding your problems and this workshop will help you get there faster.

Setting Up and Troubleshooting SQL Server

Brent Ozar

PRECONFERENCE Workshop
5/18/2015 9:00:00 AM

When you're the one who has to plan, buy, set up, and troubleshoot production SQL Servers, you need to know about hardware, SAN storage, SSDs, virtualization, and more. In this one-day course, Microsoft Certified Master Brent Ozar will share his worksheets and real-world examples to help you learn: * How to choose if clustering, AlwaysOn Availability Groups, mirroring, log shipping, virtualization, or SAN replication is right for your new build * How to configure SQL Server on a SAN or on virtualization (VMware or Hyper-V) * Testing and comparing your storage to industry benchmarks * Brent's one-month go-live checklist covering what to test before putting a new SQL Server in production * Troubleshooting outages and performance slowdowns after going live

Workshops 05/22/2015

Performance Tuning When You Can't Fix the Queries

Brent Ozar

POSTCONFERENCE Workshop
Friday May 22 , 09:00 AM-04:30 PM

Your users are frustrated because the app is too slow, but you can’t change the queries. Maybe it’s a third party app, or maybe you’re using generated code, or maybe you’re just not allowed to change it. Take heart – there’s still hope. Brent Ozar does this every week, and he’ll share his proven methodologies to performance tune with indexes, SQL Server configuration switches, and hardware. In this one-day workshop, you’ll learn: * Simplified internals – how SQL Server turns your query into an execution plan * Wait stats solutions – a list of fixes for most common bottlenecks * Plan cache analysis – how to discover the most resource-intensive queries so you know if indexes and hardware will work * Monitoring metrics – what DMVs and Perfmon counters to monitor, and what thresholds to alert on * Hardware warning signs – how to prove your server is undersized for your workloads * Tools and scripts – the best free and paid tools to make your tuning job easier This session is for developers, DBAs, and consultants who have to make SQL Server go faster. You should be comfortable writing queries and creating tables, but not as confident about interpreting SQL Server’s DMVs and diagnostic data.

Show Dates

May 18-21, 2015
Fairmont Scottsdale Princess
Scottsdale, AZ (Phoenix)

Nov 2-5, 2015 in Las Vegas
MGM Grand
Las Vegas, NV

Sponsor or Exhibit

Get Notified!

We'll keep you up to date on key dates, materials and schedules.

Related Events

Top 10 Reasons to attend

Discover why you should attend DEVintersections with our Top 10 Reasons to Attend!

More quality sessions, industry gurus and your favorite Microsoft speakers than any other event out there this Fall. Compare before investing your time and training dollars.

A conference to get a unique perspective from both Microsoft and industry experts out in the trenches.

Bonus "Simply Apps" track delivered by Microsoft’s Modern App team; access to <anglebrackets/> sessions.

If you register for a "show package" you get the full conference plus one or more optional workshops.

You get 5 conferences for the price of one, each with their own set of experts and sessions offering opportunities to cross over.

Only the top presenters will be here sharing real-world solutions and techniques to sharpen your skills for instant ROI. Check out this 32-page brochure for all your favorites.

Multiple opportunities to meet and network with your favorite industry experts will be scheduled in informal settings.

Keynotes and direct interaction with Microsoft execs like Scott Guthrie, Executive Corporate VP, Cloud and Enterprise, Microsoft, Steven Guggenheimer, Corporate VP Developer Platform, Microsoft, Rob Lefferts, Microsoft Director Office 365 & SharePoint, Bob Ward, Principal Architect Escalation Engineer and Scott Hanselman, Principal Community Architect for Web Platform and Tools.

No one is alone at this event. We will make it easy via your phone and meet-up locations to connect with other attendees and speakers. When the sun goes down you have many options from jam sessions, hackathons, game idol contests, open spaces to group discounted show & concert tickets.

At Intersection events, every attendee is a VIP and part of our growing community.

Discover Now

Powered by