SQLSaturday #279 - Phoenix 2014

Event Date: 03/29/2014 00:00:00

Event Location:

Chandler-Gilbert Community College Pecos Campus
2626 East Pecos Road
Chandler, Arizona

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: Optimizing SQL Server for SharePoint

Abstract: Knowing the vast majority of the content accessed via SharePoint is stored in SQL Server, and also knowing an incorrect configuration of SQL Server can have a detrimental impact on the performance of SharePoint it is important to understand the integration of these two products. Regardless of whether you have a dedicated DBA, or the SharePoint administrator is also the DBA, there are critical SQL Server configurations that can be made that will improve the performance of SharePoint. Often DBA’s are familiar with how to manage SQL Server, but may not be familiar with some nuances that SQL Server has when integrated with SharePoint. In this session we will demonstrate how some default SQL Server settings negatively impact SharePoint and what changes can be made to improve the performance of SharePoint. These changes include database file settings and SQL Server instance settings. We’ll also examine how to properly install SQL Server and SharePoint so they work together efficiently.

Speaker(s):

Brian Alderman

Track and Room: DBA / Prof Dev - N/A

Title: The Sqoop on Big Data from it’s humble beginnings to rise to notoriety

Abstract: Everywhere you turn in the technological literature people are talking and writing about Big Data. In this presentation you will learn about the origins of Hadoop, and how it is implemented today. In addition to the most infamous way of retrieving data from Hadoop, Map Reduce, there another way to manipulate the Hadoop data. It is possible to query the data from Hadoop in SQL Server through the use of Sqoop. In order to better understand the logic behind Sqoop, I will present information on the Hadoop components. Having this information will help you determine how the tools all fit together so that you will know which tools are the best choice for getting the desired answers from your data sources.

Speaker(s):

Ginger Grant

Track and Room: BI / Big Data - N/A

Title: Enterprise-grade MDM On SQL Server - the Keys to Success

Abstract: This session discusses a proven organizational approach and important technical considerations that lead to the successful adoption of Master Data Management (MDM) on SQL Server.

Organizational considerations include building buy-in, team capability expertise, and selling MDM to the rest of the organization while building a subject-area center of excellence. We also discuss approaches to improved time-to-value and to ensure that the technology and staff investment is matched to the expected outcome.

Great technology choices will help ensure that your best laid plans succeed and the second half of this session goes over some important technology considerations. In this part of the session we discuss User Experience, Integration Patterns, Matching, Programmability, and Data Quality.

Speaker(s):

John McAllister

Track and Room: BI / Big Data - N/A

Title: Keynote - Breakthrough Data Platform Performance with SQL 2014

Abstract: With IT budgets shrinking and demand for data continuously growing, you face the challenge of increasing database scale to meet demand with minimal increase in costs. Join us and learn how SQL Server 2014 provides breakthrough performance and scalability with in-memory technologies across all workloads including OLTP, Data Warehousing and Business Intelligence. You will also learn about the rich capabilities included in SQL Server 2014 that deliver mission critical performance, faster insights on any data through comprehensive business intelligence tools, and a platform for hybrid cloud that offers new scenarios, like simplified database backup and disaster recovery in the cloud.

Speaker(s):

Kevin Cox

Track and Room: BI/ APP DEV - N/A

Title: SQL Server 2012 Master Data Services / Data Quality Services

Abstract: Tired of seeing your name spelled 27 different ways… all from the same company? Tired of making the same corrections over and over and over again? Would it be better if business users could directly correct data and have the corrections recorded and consistently applied?

Surely someone has come up with a solution to these problems?

Come check out how software you likely already own can solve these problems.

This session was originally presented at SQLSaturday 158 in NYC, but has been enhanced with additional content and all filler has been mercilessly cut, folded, spindled and mutilated.

http://www.sqlsaturday.com/viewsession.aspx?sat=158sessionid=9892

Speaker(s):

Marc Jellinek

Track and Room: BI - N/A

Title: Getting Started with Execution Plans

Abstract: There are times when you are able to be proactive and tune existing queries. Sometimes, you will receive a phone call from your manager telling you that a certain web page or report is timing out and your users are furious. You need to quickly diagnose what the problem is. Where do you turn to first? When a query is underperforming, hogging resources or timing out, one of the first things you want to examine is the query execution plan. An execution plan provides a wealth of information that can help you quickly diagnose what is wrong. In this beginner level session you will learn what an execution plan is, how to find it, and how to interpret it to see what the query optimizer is doing and find the major pain points.

Speaker(s):

Jason Kassay

Track and Room: BI/ APP DEV - N/A

Title: Probing into the Microsoft SSIS Model: Reconfiguring SSIS Packages Using an Automated Approach

Abstract:

While many in the BI realm are comfortable performing SSIS tasks using Microsoft Business Intelligence Studio, there is that other world of exploration that utilizes the SSIS programming interface API. Why use it? In this session we will go over some basic approaches as to how to take advantage of the SSIS API model to perform package configuration and property changes in an automated manner. This is especially advantageous in enterprise systems that maintain numerous dtsx packages. Automating changes to SSIS packages reduces the amount of development time that otherwise would be spent if one were to go in and manually apply these changes using the graphical interface.

