Big Mountain Data & SQL Saturday Sessions


Data Technologies for Developers

Big Data Introduction
  25  

"Learn the Lingo" of Data Warehousing. Big Data employees are typically paid 20-30% more than their peers. Explore the technical realities and challenges within Big Data. We will discuss Data Warehouses, Star Schemas, Data Repository Architecture, Slowly Changing Data and several common terms utilized in Big Data discussions to have you speaking intelligently about Big Data.

Level 100 - Introduction
Duration: Hour
Presenter: John Weeks


NoSQL Introduction
  19  

Understand what NoSQL is and what it is not. Why would you want to use NoSQL within your project and which NoSQL database would you utilize. Explore the relationships between NoSQL and RDBMS. Understand how to select between an RDBMs (MySQL and PostgreSQL), Document Database(MongoDB), Key-Value Store, Graph Database, and Columnar databases or combinations of the above.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: John Weeks


Hive - Interactive Querying on Hadoop
  13  

Hive sounds strange and exotic, but what is it? As a SQL Server DBA you'll find Hive to be quite familiar and easy to learn. Why? Because it was developed for you. If you are a SQL developer and you have to manage data in Hadoop, Hive is your first tools of choice. This session will demystify Hive with clear examples and demos. We'll also dig into some exciting new upcoming features that makes Hive an even more compelling choice for Hadoop analytics.

Level 300 - (Intermediate): Basic knowledge of subject matter is suggested
Duration: Hour
Presenter: Scott Shaw


Build Reactive Applications with Akka
  9  

Akka is a toolkit and runtime for building highly concurrent, distributed, and fault tolerant event-driven applications on the JVM.

Level 100 - Introduction
Duration: Hour
Presenter: Garrett Smith


Handling database evolution with Liquibase
  9  

We always keep versions of our code in a source control system, but how about the database? How can we reduce the pain of updating the database model when working on a team, or even knowing when do we need to update it? What can we do if we want to rollback to a previous version of the database? Liquibase is a pretty awesome library that will help you update, maintain and control your database model, as any other asset in your project.

Level 100 - Introduction
Duration: Hour
Presenter: Andres Arias


How to get up and running in the "cloud" in less than 20 minutes
  9  

This session will cover how to be up and running in the "cloud" (OpenShift) in less than 20 minutes. I will show how easy it is to create nodes, set up continuous integration and scale all in few minutes using OpenShift.

Level 100 - Introduction
Duration: Half Hour
Presenter: Abhishek Andhavarapu


Deep Dive Into Pig and Lipstick
  7  

Starting from where we left off with the UHUG meeting we'll be taking the Lipstick tool and using it to dive into some real world problem solving in such areas a joins, udfs, large scripts, and difficult data. Pig can be complex and you may find yourself fighting yourself, the query optimizer, or your data and knowing which problem to tackle will enable you to write more performant code quickly. We'll also discuss how this tool can be utilized for other members of the team including QA and production staff.

Level 300 - (Intermediate): Basic knowledge of subject matter is suggested
Duration: Hour
Presenter: Matt Davies


Cloud-based machine learning journey with AzureML
  6  

Enjoy seeing an end-to-end demo, from getting data, developing a predictive model and experiment, to visualizing. Background: AzureML Public Preview (previously called Project Passau) is a collaborative visual development environment that enables you to build, test, and deploy predictive and social analytics solutions that operate on your data. The service and development environment is cloud-based, provides compute resource and memory flexibility, and offers zero-setup and installation woes because you work through your web browser.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Norman Warren


Building a Data Refinery
  5  

Today's innovative organizations are looking to bring together massive quantities of highly diverse data to unlock hidden business opportunities, and provide additional intelligence to business analysts. These organizations are implementing a streamlined data refinery by combining Hadoop as a scalable processing hub along with an analytic database, such as HP Vertica, for truly high performance analytics at scale. Join this conversation Chuck Yarbrough from Pentaho to discuss the merits and advantages of a big data refinery, and learn for yourself if this emerging architecture is right for your organization: In the session you will learn: How this emerging architecture enables the faster engineering of data sets, rapid analytic insight, and scalable cost savings Real-life examples of how organizations are realizing major benefits by creating streamlined data refineries

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Chuck Yarbrough


Data Warehouse Production deploys with Liquibase
  5  

Data Warehouse Production deployments are real challenge for the IT teams and companies as they are long, inconsistent and frequently unpredictable. A lot of times they are also associated with downtime for the end customers. Liquibase is an open source database-independent library for tracking, managing and applying database schema changes that is widely used on OLTP production deploys, but could also be leveraged in Data Warehouse deployment automation. This session explores the use of this tool for EDW production deploys with examples and use cases.

Level 100 - Introduction
Duration: Half Hour
Presenter: Bobbi Alexandrova


Integrating SQL Server With Hadoop
  3  

In this session we'll show a case study of how simple it is to integrate SQL Server and hadoop and how Allegiance Accomplished this. We will also talk about the pitfalls we have seen with our Elastic Search and hadoop platform since going live. Leaving this session you will have a real use architecture that you can take back and use in your own company

Level 100 - Introduction
Duration: Hour
Presenter: Pat Wright


Ask the Experts
  0  

Ask the Experts room will be open to anyone that would like to discuss with experts architecture/development practices. Come with your problems to be solved and this will be your best chance to get answers from experts in the field.

Level 100 - Introduction
Duration: Hour
Presenter: Pat Wright


TBA
  0  

TBA Placeholder

