SQLSaturday #390 - Philadelphia 2015

Event Date: 06/06/2015 00:00:00

Event Location:

45 Liberty Blvd.
Malvern, Pennsylvania

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: Building an Effective Data Warehouse Architecture

Abstract: You’re a DBA, and your boss asks you to determine if a data warehouse would help the company. So many questions pop into your head: Why use a data warehouse? What’s the best methodology to use when creating a data warehouse? Should I use a normalized or dimensional approach? What’s the difference between the Kimball and Inmon methodologies? Does the new Tabular Model change things? What’s the difference between a data warehouse and a data mart? Is there any hardware that is optimized for a data warehouse? Join this session for the answers to all these questions. You’ll leave with information that will amaze your boss and lead to a big raise… – or at least lead you down the correct path to adding business value to your organization!

Speaker(s):

James Serra

Track and Room: BI 1 - Wynnewood

Title: Absolute Introductory Session on SQL Server 2014 In-Memory Optimized Databases (Hekaton)

Abstract: Hekaton is Microsoft’s code word for their new OLTP in-memory, optimized data processing option for frequently-used tables in SQL Server 2014. In certain instances, Hekaton can yield performance gains of over 10x. This session will cover the benefits of Hekaton, why developers and DBAs would want to use Hekaton, and the different options for creating Hekaton tables. We’ll also look at the native-code stored procedure optimizations when using Hekaton. Additionally, this session will show the range and limitations of Hekaton and how it differs from traditional SQL Server tables (such as transaction handling). Along the way, the session will have several code demonstrations where we’ll look at performance benchmarks. If you’ve heard about Hekaton and in-memory optimizations and terms such as ‘latch and lock free structures’ and wondered what it all means, this session is for you!

Speaker(s):

Kevin Goff

Track and Room: BI 1 - N/A

Title: Automating Your SSIS Design Pattern for Faster Development

Abstract: Once you finish designing the SSIS packages needed for your project, the process of creating those packages is mostly redundant and time-consuming. As the source or target systems go through changes (even as small as a column rename), you’re forced to modify the packages.

BI Markup Language (BIML), which is a free plugin, removes the pain-points involved in manual development by programmatically generating packages. In this session, you’ll learn the basics of BIML and see how you can use it along with metadata to create packages automatically. You’ll also see how easy it is to regenerate the packages when the system changes. You’ll leave the session with knowledge of BIML’s building blocks and a principle I call “D[ee]MOB” that helps you automate SSIS development in your environment.

Speaker(s):

Samuel Vanga

Track and Room: Dev 1 - N/A

Abstract: What is a socal DBA? It’s a DBA that uses social media to excel in his or her DBA career! Social media includes, but not limited to Twitter, LinkedIn, Google, SQL Server forums,community sites, and more! By using various aspects of social media to one’s advantage, you can become a DBA star. Whether you’re an accidental, junior or senior DBA, if you’re not using social media, then you’re missing out on the vast array of resources at your fingertips. Can’t solve a problem, or issue? Before you call Microsoft Support, come to my session, and I will provide a ton of useful tips on how to get the answers immediately! This session is a Database Professional Development track to boost your ability to get answers when you need them!

Speaker(s):

Robert Pearl

Track and Room: BI 1 - Advanced

Title: Table Vars Temp Tables - What you NEED to Know!

Abstract: 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?”

Speaker(s):

Wayne Sheffield

Track and Room: BI 2 - N/A

Title: Version control with GIT for the DBA

Abstract: In 2005, Linus Torvalds developed a version control system (VCS) called git. Since then, it has become as platform agnostic and ubiquitous as the internet. In that same note, github, the most popular service for hosting git repositories has become so ubiquitous that Microsoft chose to host the source code for its OSS fork of the .NET framework there instead of its own codeplex.

What does this mean to a DBA? Well. whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in VCS.

In my session. We will cover:

What is version control? How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN? How do I setup git for internal use in my company? How do I host public and private repositories on github. How do pull requests work? How do I fork a SVN repo to github?

We will be covering using git from both the command line and Vis

Speaker(s):

Justin Dearing

Track and Room: BI 1 - MRP I

Title: Performance Tuning - Analyzing Execution Plans

Abstract: Did you ever get woken up at night from a call from a user screaming about poor query performance, but didn’t really know how to begin attack the problem? In this session, we will explore the basics of execution plan analysis and how to single out issues that pertain to base table operations. In this presentation, we will identify what indexes are being used by the SQL Optimizer, the different type of index operations that are performed by SQL Server and which operations are generally considered the preferred method of data retrieval. We will discuss how to determine if the indexes used by the Optimizer are optimal, according to best practices, and the exceptions to those cases. Finally, we will cover the relationships between different types of index operations and joins within SQL Server, including how the SQL Optimizer determines which join type it will use, along with the pros and cons of each join operation

Speaker(s):

Konstantin Melamud

Track and Room: BI 1 - MRP III

Title: A “101” Overview of Microsoft Power BI for Office 365

Abstract: In this session we will do a demo-driven “101” level tour of Microsoft Power BI for Office 365, a solution hosted in the Microsoft Enterprise Cloud. We will take a look at the rich set of PowerBI capabilities, particularly the self-service BI solutions offered through Excel and Office 365. We will also take a look at ways to present levels of data analysis and data visualizations which can bring together deep levels of data insight . We will also discuss a “how to” list to get started as well as the Power BI for Office 365. This session if perfect for business / data analysts, data professionals whom are looking for a session to cover the fundamentals and take away enough information to get you jump started into the right direction.

Speaker(s):

Timothy McAliley

Track and Room: BI 1 - MRP III

Title: What’s your Character Type?

Abstract: This session focuses on what you need to know about working with SQL Server Data Types. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. The presenter will focus on the differences between character data types, working with implicit vs. explicit conversions and using conversion functions.

Speaker(s):

John Deardurff

Track and Room: Advanced - N/A

Title: But it worked great in Dev! Perfomance for Devs

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

Speaker(s):

Randy Knight

Track and Room: BI 1 - Malvern

Title: From Zero to Loading a Data Warehouse