Speaker(s):

Mark Paszli

Track and Room: ETL / SSIS - N/A

Title: Introduction to the Hive Query Language for BI Developers

Abstract: The Hadoop ecosystem has emerged as the most viable means of working on huge amount of data which is now commonly referred to as “BigData”. The piping- and parallelism approach of breaking heavy tasks in to smaller manageable tasks and executing them in parallel on readily available commodity hardware, relies on the MapReduce programing framework. One of the challenges facing the enterprise BI team is the learning curve in moving from existing solutions built on traditional databases to Hadoop clusters which are primarly designed to be queries using MapReduce programing constructs . Initially developed by Facebook, and used and enhanced by other companies like Netflix and Amazon; the Hive Query Language (HQL), bridges the gap between MapReduce and Traditional SQL. In this presentation I will be discussing the basic commands required to interact with Hadoop File System (HDFS), as well as the fundamental query constructs of Hive. Demos will done on a Hortonworks , Apache Hadoop SandBox.

Speaker(s):

Orion Gebremedhin

Track and Room: BI / Big Data - N/A

Title: Increase your SSIS productivity with Biml

Abstract: 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.

Speaker(s):

Reeves Smith

Track and Room: ETL / SSIS - N/A

Title: Where did I put my (primary) keys?

Abstract: In this session we will revisit some of the fundamental design principals of relational databases: normalization rules, key selection, and the controversies associated with these issues from a practical perspective. We will consider the benefits and challenges of using different types of keys - natural, surrogates, artificial (and others?) from multiple aspects: data consistency, application development, maintenance, portability and performance.

Speaker(s):

Ami Levin

Track and Room: APP DEV / DBA - N/A

Title: Handling Errors and Data Anomalies in SSIS

Abstract: Even in the most reliable ETL system, it’s eventually going to happen: A package will fail, an output row count won’t match what is expected, a data anomaly will force a forensic search of the package infrastructure… In this session, we’ll talk about some of the things that can go wrong during package execution - and some of the defenses that can be built into SSIS to help head off those errors (or at least make the errors easier to troubleshoot). From error handlers to package restartability, and from logging methods to row count validation and remediation, we’ll cover various ways to keep your ETL flowing when problems arise.

Speaker(s):

Tim Mitchell

Track and Room: ETL / SSIS - N/A

Title: Getting Started with MDX

Abstract: In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012.

Speaker(s):

William E Pearson III

Track and Room: BI - N/A

Title: What secrets does your table schema hold?

Abstract: Data types are the basic building blocks of table design. Using the correct data type can affect data integrity and performance. Redesign after a table is in production is very difficult, so getting it right when building the table is crucial.

We begin with discussion on best practices for choosing data types and why the right data type is important for performance and data integrity. We will then run scripts to spotlight inconsistent field lengths and data types as examples of secrets that will be revealed.

This session will help you design better tables so your data is more stable and reliable. It is also a good review if you will be taking exam 70-461.

Speaker(s):

Andre DuBois

Track and Room: APP DEV - N/A

Title: Master Data Services - 4 Key Features in 60 Minutes

Abstract: SQL Server 2012 adds to the Master Data Services (MDS) platform by expanding table-level integration (staging), improving the web UI, providing an Excel add-in, and adding to the services layer. But many organizations have not yet begun to leverage the full potential. This session helps you better understand the Master Data Management (MDM) and MDS by exploring 4 key features in depth. While diving deeply into the new Excel add-in, MDM Hierarchies, MDM Business Rules, and Staging you will gain a much deeper understanding of MDS. The talk will be interspersed with tips and best practices for how start an MDM project in your organization.

Speaker(s):

John McAllister

Track and Room: BI - N/A

Title: SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive

Abstract: Windows Azure gives you a choice in where to host your SQL data, with both SQL Server running in a VM and Windows Azure SQL database. Ongoing innovations in SQL/VM and SQL DB enable both low overall TCO for management of existing applications/services and an efficient platform for the new breed of cloud applications/services. Additionally the ability to mix and match existing and new applications in the same hosted service, and to integrate with on-premises applications and networks in hybrid models provides tremendous flexibility. This session will take a deep look at the best practices when provisioning and deploying a SQL Server in a Windows Azure Virtual Machine

Speaker(s):

Kevin Cox

Track and Room: DBA - N/A

Title: Biml – The Next Step in Agile Data Warehousing

Abstract: Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive, demo focused presentation you’ll see how you can rapidly iterate through the Data Warehouse Development Cycle and provide ROI almost immediately. Learn how you can use Biml Script to automatically create staging tables, SSIS Packages, and other necessary objects during the modeling process.

Speaker(s):

David Stein

Track and Room: ETL / SSIS - N/A

Title: Introduction to FileTables in SQL 2012

Abstract: What are FileTables? How do they work? What are their limitations? These questions and more will be answered in this demo filled presentation. We will walkthrough the configuration and implementation of this feature. We will show you some use cases on how this functionality can help you manage your data in whatever forms it exists.

Speaker(s):

Warren Sifre