Level 100 - Introduction
Duration: Hour
Presenter: Pat Wright



Machine Learning

Deep Learning
  20  

Google spent over $400million for a deep learning talent acquisition: http://www.technologyreview.com/news/524026/is-google-cornering-the-market-on-deep-learning/ Learn how to get starting using deep learning for prediction. Examples that will be shown will be text prediction and digit recognition. Ben Taylor is HireVue's principal data scientist who has spent the last year working on digital interview prediction.

Level 300 - (Intermediate): Basic knowledge of subject matter is suggested
Duration: Hour
Presenter: Ben Taylor


Unstructured Data & Deep Learning
  12  

Many companies are trying to still figure out just how sophisticated they need to be about their data. While companies like Narrative Science ($29M raised), InsideSales.com ($143M raised), and many others aim to bring advanced analytics as a service deeply integrated into their products. Together we'll take a look at the cost/benefit of going from a simple classifier to a more complex deep learning approach to keyword relevance in a simple proof of concept around predicting and optimizing responses in email and tweets.

Level 300 - (Intermediate): Basic knowledge of subject matter is suggested
Duration: Hour
Presenter: David Gonzalez


Apache Spark
  11  

I would like to introduce Apache Spark. This session would cover the pros and cons over Hadoop and go over a hands on example of ETL and running analytics on spark from the Spark Shell.(I would provide a VM for the hands on example)

Volunteers: Anant Asthana
Want to volunteer? I Can Present This!


MLib
  6  

Running Machine learning models in APache Spark Using MLib. This session would briefly touch on the Machine learning models that are available on spark and the go on to 1- 2 hands on examples. Example 1 would cover Building a recommendation engine Example 2 would go over Anomaly detection.

Volunteers: Anant Asthana
Want to volunteer? I Can Present This!


Classification, the guts and the glory
  6  

Starts with the basic 2-class linear classifier, discussing the geometry and other principles involved, and builds on that knowledge to quickly move into multiclass classifiers in high-dimensional space. Discussion includes decision trees, PCA (Principle Component Analysis), LDA & QDA (Linear & Quadratic Discriminant Analysis), transforms, and dimensionality reduction. A basic understanding of linear regression and least-squares fitting is assumed.

Volunteers: David Owen
Want to volunteer? I Can Present This!



Data Analytics

Three Classic Mistakes of Data Analysis
  19  

Most folks get started analyzing data and drawing inferences the moment they have some data available. Statistical tools can be very valuable in providing new information and insight, however, any one of these three mistakes can completely mislead teams, leading them astray, and drawing the wrong conclusions. So - what are the three mistakes and how do they help? That will be discussed in this session with a limited amount of interactivity.

Level 300 - (Intermediate): Basic knowledge of subject matter is suggested
Duration: Half Hour
Presenter: Rai Chowdhary


Resume modeling
  17  

This session will cover the full flow for doing resume prediction from candidates to scoring resumes algorithmically. This talk should help inspire individuals who are looking at doing text prediction from unstructured formats. Also, it should inspire general unstructured prediction interests. Ben is HireVue's principal data scientist and has been responsible for much of the machine learning behind digital interview prediction.

Level 300 - (Intermediate): Basic knowledge of subject matter is suggested
Duration: Hour
Presenter: Ben Taylor



Professional Development

Data Driven Culture for Business Users
  14  

In big data companies, business intelligence problems are tackled by three major groups: Data scientists, analytics, and business analysts. With big data technology developing at a rapid pace, data scientists and data analytics experts are being asked to focus on more and more on predictive and machine learning business questions. Meanwhile, business analysts, who often rely on data analytics support, are left without adequate support to solve the business problems that will impact their bottom line. Sara and Raquel will present a case study of how eBay’s “Shared Purpose” has fostered a culture of professional learning opportunities for business analysts to grow foundational technology skills. As business analysts become increasingly more versant on data discovery technologies, and even basic SQL, we can bridge the gap between the business side and the analytic side -- driving increased business productivity overall.

Volunteers: Sara Jones
Want to volunteer? I Can Present This!


Building the Big Data Community in Utah
  13  

What are the strategic and tactical steps that have been taken to grow the Big Data Community in Utah? What will be the path going forward and how do we alter the trajectory we're on to reach seemingly unachievable levels of success and become the premier Big Data Hub for the country and the world? Overview, thought discussion, and open conversation about the next steps to community stardom!

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Nick Baguley


Dynamics of Mob Programming
  5  

Taking Agile development to the next level. What it means for Developers, Project Managers, and Business Analysts. What value it adds to the Client.

Level 200 - (Beginner): Introductory / fast moving
Duration: Half Hour
Presenter: Pamela Bradford


Intrepreneurism and the Giant Hairball
  3  

How to escape the gravitational pull of corporate status quo, by employing an innovative approach to R & D using a combination of Entrepreneurial Project Management, tertiary level analysis, and mob programming.

Level 200 - (Beginner): Introductory / fast moving
Duration: Half Hour
Presenter: Pamela Bradford


Using SQL For a Legacy Data Migration
  1  

SQL was the platform for staging legacy stat for migration into a new business system. It was used for data translation, cleansing, integrity validations and consistency validation. Business Process Analysts were able to quickly evaluate the data for migration readiness as well as migration metrics.

Level 100 - Introduction
Duration: Half Hour
Presenter: Altair Kaminski



Architecture

Data Modeling on NoSQL
  19  