Abstract: You’re tasked to create the ETL process for a brand-new data warehouse. Where do you start? Data warehouse ETL boils down to three specific problems: Staging, Dimensions, and Facts. This session will show you solutions to these three problems. You’ll first learn the fundamentals of a data warehouse before diving into creating packages and leveraging common patterns. You’ll see both simple and advanced scenarios such as incrementally loading staging tables, processing type1 and type2 slowly changing dimensions, early arriving facts, snapshot fact tables, and bridge tables. If you want to create scalable and efficient SSIS packages to load a data warehouse, this session is for you.

Speaker(s):

Samuel Vanga

Track and Room: DBA 2 - Wynnewood

Title: APPLY Yourself

Abstract: Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.

Speaker(s):

Kevin Feasel

Track and Room: Dev 2 - N/A

Title: Punishing Yourself with Continuous Delivery

Abstract: Do you deploy code once every couple of months, or quarters…. or years? Is deployment terrifying and fraught with catastrophes? Then why not do it more often? Continuous Delivery (CD) takes deployment to the next level, turning the terror of pushing out code into happiness, sunshine and butterflies. CD is the practice of maintaining the deployment pipeline so that new features can be delivered quickly and with fewer failures. This session will cover how to do CD in a Business Intelligence Environment.

Speaker(s):

Mark Wojciechowicz

Track and Room: BI 1 - Malvern

Title: Replicaton Technologies

Abstract: Replication is a native SQL Server component which is used for copying, distribution and aggregating data between databases and servers. In this presentation SQL Server MVP discusses the different replication types and technologies and their sweet points. He also shows common use cases, gotcha’s, and performance tuning and troubleshooting techniques.

Speaker(s):

Hilary Cotter

Track and Room: BI 1 - N/A

Title: HealthySQL III

Abstract: Are your SQL Servers Healthy? Are all the SQL Servers you manage, healthy running optimally and has the high availability that is expected? How do you know for sure? Have you checked on the health of your SQL Servers lately? What is a HealthCheck, and how do we perform one? If you are a DBA, then you ought to know! Well Pearl Knows. Robert Pearl talks about the importance of regular health checks of your SQL Server(s). We will talk about the need to create a baseline and provide some time-tested ways to determine if your SQL Servers are healthy and prove it to your managers, clients and heaven forbid, your IT auditors. Using various tools and scripts, you will come out of this session feeling much better :-)

Speaker(s):

Robert Pearl

Track and Room: Advanced - N/A

Title: SQL Server Cryptology - A Primer

Abstract: So, you got told you need to encrypt “the database”. Now what? Join this session by security expert Sebastian Meine (Ph.D.) for an introduction to the fascinating world of cryptology. In this session, geared towards the DBA, you will learn the difference between symmetric and asymmetric encryption, discover what a cryptographic one-way hash function is and probe into cryptographically secure pseudo random number generation. After exploring the different definitions, you will be able to observe how to implement encryption, decryption, transparent data encryption (TDE) and hashing in SQL Server. We will pay special attention to areas where the choice of encryption technology affects your database maintenance and recovery strategies. After attending the session, you will be able to identify the right technology to use in your specific use case and you will have the basic knowledge to start implementing it immediately.

Speaker(s):

Sebastian Meine

Track and Room: BI 1 - Wynnewood

Title: Stress testing SQL Server

Abstract: How high can we go? Frequently in your career as a DBA you will be asked how much load can your SQL Server support. In this session, SQL Server MVP Hilary Cotter, shows you how to Microsoft tools to stress test your application and determine what your bottlenecks are and how high you can ramp up your workload.

Speaker(s):

Hilary Cotter

Track and Room: BI 2 - MRP I

Title: What’s an execution plan and why does it matter?

Abstract: Even if you’ve never looked at an execution plan before, you’ll come away from this talk with a good understand of why they’re a critical tool in performance tuning. We’ll cover how to get the plan and how to read it. We’ll look at some badly performing queries and see what the execution plan tells us about how we can improve their performance.

Speaker(s):

Sharon Dooley

Track and Room: Advanced - Paoli

Title: The Ticking Timebombs in Your Databases

Abstract: You’ve worked hard to build the best systems you can, and then one night you get called in to resolve a production incident. As you peer into your database, you see it: something so bad it sends shivers down your spine. How did that get in there? Who did that? Why? And how do you fix it?

In this session, we look at the workarounds, technical debt and clever designs that can cause you grief when you least expect it. We will also include perfectly fine features that can haunt you later. We will discuss how these things happen and give you tools to identify the ones that cause the most pain.

Join us: you’ll keep your job, have happier users and get more rest.

Speaker(s):

Karen Lopez

Track and Room: Beginner - MRP I

Title: Availability Groups 101: An Introduction

Abstract: One of the most talked about new features in Microsoft SQL Server is AlwaysOn Availability Groups. In this session, we’ll cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications and databases, are currently using Database Mirroring, or if you’re just curious about Availability Groups, then you won’t want to miss this session.

Speaker(s):

Adam Belebczuk

Track and Room: BI 1 - MRP II

Title: 60 Reporting Tips in 60 Minutes

Abstract: This session will be rapid fire, fast-paced experience, focusing on all sorts of reporting tips. This session is for the YouTube generation. Do you have a short attention span? Are 15-second commercials too long to sit through? Do you want the very best reporting tips collected from watching hundreds of videos and reading a library of books, plus years of reporting experience? Come to this session. We have tips on Excel, data visualization, interviewing stake holders, organizing reporting teams, securing reports, consolidation, dashboard design, SSRS, SSIS, and T-SQL authoring. You’re guaranteed to learn something actionable that will make you more effective in your career.

Speaker(s):

Ike Ellis

Track and Room: Dev 1 - Paoli

Title: Storage For the DBA

Abstract: One of the biggest issues in database performance centers around storage. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, we’ll be looking at storage from both the database and storage perspectives. We’ll be digging into LUNs, HBAs, the fabric, as well as RAID Groups. In addition to theory, we’ll be looking at an actual EMC SAN so that we can translate what we see in the Storage Array with what we see on the actual server.

Speaker(s):

Denny Cherry

Track and Room: BI 2 - MRP II

Title: Change Data Capture in SQL Server 2008/2012