Track and Room: APP DEV - N/A

Title: Murder They Wrote

Abstract: Top 10 methods to kill your database performance. The attendee will leave this session with some ideas on what to look for and what to tune in order to improve performance.

Joint Session with Wayne Sheffield

Speaker(s):

Jason Brimhall

Track and Room: DBA - N/A

Title: Getting started with Big Data and BI

Abstract: HDInsight is the latest evolution of Hadoop on the Windows platform. It allows you to manage big and unstructured data while using the rich Business Intelligence tools provided by SQL Server. This session will cover big data architecture and demonstrate map/reduce, the nucleus of big data technology. You will also see how you to get maximum value out of big data by incorporating it into your BI architecture with tools such as Hive, Excel, PowerQuery, and Tabular models.

Speaker(s):

Carlos Bossy

Track and Room: BI - N/A

Title: SQL Clustering - what it is, what it isn’t, and how to get both

Abstract: Windows Failover Clustering has been a common solution to providing failover and high-availability in SQL Server environments, and can be used to cluster an instance of sql server, as well as serve as the supporting infrastructure for AlwaysOn. But for a new server deployment, which should you use - traditional clustered instances or AlwaysOn, and what’s the difference? While not delving into advanced implementation, this session will describe what clustering is, the components involved, how it’s used (both historically and with AlwaysOn), clear up some common terminology around clustering, and help set the stage for your next deployment.

Speaker(s):

Ryan McCauley

Track and Room: DBA - N/A

Title: Understanding the SQL Server Transaction Log

Abstract: 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.

Speaker(s):

Randy Knight

Track and Room: DBA / Prof Dev - N/A

Title: SQL 2012 Extended Events

Abstract: Extended Events were introduced in SQL Server 2008. With SQL 2012, we have seen a significant upgrade to this feature. Join me for a little adventure into what extended events are. 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.

Speaker(s):

Jason Brimhall

Track and Room: APP DEV / DBA - N/A

Title: Locks, Blocks, and Deadlocks Oh My!

Abstract: 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.

Speaker(s):

Randy Knight

Track and Room: APP DEV / DBA - N/A

Title: Documentation – you know you love it

Abstract: 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.

Speaker(s):

TJay Belt

Track and Room: DBA - N/A

Title: Database Release Management: Tips to help organize it

Abstract: 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.

Speaker(s):

TJay Belt

Track and Room: DBA - N/A

Title: Powershell for SQL Server DBA’s

Abstract: Is the list of servers you manage growing and growing? Are you starting to wonder if there is a more efficient way to manage your SQL Server instances than T-SQL and SSMS? In this session we will give you an introduction to PowerShell with a focus on SQL Server. In this session, we will cover the basics towards configuring and using PowerShell. We will also cover the basic syntax of PowerShell that will help you get started in the right direction. Finally, we will conclude the session with some examples that could make your SQL Admin life a lot easier.

Speaker(s):

John Sterrett

Track and Room: DBA / Prof Dev - N/A

Title: Data Warehouse Mistakes You Can’t Afford to Make

Abstract: Many data professionals understand the basics of Data Warehouse design, including Dimension and Fact Tables, slowly changing Dimensions, and the use of meaningless surrogate keys. However, it isn’t until you’ve created a dimensional model and put it into production, that you realize just how much of an impact seemingly trivial mistakes can make. They can hobble performance, allow inaccuracy, and perhaps worst of all, inhibit adoption and usage of the new system.

Learn how to avoid many common mistakes, from someone who’s made them and then found ways to correct them.

Speaker(s):

David Stein

Track and Room: BI - N/A

Title: Power BI – Cloud Self-Service BI

Abstract: Reporting has moved to the cloud with the introduction of Power BI. Get the Power with Power Query, Power Map, Power Pivot and Power View which you will learn about while finding out how they all work together with Microsoft Excel and Office 365 to create a Self-Service Business Intelligence application in the cloud.

Speaker(s):

Ginger Grant

Track and Room: BI / Big Data - N/A

Title: Enterprise Tabular Models

Abstract: Tabular models in SQL Server 2012 give us a powerful analytic engine that is faster and easier to implement than traditional multi-dimensional cubes using Analysis Services. In this session, you’ll see how to develop analytic models using your existing data sources and learn best practices for preparing data so that it can be effectively used as a Tabular database. In addition to creating the model, you’ll see how to quickly add measures, hierarchies, and calculated columns to provide a rich user experience and how the model works with Excel, SSRS and other reporting tools.

Speaker(s):

Carlos Bossy

Track and Room: BI - N/A

Title: Make Your DBA Happy: 5 Habits Developers Can Implement Today

Abstract: Don’t make your DBA groan each time you need to start a project! There are best practices and good habits developers can be using when developing databases that not only make your DBA happy, but keep the application and entire database server healthy. Learn about 5 good habits developers can be using right now to show your database admin you really care, including but not limited to T-SQL query construction and database design.

Speaker(s):

Eric Oszakiewski

Track and Room: APP DEV - N/A

Title: Translate SQL server performance issues into business costs