NoSQL is being pulled closer and closer to the core of applications, not just as a reporting and data mining tool. More and more applications are leveraging the power of NoSQL as a primary means of data storage. This session will cover how to successfully model application data on NoSQL storage engines for everyday application use. We'll explore common design patterns, techniques and tips that help developers leverage the horizontal scalability of NoSQL stores while embracing their inherent limitations.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Bryce Cottam


Real time analytics using Hadoop and Elasticsearch
  15  

This session will cover how to use a batch processing engine (Hadoop) and speed layer (elasticsearch) for near real time analytics. Our master record store is SQL Server. We use Hadoop to perform all the heavy computations, etl process etc. And elasticsearch as the speed layer to which the reporting API’s hit. This session will also cover on how to import data into Hadoop, perform the necessary computation and export the data to an external data source.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Abhishek Andhavarapu


Hadoop and the Data Warehouse
  12  

Many of us are used to traditional data warehouse design architectures. This includes ETL, data staging, data cleansing, and dimensional design. How does Hadoop change all of this and where does it fit in? Is Hadoop meant to replace the data warehouse or integrate with the data warehouse? This session will cover key design patterns based on real-world use cases to show where Hadoop fits into your existing data warehouse infrastructure.

Level 300 - (Intermediate): Basic knowledge of subject matter is suggested
Duration: Hour
Presenter: Scott Shaw


Battle of the Big Data Bands
  8  

From a technical architecture point of view, big data has so many choices and yet so little time to try them out. We've put them to the test to see how they stack up against each other. See how the following perform head-to-head: Amazon Redshift > SQL Server Tabular > On-premise MPP (Actian Matrix for this demo) > Google Big Query > Hadoop/Hive.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Peter Nettesheim


Intro to Dimensional Modeling
  8  

Most BI tools require a dimensional model but how do you go about designing that kind of model? What's a star schema, fact or dimension table? In this session we will start with the basics of dimensional modeling including a retail dimensional model example. Then we will take a look at building the model in Oracle SQL Developer Data Modeler. This free tool from Oracle has basically all of the same features as licensed data modeling tools. By the end of this session, you should be comfortable building a simple dimensional model in Oracle SQL Developer Data Modeler.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Michelle Kolbe


Bigger Busses and More Complexity: Simplicity with Apache Kafka
  5  

We'll take a look at Apache Kafka and how it potentially is a fit for enterprises. We'll talk about a few of the canonical examples with associated experiences as well as some novel configurations. Whether it is messaging, log aggregation, stream processing, or something beneficial in your use case, at the end you'll be able to intelligently decide whether or not this technology has a place in your architecture.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Matt Davies


Sustained Growth: From Seed to Tree Lessons Learned
  4  

The hype around "Big Data" often equates to a feeling of urgency which causes half-baked ideas spawning projects, consuming resources, and resulting in questionable results. Just because "Big Data" solutions are mainly open source does not imply there are risks involved which must be mitigated. These may include costs, freshness of the tools, finding development resources, adjustments to development processes, and management approvals. Many enterprises find themselves not knowing where to start or down the process of tackling too much. We'll talk about some strategies which should help an organization mitigate these risks and how to take the seedling idea to mature product (and onto the forest) in a sustained growth-centric model. If you are in architecture, development, production support, or , especially, management, you'll want to attend.

Level 300 - (Intermediate): Basic knowledge of subject matter is suggested
Duration: Hour
Presenter: Matt Davies



Business of Data

Be a Data Hero and Drive Business Results
  13  

Companies need data to help them determine what's working, what isn't working, and where they need to be spending their money (or not). A lot of companies today are starting to understand that data is a key component (although not the only component) for delivering successful products. However, there are still gaps between the data that business executives think is relevant, the data that is actually relevant, and the decisions that are made based on interpretation of the data. In this session we will talk about how you can be the voice of reason, and how you can potentially redirect company strategy based on key metrics and user behavioral data. Ultimately, you could drive business success by taking a leadership role in data delivery, analysis, and communication.

Level 100 - Introduction
Duration: Hour
Presenter: Hala Saleh


Big Data Market Overview
  12  

This session will give you an insider look into what is driving the Big Data market. I'll relay lessons learned from talking with C-level executives from some of the largest corporations in the midwest as well as talking with guys in the trenches from companies like LinkedIn, Facebook, and Twitter. Everything is changing and this session will help you ride the tide and understand where things are going.

Level 100 - Introduction
Duration: Hour
Presenter: Scott Shaw


Understanding Your Processes Through Operational Intelligence
  10  

Business processes can get large and complex. So much so, that no one can understand each piece of the puzzle that makes the entire process work. This talk will be on how we put into place ways to capture the events of the processes so that we can more effectively understand and troubleshoot the system. This also allows us to perform further analysis (drilling down into details of the process, time patterns to see trends in how long a certain action takes, root cause analysis, and processing load analysis). This can also help people understand the many steps that can go into a business process.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Scott Heffron , Scott Heffron


Taking the "So What" Out of Hadoop
  9  

Hadoop and other "Big Data" technologies are gaining more traction within enterprises as time progresses but often these very enterprises find upper management asking tough questions like: "How did the project increase my bottom line?" "How did the project save me money?" "How will this project add to my business capabilities?" "We have it now, so what?!" During this session we'll discuss how these tools should be viewed as a means to an end rather than more more box to check off in the shiny technologies list. We'll discuss some interesting outcomes and how to really justify this new capability with stakeholders so all may look back and change the "so what" questions to "what's next?"