Abstract: In this session, I’ll talk about Change Data Capture (CDC) terminology and configuring a database for Change Data Capture. I’ll show how to read CDC log tables, and show CDC code samples. I’ll discuss CDC and SQL Server Agent jobs, and the use of CDC versus database triggers (and where triggers are still needed). Also, the impact of CDC on the transaction log and system performance will be explored. Finally, I’ll talk about how to deal with schema changes, performance tuning, and using CDC in an ETL (Extract-Transform-Load) environment with SQL Server Integration Services. Time Permitting, I’ll show some of the SSIS 2012 enhancements in dealing with CDC

Speaker(s):

Kevin Goff

Track and Room: DBA 2 - MRP III

Title: Everything you were afraid to ask about cluster quorums, explained

Abstract: In this deep dive Cluster MVP Dave Bermingham will take a look at cluster quorum options and how they have evolved over the years. Starting with Disk only quorums and ending with Cloud Witness, by the end of this session you should understand this most commonly misunderstood cluster concept and be ready to tackle your next AlwaysOn Availability Groups deployment or AlwaysOn Failover Cluster Instance implementation. Multisite and SANLess clusters will be discussed as well as the implications of Dynamic Quorum and Dynamic Witness.

Speaker(s):

David Bermingham

Track and Room: BI 1 - N/A

Title: Flash and SQL Server— Re-Thinking Best Practices

Abstract: Flash storage is a game changer for virtually every app in which it is used. Whether used locally, for tiered storage, or all-flash arrays, flash is turning what we thought we knew about SQL Server best practices on its head. Contemporary IT environments should standardize their architecture including a tier of flash. Virtualized or non-virtualized, standardizing on in-server flash is vital for optimizing performance, scalability, efficiency (technical and cost), reliability, availability. Learn how flash flips the /faster bit the significant impact flash makes not just in terms of performance, but also best practices, the massive savings in licensing driven by consolidation on flash.

Speaker(s):

J May

Track and Room: BI 2 - MRP II

Title: Data Meaning

Abstract: Most database SQL training talks about syntax or tools. But the missing element is the most important, learning what the data means and how you can use that to write better code or to troubleshoot problems. Sure the meaning is different in every database, but the techniques to learn what the business rules are, what the data actually means to the users, and how to figure out what the column name xfp_reg could possibly mean are the same. Come join me and learn to Query With Meaning.

Speaker(s):

Judith Moffitt

Track and Room: Dev 2 - 30th Street

Title: What’s New in SQL Server vNext

Abstract: In this session, I will share the roadmap of SQL Server vNext. This will be a fast paced overview of what’s coming both in SQL Server on-premise and Azure SQL Database. Hold your questions until the end so we can get through the feature list.

Speaker(s):

Bill Emmert

Track and Room: BI 1 - MRP II

Title: Monster Text Manipulation: Regular Expressions for the DBA

Abstract: Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures filled with table variables instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cuts that work from hours to seconds. I use regular expressions all the time and I have taken many tasks down from several days to just a few minutes. Stop writing code manually and let regular expressions do it for you. Here you’ll learn: • The most useful regular expression commands. • The appropriate times to use regular expressions. • How to use regular expressions to write code for you. • How to incorporate regular expressions into large tasks and combine them with other methods.

Speaker(s):

Sean McCown

Track and Room: BI 2 - Berwyn

Title: Minion Maintenance and Backup Solutions

Abstract: The new Minion solutions are taking the SQL community by storm, and no wonder: they’re free, simple to use, and deeply configurable. In this session I’ll show you the benefits to Minion Reindex and Minion Backup: • Simple installation and configuration for all shops, large or small • Single or multi-server installation script • Table-based configuration eliminates the need for excessive jobs • Highly customizable options • Flexible include and exclude options, including the use of regular expressions • “Statement only” option generates statements without running them • Extensive logging • Live insight into the current maintenance operation Minion Backup also provides a truly superb specialty: dynamic backup tuning. Minion Reindex and Minion Backup scale to the size of your enterprise, from one to thousands of instances. With Minion’s true configurability and enterprise features, you can do things never before possible in your maintenance routines.

Speaker(s):

Sean McCown

Track and Room: BI 1 - Paoli

Title: DBA 911 - Database Corruption

Abstract: Database corruption is simply a fact of a DBA’s life - if you haven’t seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands such as DBINFO, CHECKDB and PAGE. You’ll learn how to monitor for corruption with SQL Server Agent Alerts and Jobs, and when it’s time to restore instead of repair. After attending this session, you will be able to check for issues such as page corruption or data purity problems, and take the appropriate measures to deal with them.

Speaker(s):

David Maxwell

Track and Room: BI 1 - MRP II

Title: Visual Studio Online for cost effective code and Project Mgmt

Abstract: Whether you are working on side project or an Enterprise grade solution, VSO is a cost effective cloud-based option that is hard to beat.

We’ll look at what it is, licensing, pricing and features for developers, project managers and stake holders.

Speaker(s):

Ravi Gudlavalleti

Track and Room: Dev 1 - 30th Street

Title: Getting to Know Your DB

Abstract: In this session we will explore some practical scripts to help create database documentation. We will be looking at how to make some of those documentation tasks easier, while giving you greater insight into your database(s). Attendees will be able to leave with some additional tools for their toolbox and through the use of these scripts the attendee will be able to perform these tasks faster.

Speaker(s):

Jason Brimhall

Track and Room: BI 2 - DBA 1

Title: Master Data Services– Integration through SSIS

Abstract: Building upon ‘Master Data Services – A Primer’, this presentation will show the integration of MDS through SSIS as a way to push and pull information to and from your MDS implementation. Basic MDS knowledge is helpful when attending this session.

Speaker(s):

Christopher Exley

Track and Room: DBA 2 - Wynnewood

Title: Automate Your ETL Infrastructure with SSIS and PowerShell

Abstract: Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious and it’s easy to miss something in the process of generating the same basic package over and again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session we’ll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.

Speaker(s):

Allen White

Track and Room: BI 2 - Wynnewood

Title: Clusters Your Way: #SANLess Clusters for Physical, Virtual Cloud Environ.

Abstract: Microsoft Cluster MVP Denny Cherry will discuss how to create #SANLess clusters in environments where traditional shared storage clusters are impractical or impossible: local high performance clusters leveraging SSD and Flash-based PCIe storage and clustering in the cloud - no SAN (or SAN Admin required). He will also discuss cost-effective strategies to get HA and DR protection without a SAN.