Abstract: DBAs understand their bottlenecks, managers understand business issues, this presentation will help both sides understand each other and how to put a dollar figure in business terms on your performance problems. Putting actual costs to problems allows the business to determine if it worth fixing and allows the DBA to obtain budget to move their environment forward.

Speaker(s):

Shawn Meyers

Track and Room: DBA - N/A

Title: Designing and Loading Slowly Changing Dimensions

Abstract: Slowly Changing Dimensions form an integral part of any Data Warehouse environment, and there are many different factors that will determine the flexibility, scalability and effectiveness of the dimensional structure.

The first part of this session takes a look at all the different design elements and considerations of SCD’s. We’ll look at whether it is feasible to create a snowflake, how to deal with relationships between dimensions as well as 1:1 and many:many relationships with fact tables.

Afterwards, we will walk-through a practical and effective method (with code) to load SCD’s with T-SQL.

Speaker(s):

Martin Schoombee

Track and Room: BI - N/A

Title: Battle of the Finch Bots

Abstract: Robots, SQL, Twitter and games! In an ongoing battle across SQLSaturdays, our two Finch bots RGPDEV (represents developers) and RGPDBA (represents DBAs) will compete against each other. You the audience will help determine the winner of the finch bot race by voting real time on twitter for your favorite robot. After all games are over we will use the data collected by the finch bots to select 4 participants to advance to a cyber boxing tournament to win a finch bot.

Speaker(s):

Jeff Renz

Track and Room: BI/ APP DEV - N/A

Title: SQL Server Statistics – What Are The Chances?

Abstract: For far too long, I thought that statistics only contained information on table row counts. While they do contain that information, there is more to it than that. In this beginner session, we’ll go over statistics – how they are created, the different types of statistics that exist, how they’re maintained and how the Query Optimizer uses them. We will also touch on system tables and DMVs that will provide additional information on your statistics. At the end of this session, you should have a better idea of how SQL Server makes decisions on how to gather data.

Speaker(s):

Lori Edwards

Track and Room: DBA - N/A

Title: Writing Better T-SQL Queries with Window Functions

Abstract: SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could.

This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You’ll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.

Speaker(s):

Kathi Kellenberger

Track and Room: APP DEV - N/A

Title: Fundamentals of Data Warehouse Architecture and Design

Abstract: This session will cover key ideas for organizing the hardware and software environment into appropriate logical and physical tiers in order to best support data warehouse extraction, staging, and data mart processes. Additionally the session will cover key differences in leading data warehouse architectures and will finish with a primer on dimensional modeling.

Speaker(s):

Joe Salvatore

Track and Room: BI/ APP DEV - N/A

Title: Beyond Plateaux: Optimize SSAS via Best Practices

Abstract: Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This Best Practices session applies equally to Analysis Services 2008, 2008R2 and 2012.

Speaker(s):

William E Pearson III

Track and Room: BI - N/A

Title: Physical Join Operators

Abstract: SQL Server implements three different physical operators to perform joins. In this session we will examine how each of these operators work, its advantages and challenges. We will try to understand the logic behind the optimizer’s decisions on which operator to use for various joins using (semi) real life examples and we will see how to avoid common join related pitfalls.

Speaker(s):

Ami Levin

Track and Room: APP DEV - N/A

Title: Introduction to Microsoft Power Query

Abstract: Microsoft Power Query is an Excel plugin that enhances self-service business intelligence by allowing for discovering, merging, and enriching data from a variety of data sources including relational, structured and semi-structured, OData, Web, Hadoop, Azure Marketplace, and more. Power Query also provides you with the ability to search for public data from sources such as Wikipedia. In this session we’ll explore the basics of Power Query including how to use the plugin to source, merge, and enrich data to support self-service analytics.

Speaker(s):

Josh Sivey

Track and Room: BI/ APP DEV - N/A

Title: SQL 2012 AlwaysOn

Abstract: Class will cover the basics of AlwaysOn and it is terminology. It will also cover basic setup and configuration using asynchronous commit mode.

Speaker(s):

Gene Stout

Track and Room: DBA - N/A

Title: SQL Server 2014 New Features

Abstract: There is MUCH more to SQL Server 2014 than just Hekaton and Updatable Column Store Indexes!! This session will be a medium-to-high-level overview of many of the new features and enhancements coming in SQL Server 2014. We will take a look at some of the new functionality via demos as well.

Speaker(s):

Kevin Boles

Track and Room: DBA - N/A

Title: Women in Tech Panel

Abstract: This session, modeled after the popular PASS WIT Luncheons, will be a lively discussion about issues affecting women – and men – in tech. Everyone welcome to this very interactive session.

Speaker(s):

Kathi Kellenberger

Track and Room: DBA - N/A

Title: Event Notification in SQL Server 2012

Abstract: This session will cover an introduction to Event Notification usage in SQL Server 2012.

Speaker(s):

Robert Miller

Track and Room: DBA - N/A

Title: SQL Injection

Abstract: Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!

Speaker(s):

Kevin Boles

Track and Room: DBA - N/A

Title: The Curious Case of Isolation Levels