Level 300 - (Intermediate): Basic knowledge of subject matter is suggested
Duration: Hour
Presenter: Matt Davies


Do I Have a "Big Data" Problem?
  9  

A discussion about what exactly qualifies as a "Big Data" problem? Am I getting caught up in the hype? Am I throwing good after bad? Is this some shiny new trinket I can play with or do I actually _need_ the capabilities of Big Data tools? There is no clear cut answer as to what qualifies for a "Big Data" problem, but we'll talk about how to identify certain characteristics which lean to, and lean away from using Big Data. We'll take some of your use cases and discuss how these tools may help, or if some other tool would be better.

Level 100 - Introduction
Duration: Half Hour
Presenter: Matt Davies


It Takes Three Brains to Analyze Data
  8  

It is quite important to understand how the brain functions and what impact does that have when it comes to using data to make decisions. The world is replete with examples of bad decisions being made despite the data suggesting otherwise. Participants will gain insight into why we make decision mistakes despite the availability of factual data.

Level 100 - Introduction
Duration: Half Hour
Presenter: Rai Chowdhary


Getting Action out of your data
  0  

Having lots of data and even segmenting your data for understanding and knowledge is great, but how do I take it to the next level. This course will cover what it means to not only group, but identify what it actually means to automate and achieve outcomes and results from the data you gather. Attending this course will help explain how to achieve greater actions from your data internally and externally

Level 100 - Introduction
Duration: Hour
Presenter: Andy Bird



Data Visualization / Story Telling

Get Value from your investment in Big Data; an deep dive into analytic & visualization tools (Microsoft PowerBI, Tableau, D3)
  15  

Get a very fast demo of visualization tools used to do one of three things: 1. Change a process or behavior 2. Change a product 3. Move a metric And find out when and why you want to use these tools: -Tableau -Microsoft PowerBI (Power View, PowerPivot) -D3

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Norman Warren


The Why of Reporting
  9  

As BI developers and SQL developers, we are consistently asked to generate reports with lots of data. But why? How are these reports used? What questions can we ask to generate more useful reports? What types of data can help your reports be more than a "data dump"? Discussion of the "why" of reporting and what tools we can use to help decision makers use our reports to effect change.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Matt Horton


Hunting for ELK
  5  

ELK stands for ElasticSearch, Logstash, and Kibana. These three technologies work together to allow quick access to much of the ElasticSearch goodness. Logstash provides an easy input capability for many kinds of streaming and static data. Kibana provides a quick UI to view the data in ElasticSearch that is both beautiful and configurable. Together, we'll bring up a working stack and explore some of the code used to power utahairquality.life. Alan Zhau will be co-presenting.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Craig Brown



SQL Saturday Sessions

SQL Query Tuning
  18  

Explore proven methods to rapidly identify and fix inefficient SQL. This course will include but is not limited to the following: 1. Sight recognition of inefficient or troublesome SQL. 2. Understanding how to use STATISTICS IO and TIME. 3. Basic understanding of an execution plan to evaluate indexes and sheer amount of data at each stage.

Level 100 - Introduction
Duration: Hour
Presenter: Willis Godwin


The Lost Science of Set Theory
  12  