Speaker(s):

SIOS Technology

Track and Room: Advanced - MRP II

Title: Beginning PowerShell Scripting

Abstract: This is a beginers powershell talk. While we will be talking about how to query and administrate SQL server with powershell, it will be a more generic talk about using PowerShell.

Speaker(s):

Justin Dearing

Track and Room: Advanced - Paoli

Title: Optimizing Protected Indexes

Abstract: As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to “index” commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.

Speaker(s):

Chris Bell

Track and Room: BI 1 - MRP I

Title: Continuous Integration for Databases

Abstract: Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration has proven to be a valuable technique in improving software quality by finding problems quickly and letting developers know immediately they have introduced a bug.This session demonstrates how you can implement CI for SQL Server databases, execute automated tests against your code and inform developers that they have caused a problem immediately.

Speaker(s):

Steve Jones

Track and Room: BI 1 - 30th Street

Title: Beginner TSQL

Abstract: That’s right, attendees choose! I’ll show 30 possible topics on the screen, and the attendees vote on which topics I’ll cover. Everything from isolation levels to ranking…everything from GUIDs to table-valued functions….everything from querying temporal data to instances where subqueries are necessary….everything from update triggers to reading execution plans. The good news is that you’ll walk away with 30 code samples, even though we’ll only cover a portion of them in the presentation. This has always been a very popular session.

Speaker(s):

Kevin Goff

Track and Room: Advanced - Paoli

Title: Shortcuts to Building SSIS in .Net

Abstract: Using an Open Source project API Library this session will show how SSIS Packages can be created as easily in C# .Net as they are in BIDS. During the session real world examples will be used to show how SSIS Code can be created in BULK.

Speaker(s):

Paul Rizza

Track and Room: BI 1 - Malvern

Title: Azure SQL Database (Software As A Service)

Abstract: Are you tired of installing, configuring and patching Microsoft SQL Server? Azure SQL database maybe a way to move some of your existing infrastructure to the cloud.

Depending upon your companies philosophy, it might be great for development, testing, and possibly production environments.

The exciting thing about this service is that new features will be released on this platform first before trickling down to the on-premise editions.

The demonstration will show how to create and load a new database from scratch using the Azure Portal, SSMS and BCP.

Speaker(s):

John Miner

Track and Room: BI 1 - Malvern

Title: Interviews and Resumes

Abstract: Whether you are in the hunt for a new job or looking for a new employee to fit in, this session is for you. We will cover common interview techniques used today. We will discuss the goals of these techniques from the interviewer point of view and how you should respond from a job seeker point of view. We will also cover resumes and their purpose. Your resume is your first impression; make it count.

Speaker(s):

Rick Heiges

Track and Room: BI 1 - Advanced

Title: Panel: Will the DBA Job of the Future Still Involve DBAs?

Abstract: While technologies have been changing rapidly since databases were born, the basic tasks a DBA has performed have been a stable foundation of professional database design and support.

But in the last few years, NoSQL technologies (“it’s schemaless!”), cloud (“our databases are managed elsewhere!”) and recent SQL Server features (“it’s new and improved!”) will have an impact on DBA jobs, tasks and careers.#160;

Our panel of SQL Server experts will share their #160;current experiences in the data profession.#160; They will share what they believe you should be working towards now and in the future.

Speaker(s):

Karen Lopez

Track and Room: DBA 1 - MRP III

Title: Creating a Solid Data Model for PowerPivot

Abstract: A solid BI Analysis starts with the model it is based on. This session looks at best practices and avoiding common mistakes when creating the data model on which your PowerPivot and Power View reports are based. Using PowerPivot takes a change in mindset from the traditional pivot table connected to an excel sheet or SSAS cube. You will walk away with a better understanding of how to build your models and how to approach your data analysis when using PowerPivot.

Speaker(s):

Dan Clark

Track and Room: DBA 2 - Wynnewood

Title: Leveraging CDC and SSIS for ODS/DM/DW Loads

Abstract: One of the challenges with loading ODS/DM/DW is gathering data and reducing performance impact. Change Data Capture (CDC) is a means to capture all the changes of a given table, but how do you load this data to another Database. We will walk through the process and considerations for loading data using SSIS package and how to detect changes to the CDC Configured Tables which has been known to cause SSIS Package failures.

Speaker(s):

Warren Sifre

Track and Room: DBA 2 - MRP III

Title: The Restore Cookbook

Abstract: How do you restore a database that has lost a file? How do you recover from a lost transaction log? How do you get rid of corruption in the fastest time?

At some point in time, these and other destructive scenarios will happen to your databases. And people will look at you and expect you to react swiftly and confidently.

Come see the scenarios and demos so you’ll be prepared with the right ingredients to cook up your RESTORE recipe!

Speaker(s):

Warner Chaves

Track and Room: BI 2 - MRP II

Title: Maximizing Failure with Continuous Integration

Abstract: Continuous Integration (CI) is an Agile methodology which enables teams to quickly find bugs in their code and fix them before they reach production. The goal of CI is to always have a working product that can be deployed at any time. Through its practice, developers fail faster and more often than ever before, allowing the developer to fix problems while they are fresh in the mind. This session will cover the basics of CI and show how this can be implemented in a Business Intelligence environment.

Speaker(s):

Mark Wojciechowicz

Track and Room: BI 1 - N/A

Title: SQL Server 2014 Optimizer “Goodies”

Abstract: SQL Server 2014 introduces several new, small enhancements to the Query Optimizer. In this talk, you will learn about a new, real-time query monitoring tool, some significant changes to the way index statistics are computed, and the details of SQL Server’s new cardinality estimator. This presentation assumes knowledge of the pre-2014 Query Optimizer as well as basic query tuning techniques.

Speaker(s):

Sharon Dooley

Track and Room: Dev 2 - Malvern

Title: Agile Data Warehouse Development

Abstract: Long gone are the days when we had two to five years to deliver a Data Warehouse. Business Units want, need, and demand faster turnaround to start collecting on ROI. How can we take the Agile Methodology and apply it to Data Warehouse development? We will discuss how to apply it at the project level and then take a look at some data warehouse specific practices.