Abstract: Have you ever seen or used “WITH (NOLOCK)” in T-SQL? Do you know what it does and its side effects? Is SQL Server optimistic or pessimistic when it comes to locking? Can it be both? In this session we will cover these questions and discuss how and why SQL Server takes locks and how that affects other users. We will go over alternatives for using NOLOCK and discuss when it is appropriate to use. In addition, we will discuss what are the ACID properties and how to monitor locks and blocks.

Speaker(s):

Keith Tate

Track and Room: APP DEV / DBA - N/A

Title: An End-to-End Big Data Architecture to Improve Marketing ROI

Abstract: In this presentation you will learn about a real life big data use case to increase web and directly mail marketing ROI, using different components - R, Hadoop, Mahout, data warehouse, Powerpivot and Powerview. Those different technologies are implemented to work together to deliver a smart auto-learning system to produce prediction models, such as lead to buyer conversion prediction, search engine marketing optimization and spending allocation optimization. This data architecture solution will help you to determine how big data solution can help your organization to full utilize your existing data.

Speaker(s):

John Yang

Track and Room: BI / Big Data - N/A

Title: Becoming Certified In Microsoft SQL Server

Abstract: Chris Hyde has been working with the Microsoft SQL Server stack for over twelve years and has completed certification exams in SQL versions 2012, 2008, 2005, and 2000. He is a Senior Consultant with Leidos Health specializing in the healthcare market, which he particularly enjoys as he gets to tackle different types of data problems at each client. He is currently on the board of the Albuquerque chapter of SQL PASS.

Speaker(s):

Chris Hyde

Track and Room: BI/ APP DEV - N/A

Title: Preparing SQL for SharePoint the balance of resources

Abstract: In this session we will discuss recommended practices around the preparation of SQL for SharePoint 2013.

Speaker(s):

Eric Stoltze

Track and Room: DBA - N/A

Title: Dashboards - More than One Way to Visualize Data

Abstract: Presenting BI in a sophisticated look that is both user friendly and easy to use can be challenging. In this session I will review the three major types of dashboards (Operational, Strategic, and Analytical). Using Visio, SSRS, SharePoint and Pyramid Analytics I will demonstrate examples of each of the dashboard types.

Speaker(s):

Jeff Renz

Track and Room: BI / Big Data - N/A

Title: Basics of Query Performance Tuning

Abstract: Maintaining SQL Server performance is a constant task. Whether you are a developer or a database administrator, there are many things that you can do to avoid those poorly performing queries. In this session we’ll discuss some common guidelines and offer some tidbits for developing fast queries; and if you already have some poorly performing queries, we’ll discuss some ways to identify the source of the poor performance.

Speaker(s):

Vern Rabe

Track and Room: DBA - N/A

Title: Unlock the Power in Power BI

Abstract: Power BI is Microsoft’s latest cloud self service BI offering. Join me as we peel back the layers and features of Power BI. What’s available? When, How, and Why do I use Power BI? See how Power BI can truly enable business users to lead the way and build justification for critical business decisions without needing IT data gurus.

Speaker(s):

Matt Smith

Track and Room: BI - N/A

Title: 15 Quick Tips for SSIS Performance

Abstract: When reviewing your ETL processes, the No. 1 question is always, “Does it work as expected?” Closely following that question is the ubiquitous, “How fast does it run?” This session’s tips are targeted at improve the latter.

In this session, we’ll focus on SSIS package performance, quickly reviewing 15 common hotspots for performance issues as well as recommended methods for maximizing throughput. You’ll walk away with some key design patterns and recommendations that you can use today to improve SSIS package performance.

Speaker(s):

Tim Mitchell

Track and Room: ETL / SSIS - N/A

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Ryan McCauley

Twitter: - @SQLRyan

LinkedIn: Ryan McCauley

Contact: http://www.TryCatchFinally.net

Ryan McCauley has been in IT for 15 years, and has filled roles from .NET developer to MSSQL DBA, but is currently an IT Manager at a mid-size Cable/HSD company. In each role, Ryan is always looking for ways to solve new and unique challenges. In additional to solving technical problems and managing a team of DBAs and Report Developers, Ryan likes to get to the bottom of problems and help everybody clearly define a shared solution. Ryan is an MCP and frequently helps out others on StackOverflow, Experts-Exchange, and under the #sqlhelp tag on Twitter.

Carlos Bossy

Twitter: - @carlosbossy

LinkedIn: Carlos Bossy

Contact: http://www.carlosbossy.com

Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.

Jason Kassay

Twitter: - @jasonkassay

LinkedIn: Jason Kassay

Contact: http://www.JasonKassay.com

Jason Kassay is a database administrator, software engineer amp; speaker from Colorado with over 12 years of experience. He is passionate about SQL Server, programming, release process, automation amp; performance tuning. Jason is an active member of the SQL Server community amp; volunteers/presents at events such as Colorado User Groups, SQLSaturday amp; Colorado GiveCamp. When not tuning databases or coding, Jason will most likely be found spending time with his family, playing hockey or running.

Tim Mitchell

Twitter: - @Tim_Mitchell

LinkedIn: Tim Mitchell

Contact: http://www.TimMitchell.net

Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.

Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.

Ginger Grant

Twitter: - desertislesql

