November 10-13 2014

MGM Grand

Las Vegas, Nevada

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

Rob Lefferts

Microsoft

Director of Program Management for the Office APPS Team

Picture

Richard Campbell

.NET Rocks! / RunAs Radio

Picture

Brent Ozar

Brent Ozar Unlimited

Picture

Kimberly L. Tripp

SQLskills.com

President/Founder

Picture

Joe Sack

SackHQ.com

Picture

Jonathan Kehayias

SQLskills

Principal Consultant

Picture

Tim Chapman

Picture

Kevin Kline

SQL Sentry, Inc.

Director of Engineering Services

Picture

Greg Lutz

ComponentOne

Product Manager

Picture

Paul White

SQL Kiwi Limited

Picture

Paul S. Randal

SQLskills.com

CEO / Owner

Picture

Andrew J. Kelly

SolidQ

Mentor

Picture

Kendra Little

Brent Ozar Unlimited

Managing Director

Picture

Glenn Berry

SQLskills

Principal Consultant

Picture

Jeremiah Peschka

Brent Ozar Unlimited

Picture

Bob Ward

Microsoft

Principal Architect Escalation Engineer

Picture

Aaron Bertrand

SQL Sentry, Inc.

Sr. Consultant

Picture

David Pless

Microsoft

Picture

Jason Taylor

Stackify

CTO

Workshops

Surviving the Azure Avalanche

Michele Leroux Bustamante

Zoiner Tejada

PRECONFERENCE Workshop
Sunday Nov 09, 09:00 AM - 04:30 PM

There are so many amazing features available in with Windows Azure today that it is a mini technology avalanche on its own. The goal of this workshop is to provide an end to end overview with some perspective on when to use each feature, and which features we see gaining the most traction with customers today. You'll learn how to choose between computing platforms (IaaS and PaaS models- VMs, Websites and Cloud Services) and how those platforms play together in an enterprise or webscale solution how to choose the right technology for asynchronous work (Azure Scheduler, Mobile Services Scheduler, Azure Web Jobs, Azure Automation, Worker Roles, etc how to choose between queuing technologies (Storage Queues, Service Bus, Notification Hubs) working with media and content (Blob Storage, Cache, CDN, Traffic Manager, Media Services) approaches to data (NoSQL, relational, big data) and many other features including those related to security, mobile development, networking and devops. Practical architecture scenarios and demonstrations will help illustrate how to apply each feature. No feature will be left unturned, so bring your coffee and let's do this!

SQL Server Architecture: Choosing Virtualization, Clustering, AlwaysOn, and More

Jeremiah Peschka

Kendra Little

Brent Ozar

PRECONFERENCE Workshop
Sunday Nov 09, 09:00 AM - 04:30 PM


Level = 200-300

You need to recommend the right architecture for your company's SQL Servers. The CTO is interested in the cloud, while the SAN Administrator wants to virtualize everything in-house. One of the business users believes that SQL Server Availability Groups can work with both technologies and solve all your problems.