Many database developers today do not have a Computer Science degree and may also have begun their career developing software using procedural programming languages (Java, C#, etc.). As a result, they may not have the background needed to conceptualize solutions in terms of sets of data and therefore may not be able to develop efficient set-based queries. In this session, we will review the basics of set theory and how it applies to database development to enable you to turn cursors, loops, and other procedural programming practices into efficient set-based operations that make the most use of a relational database engine.

Level 100 - Introduction
Duration: Hour
Presenter: Aaron Cutshall


Adding Hadoop to your Data Tool Kit
  12  

This session will show you how to you Sqoop and Hadoop to offload your resource intensive data data transformations to Hadoop and the results back to your SQL Server quickly and easily.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Montrial Harrell


Reporting Services for Mere DBAs
  10  

As a DBA in the modern era, you may be required from time to time to do something outside of your comfort zone. One of these things may be to become quickly acquainted with SSRS. Even better is that you may be required to do things you have not considered in a standard report. In this session, you will learn how to implement a framework to help provide a common ground for your reports. This session will delve into fun topics such as dynamic grouping and dynamic sorting. We are not talking about the interactive sorting that your accountant may use. Attendees will also be introduced to a few quick methods of exporting Reports from the report server - this is from a DBA perspective after-all!

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Jason Brimhall


Make SQL Server Management Studio Bark Like a Dog
  9  

You touch SQL Server Management Studio almost every day. Do you use it to its fullest or are you wasting time? This session will cover 15 aspects of SSMS that will make you more efficient as a professional. You will learn how to customize your toolbars, leverage templates, and work with multiple environments. You will be introduced to drag/drop shortcuts, secret hotkey combinations, and copy/paste behaviors most users do not know about. You will leave with a full understanding of the debugger, breakpoints, data tips, and setting up RPC to debug remotely. Finally, for those looking for the ultimate in flexibility you will learn how to build your own ad-ins from scratch. This session is for SQL Server professionals across BI, development

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Russ Thomas


Fun with Availability Groups
  9  

Follow along as we adventure through the vastness that is Availability Groups in SQL Server. In this beginners guys we show you how to make an Availability Group from scratch, the new system tables that go along with Availability Groups, and how to troubleshoot your Availability Group using the system tables and SSMS.

Level 100 - Introduction
Duration: Hour
Presenter: Christopher Wolff


I’m New, Select Me!
  9  

I have been new to something at some point in my life, new town, new job or new profession. Now, I am the new DBA! Feeling overwhelmed, not sure where to begin. I know I have data and maybe lots of it. I need a friend and mentor to help me discover my new role. Select wants to be my friend, in fact Select and I need to become best friends. For Select and I to become best friends, we need to learn about each other, our weaknesses and our strengths. Come along, Select wants to introduce you to all of Selects friends. Let’s meet Where, Join, Group By and more of Select friends. Come along, let’s discover Select and his friends.

Level 100 - Introduction
Duration: Hour
Presenter: Tom Norman


TSQL Best Practices for SQL Engine Kindness
  9  

This session will take a look at things that you should regularly know and use when coding TSQL. How can you be really friendly to SQL? The items covered will show you things that will help ensure that your code is readable, efficient and maintainable. We will look at query semantics, datatypes, things to avoid as well as how to be super friendly to the SQL Engine and allow things to work well.

Level 100 - Introduction
Duration: Hour
Presenter: Ben Miller


PoShDBA: Practical PowerShell for the DBA
  9  

This session will cover real world functions that are used for real DBA work. There will be a few slides but mostly demos with actual scripts to help you do your job. I will also introduce some SQLPSX to assist as well. Things like Reading/Changing the following: Permissions, DB Owner maintenance and database space management. We all could use a few standard things in our DBA world of ever changing roles and "I have to have it now" stuff, that Management Studio can get in the way of getting it done faster. Join me for a fun PowerShell hour.

Level 100 - Introduction
Duration: Hour
Presenter: Ben Miller


Windowing Functions in SQL Server 2012
  9  

SQL Server 2012 brings with it nearly full ANSI compliance with the windowing functions. Come to this code filled session to learn about all of the windowing functions in SQL Server 2012: Ranking functions, changes for windowing in the Aggregate functions and the new Analytic functions. We’ll examine how this latest implementation of the windowing functions allows us to perform running and sliding aggregations; retrieve data from adjacent rows in the partition, and much more – all without self-joins back to the source table.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Wayne Sheffield


Understanding Transaction Isolation Levels
  7  

SQL Server offers several isolation levels beyond the default "READ COMMITTED". But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Randy Knight


Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues
  7  

Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Janis Griffin


To The Cloud, Infinity, & Beyond: Top 10 Lessons Learned at MSIT
  7  

Session Summary: Microsoft IT's Cloud strategy involves migrating hundreds of applications to Azure. The scale on which it is being done may be unprecedented. Lessons Learned are numerous. This session exposes the most important—& painful—ones. Session Abstract: As part of the team leading the migration effort from Microsoft IT's on-prem servers to The Cloud, I've collected a number of best practices that can save your organization weeks or months of effort & untold dollars in development & implementation costs. Those who think the only tool required to move SQL instances from the datacenter to IaaS VMs is a forklift have a hard lesson to learn. In fact, it's much, much more challenging than that. This session will introduce the Top 10 Lessons Learned in the MSIT migration effort & provide actionable guidance that customers can begin using immediately.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Jimmy May


Simple things you can do to make the Query Optimizer more efficient!
  7  

On occasion as DBAs we have need to disable the foreign keys and constraints on one or more tables. Guess what, SQL Server no longer trusts those constraints when you re-enable them. What does that mean? In this discussion, we’ll talk about what the impact is to your queries when you have non-trusted constraints, how to find the non-trusted constraints, and how to soothe SQL Servers mistrusting heart so that it will trust your constraints again! How about your foreign keys? Are you using implicit conversions? Are your stats 'stale'? All of these things effect how the query optimizer works and can negatively affect you query performance.

Level 100 - Introduction
Duration: Hour
Presenter: Malcolm Tutor


Understanding SQL Server XML Features
  6  

The XML Functionality embedded into SQL Server 2005 and 2008 is one of its most powerful yet least understood features. This seems to be primarily because DBA's shy away from it and developers prefer to work with XML in their code. In this session we will explore the XML features of SQL Server and how we can bridge these two worlds. Topics covered will include retrieving relational data as XML, storing XML in the database using the XML Datatype, XML indexes, and the XQuery functions included in SQL Server. We will also look at using XML as stored procedure parameters as a way to pass large amounts of complex data between client and server.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Randy Knight


Don't Panic, DBAs! Databases on VMware made easy.
  6  

More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Janis Griffin


Documentation – you know you love it
  6  

We will discuss some of the most important things that you as a Data Professional can document to make your job much easier, ensure information consistency between groups, and better prepare your organizations for raising the bar on your day to day business. Think of this as a sort of Database Library that allows you to finally detail the processes you follow currently to perform repetitive tasks. This Library will also allow you to simply document your systems for your and others knowledge.

Level 100 - Introduction
Duration: Hour
Presenter: tjay belt


Master Data Management - Getting Started with SQL Server MDS
  6  

This session will provide an introduction to Master Data Management (MDM). We explore the basic concepts, types of MDM solution, and the basics for a successful MDM Implementation. With a working definition in hand, we'll discuss strategies for beginning a successful MDM pilot in your organization and look at some of the pitfalls to avoid. We'll wrap the business discussion up with some tips for selecting the right domains to solve and some tips for managing the politics of MDM. After we've set the stage for what, how and why you need MDM, we'll take a brief look at SQL Server MDS through the Excel add-in and talk about the Architecture of MDS

Level 100 - Introduction
Duration: Hour
Presenter: John McAllister


Database Monitoring : Trying To Keep Sane
  6  

Each of our database systems has its complexities, its idiosyncrasies, its touchy points. Digging into each of these, understanding them, baselining them and monitoring them is an essential part of a DBA's job. Doing these simple tasks in such a way that allows you to sleep at night while your systems churn away safely and gracefully is an art that we all attempt to accomplish. We will discuss various ideas, tools, approaches, and solutions to how to monitor different pieces of our systems. Examples, code, tools, will all be shown off and shared so we can all do better.

Level 100 - Introduction
Duration: Hour
Presenter: tjay belt


Understanding the SQL Server Transaction Log
  5  

The SQL Server transaction log is one of the most misunderstood components of the database engine. What makes it grow? How does it get truncated? Should I shrink it? What is a VLF? In this session we will answer these questions and more.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Randy Knight


Locks, Blocks, and Deadlocks Oh My!
  5  

Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Randy Knight


PoShDBA: Look Mom, No TSQL
  5  

PowerShell is here to stay and the DBA can do so much to leverage this technology. There will be a few slides but mostly demos with actual scripts to help you do your job. There are many ways to use PowerShell as a DBA and this session will focus on using PowerShell and SMO and other libraries like SQLPSX to create completely helpful scripts that do not have a TSQL component in the script. This is super powerful and when you couple it with Windows/SQL Server Core edition, you will see why this is killer. You will come away with scripts to configure a brand new server or bring an old one back in line with standards that are documented in the script.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Ben Miller


Table Vars & Temp Tables - What you NEED to Know!
  5  

Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Wayne Sheffield


Top 5 SQL Server 2014 Hybrid Cloud Features
  5  

: Microsoft SQL Server 2014 brings to market new capabilities to simplify cloud adoption and help you unlock new hybrid scenarios. This demo-filled session will highlight these features and show how you can use these features to lower your TCO and help manage your mission-critical applications by leveraging the cloud to provide new disaster recovery and backup solutions. In this session we will look at 5 great hybrid scenarios that are made possible by both great new features as well as enhanced features of SQL Server 2014. We’ll not only look how to use and implement these hybrid features, but also look at look at and discuss scenarios around why you would use these hybrid cloud features to expand your on-premises options without adding complexity. We’ll look at how you can easily move workloads from your datacenter to Windows Azure while still maintaining a complete view of your infrastructure with increased proficiency and reduced cost.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Scott Klein


Increase your SSIS productivity with Biml
  5  

Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign. This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Reeves Smith


Critical Incident Debrief; Verbal Judo for the DBA
  4  

Production DBAs often work in a world of high stress and high stakes. Organizations, teams, and individuals who do not know how to effectively debrief a critical incident are fated for continual career frustration at best, career failure at worst. The attendee will leave with an understanding of the benefits of an "after action", what makes up a proper debrief, templates to use as guides, and the resources to rally your team for future success. The participant will also be able to use these skills in not so critical incidents to build relationships and street cred as a DBA.

Level 500 - (Expert): Advanced and in depth; experience is required
Duration: Hour
Presenter: Russ Thomas


Understanding Your Processes Through Operation Intelligence
  4  

Business processes can get large and complex. So much so, that no one can understand each piece of the puzzle that makes the entire process work. This talk will be on how we put into place ways to capture the events of the processes so that we can more effectively understand and troubleshoot the system. This also allows us to perform further analysis (drilling down into details of the process, time patterns to see trends in how long a certain action takes, root cause analysis, and processing load analysis). This can also help people understand the many steps that can go into a business process.

Level 100 - Introduction
Duration: Hour
Presenter: Scott Heffron


Crazy Things Developers Do
  4  

Throughout my career, I've seen developers do some pretty crazy things to databases (and truth be told, I've done some of these myself!). Come to this session to learn about SQL Injection attacks and how SQL can use Referential Integrity to optimze queries. Trust me... your DBA will love you for making these changes.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Wayne Sheffield