LinkedIn: Ginger Grant

Contact: http://www.DesertIsleSQL.com

Ginger Grant manages the consultancy Desert Isle Group and shares what she has learned while working with data technology to people around the world. As a Microsoft MVP in Data Platform, Microsoft Certified Trainer and an instructor on DataCamp, she focuses on guiding clients to create solutions using the entire Microsoft Data Stack, which includes SQL Server, Power BI, and Azure Data Cloud components. When not working, she protypes the latest pre-release data technologies, maintains her blog http://www.desertislesql.com, and spends time on twitter @desertislesql.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Ginger Grant

Twitter: - desertislesql

LinkedIn: Ginger Grant

Contact: http://www.DesertIsleSQL.com

Mark Paszli

Mark Paszli is a senior consultant at Neudesic with over 10 years experience in Microsoft BI Solutions. His background originates in Engineering, who then crossed over to the realm of .Net application development and is now actively involved in helping clients achieve their goals using data driven methodologies within the Microsoft BI practice.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Chris Hyde

Twitter: - ChrisHyde325

LinkedIn: Chris Hyde

Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.

Marc Jellinek

Contact: http://marcjellinek.wordpress.com

Marc Jellinek is a Senior Lead Consultant with Catapult Systems, a Microsoft National Systems Integrator based in Austin, TX.

Marc’s been working with SQL Server since version 4.21 for employers such as Microsoft, Ernst Young and Major League Baseball.

Tim Mitchell

Twitter: - @Tim_Mitchell

LinkedIn: Tim Mitchell

Contact: http://www.TimMitchell.net

Josh Sivey

Twitter: - @joshsivey

LinkedIn: Josh Sivey

Josh Sivey is a Microsoft Certified Professional with over fifteen years of experience delivering solutions using Microsoft technologies. He enjoys helping empower users to unlock the power of corporate data using the Microsoft BI stack. Josh is a Technology Solutions Professional with Microsoft. In his free time, he enjoys saving Hyrule from the clutches of Ganon with his son and playing My Little Ponies with his daughter.

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.

Gene Stout

I have working with SQL and Informix Database engines for over 13 years

Robert Miller

Twitter: - https://twitter.com/RobertMiller

LinkedIn: Robert Miller

Contact: http://sqlhuman.com

Robert Miller has managed Microsoft SQL Server implementations for the past twenty years. Additional, he is an accomplished architect, application developer, SAN and Systems administrator. In addition to Microsoft SQL Server, he has experience with Oracle and VMS/Rdb database environments. Robert#39;s specialty is working in and architecting high-performance, high-availability environments.

Eric Oszakiewski

Contact: http://oszakiewski.net/erics_blog

Eric has been a developer for 32 years, working with SQL since 2006, managing SQL development, performance tuning optimization, SSIS package development auditing, and SSRS design development. Currently developing .Net SharePoint solutions for General Motors.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence

John Yang

John Yang is currently the co-founder and chief architect for Data and Decision. His areas of expertise include big data, data mining, data warehouse architecture, business Intelligence and predictive analysis, he is also the part time research associate with ASU Biomedical Informatics Department, working towards promoting clinical research data warehouse to research community.

Carlos Bossy

Twitter: - @carlosbossy

LinkedIn: Carlos Bossy

Contact: http://www.carlosbossy.com

Eric Stoltze

Contact: http://sharepointdavinci.blogspot.com/

Based in Phoenix, Arizona, Eric is a Senior Consultant within the Portals and Collaboration Group at Neudesic LLC. With 13 years of experience in multiple facets of IT, Eric enjoys the SharePoint platform because “it is an evolving product line that constantly brings new and exciting solutions to market”. Eric has a deep theoretical and practical understanding of SharePoint and Windows infrastructure. Eric holds multiple Microsoft certifications.

John McAllister

LinkedIn: John McAllister

Contact: http://www.profisee.com

John McAllister co-founded Stratature, an Independent MDM software vendor, in 2001. Following Microsoft’s acquisition of Stratature in 2007 John served as Group Program Manager for MDS and oversaw the incorporation of MDM into SQL Server. John now serves as the Regional Sales Director for Profisee, Inc. which provides enterprise-class MDM Solutions built on top of Microsoft’s MDS offering. John has worked with 100’s of organizations around the world in all phases of MDM projects.

Reeves Smith

Twitter: - SQLReeves

LinkedIn: Reeves Smith

Contact: http://reevessmith.wordpress.com

Reeves Smith, owner and principal architect of Macer Consulting, is passionate about applying data technologies that empower organizations. Reeves wields his knowledge and experience to lead, design, architect, and teach, working with both data center and business project teams. He approaches every project by first understanding the organization’s business challenges, and then developing a unique approach that targets those business needs accurately and effectively.

Reeves Smith has more than 20 years of experience working on the SQL Server stack. He is a Microsoft Data Platform MVP and Microsoft Certified Master, and regularly delivers technical presentations at international, regional, and local conferences and user groups.

Jeff Renz

Twitter: - jeff_renz

LinkedIn: Jeff Renz

Contact: http://www.revgen.com