In this one day workshop, you'll learn:

  • When virtualization is the right fit (and when it's not)
  • How to mix platforms and features to keep SQL Server available
  • How to choose the right technology to scale out reads and writes
  • When the cloud is right for you
  • When to invest in application technology like caching

Topics covered:
  • Understand the pros and cons of replication, Failover Clustering, Database Mirroring, Availability Groups, and Application Caching
  • Identify patterns that work well for virtualization
  • Learn when cloud providers can offer benefits for performance and availability
  • Get hands-on experience recommending short and long term changes for existing architecture
  • Design a new architecture for a real-world challenge

Core SQL Server Fundamentals

Andrew J. Kelly

PRECONFERENCE Workshop
Sunday Nov 09, 09:00 AM - 04:30 PM


Level = 100-200

SQL Server is the type of product that you can almost use as is right out of the box for small and up to some medium-sized projects. However, if you really want to do things right the first time and avoid some of the most common growing pains, you need to understand the core fundamentals. We will spend the day helping you to understand exactly what these are and how to utilize them to your advantage. This will include such aspects as key installation choices, instance and database level configuration options along with important tempdb considerations. We will also spend time covering database maintenance tasks including backup and restore, DBCC's, re-indexing, and other miscellaneous tasks that should not be overlooked. Do you wonder about things like how many files you should use for a database or what the setting of MAXDOP should be? Are you relatively new to SQL Server or, like most folks, never had the time to learn these aspects properly from the beginning? If so, this is a must-attend workshop!

Develop a Complete Multi-platform 2D Game with Unity and C#

Daniel Egan

PRECONFERENCE Workshop
Sunday Nov 09, 09:00 AM - 04:30 PM

Mobile games are the hottest slice of the app market on any platform. Come learn how to develop an entire 2D game from the ground up using Unity and C#. Unity is one of the major game engines in use by everyone from hobbyists to AAA game studios worldwide. You will learn about the new Unity 2D toolset, how to import graphics, the various components and behaviors for your objects, create a rich & interactive environment, use C# to control your game objects, and finally how to build your game for multiple platforms. Prepare to be amazed at what you can do!
No prior game development experience is needed to reap the benefits of this session.

Building Mobile Cross-Platform Apps for iOS, Android & Windows Devices with C#

Nick Landry

PRECONFERENCE Workshop
Sunday Nov 09, 09:00 AM - 04:30 PM

Building native applications across multiple platforms is hard. iOS requires knowledge of Xcode, the iOS SDK and Objective-C. Android requires Eclipse, the Android SDK and Java. Windows 8 & Windows Phone require Visual Studio, C# and the WinRT SDK. Are we really expected to learn all of this? You can take the HTML5 & PhoneGap route, but not all apps should be built using a hybrid approach. If you want to create a truly competitive app with a premium experience, you&rsquoll need to go native. Fortunately, there is a way you can share a lot of your code across mobile platforms and do so using the C# language you already know and love. The Mono framework is an Open Source project that brings .NET to other platforms, and Xamarin tools leverage Mono for iOS and Android development.

This workshop explores how you can build cross-platform applications for iOS, Android, Windows Phone & Windows 8 using C#. You'll learn the application models of iOS, Android and Windows and how to structure your projects for maximum code reuse. You will build a sample cross-platform solution using Visual Studio and/or Xamarin Studio, and learn about the platform-specific tools at your disposal. We'll cover some of the platform-specific APIs of iOS and Android and how Xamarin lets you call them from C# code. You'll also learn how to design a proper user interface for each platform while reusing as much business logic and data-access code as possible.

Next we'll dig into Microsoft Visual Studio 2013 and the new Windows Universal Apps, extend our app using XAML & C#, and debug it with Windows 8.1 and the Windows Phone Emulator. We&rsquoll then explore the converged WinRT API services and features, such as Live Tiles, Speech, etc. We&rsquoll also spend valuable time going over the new app model for Windows device apps, how to share code between phone and tablet, and how to build a converged UI in XAML for Windows 8.1 and Windows Phone. Lastly we'll go over the app packaging and how to submit your Universal apps to the Windows Store.

We'll also learn how to build cloud-enabled cross-platform applications for iOS, Android and the Windows platform using C#, Xamarin tools & frameworks, and Windows Azure Mobile Services. You'll learn how to authenticate users via Microsoft, Google, Facebook or Twitter credentials, store data remotely in cloud tables, and more. Additionally, discover how to send push notifications from cloud-hosted services to a mobile app running on a Windows, iOS or Android tablet or phone, and learn how to handle those alerts in your mobile app. We'll discuss the various push notification services from Microsoft, Apple and Google, how to leverage them in your mobile applications, how to deal with push scenarios for any given multi-platform app, and we'll also look at Notification Hubs that can let you push millions of notifications with just a few lines of code.

Native mobile development doesn't have to be so hard. Come learn how your .NET skills can be transformed for true cross-platform mobile development.

Mastering SQL Server Execution Plan Analysis

Paul White

PRECONFERENCE Workshop
Sunday Nov 09, 09:00 AM - 04:30 AM

Expert-level query tuning and performance analysis requires a deep understanding of both the query optimizer and the execution plans it produces.

The first part of this full-day workshop covers the SQL Server Query Optimizer in-depth. Starting with a clear overview of the basics, the session will progress rapidly to look at the detailed and often subtle behaviors that have real impact on almost every query you write. At the end of the query optimizer section, you will understand how it works, its strengths and weaknesses, and how to design databases and write queries to get the best from it.

The second part of the session begins with an introduction to the Query Execution Engine framework, query plan operators, and the main things to check in execution plans. We will then move on to developing the expert practical skills you will need to start interpreting execution plans instead of just reading them, including accurate plan assessment, selecting targets for improvement, and confidently making effective changes.

Practical Agile Workshop

Greg Smith

PRECONFERENCE Workshop
Sunday Nov 09, 09:00 AM - 04:30 PM

This one-day workshop will focus on the essence of Agile and how to apply it effectively in the real world. You won't learn every Agile practice (that takes much longer than a day), but the workshop will focus on a few basic principles and strategies that ensure a faster, more accurate delivery to your business partners. If you and your team have some Agile experience that wasn't entirely successful, or you've hesitated to go down the Agile path, this workshop will cover the common issues that prevent teams from getting value from Agile and how to address them. You should attend this workshop if you work as part of a software team, including managers. We will cover areas such as:

  • Agile with distributed teams
  • Using Agile with non-dedicated teams
  • Using Agile with off-the-shelf packages
  • Determining the level of Agile to use based on project type
  • Improving project estimation
  • Ensuring that the software delivered is used
  • Using Agile on non-software projects

This workshop is based on practical lessons learned from over 100 Agile transformations at start-ups, Fortune 500 companies, associations and non-profits, healthcare, media, banking, energy, e-commerce, online trading, cloud services, food and beverage, and government agencies. Start the conference with a completely fresh way of approaching how your team delivers better projects.

On the Metal: Essential HTML5, CSS3, and JavaScript (HANDS-ON, BRING YOUR LAPTOP)

Todd Anglin

PRECONFERENCE Workshop
Monday Nov 10, 09:00 AM - 04:30 PM

HTML5 and CSS3 have arrived and they are redefining rich, standards-based web development. Features previously the exclusive domain of browser plug-ins can now be added to web applications as easily as images. Understanding the new power that these standards define, as well as the rapidly increasing power and speed of JavaScript in modern browsers and devices is essential. In this full-day workshop, you will be guided through the new features in HTML5 and CSS3, with special attention to how these technologies can be used today in new and old browsers.
Among the topics that will be covered:
  • HTML5 fundamentals and elements
  • HTML5 adoption strategies
  • HTML5 forms and validation, geolocation, offline applications, localstorage
  • HTML5 "Polyfills"
  • CSS3 fundamentals & browser support
  • CSS3 styles (shadows, rounded corners, gradients) and animations
  • HTML5 and CSS3 browser support, tips, and tricks.
  • JavaScript best practices for modern browsers
  • Modern HTML application architecture (SPA)

Leave this workshop with the knowledge you need to start using HTML5, CSS3, and JavaScript to build modern standards-based applications for the web and mobile devices. LAPTOPS ARE ENCOURAGED to follow along, but not required.

The Architecture Clinic

Juval Lowy

PRECONFERENCE Workshop
Monday Nov 10, 09:00 AM - 04:30 PM

Wonder about architecture best practices, guidelines and pitfalls? You sense there is more to decomposing a system based merely on requirements? Wonder how to design world-class systems? You understand the concepts but not how to apply them? In the first half of this high pace tutorial, Juval will explain his original approach to large system analysis design and his method. Then, he will present a comprehensive case study, outlining the architecture that addresses the requirements, discussing logical tiers, security, interoperability, scalability, transactions, and other aspects of a modern application. You will see how to approach rarely discussed topics such as allocation of services to assemblies, allocation of services to processes, transaction boundaries, identity management, authorization and authentication boundaries and more. Time permitting you will also see how to design the project behind that system.

Performance Troubleshooting Using Waits and Latches

Paul S. Randal

PRECONFERENCE Workshop
Monday Nov 10, 09:00 AM - 04:30 PM


Level = 300-400

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.

High Performance, Scalable Asynchronous Processing Using Service Broker

Jonathan Kehayias

PRECONFERENCE Workshop
Monday Nov 10, 09:00 AM - 04:30 PM


Level = 100-300 (some 400 at the end)

Sometimes a workload has been tuned for optimum performance but you STILL need it to go faster and scale further. One of the most overlooked but most powerful solutions is to move wholly or partially to asynchronous processing using the Service Broker feature that's been available since SQL Server 2005. In this practical workshop, you'll learn the benefits of using Service Broker in a variety of real-world scenarios. We'll cover how to implement the components required for single database, multi-database, and multi-instance solutions and how to architect solutions that will scale to meet business requirements now and in the future. This workshop will show you how to get Service Broker configured correctly the first time, for easy, foolproof deployments that solve real business problems. Often, the SQL Agent is chosen for asynchronous processing and unfortunately, it pales in comparison with what you can do using Service Broker I&rsquoll compare and contrast the two for a full understanding of why! I've been implementing this solution successfully more and more over the last few years and it's time you added it to your design patterns library.

Service Orientation Technologies: Designing, Developing, Implementing WCF and the Web API

Miguel Castro

PRECONFERENCE Workshop
Monday Nov 10, 09:00 AM - 04:30 PM

Service Oriented Architectures are the best way to ensure that today's applications are extensible, maintainable, and scalable in a volatile world filled with ever-changing demands. Decomposing your systems into smaller, loosely coupled, and more autonomous components ensures that your application can continue to grow or change without having to continuously undergo rewrites or redesigns. But with great power comes great responsibility (don't say it), and the need for great technology and tooling. WCF is the heart of Microsoft's stack for building connected systems and loosely coupled components. ASP.NET Web API is the latest addition to this stack in a world where REST and it's interoperability power becomes more necessary and in more demand. Come learn both of these technologies and how to properly use them, apart and together. I will teach you what a Service Oriented Architecture is and how to use WCF & Web API from the ground up. Then I'll show how to integrate both these technologies together into applications whose clients may vary from WPF to ASP.NET MVC to Windows 8 Tablet apps. I&rsquoll cover setup and consumption of your services end-to-end, showing you how and where to properly set up your projects, properly use proxies, contracts, and even REST URL design. You'll have the knowledge of how to use service technology and to properly implement it in a clean and elegant fashion.