Speaker(s):

Bob Blackburn

Track and Room: BI 1 - Malvern

Title: Connecting Power BI to On-Prem SSAS Tabular

Abstract: If you’ve ever looked at the visualizations available in Power BI for Office 365 or the robust sharing capabilities available with the cloud service, but the requirement of uploading/storing data in the cloud was a deal-breaker, there is a new option available for you in the current Power BI Preview. The new Power BI Analysis Services Connector allows you to directly query on-premises SSAS Tabular data for display in Power BI. In this session, we’ll go through installation and configuration of this Connector which can open all-new data sources for use in the cloud.

Speaker(s):

Kerry Tyler

Track and Room: Dev 1 - Berwyn

Title: You Want Me To Do What? SQL Security Basics

Abstract: You’ve done it! You have a database now! Maybe not of your own choice, but you have one. What do you do now to get it secured properly? Come learn the basics of SQL Security to start down the path of proper database protection.

Speaker(s):

Chris Bell

Track and Room: Advanced - Paoli

Title: Hybrid Cloud Scenarios with SQL Server 2014

Abstract: SQL 2014 has significant changes to allow seamless hybrid cloud scenarios. This session will talk about “why cloud” as well as the options available with backup, deployment, and new development scenarios with SQL 2014 and Azure.

Speaker(s):

George Walters

Track and Room: BI 1 - MRP I

Title: Crazy Things Developers Do

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

Speaker(s):

Wayne Sheffield

Track and Room: Dev 2 - 30th Street

Title: Get Familiar with Spatial Data

Abstract: You’ve never worked with spatial data and would like to know how to do it. We’ll go through very basic SQL Server Spatial data functionality and draw some Spatial pictures using Management Studio.

Speaker(s):

Slava Murygin

Track and Room: Dev 2 - 30th Street

Title: Common Coding Mistakes and how to Mitigate them

Abstract: There are several programming design patterns that work great in object orientated code that doesn’t scale well inside of SQL Server. In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.

Speaker(s):

William Wolf

Track and Room: Dev 2 - 30th Street

Title: Become a SQL Server Performance Detective

Abstract: When your database is having performance issues, you need to quickly and accurately diagnose and resolve performance issues. Like any good detective, you need to look for clues to find “The Smoking Gun.” We will cover various tools at our disposal which can help us pinpoint and resolve issues quickly, using Dynamic Management Views (DMVs), SQL Profiler and other queries. We will discuss emergent performance issues as well as chronic issues and find ways to piece together the clues to figure out the root cause of our problems.

Speaker(s):

Danette Riviello

Track and Room: BI 2 - MRP I

Title: To SSAS or not to SSAS, that is the question

Abstract: Have you every wondered if you should be using SSAS? Are you curious about learning the basics? Then this is the talk for you! Join us as we explore the basics of Multi-Dimensional and Tabular SSAS solutions. We will connect solutions with Excel and demonstrate how Power View and other data visualizations work. After this session you will feel more comfortable starting your own solutions with SSAS.

Speaker(s):

Ayman El-Ghazali

Track and Room: Dev 1 - MRP III

Speakers

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

Paul Rizza

Twitter: - @PaulRizzaSQL

LinkedIn: Paul Rizza

Contact: http://blogs.msdn.com/b/paulrizza/

Paul Rizza is a Senior Consultant at Microsoft Consulting Services (MCS), Lead on the MCS SQL Hiring Team, and has over 25 years’ experience consulting, teaching and developing on SQL Server platforms. Paul’s expertise includes ETLs, Dimensional modeling, architecting highly available SQL environments and performance tuning. Paul has an Undergraduate degree from UMBC and a Master’s degree both in Computer Science with a concentration in Database Theory from Johns Hopkins University.

George Walters

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

LinkedIn: George Walters

Contact: https://georgewalters.wordpress.com/

Currently a partner technical strategist, George has been solving customer needs and issues. He can translate customer pain into potential solutions.

A seasoned Microsoft SQL and Azure expert, with over 20 years of experience with Microsoft SQL Server, Sybase, Oracle, and other relational databases.

Specialties: Partner strategy, PreSales Engineering, Cloud Architecture, Enterprise Scalability, SQL Server performance, Business Intelligence, High Availability, Scale. I volunteer and present relevant topics at SQLSaturday and internal Microsoft events

Dan Clark

LinkedIn: Dan Clark

Contact: http://drclarkblog.wordpress.com/

Dan Clark is a senior data analytics consultant. He is focused on all things data analytics and training others how to get value from their data. Dan has published several books and numerous articles on .NET programming and data analytics. He is a regular speaker at various developer and database conferences and user group meetings and enjoys interacting with the Microsoft developer and database communities. His latest book Beginning Power BI published by Apress is a will get you up and running with self-service data analytics on the Power BI platform in no time.

Sharon Dooley

Sharon Dooley has worked with SQL Server since its first release. Her major areas of specialization are database design and performance tuning. She has a consulting practice and teaches and writes courses for Learning Tree International, where she is SQL Server Curriculum Architect. Sharon is an active member of PASS and leads the DBA Virtual Chapter.

Timothy McAliley

Twitter: - sysframeworks

LinkedIn: Timothy McAliley

I am currently a Microsoft Cloud Solutions Architect in the Washington, DC area. Previously, I was a Microsoft Technology Solutions Professional (TSP), a Microsoft Account Technology Strategist and a SQL Server Premier Field Engineer. Prior to Microsoft, I was a Technical Trainer and DBA in the Enterprise Security Group at Symantec . I have been in IT for over 20 years. My particular interests are IT operations, IT auditing, IT audit frameworks, IT service management (ITSM), ITIL, information security, project management, and database/application tier high availability solutions. I also co-run the Northern Virginia SQL Server User Group ( @novasl) and also co-run the Azure Datafest events.

Kerry Tyler

Twitter: - AirborneGeek

LinkedIn: Kerry Tyler

Contact: http://airbornegeek.com

Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.

Justin Dearing

Twitter: - zippy1981

LinkedIn: Justin Dearing

Contact: http://www.justaprogrammer.net