Columnstore Indexes in SQL Server 2014: Flipping the DW /faster Bit
  4  

Columnstore indexes were introduced in SQL Server 2012 & have been wholly re-architected & optimized in SQL Server 2014. Columnstore indexes are optimized for data warehouse workloads & are a hybrid technology leveraging the best of off-disk & in-memory capabilities. Transparent to the app, columnstore has been shown to render queries at subsecond response times which heretofore took many minutes or longer. This presentation includes an overview of SQL Server 2012 & a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites & inside MSIT. The presentation is rich in demos, including leveraging IaaS—Columnstore in The Cloud. Learn whether columnstore can change your users' world & why columnstore may be a compelling reason to upgrade. Learn how columnstore indexes flip the DW faster bit & why columnstore manifests my motto, “Change the world or go home!”

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Jimmy May


Tools in Your Toolbox You’re Not using! Why Not?
  4  

Policy Based Management (PBM) and Central Management Server (CMS) are tools you already have if you have at least one SQL 2008 instance. These powerful but often overlooked tools are simple to use, and together they give you a central point from which to manage all your SQL instances. You can even manage your SQL 2000 and 2005 servers as well. This live demo session will show you how easy it is to use these 'hidden gems' that have been lying about in your SSMS toolbox. Real world solutions for real world problems in just minutes.

Level 100 - Introduction
Duration: Hour
Presenter: Malcolm Tutor


Database Release Management: Tips to help organize it
  4  