Very Large Tables: Optimizing Performance and Availability through Partitioning

Kimberly L. Tripp

PRECONFERENCE Workshop
Monday Nov 10, 09:00 AM - 04:30 PM


Level = 200-400

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 &ndash 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.

Topics covered:
  • Partitioned Views
    • o Pros/Cons
    • o Design considerations/architecture
  • Partitioned Tables
    • o Pros/Cons
    • o Design considerations/architecture
  • Combining PVs & PTs
    • o Performance, statistics, and large tables VLT
    • o Why filtering (filtered indexes/filtered stats) doesn't work as well as partitioning
    • o Maintenance considerations

PowerShell the Whole Kit & Caboodle: Building SharePoint from the Bottom Up the Right Way

Jason Himmelstein

Seb Matthews

PRECONFERENCE Workshop
Monday Nov 10, 09:00 AM - 04:30 PM

Nowadays with organizational budgets being ever more squeezed, IT Pro's are being asked to take responsibility for more and more in the application tier.

With this in mind, this pre-con day will focus on the implementation, from scratch, of a SharePoint environment from the perspective of an IT Pro.

Using PowerShell wherever possible, we will build a farm out from bare Windows Server machines covering steps including:
  • SharePoint under the bonnet 101
  • Preparing Windows Servers for SharePoint and SQL Server
  • Creating Windows and SQL Server clusters
  • Scripted installation of SQL Server in a ''SharePoint ready'' way
  • Deploying SharePoint using script automation
  • Configuring SharePoint databases with PowerShell
  • Optimising SQL Server for SharePoint
  • SQL maintenance for SharePoint
  • Backup and restore of SharePoint content