Jeff Renz is a Senior Architect at RevGen Partners, currently working as the design architect and implementation lead on several projects for a Fortune Top 50 company. Jeff has worked with SQL Server and BI for 15+ years and has 10 years’ experience with data warehouse design and implementation. In addition to consulting, he is joining the University of Denver adjunct faculty and is expected to begin teaching in the ICT program starting in June. He received his bachelor’s degree in Computer Science, his master’s degree in Operations Research from Colorado School of Mines, and will be graduating from the Harvard Business Analytics Program in December.

Matt Smith

Twitter: - @SmithMattC

LinkedIn: Matt Smith

Matt is currently a Data Platform Business Intelligence Technology Solution Professional and works heavily with Enterprise level architectural, analytical, and operational solutions. His technical and leadership experience spans across numerous industries. He has a strong interest in remaining tactical in while working at the strategic level.

His goal is to assist clients in analyzing, cleansing, and presenting their data so they can make more educated decisions about their business.

Brian Alderman

Contact: http://www.microtechpoint.com

Brian has been focused on helping IT Pros and Database Administrators (DBAs) better understand core Microsoft technologies for over 25 years. As an industry-recognized consultant, author, and conference speaker, Brian’s expertise ranges across Microsoft operating systems; SharePoint, SQL Server, and Active Directory. A frequent presenter at SharePoint Conferences around the world, he has authored or contributed to several SharePoint, SQL Server, and other technical books, and is an MCSE and MCT.

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

Contact: http://www.sqlsolutionsgroup.com/blog

Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.

Warren Sifre

Twitter: - WAS_SQL

LinkedIn: Warren Sifre

Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com

Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.

Jeff Renz

Twitter: - jeff_renz

LinkedIn: Jeff Renz

Contact: http://www.revgen.com

Lori Edwards

Twitter: - www.twitter.com/loriaedwards

LinkedIn: Lori Edwards

Contact: http://www.sqlservertimes2.com

Lori Edwards currently holds the position of Solutions Engineer for SentryOne. Prior to working with SQLSentry, she spent 11 years working as a production DBA. She also has volunteered for PASS since 2009 on the Program Committee, ERC, Nomination Committee and speaking at SQLSaturdays.

TJay Belt

Twitter: - @tjaybelt

LinkedIn: TJay Belt

Contact: http://tjaybelt.blogspot.com

TJay Belt is an outdoorsman at heart who enjoys riding dirtbikes, waterskiing, boating, playing racquetball and spending time with his family. When he can’t be out playing, TJay loves to tinker with databases. TJay has been an IT professional for over a decade and a half. Currently serving as a Senior Database Administrator with Imagine Learning. TJay has progressed through several roles in his database career including developer, data guy, database developer, database analyst and DBA.

TJay Belt

Twitter: - @tjaybelt

LinkedIn: TJay Belt

Contact: http://tjaybelt.blogspot.com

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

Contact: http://www.sqlsolutionsgroup.com/blog

John McAllister

Twitter: - @jmcallis64

LinkedIn: John McAllister

Contact: http://www.profisee.com

Kevin Cox

Twitter: - @kevincoxsql

Kevin Cox has been working with databases for over 35 years and with SQL Server for more than 25 years. He is an author, lecturer, and mentor in database subjects. Kevin is currently with the Microsoft Azure Engineering product group in the Customer Advisory Team and feels fortunate to be able to work on the largest projects around the world.

Martin Schoombee

Twitter: - sqlmartin

LinkedIn: Martin Schoombee

Contact: http://www.martinschoombee.com

Martin is an independent Business Intelligence Analytics consultant, helping customers make sense of their data for more than 15 years.

Andre DuBois

Twitter: - @MtnDBA

Contact: http://MtnDBA.wordpress.com

Andre has been in the IT industry for over 25 years in various positions with the majority working as database administrator, designer and programmer. His experience has been in the financial, travel and education industries.

Vern Rabe

Twitter: - @VernRabe

LinkedIn: Vern Rabe

Contact: http://www.rabedata.com

Vern Rabe is an independent SQL Server consultant and contract trainer in Portland, OR, and leader of the Oregon Data Community user group, formerly OregonSQL. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been passionate about databases since 1992 and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server knowledge gained from the mixture of academic and practical experiences acquired from his classroom instructing and varied consulting contracts. Vern regularly presents technical sessions at SQL Server user group meetings, SQLSaturdays, and PASS Summit.

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.

David Stein

Twitter: - @Made2Mentor

LinkedIn: David Stein

Contact: http://www.Made2Mentor.com

David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

Shawn Meyers

Twitter: - 1dizzygoose

LinkedIn: Shawn Meyers

Shawn Meyers is a Field CTO working at Tintri. Shawn has worked in IT for 25+ years and specifically with SQL Server for 20+ years, beginning with version 6.5. A frequent speaker at many events including PASS Summit, VMworld, VMUGs, Virtual Chapter sessions, and many SQLSaturday events. Current focus is on improving DBAs lives with better infrastructure.

David Stein

Twitter: - @Made2Mentor

LinkedIn: David Stein

Contact: http://www.Made2Mentor.com

Ami Levin

Twitter: - ami_levin