The very nature of a database system is to be dynamic; rarely static. The applications that use databases tend to change, requiring changes to occur within our databases. The totality of pieces and parts that comprise this ‘change’ will be combined into a ‘Release’ that will be applied to your systems. Controlling this change is not rocket science, but it is not without its complexities. We will discuss various terms, define processes, share ideas, and suggest tools to assist you in performing this necessary function, while minimizing risk, and impacting your systems in a graceful fashion.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: tjay belt


SQL 2012 Table Compression
  4  

SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.

Level 300 - (Intermediate): Basic knowledge of subject matter is suggested
Duration: Hour
Presenter: Jason Brimhall


SQL 2012 Extended Events
  4  

Extended Events were introduced in SQL Server 2008. With each edition through SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into Extended Events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events.

Level 300 - (Intermediate): Basic knowledge of subject matter is suggested
Duration: Hour
Presenter: Jason Brimhall


Visual Studio
  4  

How to make queries into beautiful reports that will please the boss.

Volunteers: No Volunteers
Want to volunteer? I Can Present This!


XPath - XQuery; I guess if I HAVE to
  3  

I don't know anyone who likes it, but the reality is sooner or later you'll have to use XML in your database career. XML appears in extended events, ring buffer queries, the plan cache and more and more in stored procedures and columns. Attend this session to find out what you need to know to leverage xpath, xquery, and semi-structured data in administering databases.

Level 100 - Introduction
Duration: Hour
Presenter: Russ Thomas


SQL Server Encryption
  3  

What encryption is available in your version of SQL Server? This session will cover how to set up the Encryption Hierarchy and the requirements for the new Backup with Encryption in SQL 2014. We will also cover end to end Transparent Database Encryption (TDE). This session will go over all the steps and caveats that go with this technology. Encryption is here to stay so jump on and let's take it for a ride.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Ben Miller


Migrating SQL Server applications to run on MPP systems (PDW, Netezza, etc.)
  3  

Find out what makes Massively Parallel Processing (MPP) systems different from traditional Relational Database Management System (RDMS) environments and how to prepare your application to run on them. You'll learn about the key players in the MPP DB space, what you gain in such a transformation, what you lose, and how to get the most from the end result.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Aaron Cutshall


Building a Self-Service BI Solution with SQL Server 2012 and SharePoint 2013
  3  

For many seasoned BI developers, the concept of self-service BI conjures up images of rainbows and unicorns. And while there are definite limitations to what can be done, not to mention what should be done, with self-service BI, Microsoft continues to pursue the self-service angle with its BI products. This presentation will focus on bringing together its two of its flagship products, SQL Server 2012, and SharePoint 2013, to build a "guided" self-service BI solution that is both scalable and secure.

Level 100 - Introduction
Duration: Hour
Presenter: Martin Miller


SSIS Logging Reconsidered
  3  

The advent of SQL Server 2012, SQL Server Data Tools and Integration Services Catalogs have significantly improved out of the box logging. Unfortunately, logging best practices have not evolved with the new logging tools. This talk will outline the logging available “out of the box” with SSIS and discuss the implications for “traditional” ETL logging. Logging best practices will vary by business, industry and regulatory environments. We will review examples from the most basic operational logging to the most sophisticated logging required for auditing and regulatory compliance.

Level 300 - (Intermediate): Basic knowledge of subject matter is suggested
Duration: Hour
Presenter: Michael Sexton


The Augean Stables: Data Cleansing in the Modern Enterprise
  3  

Every database professional knows the database design ideal and we have all seen that ideal on numerous occasions - databases in perfect third normal form; constraints and relational integrity rigorously enforced; elegant error handling in every SQL statement; data so clean you can eat off it. Unfortunately we’ve only seen this ideal in textbooks and sample databases designed by vendors. The databases we see in the real world are… less than ideal shall we say. Of course, we use other phrases for what we see but human resources frowns on such terms and this is, after all, a family friendly presentation. Database professionals in Greece circa 600 BCE may have access to the Alpheus and Peneus rivers to cleanse their particular stables but we modern folks need to rely on the tools on our own computers such as SQL and SSIS. Mike will review various techniques and tools for data cleansing that will help you wash away the muck to get to the data gold standard.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Michael Sexton


Database Monitoring : Trying To Keep Sane
  3  

Each of our database systems has its complexities, its idiosyncrasies, its touchy points. Digging into each of these, understanding them, baselining them and monitoring them is an essential part of a DBA's job. Doing these simple tasks in such a way that allows you to sleep at night while your systems churn away safely and gracefully is an art that we all attempt to accomplish. We will discuss various ideas, tools, approaches, and solutions to how to monitor different pieces of our systems. Examples, code, tools, will all be shown off and shared so we can all do better.

Level 100 - Introduction
Duration: Hour
Presenter: tjay belt


Flash storage 101 and what it can do for your databases
  3  

NAND flash storage is becoming the storage of choice on which to run performance-demanding workloads. Moving to flash storage without architectural changes, however, may not result in reaching the desired goal. This session will give an overview of how our technology works, what to look for in the world of flash, and how to modernize your database architecture with this new technology.

Level 100 - Introduction
Duration: Hour
Presenter: Sumeet Bansal


PaaF: Performance as a Feature in an ORM World
  2  

A high performing data tier does not happen by accident. High quality shops understand that performance must be designed as a feature. While SQL Server remains one of the most popular databases in the world, the modern software engineer would rather learn Entity Framework, Dapper, or ORMLite over straight TSQL. Since the TSQL keys have in many cases been handed over to a service tier or ORM, maintaining a high performing database in this environment places significant emphasis on fundamental design. This session will identify the 5 most important factors that every database requires to support "performance as a feature" for anyone working with a server whose TSQL has been abstracted at the code layer.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Russ Thomas