By the end of the day, we will aim to have a working SharePoint environment that is ready, quite literally, for production use.

As an added bonus to attendees, we will provide access to all the scripts used during the day so that you can take the scripts and replay the session for yourselves as a learning experience or for real-world use.

With a ton of information to get across in the day, the session will be fast-paced and challenging, but there will be plenty of time for questions and follow ups through the day and via social media.

We hope to see you there!

AngularJS in 0 to 60

John Papa

Dan Wahlin

PRECONFERENCE Workshop
Monday Nov 10, 09:00 AM - 04:30 PM

HTML5 Single Page Apps (SPAs) focus on delivering enhanced user experiences with significant client-side interactions using JavaScript, HTML5 and CSS. AngularJS does all of the heavy lifting for you to pave the road towards building a SPA. This workshop explores the core pieces that help you build end-to-end SPA solutions using AngularJS including code structure and modularity, using data binding and MV*, abstracted remote data calls, page navigation and routing, rich data features, and responsive design.
Throughout the workshop you'll learn how to build robust SPA applications with Angular. You'll see several focused demos and full featured apps that will help you learn and understand the role of key AngularJS components such as modules, controllers, factories, directives, and more. We'll wrap up with a dive into rich data management using Breeze.

This workshop covers:

*SPA fundamentals
*Importance of Separation of Concerns (SoC)
*JavaScript patterns for creating organized code
*Key components of AngularJS
*How directives can be used
*The role of views, controllers, and $scope
*Managing remote data calls using services or factories
*The role of modules and how they can be used
*Routing and page navigation
*Handling dirty data
*Data validation
*Data binding
*Using rich data with Breeze.js
*Navigating and App LifeCycle
*Debugging Tips