Justin Dearing has been working in IT in 2002. He started as a night shift AS/400 operator and rose through the ranks at a series of companies. He currently works as a developer in the capital markets industry.

Justin has served in both the development and production side of the house on Windows, Unix and Midrange Platforms. His database experience includes MongoDB, MySQL, Postgres and Microsoft SQL server. These days he programs in C#, PowerShell and PHP.

Sebastian Meine

Twitter: - @sqlity

LinkedIn: Sebastian Meine

Contact: http://sqlity.net/en/blog/

Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server. Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor lead developer of tSQLt.

Slava Murygin

Twitter: - SlavaSQL

LinkedIn: Slava Murygin

Contact: http://slavasql.blogspot.com/

Started working with SQL Server 7.0 as DBA and Developer. Since then went through all SQL Server versions, migrations and multiple companies of different sizes and industries. Currently working as a contractor with all aspects of SQL Server, including, but not limited to: troubleshooting performance, designing/developing: databases, systems, processes, data warehouses, cubes, reports, ETLs; Refactoring old code; Migrating data from other systems to SQL Server; Securing the data on enterprise level.

Kerry Tyler

Twitter: - AirborneGeek

LinkedIn: Kerry Tyler

Contact: http://airbornegeek.com

Ben Galluzzo

Twitter: - BenGalluzzo

LinkedIn: Ben Galluzzo

Contact: http://www.bengalluzzo.com/

I#39;m a software developer with a passion for anything that beeps and blinks. I first delved into databases on an Atari 800XL, and I never stopped looking forward since. I often have my hands in everything from databases and software to circuits and embedded systems. When I#39;m not beeping or blinking, I#39;m often spending time with my family, woodworking, building things, or outdoors.

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.

Ayman El-Ghazali

Twitter: - thesqlpro

LinkedIn: Ayman El-Ghazali

Contact: http://www.thesqlpro.com

Ayman is a passionate SQL Server DBA, Developer, and BI Developer. His passion for technology started when he was a young boy playing DOS games on his father’s computer. He can be reached via his blog or twitter handle and is looking forward to connecting with other SQL Geeks.

Sean McCown

Twitter: - @KenpoDBA

Contact: http://www.midnightdba.com/dbarant

Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.

Warner Chaves

Twitter: - @warchav

LinkedIn: Warner Chaves

Contact: http://sqlturbo.com

Warner is a SQL Server MCM, Data Platform MVP and Principal Consultant at Pythian, a global Canada-based company specialized in DBA services. A brief stint in .NET programming led to his early DBA formation working for enterprise customers in Hewlett-Packard ITO organization. From there he transitioned to his current position at Pythian, building and managing data solutions in many industry verticals while leading a highly talented team of Data Platform consultants.

William Wolf

Twitter: - sqlwarewolf

LinkedIn: William Wolf

Contact: http://www.sqlwarewolf.com

Bill is the Manager of SQL Server Performance Tuning for RDX. He works with over 400 customers on solutions within the SQL Server environment and specialized in code tuning and mentoring the team within RDX. He has become a SQLSaturday veteran speaking at nearly 40 SQLSaturdays in the last 3 years. He has also spoken at Summit and is an Idera Ace class of 2018. Bill is active in the Pittsburgh SQL Server User Group. He is also the chapter lead for the DevOps Virtual User Group. He is passionate about educating users on SQL Server and mentoring others.

Sean McCown

Twitter: - @KenpoDBA

Contact: http://www.midnightdba.com/dbarant

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.

Chris Bell

Twitter: - @cbelldba

LinkedIn: Chris Bell

Contact: https://www.wateroxconsulting.com/

Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do ‘Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris’ thoughts and technical community activities at WaterOxConsulting.com.

Bob Blackburn

Twitter: - @SQLeek

LinkedIn: Bob Blackburn

Bob Blackburn is a Sr. BI consultant with Anexinet. He has over 10 years experience in Business Intelligence using the Microsoft BI Stack along with various reporting tools. He has worked with large corporations to build, upgrade, and maintain their Data Warehouse and ETL systems.

Kevin Goff

Twitter: - @KevinSGoff

Contact: http://www.KevinSGoff.net

Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP

Database architect/developer/speaker/author

Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics

Frequent speaker at community events in the Mid-Atlantic region.

Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics

Karen Lopez

Twitter: - @datachick

LinkedIn: Karen Lopez

Contact: http://datamodel.com

Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.

Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”

David Maxwell

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

LinkedIn: David Maxwell

Contact: https://dmmaxwell.wordpress.com/

David Maxwell has almost 20 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. David has been a frequent presenter at SQLSaturday events around the United States since 2012, as well as a presenter for the DBA Fundamentals Virtual Group, the Performance Virtual Group, 24 Hours of PASS, and the annual PASS Summit. David participates in his local Columbus Ohio PASS Local Group, where he serves on the board of directors as SQLSaturday coordinator.

SIOS Technology

Twitter: - @SIOSTech

LinkedIn: SIOS Technology

Contact: http://us.sios.com/blog/

SIOS Technology Corp. makes software products that protect data and applications from downtime, while eliminating complexity, and reducing labor costs. SIOS products make clusters in both SAN and #SANLess environments easy to use and easy to own. By removing the configuration limitations of traditional clusters, SIOS products give enterprise data managers the freedom to run applications in the environment that best meets their needs – physical, virtual, cloud or any combination thereof.

Hilary Cotter

Hilary Cotteris a 20 year IT veteran who has answered over 20,000 questions on the forums. Some of them correctly. He specializes in HA technologies, especially replication, performance tuning, full-text search, and SQL Server Service Broker.

Hilary is also an author, or contributor on a number of books on SQL Server.

Konstantin Melamud

Twitter: - @kmelamud

Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQLSaturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.

Kevin Goff

Twitter: - @KevinSGoff

Contact: http://www.KevinSGoff.net

Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP

Database architect/developer/speaker/author

Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics

Frequent speaker at community events in the Mid-Atlantic region.

Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics

Hilary Cotter

Hilary is also an author, or contributor on a number of books on SQL Server.

Mark Wojciechowicz

Twitter: - @MarkW_BI

LinkedIn: Mark Wojciechowicz

Mark Wojciechowicz is a Business Intelligence Solutions Architect with a passion for process improvement. He has spoken to the Philly user group in the past about continuous integration, continuous delivery, SSDT, and a myriad of other business intelligence related topics.