But it worked great in Dev! Perfomance for Devs
  2  

If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production.

Level 100 - Introduction
Duration: Hour
Presenter: Randy Knight


Policy Based Management, Trolls and Watchmakers
  2  

Peanut Butter and Jelly holds two slices of bread together what can hold my Sql Servers together, PBM? Do you like to be constant, have a pattern and be reliable? I have way too much to do, I can’t review every line of code. Help me, please! PBM is your friend, your ally and the gateway to your system. Policy Based Management can be your bridge to your Sql Server. Let PBM be your troll, letting the best pass. But wait, PBM can also be your watchmaker. Policy Based Management, Trolls and Watchmakers, come watch PBM control our systems.

Level 100 - Introduction
Duration: Hour
Presenter: Tom Norman


Converting Unreliable Deployments Into Consistent Releases
  2  

The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or the incorrect version. Each database is made up of a lot of objects in different environments. When you create an object like a table or stored procedure, you need to get this object deployed into each environment. Together we will discover how to separate each object for proper order deployment while releasing only objects which have changed. Deployments can cause you trouble but we will provide a reliable deployment and version control process.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Tom Norman


SQL Server 2014 in-memory OLTP Deep Dive
  2  

SQL Server's new In-Memory OLTP technology (codenamed 'Hekaton') promises to be one of the most exciting new features to be released when SQL Server 2014 ships. As a DBA you will have a number of questions surrounds it's internals, how it should be administered and how it will impact you high-availability design. In this session In this demo-filled session we will discuss Hekaton from a DBA perspective. We will look at Hekaton's architecture and internals, capacity planning considerations, administration considerations and how it impacts your high-availability design. He will also present some use cases and examples of where the in-memory technology can be used.

Level 300 - (Intermediate): Basic knowledge of subject matter is suggested
Duration: Hour
Presenter: Scott Klein


Best Practices for Leveraging SQL Server in Azure Virtual Machines
  2  

Microsoft Azure Virtual Machines is a robust infrastructure for SQL Server, providing the full benefits of infrastructure-as-a-service offering in Microsoft data centers. SQL Server in a Azure Virtual Machine enable both low overall TCO and an efficient platform for enterprise level workloads. This session will examine the critical facets beyond the mere provision of the SQL VM, and look at the characteristics and considerations for tuning, optimizing, and the key indicators for monitoring performance. We’ll look at special consideration for High-Availability and Disaster Recovery, and pay a little special attention on scalability.

Level 300 - (Intermediate): Basic knowledge of subject matter is suggested
Duration: Hour
Presenter: Scott Klein


Agile BI Development with PowerPivot and SSAS Tabular Model
  2  

As organizations continue to place a major emphasis on business intelligence, the demands and constraints placed upon BI developers and architects continues to grow. Gone are the days when our customers were willing to wait 6 months for a BI project to be delivered. Organizations need access to critical information much faster now in order to remain competitive in a fast paced, digital economy. Meeting these increasing demands means not only adopting new methodologies and best practices, but also new technologies. This presentation will focus on one of these technologies that is available in two different products from Microsoft: PowerPivot for Excel, and the Tabular Model of SQL Server Analysis Services. Both of these products utilize a new in-memory, columnar database engine called the "XVelocity Engine", and a new BI model called the "BI Semantic Model" to make development of BI solutions much faster and more agile than the traditional star-schema and cube model used in the past.

Level 100 - Introduction
Duration: Hour
Presenter: Martin Miller


Hello, my name is DAX! An introduction to Data Analysis eXpressions.
  2  

DAX is the new expression language used for PowerPivot and the Tabular Model of SQL Server Analysis Services. Although much simpler and easier to learn than its predecessor, MDX, DAX can still be used to create powerful analytic expressions for OLAP queries and reports. This presentation will start with the basic syntactical elements of DAX, and will progress through the most important DAX functions, finishing with examples of measures and calculated columns created using DAX. This presentation is intended to be a follow-up to "Agile BI Development with PowerPivot and SSAS Tabular Model", but is suitable for anyone who has experience working with PowerPivot or the SSAS Tabular Model.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Martin Miller


Storage Spaces: Flipping the I/O /faster bit in Azure
  2  

By default & by design, I/O in Azure IaaS VMs is notoriously slow relative to on-prem solutions we've grown to know & love. As an I/O SME, it's been challenging to embrace this new relationship. At Microsoft IT, we're working with the SQL Server Program Group in pioneering I/O best practices as part of our Cloud strategery. In this session, I'll share the lessons learned, explain the pitfalls of default settings, learn how to test, validate, & analyze your I/O using various tools including Azure Storage Analytics & SQLIO Automation, identify & mitigate Azure throttling, learn why the well-known yet deprecated OS striping invites database corruption, & how to implement & monitor Windows Server Storage Spaces to maximize I/O performance & maximize database consistency.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Jimmy May


Database Decoder Ring
  2  

I recently took over a new database that I needed to query and report from but I didn't know what was there and how it all connected. Join me on my journey of tips and tricks to decode your next new database. There will be some T-SQL, some Interface work and a little bit of Sherlocking while avoiding locking.

Level 200 - (Beginner): Introductory / fast moving
Duration: Hour
Presenter: Andrea Allred



Track Name

Session Name

Track

Level

Duration

Session Abstract