Bootstrap Bootcamp

Paul D. Sheriff

PRECONFERENCE Workshop
Monday Nov 10, 09:00 AM - 04:30 PM

If you need to build a mobile web site, then this workshop is for you. We will cover technologies such as HTML 5, CSS 3, bootstrap and modernizr. We will use Visual Studio 2013 and show how they have built-in these important technologies to help us create compelling mobile web applications. All of these tools are available to both Web Forms and MVC developers, so regardless of which one you wish to use, you are covered. Besides learning the basics of Bootstrap, you will also see how to build navigation for your web applications, how to apply different themes, and design common business forms such as login, sign up, member profile, about, contact us and others.

Attend this workshop to learn the following:
*A quick introduction to HTML 5 & CSS 3
*Bootstrap 101
*Bootstrap layout system
*Building navigation
*Theming
*Working with tables
*Designing input forms
*Standard input forms

Mission Impossible: Learn How to Become a SharePoint Requirements Secret Agent and Decode Your Project's Secrets with Our Super-Secret-Agent Tools and Techniques

Michelle Caldwell

Ruven Gotz

PRECONFERENCE Workshop
Monday Nov 10, 09:00 AM - 04:30 PM

If you don't have a clear understanding of what your clients/stakeholders want, your SharePoint project will likely fail in at least some key areas. The problem is that getting people to explain what they want is really hard. We will present a collection of innovative techniques, based on visual and tactile tools that have been proven to really help with this problem.

Gamestorming and innovation techniques make it easier for your clients/stakeholders to explore the real issues and to articulate the true goals that they have for the project. Visual tools such as mind mapping let you capture and present your thinking in a clear way that allows for immediate course correction.

The tools and methods we will teach you are free or very low-cost and can be learned quickly. During the workshop, you will be an active participant which will give you a rapid understanding of how these methods work and how you can apply them on your projects.

You will learn about eliciting client goals, prioritizing conflicting requirements and capturing the results in ways that can be easily understood. We will show you the use of visual tools for taxonomy and navigation design, capturing decision making in very complex (some say 'wicked') scenarios and short-circuiting the endless rounds of meetings and document revisions that typically happen on projects.

We will also show you other tactile/visual tools that are fast to implement and easy to learn for tasks such as wire framing and SharePoint taxonomy design.

In order to be successful on your SharePoint projects, you need to achieve shared commitment via shared understanding. During this workshop, you will learn how to get there.

Welcome to Microsoft Azure: A Hands-on Workshop for Developers

Brian Randell

PRECONFERENCE Workshop
Monday Nov 10, 09:00 AM - 04:30 PM

Microsoft Azure is a mature, feature rich platform that provides you with a multitude of options for building public, hybrid, and private solutions. Add with the power of Visual Studio 2013 and Visual Studio Online and you have a powerful set of tools to build just about anything.

In this hands-on workshop, learn how to build and deploy an ASP.NET web site to Windows Azure. You'll learn how to use the ALM tools in Visual Studio Online to track what you're creating, manage your code via version control, and use the elastic build service to compile your code and finally deploy it to Microsoft Azure.

Here's a rough breakdown of what we'll cover:

  • Introduction to ASP.NET and Visual Studio 2013 Web Tooling
  • Building Web Applications using the latest ASP.NET technologies
  • API Services for both web and devices
  • Running, improving and maintaining a site in the real world using continuous delivery
  • Monitoring your application to gain insights into how it's running and how your users are using it

In addition to the hands-on portion, there will be lectures and breaks where you'll learn insights on how to architecture you system and take advantage of all the tools and technologies out there. Finally, you'll be prepared to take you bits how and share what you've learned with your team.

So prepare yourself to get hands-on!

You just need to bring a laptop that can run the one of the Microsoft Remote Desktop clients-yes this means you can bring your Mac! We'll provide you with access to a virtual machine in Azure with all the tools you need to work on the hands-on portions of the workshop.

If you're an MSDN Subscribers, you receive up to $150/month in Windows Azure credits and reduced rates. Activate your Windows Azure benefits using before you come.