Ravi Gudlavalleti

Twitter: - @RaviGBI

LinkedIn: Ravi Gudlavalleti

Ravi is a Business Intelligence Architect at Anexinet with over 14+ years of experience helping clients leverage data for insights and strategic advantage.

Danette Riviello

Twitter: - n/a

LinkedIn: Danette Riviello

Contact: http://n/a

Danette Riviello has been working with databases for thirty years. With experience as a database developer, database administrator and manager of DBAs, she is now Lead System Architect at Magellan Health. She has spoken at a SQL Pass Summit, Baltimore SQL Server Users Group and SQLSaturdays. Her technical expertise is in Disaster Recovery Planning, Performance Tuning and Replication.

Denny Cherry

Twitter: - mrdenny

LinkedIn: Denny Cherry

Contact: https://www.dcac.com

Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.

Bill Emmert

William Emmert, Technical Director/Technology Architect, Microsoft Technology Center, Microsoft Corporation Bill is a Data Platform Architect in the Philadelphia Microsoft Technology Center (MTC). He started his career at Microsoft in 1998 in Consulting Services focusing on design, development, testing, deployment and troubleshooting SQL Server OLTP and OLAP solutions. In 2007, he worked on the SQL Server product group for 1 year as a member of the SQL Server Customer Advisory Team (SQLCAT) returning back to consulting in 2008. In 2010 he worked in the New York MTC as a SQL Architect before taking on his current roles in the Philadelphia MTC in 2011. Bill has worked in the computer industry for 30 years.

Robert Pearl

Twitter: - @PearlKnows

LinkedIn: Robert Pearl

Contact: http://www.sqlservercentral.com/blogs/pearlknows/

Robert Pearl is a 5-year SQL Server MVP and creator of the award-winning database and monitoring alert system, SQLCentric. Author of the HealthySQL - Comprehensive Guide to Healthy SQL Server Performance. He’s the founder of Pearl Knowledge Solutions. As a SQL Server community evangelist, he covers local SQL Server events in the New York City area and maintains the Pearl Knows blog. Voted TOP BLOGGER in 2011.

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.

Judith Moffitt

With over 20 years of database experience, Judy specializes in creating complex imports/ exports and reporting queries. She has done development for databases for aviation/flight planning, equipment maintenance, inventory, sales proposals and meeting planning. Her expertise saved the US government over $400 million by identifying parts that were on order in one place that were in the excess inventory at another, a task that required her to query many databases with many different data structures.

She is currently employed by EPAM and extensively works with developers in India and across the US.

Allen White

Twitter: - SQLRunr

LinkedIn: Allen White

Contact: http://dataperfpro.com/blog/

Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.

Rick Heiges

Twitter: - heigesr2

LinkedIn: Rick Heiges

Contact: http://sqlblog.com/blogs/rick_heiges/default.aspx

Rick is a Former Data Platfrom MVP and Sr. Consultant for Microsoft where he focuses on working with customers on their data estate. His career includes work as a DBA, University full-time faculty member, Systems Analyst, Project Leader, and Developer. He has found his passion in working with data and the community. Rick served nine years on the PASS Board of Directors and spearheaded the popular 24 Hours of PASS event. He also started his local User Group in 2002. Today, he spends much of his time with his head in the clouds.

Samuel Vanga

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

LinkedIn: Samuel Vanga

Contact: http://SamuelVanga.com

Sam Vanga helps business people solve their data problems and enables them make data-driven-decisions. His specialties include data integration, data warehouse and database development, and BI design. Sam blogs at http://SamuelVanga.com.

Kevin Goff

Twitter: - @KevinSGoff

Contact: http://www.KevinSGoff.net

Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP

Database architect/developer/speaker/author

Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics

Frequent speaker at community events in the Mid-Atlantic region.

Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics

Wayne Sheffield

Twitter: - @DBAWayne

LinkedIn: Wayne Sheffield

Contact: http://blog.waynesheffield.com/wayne

Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne

Adam Belebczuk

Twitter: - @SQLDiablo

LinkedIn: Adam Belebczuk

Contact: http://www.sqldiablo.com/

Adam Belebczuk is the Owner amp; Principal Consultant at Belebczuk Consulting Services, LLC and has more than 10 years of experience in IT, ranging from customer service to server/network administration to software and database development and administration. Adam is the Chapter Leader for the Ohio North SQL Server Users Group, a frequent speaker and volunteer at PASS events, and specializes in SQL Server development, performance tuning, high availability, and disaster recovery.

James Serra

Twitter: - www.twitter.com/JamesSerra

LinkedIn: James Serra

Contact: http://www.JamesSerra.com

James Serra is a big data and data warehousing solution architect at Microsoft. He is a thought leader in the use and application of Big Data and advanced analytics. Previously, James was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 35 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker. He is the author of the book “Reporting with Microsoft SQL Server 2012”.

Wayne Sheffield

Twitter: - @DBAWayne

LinkedIn: Wayne Sheffield

Contact: http://blog.waynesheffield.com/wayne

John Miner

Contact: http://www.craftydba.com

John has twenty-five years of data processing and project management experience. His expertise encompasses all phases of the project life cycle, including design, development, implementation, and maintenance of systems. He is currently a Senior Consultant at Atrion Networking Corporation providing customers with Database and Business Intelligence solutions. When he is not busy at PASS events, he spends time with his wife and daughter enjoying outdoor activities.

J May

Twitter: - @aspiringgeek

LinkedIn: J May

Contact: http://blogs.msdn.com/jimmymay

Jimmy May is a Microsoft Certified Master (MCM). He’s formerly a Principal Architect at Microsoft as well as Senior Program Manager for the SQL Server Customer Advisory Team (SQL CAT) where he managed the Customer Lab which hosts the biggest, fastest, most interesting SQL Server apps from all over the world. More recently he was a SQL Server Technologist for what was Fusion-io’s Data Propulsion Lab (DPL). He is a founder of the IndyPASS IWUG user groups.

Karen Lopez

Twitter: - @datachick

LinkedIn: Karen Lopez

Contact: http://datamodel.com

Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”

Chris Bell

Twitter: - @cbelldba