LinkedIn: Ami Levin

Contact: http://www.amilevin.com

Ami is a data nerd that has been designing, consulting, training, writing, and speaking about SQL, relational modeling, and data platform architecture for more than 20 years. Currently works as a freelance consultant, senior SQL instructor at O’Reilly Media, as an author for PluralSight and LinkedIn Learning.

Ami Levin

Twitter: - ami_levin

LinkedIn: Ami Levin

Contact: http://www.amilevin.com

Joe Salvatore

Contact: http://datadesignpro.com/

Joe is an accomplished Business Intelligence Architect with Pragmatic Works. For over 15 years, Joe, has designed complex business intelligence solutions for customers throughout all of North America. His focus on architecting the right hardware and software solution along with implementing best practice dimensional models has earned him high praise from customers.

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

John Sterrett

Contact: http://johnsterrett.com

John Sterrett is a Group Principal and Sr. Consultant at Linchpin People. Previously, he was a Sr. Database Admin Advisor for Dell, directly responsible for several mission-critical databases behind dell.com. John has presented at many community events, including PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturday’s, PASS Chapters and Virtual Chapter meetings. John is a PASS Regional Mentor and founded WVPASS user group and the HADR Virtual Chapter.

Keith Tate

Twitter: - https://twitter.com/keith_tate

LinkedIn: Keith Tate

Contact: http://thesqlchef.com

Keith Tate is a Senior Database Administrator with over 17 years of experience as a data professional. During Keith#39;s professional career he has been a developer, DBA and data architect. Keith is also active in the SQL Server community and is currently the chapter leader of the Albuquerque SQL Server User Group.

Orion Gebremedhin

Twitter: - oriongm

LinkedIn: Orion Gebremedhin

Contact: http://www.bi-insights.com/

Orion Gebremedhin, is the Director of Technology for Data and Analytics Platform at Neudesic . He is also a Data Platform (vTSP) for Microsoft Corporation focusing on Big Data technologies. Orion brings extensive experience in implementing advanced analytics and big data technology solutions in various industries. He is a frequent speaker in various technology events; and currently leads the Big Data and Advanced Analytics roadshow sponsored by Neudesic and Microsoft. Neudesic has been providing innovative technologies, services and software products for more than a decade to help organizations gain a competitive advantage and position them for success.

Kevin Cox

Twitter: - @kevincoxsql

SQLSaturday #279 - Phoenix 2014

Sessions

Title: Optimizing SQL Server for SharePoint

Title: The Sqoop on Big Data from it’s humble beginnings to rise to notoriety

Title: Enterprise-grade MDM On SQL Server - the Keys to Success

Title: Keynote - Breakthrough Data Platform Performance with SQL 2014

Title: SQL Server 2012 Master Data Services / Data Quality Services

Title: Getting Started with Execution Plans

Title: Probing into the Microsoft SSIS Model: Reconfiguring SSIS Packages Using an Automated Approach

Title: Introduction to the Hive Query Language for BI Developers

Title: Increase your SSIS productivity with Biml

Title: Where did I put my (primary) keys?

Title: Handling Errors and Data Anomalies in SSIS

Title: Getting Started with MDX

Title: What secrets does your table schema hold?

Title: Master Data Services - 4 Key Features in 60 Minutes

Title: SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive

Title: Biml – The Next Step in Agile Data Warehousing

Title: Introduction to FileTables in SQL 2012

Title: Murder They Wrote

Title: Getting started with Big Data and BI

Title: SQL Clustering - what it is, what it isn’t, and how to get both

Title: Understanding the SQL Server Transaction Log

Title: SQL 2012 Extended Events

Title: Locks, Blocks, and Deadlocks Oh My!

Title: Documentation – you know you love it

Title: Database Release Management: Tips to help organize it

Title: Powershell for SQL Server DBA’s

Title: Data Warehouse Mistakes You Can’t Afford to Make

Title: Power BI – Cloud Self-Service BI

Title: Enterprise Tabular Models

Title: Make Your DBA Happy: 5 Habits Developers Can Implement Today

Title: Translate SQL server performance issues into business costs

Title: Designing and Loading Slowly Changing Dimensions

Title: Battle of the Finch Bots

Title: SQL Server Statistics – What Are The Chances?

Title: Writing Better T-SQL Queries with Window Functions

Title: Fundamentals of Data Warehouse Architecture and Design

Title: Beyond Plateaux: Optimize SSAS via Best Practices

Title: Physical Join Operators

Title: Introduction to Microsoft Power Query

Title: SQL 2012 AlwaysOn

Title: SQL Server 2014 New Features

Title: Women in Tech Panel

Title: Event Notification in SQL Server 2012

Title: SQL Injection

Title: The Curious Case of Isolation Levels

Title: An End-to-End Big Data Architecture to Improve Marketing ROI

Title: Becoming Certified In Microsoft SQL Server

Title: Preparing SQL for SharePoint the balance of resources

Title: Dashboards - More than One Way to Visualize Data

Title: Basics of Query Performance Tuning

Title: Unlock the Power in Power BI

Title: 15 Quick Tips for SSIS Performance

Speakers

Sponsors