If you're not an MSDN Subscriber, you need to activate a Microsoft Azure trial subscription at no cost before you show up.

SharePoint 2013 Development JumpStart

Mark Rackley

Rob Windsor

PRECONFERENCE Workshop
Monday Nov 10, 09:00 AM - 04:30 PM

Getting started with SharePoint development can be challenging. SharePoint is built on top of ASP.NET so there are many similarities between ASP.NET and SharePoint development, but there are also many differences. Understanding these differences and how they change the way you build solutions that target the SharePoint platform is one of the keys to becoming an effective SharePoint developer. With this in mind, this full-day pre-conference workshop has two goals: to introduce you to the tools, APIs and practices used during SharePoint development and to highlight the areas where SharePoint and ASP.NET development differ. Specifically, we will cover the SharePoint platform architecture, the SharePoint developer environment, and the SharePoint developer APIs. We&rsquoll also look at how to do development in both managed code and JavaScript, using both Visual Studio and SharePoint Designer.

Modern Websites and Cloud Topologies

Michele Leroux Bustamante

Zoiner Tejada

POSTCONFERENCE Workshop
Friday Nov 14, 09:00 AM - 04:30 PM

Modern websites are built using a combination of tools, platforms and techniques. Whether its providing rich graphics, animation and interaction in an age without Flash, attaining bi-directional communication between client and server with Web Sockets, WebRTC or SignalR, building a responsive website that intelligently adjusts itself to best fit your user's device or building a website with all the storage, threading and offline use features that were previously only done with desktop apps. Modern websites are typically implemented with a development stack such as MEAN (MongoDB, Express, Angular, Node.js) LAMP (Linux, Apache, MySQL, PHP) ASP.NET, MVC, Web API, SQL, or Ruby, Apache, MySQL. In this workshop we'll provide you with a hearty taste of these architectures and compare approaches across them for developer productivity in web frameworks (Angular, MVC, Knockout, Bootstrap, Foundation) and implementing the data layer using different approaches among NoSQL (MongoDB/document, Neo4/graph, Redis/key-value, Cassandra/columnar, SPARQL & RDF/triple stores) and relational (SQL Database, SQL Server, MySQL). Things like developer productivity, and how the popular development stacks are employed to deliver cloud-enabled solutions. We'll also discuss deploying these solutions to public cloud providers such as Google, Amazon and Microsoft Azure. At the end of this workshop you will have a broad understanding of the modern website development landscape, from back end cloud infrastructure up to your web presentation layer.

Metaprogramming with Roslyn

Kathleen Dollard

POSTCONFERENCE Workshop
Friday Nov 14, 09:00 AM - 04:30 PM

Metaprogramming is the arching principle for techniques where code does more than the strict interpretation of the computer language. It encompasses strategies as diverse as code generation, Aspect Oriented Programming (AOP), Domain Specific Languages (DSL), and runtime code creation. The new .NET Compiler as a Service (Roslyn) opens up the opportunities in metaprogramming by making it practical to explore and create syntactic and semantic trees. This day starts with metaprogramming principles and an overview of techniques. The afternoon dives deep into a single easily accomplished approach to metaprogramming - code generation. You'll learn how to think about your code as a set of patterns, unique input to those patterns and handcrafted customizations. You'll learn more about working with the complexities of the Roslyn trees and creating custom built interfaces to simplify access to the information, for a specific purpose. You'll leave able to create strongly typed code-first style input to your own templates and provide rich customization points that maintain application integrity. Use these techniques to remove the boring, stupid parts of application development.

Data-Centric Single Page Applications with Angular, Breeze, and Web API

Brian Noyes

POSTCONFERENCE Workshop
Friday Nov 14, 09:00 AM - 04:30 PM

You need to build an HTML client app either as a browser app or to package as a hybrid mobile app, and there is a lot of data presentation and manipulation involved. You may be fully embracing the Single Page Application (SPA) architecture, or you may just have some highly interactive and data-centric pages you need to implement. You want to make sure you end up with good, clean, maintainable, testable, and easy to implement client and server side code.
This workshop will take you end-to-end, showing you how to put together a rich data driven HTML client interface using Angular to separate the UI data manipulation, separate the markup and logic, and navigate between views. You'll see how to use Breeze to do the heavy lifting on making the service calls for you, tracking changes on the entities, sending changes to the server side in batches, and more. Then you'll also see how to set up the server side using ASP.NET Web API to expose the services consumed by your client. By the end of the day, you will know how to build out the vertical slices of your app from top to bottom.
You will learn:
  • How to do data binding in HTML client side applications with AngularJS
  • How to structure views, view models, and navigation with Angular
  • How to simplify AJAX data access via services with Breeze