LinkedIn: Chris Bell

Contact: https://www.wateroxconsulting.com/

Christopher Exley

Twitter: - @ExleyC

LinkedIn: Christopher Exley

Contact: http://www.anexinetbi.blogspot.com/

A Director of Business Intelligence with Anexinet and President of the Philly BI User Group, Chris is a talented BI professional with extensive experience in the field. Demonstrable success in the areas of client relationship management, leading teams of IT professionals, and managing projects. Experience also includes development of strategic vision for BI Practice, creation of sales collateral, development and delivery of client facing presentations, and mentoring team members.

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

Robert Pearl

Twitter: - @PearlKnows

LinkedIn: Robert Pearl

Contact: http://www.sqlservercentral.com/blogs/pearlknows/

Mark Wojciechowicz

Twitter: - @MarkW_BI

LinkedIn: Mark Wojciechowicz

David Bermingham

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

LinkedIn: David Bermingham

Contact: http://clusteringformeremortals.com/

David Bermingham is recognized within the community as a high availability expert and has been honored by his peers by being elected to be a MVP in Clustering since 2010 and most recently has been recognized as a Cloud and Datacenter MVP. David’s work as technical evangelist at SIOS has him focused on evangelizing Microsoft high availability and disaster recovery solutions for both on premise and cloud deployments. He lives in New Jersey with his wife and three kids where he a school board member, scout leader and musical director of an 8-piece jazz band, M-Town.

Ike Ellis

Twitter: - @ike_ellis

LinkedIn: Ike Ellis

Contact: http://blog.ikeellis.com

Ike Ellis is a Senior Data Architect and partner for Crafting Bytes. He has designed and implemented data solutions for many well-known organizations. He has been a Microsoft Data Platform MVP since 2011. He co-authored the book “Developing Azure Solutions,” now in its second edition. He is a popular speaker at SQLBits, PASS Summit, and SQL in the City. He speaks at user groups, code camps, and SQLSaturdays. He has written courses on SQL Server for developers, Power BI, SSRS, SSIS, and SSAS for Wintellect. He has an upcoming course on CosmosDB. He founded the San Diego Tech Immersion Group, a technical book club based in San Diego and is the co-chair of the San Diego Software Architecture Group.

Samuel Vanga

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

LinkedIn: Samuel Vanga

Contact: http://SamuelVanga.com

Theresa Iserman

Twitter: - @TheresaIserman

LinkedIn: Theresa Iserman

Theresa Iserman is a SQL Server Premier Field Engineer at Microsoft. She’s been working with databases for over 15 years and has held roles working with transactional amp; data warehouse systems, web application development, amp; technical project management. Theresa tweets at www.twitter.com/theresaiserman

Justin Dearing

Twitter: - zippy1981

LinkedIn: Justin Dearing

Contact: http://www.justaprogrammer.net

John Deardurff

Twitter: - SQLMCT

LinkedIn: John Deardurff

Contact: https://www.sqlmct.com

John has been a Microsoft Certified Trainer (MCT) for over 20 years teaching Azure, SQL Server, Exchange Server, and Windows Server networking courses. He is currently a SQL Premier Field Engineer for Microsoft. He is an MCT Regional Lead for the Eastern United States and a former Data Platform MVP.

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.

Sharon Dooley

SQLSaturday #390 - Philadelphia 2015

Sessions

Title: Building an Effective Data Warehouse Architecture

Title: Absolute Introductory Session on SQL Server 2014 In-Memory Optimized Databases (Hekaton)

Title: Automating Your SSIS Design Pattern for Faster Development

Title: Social DBA

Title: Table Vars Temp Tables - What you NEED to Know!

Title: Version control with GIT for the DBA

Title: Performance Tuning - Analyzing Execution Plans

Title: A “101” Overview of Microsoft Power BI for Office 365

Title: What’s your Character Type?

Title: But it worked great in Dev! Perfomance for Devs

Title: From Zero to Loading a Data Warehouse

Title: APPLY Yourself

Title: Punishing Yourself with Continuous Delivery

Title: Replicaton Technologies

Title: HealthySQL III

Title: SQL Server Cryptology - A Primer

Title: Stress testing SQL Server

Title: What’s an execution plan and why does it matter?

Title: The Ticking Timebombs in Your Databases

Title: Availability Groups 101: An Introduction

Title: 60 Reporting Tips in 60 Minutes

Title: Storage For the DBA

Title: Change Data Capture in SQL Server 2008/2012

Title: Everything you were afraid to ask about cluster quorums, explained

Title: Flash and SQL Server— Re-Thinking Best Practices

Title: Data Meaning

Title: What’s New in SQL Server vNext

Title: Monster Text Manipulation: Regular Expressions for the DBA

Title: Minion Maintenance and Backup Solutions

Title: DBA 911 - Database Corruption

Title: Visual Studio Online for cost effective code and Project Mgmt

Title: Getting to Know Your DB

Title: Master Data Services– Integration through SSIS

Title: Automate Your ETL Infrastructure with SSIS and PowerShell

Title: Clusters Your Way: #SANLess Clusters for Physical, Virtual Cloud Environ.

Title: Beginning PowerShell Scripting

Title: Optimizing Protected Indexes

Title: Continuous Integration for Databases

Title: Beginner TSQL

Title: Shortcuts to Building SSIS in .Net

Title: Azure SQL Database (Software As A Service)

Title: Interviews and Resumes

Title: Panel: Will the DBA Job of the Future Still Involve DBAs?

Title: Creating a Solid Data Model for PowerPivot

Title: Leveraging CDC and SSIS for ODS/DM/DW Loads

Title: The Restore Cookbook

Title: Maximizing Failure with Continuous Integration

Title: SQL Server 2014 Optimizer “Goodies”

Title: Agile Data Warehouse Development

Title: Connecting Power BI to On-Prem SSAS Tabular

Title: You Want Me To Do What? SQL Security Basics

Title: Hybrid Cloud Scenarios with SQL Server 2014

Title: Crazy Things Developers Do

Title: Get Familiar with Spatial Data

Title: Common Coding Mistakes and how to Mitigate them

Title: Become a SQL Server Performance Detective

Title: To SSAS or not to SSAS, that is the question

Speakers

Sponsors