From Zero to XAML

Billy Hollis

POSTCONFERENCE Workshop
Friday Nov 14, 09:00 AM - 04:30 PM

Microsoft has re-emphasized XAML. It provides the most powerful UI stack for both for today's desktop development, and tomorrow's mobile/Windows 8 applications. Need to bootstrap yourself into an understanding of XAML basic concepts? This is the workshop you need. Layout and markup, content and composition, templating, styling, and the powerful data binding system are all covered. This workshop is suitable for those with no XAML exposure up through those who have used it but have not yet written a production application.

Queries Gone Wild 2: Statistics and Cardinality in Versions 2008, 2008R2, 2012, and 2014

Kimberly L. Tripp

Joe Sack

POSTCONFERENCE Workshop
Friday Nov 14, 09:00 AM - 04:30 PM


Level = 200-400

Have you ever wondered why SQL Server did what it did to process your query? Have you wondered if it could have done better? And, if so, how? Transact-SQL was designed to be a declarative language that details what data you need, but without any information about how SQL Server should go about getting it. Join order, predicate analysis &ndash how does SQL Server decide the order or when to evaluate a predicate? Most of the time SQL Server gets the data quickly but sometimes what SQL Server does just doesn't seem to make sense. Inevitably you'll encounter certain workloads and queries that just aren't performing as well as you expect. There are numerous reasons why query performance can suffer and in this full-day workshop, Kimberly and Joe will cover a number of critical areas while showing you how to analyze a variety of query plans throughout the day.

But, it's not just about analysis &ndash it's really about solving your query performance problems. Each problem has a different way of handling it and you'll walk away with a plethora of strategies to troubleshoot and tackle even the most gnarly of query problems. When data distribution is heavily skewed, cardinality estimation (how many rows the Query Optimizer expects each operator to process) can be wildly incorrect resulting in poor quality query plans and degraded performance. You've probably seen the advice to just rebuild indexes or update all statistics if a query plan looks wrong - but is that the right advice? In many cases, NO! These are ''sledgehammer'' approaches that only solve the immediate problem. In this full-day workshop, you'll learn much more finessed ways to solve query plan quality problems.

Topics covered include understanding statistics, dealing with heavily skewed data, dealing with distribution problems, troubleshooting common and advanced scenarios, and a full overview of the changes made to the cardinality estimator in SQL Server 2014.

Topics covered:
  • Statistics
  • Data distribution
    • Evenly distributed data (yeah, right)
    • Problems with uneven distribution
    • Analyzing data skew
    • Filtered Statistics (FS)
    • Automating the creations of FS
  • Predicates and selectivity
  • Model assumptions
  • Validating assumptions
  • ''Classic'' cardinality estimate troubleshooting methods
  • Cardinality changes in 2014
    • Increased correlation assumptions for multiple predicates
    • Modified ascending key and out-of-range value estimation
    • Join estimate changes
    • Join containment assumption changes
    • Distinct value count estimation changes
    • Advanced diagnostic output
    • Troubleshooting the new cardinality estimator

What's in SharePoint 2013 and Office 365 for No-Code Developers and Power Users?

Asif Rehmani

POSTCONFERENCE Workshop
Friday Nov 14, 09:00 AM - 04:30 PM

SharePoint 2013 (and it's related components in Office 365) brings with it a bold new look compared to the earlier versions. In addition to the superficial changes, much more has changed under the covers. What's in it for power users and no-code developers? Come to this session and we'll show you!

We'll start by looking at the graphical changes (both pros and cons) and then dive into the various no-code tools and technologies such as SharePoint Designer, InfoPath, Access, search-based Web Parts and more. You will discover the power of automating business processes using these tools that will make your life much easier compared to the ''harder ways'' of doing things in SharePoint.

SharePoint 2013 and Office 365 Admin MasterClass

Chris McNulty

POSTCONFERENCE Workshop
Friday Nov 14, 09:00 AM - 04:30 PM

Building on the concepts explored throughout the week, this masterclass will explore advanced SharePoint and Office 365 administration for the IT pro. This class will assume a basic working understanding of SharePoint 2013 migration administration site customization and security. This full-day workshop will give experienced IT professionals the guidance to lead and support SharePoint implementations that go beyond document storage to deliver powerful business services. Key topics will include:

  • Installation and service migration
  • Active management, administration and reporting using native tools and PowerShell
  • SQL administration for the irregular DBA
  • Advanced engineering for next generation workloads
  • Search
  • Business intelligence
  • Office Web Apps
  • Enterprise content management, navigation and routing
  • Engineering for custom applications
  • Azure deployments
  • Hybrid identity integration
  • Troubleshooting and optimization
  • Stress testing
  • Service Pack 1

JavaScript Everywhere - Learn to Build a Cross-platform JavaScript Application that Works EVERYWHERE

Jeff Fritz

POSTCONFERENCE Workshop
Friday Nov 14, 09:00 AM - 04:30 PM

JavaScript has quickly become the language to write code in that you want to be able to share between services on the web, in Windows, and on mobile devices. Join Jeff as he walks you through constructing a JavaScript application and development techniques allow you to migrate from ASP.NET and the web to Windows 8, Windows Phone, iOS, and Android. You'll see how to quickly JavaScript can be used cross-platform, and you'll learn how to take your SOLID development practices to another level by targeting every platform with your next application.

Developer's Guide to Tuning Somebody Else's SQL Server

Jeremiah Peschka

Kendra Little

Brent Ozar

POSTCONFERENCE Workshop
Friday Nov 14, 09:00 AM - 04:30 PM


Level = 200-300

Your company sells software that relies on SQL Server, and your customers want help with performance and reliability. You have some developers on staff, plus a handful of help desk support folks, but none of them are DBAs, and none have had SQL Server training. Your customers call up complaining about slow queries, and you're tired of the calls being escalated to you.

In this one-day workshop, you'll learn:
  • How to identify the SQL Server's real bottleneck
  • How to prove that it's not your code, or
  • If it is your code, how to fix it quickly with indexes
  • How to communicate it in a way customers will love
  • What hardware and HA/DR solutions to recommend to your clients
  • How to know if your customers will be happy with virtualization
You'll even get a First Responder Kit for your help desk team and developers to quickly triage the customer's performance issue and get them back on track.

Topics covered:
  • Learn how to safely query dynamic management views
  • Understand how to triage blocking and slow queries
  • Learn how to build good-enough indexes for most use cases
  • Adapt a starter ''ISV best practices'' guide for your own customers
  • Discover the inherent limits of virtualization and shared storage

Getting Started with Xamarin Forms (HANDS-ON, BRING YOUR OWN LAPTOP)

Carl Franklin

POSTCONFERENCE Workshop
Friday Nov 14, 09:00 AM - 04:30 PM

Xamarin Forms, Xamarin's solution for creating native iOS and Android apps completely in Visual Studio, is compelling. Getting started, however, can be daunting. There are many moving parts that all have to fall into place before you can write Hello World. This workshop will get you off to a good start.

In this post-conference workshop, we will walk through the setup process together, and write our first real cross-platform native app using Xamarin Forms all in C# and XAML, and using only Visual Studio.

The workshop has two parts. The first half of the day will be devoted to setup. Bring your Mac Mini. Bring your phones. Bring your laptop. We will get your development environment set up correctly and register as SDK developers with Apple, Google, and Microsoft.

After lunch, we'll dive into Xamarin Forms. We'll build a real app that runs on iOS, Android and Windows Phone devices. We'll write platform-specific code for each app, and return real-time sensor data to the UI. We'll look at how Apple and Google handle their respective app stores and how to deploy to them.

After taking this one-day workshop, you will be ready to develop native apps for the iPhone, iPad, Android phones, and Windows Phones 100% in Visual Studio with C# and XAML.

Requirements:

  • You must bring a laptop running Windows 8/8.1 running Visual Studio 2013 Professional or higher. It must have working WiFi. Please don't bring a slow or otherwise crippled machine. We want this workshop to go smoothly for everyone.
  • Bring an Android phone or device. If you have one, using a real phone will make Android apps go so much faster. The emulator is dog slow.

Optional Hardware:

If you want to bring a mac mini, please do. But if you do, there are a few extra steps that you must take before you're ready to attend the workshop. Read my blog post at http://tinyurl.com/MacMiniPrep for detailed instructions.
Sponsor or Exhibit

Register

Register by November 2, 2014 for a "show package" and receive a $200 gift card.

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.

Register by September 8 and save. If you register for a "show package" get a choice of a $200 gift card. A show package is 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