SQLSaturday #497 - Huntington Beach 2016

Event Date: 04/02/2016 00:00:00

Event Location:

Goldenwest College
15744 Goldenwest Street
Huntington Beach, California

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: Mastering Master Data Services

Abstract: As your organization grows, one challenge will be the management of data between systems and organizational units. With MDS, Microsoft provides the ability to have one accurate source of non-transactional data. This data can then be used within applications, other databases, and ETL processes. By leveraging data stewards to help manage the data repository, you can ensure that your MDS data is always up-to-date and accurate.

In this presentation we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this presentation, you will have a good understanding of what master data management is, what MDS does, how to use it, and how to get started with your own MDS project.

Speaker(s):

Jeff Prom

Track and Room: BI Platform Architecture, Development Administration - Humanities 307

Title: Rock Your Technical Interview (Part 2)

Abstract: Have you ever not gotten a job because you weren’t prepared for the interview? Would you like a big raise? Do you need motivation to rock your career? I’ve interviewed 100’s of software developers and will share my knowledge on how to survive, what we look for and even divulge some of the secrets we use during the process. Whether you are looking for a new position within your company or at a new company you need to attend this session. Included are crazy and strange interview stories from engineers just like you! Learn tips to get you started, working with recruiters, getting prepared, the technical interview and more. You will also learn what is the #1 question you need to ask during an interview… it’s a game changer! Make sure you attend part 1!

Speaker(s):

David McCarter

Track and Room: Other - Humanities 208

Title: Protecting your data in the Cloud

Abstract: Are you concerned about moving to cloud, because of the safety of your data ? Organizations choose to go with the platform services of Azure using SQL Databases or they go with the Infrastructure services of Azure using virtual machines, in both cases security of your data is vital. This demo driven session will give you all the information you need to know about the security implementations available in SQL Databases in Azure and SQL Server. The session will cover the following topics with demos. Introduction to cloud adaptation of the organizations, - how enterprises adopt to the cloud and how startups are moving to the cloud. SQL relational store options in Azure. Security features of SQL Databases Cloud demanded security features of SQL Servers Using Azure Key Vault to secure data in SQL Server

Speaker(s):

Vijayakumar Thurupathan

Track and Room: Cloud Application Development Deployment - Humanities 303

Title: SQL Injections and How to Stop Them

Abstract: Right now, there are hackers all around the world trying to get into your web applications. How safe are you? By using a technique called SQL injections, hackers can wreak havoc with web applications by compromising security, manipulating data, hoarding system resources, retrieving sensitive information, and manipulate data database objects such as dropping databases!

During the demo, we will take on a couple of different roles. As a hacker we will walk through steps a hacker might take to compromise a web application in order to retrieve sensitive data such as credit card information, usernames, passwords, and social security numbers. Assuming the role of a developer, we will then show various prevention techniques and their effectiveness in preventing SQL injections.

Attend this session to learn how SQL injections work, identify if you are being attacked, and how to stop them.

Speaker(s):

Jeff Prom

Track and Room: Strategy and Architecture - Humanities 307

Title: Rock Your Technical Interview (Part 1)

Speaker(s):

David McCarter

Track and Room: Other - Humanities 208

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 cut that work from hours or days to minutes or even seconds. Stop writing code manually and let regular expressions do it for you. 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: Enterprise Database Administration Deployment - Health Sci. 131

Title: Data Modeling for Integration of RDBMS with NOSQL

Abstract: Join us to explore how emerging data modeling methods and model notations help us define, and easily communicate, robust integration points between NOSQL data stores and emerging RDBMS ‘Lean Data Warehouse’ models that would otherwise be challenging to map across due to radical differences in normalization. Did you buy the pitch about how ‘BigData and RDBMS Data Warehouses can remain in isolation’. Me neither! You will leave this sessions not only free from some rigid E/R modeling assumptions and diagramming standards, but also armed with an introduction to a practical method of logical data modeling in the new world of polyglot data storage.

Speaker(s):

Daniel Upton

Track and Room: Strategy and Architecture - Health Sci. 117

Title: Mastering and Enhancing Company Data

Abstract: Getting a good 360 degree view of organizations (customers or vendors) or doing customer centric analysis is often complicated as a result of bad data/ duplicate data / inconsistent data coming from multiple systems. In addition, there are external factors like mergers and acquisitions, inter-company relationships and other nuances that may not be captured in source systems. Getting a clear picture of customer and vendor data can not only provide a clear picture for analysis of information, but also aid in critical risk management functions. In this session, you will learn about some techniques and data services from DB that you can use to clean and enhance your data.

Speaker(s):

Rushabh Mehta

Track and Room: BI Platform Architecture, Development Administration - Health Sci. 120

Title: PolyBase in SQL Server 2016: Query Hadoop with ease

Abstract: With the increased volumes of unstructured and semi-structured data , organizations are adopting heterogeneous data stores like Hadoop and cloud, requiring new skill sets to operate and making it harder for DBAs to build applications over them. This session will describe PolyBase, a new feature in SQL Server 2016, that will open the doors to data stored outside of SQL Server. PolyBase allows customers to use T-SQL to access and query data residing in Hadoop or Azure blob storage. It can intelligently push-down computation to Hadoop by generating Map jobs on-the-fly as well as scale-out query processing in SQL Server to enable highly performant queries on massive Hadoop data sets.

This session will cover the PolyBase fundamentals of what the feature is, how customers are using it and how it works under-the-covers. In addition, the session will include a Live Demonstration of how PolyBase can be used to bring relational and semi-structured data together using SQL skill sets.

Speaker(s):

Sahaj Saini

Track and Room: Analytics and Visualization - Humanities 307

Title: Be a Role Model for Women in Tech through Blogging

Abstract: Have you wanted to start giving back to our amazing SQL Community through writing, but are not sure how to start? Do you want to start blogging, but are anxious about criticisms? Are you unsure what to write about? I’ll walk through how to find topics to start writing about. I’ll go over tools to help you blog, and websites that you can start blogging about. We’ll discuss why it’s import to be a woman blogger, and I’ll share with you my experience over the last three years as a woman blogger in our community. Role models are needed for women in tech. They need to know that they are wanted in the community and that they have a voice. Be that role model through blogging.

Speaker(s):

Mickey Stuewe

Track and Room: Professional Development - Health Sci. 120

Title: VLDB: Partitioning in SQL Server Standard Edition.

Abstract: Partitioning has long been one of the key feature sets utilized to improve performance or reduce contention within our large tables in SQL Server. However, table partitioning has been solely the prerogative of SQL Server Enterprise edition. You may be asking yourself, “Why is he talking about table partitioning? Didn’t we just establish it’s only available in Enterprise and not available to us Standard edition users?” Even though you’d be correct, there are techniques available to us in Standard edition which would accomplish the same result as table partitioning. Yes, I am talking about partitioned views.

In this session we will go through the steps needed to configure and use the partitioned views to achieve the same result as table partitioning. We will also configure the maintenance jobs to demonstrate the sliding window functionality, and for those of us who are lucky to have Enterprise edition, we will see how to be able to take advantage of combining the use of both partitio

Speaker(s):

Konstantin Melamud

Track and Room: Enterprise Database Administration Deployment - Humanities 307

Title: Query Processing in In-Memory OLTP (Hekaton)

Abstract: In-Memory OLTP (code name: Hekaton) is the most important new feature in SQL Server 2014, and this session will teach you how query processing and optimization work with this new database engine. After explaining the basics, we will discuss how the query optimizer is used in In-Memory OLTP by both natively compiled stored procedures and by traditional stored procedures accessing memory-optimized tables through the query interop functionality. We will also take a look at how the new hash and range indexes are used, as well as how their performance implications are also covered along with the process of translating the plan created by the query optimizer into C code. Finally, some limitations with the current release will also be explained.

Speaker(s):

Benjamin Nevarez

Track and Room: Application Database Development - Health Sci. 117

Title: Power BI Desktop – A BI developer’s view

Abstract: Power BI Desktop is the new self-service entry in the Microsoft BI development landscape but what does it offer the professional BI developer? This session will explore Power BI Desktop features for data accusation and manipulation, sample some of the visualization provided and review the deployment options.

Speaker(s):

Phil Robinson

Track and Room: BI Information Delivery - Humanities 303

Title: Connecting Power BI to On-Prem Data with SSAS

Abstract: Microsoft Power BI is going great places. Its great visualizations, easy-to-use tools, and robust sharing capabilities are improving with new releases almost every time you turn around. But, what if uploading or storing your company’s data in the cloud is a potential deal-breaker? Fortunately, the Microsoft Power BI Gateway - Enterprise make it possible to live query data in an on-premises SSAS instance for display in Power BI. In this session, we will go through what this gateway does, how it works, and how it is installed to show that BI in the cloud doesn’t require data in the cloud.

Speaker(s):

Kerry Tyler

Track and Room: BI Information Delivery - Humanities 305

Title: 3 Skills Every Junior DBA Must Know

Abstract: You’re just getting started as a SQL Server Database Administrator – or you’re trying to get there. You’re confused about exactly what you need to learn to master the basics of the job. Kendra Little has been there, and she can help! In this session she’ll explain three critical skills that every Junior DBA must master. You’ll leave this session with free scripts and an itemized, online training plan to achieve your goals.

Speaker(s):

Kendra Little

Track and Room: Enterprise Database Administration Deployment - Health Sci. 131

Title: Cisco and Nimble Storage: Partners to Create a Next Gen SQL Server Solution

Abstract: SQLHA founder Allan Hirt is a Microsoft Cluster MVP, consultant, and trainer who specializes in all things related to mission critical SQL Server - high availability, disaster recovery, consolidation, virtualization, administration, and more. Based in the Boston, MA area, he travels all over the world to work with and train clients. Allan is currently working on the book Mission Critical SQL Server.

Speaker(s):

Ed Cho

Track and Room: Enterprise Database Administration Deployment - Health Sci. 117

Title: Mysteries of Data Masking Revealed - in Azure, SQL Server, and beyond.

Abstract: Data Masking, or Data De-identification, is a technique allowing a database practitioner to hide data with “false” values. Done in response to the compliance regulations such as HIPAA, GLBA, PCI and other, it allows securing data in variable ways based on the user role in the organization. Data Masking is not encryption! The strategies and algorithms would differ whether you need to use it in production or non-production environment and whether you need to apply it enterprise -wide or in separate applications. Learn about data masking as a part of privacy - by -design strategy and how to decide what to use and where.

Speaker(s):

Yevgeniya Mushkatblat

Track and Room: Application Database Development - Humanities 307

Title: A NoSQL Primer for the SQL Server Developer

Abstract: You have all probably heard about this “NoSQL” thing and wondered what is about, how does it differ from SQL Server and how will this affect me. You might want to just stick your head in the sand and ignore it, but as database professionals it is always good to know about what other technologies might be out there to compliment your existing solutions. We will not be going deep into any one solution, but by the end of this session, the goal will be that you understand the following:

The different types of NoSQL databases
Some use cases where they might be applicable
Some of the major solutions out there for each one

Speaker(s):

Andrew Karcher

Track and Room: Strategy and Architecture - Health Sci. 117

Title: Understanding and Monitoring Tempdb

Abstract: Every SQL Server system that you work with has a tempdb database. In this session, learn how tempdb is structured, what it is used for, and what common performance problems are tied to this shared resource. Gain an understanding of tempdb contention and the snapshot isolation version store and how to detect problems with both. You will leave this session with a new confidence in what configuration and file settings may prevent problems in your environment.

Speaker(s):

Vicky Harp

Track and Room: Application Database Development - Health Sci. 117

Title: Are You Optimistic About Concurrency?

Abstract: What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012’s SNAPSHOT Isolation optimistic? How can SQL Server 2014’s In-Memory OLTP provide truly optimistic concurrency? In this session, we’ll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having totally in-memory storage with no waiting!

Speaker(s):

Kalen Delaney

Track and Room: Enterprise Database Administration Deployment - Health Sci. 131

Title: SQL and VMware - more than just virtualization demos

Abstract: The demos in this session have been developed to illustrate a few key capabilities of VMware vSphere and VMware NSX that can be used to enhance the overall SQL Server implementation. As a true platform of virtualized hardware, vSphere should be considered the premier platform on which to implement SQL Server. Features such as vSphere vMotion, vSphere HA, Distributed Resource Scheduler and Fault Tolerance are complimentary to all the features and capabilities of SQL Server and create an unparalleled combination of the world’s top RDBMS and the world’s most complete and effective virtualization proposition. With network virtualization NSX can provide security enhancements unachievable with any other technology and can streamline SQL server deployment automation processes. Please join us for this demonstration of advanced vSphere and NSX feature functionality and an explanation as to how this enhances your SQL Server environment.”

Speaker(s):

Niran Even-Chen

Track and Room: Enterprise Database Administration Deployment - Humanities 305

Title: Keeping your SQL Objects Safe In Development

Abstract: It has been a long established practice to keep maintain application code in version control. Versioning your application code allows you to view changes made by several developers working on the same project. It allows the team to get the latest changes in a consistent and reliable manner. It allows you to return your code to a prior state. It even acts as a safety net for when that day comes when your developer’s computer won’t turn on.

So, what about your SQL Objects?

Join me in this demo heavy session where we will explore the benefits of versioning your SQL Objects and learn how it can enable streamlined database development without sacrificing control and visibility. We’ll be using Red Gate’s SQL Source Control tool for demos, and we’ll see how it integrates with your existing version control software to manage your SQL Objects just like application code.

Speaker(s):

Mickey Stuewe

Track and Room: Enterprise Database Administration Deployment - Humanities 307

Title: SQL Stretch Database

Abstract: Your SAN consumption is increasing faster than your budget, you have tables so big that you dread re-indexing, or your end-users demand their cold or archived data always be online. There’s a solution that lets you take advantage of the Cloud, on your terms, all without impacting your existing end-user applications or queries. Come find out how you can move your data securely and transparently, free up disc space and reduce your SAN consumption, while retaining full control from the on-premises SQL Server. You’ll reduce maintenance operations time and resources, plus lower overall cost. Learn how SQL Stretch database will simplify your journey to the Cloud!

Speaker(s):

Sapna Jeswani

Track and Room: Enterprise Database Administration Deployment - Humanities 206

Title: The Key to Keys

Abstract: So many of us have learned database design approaches from working with one database or data technology. We may have used only one data modeling or development tool. That means our vocabularies around identifiers and keys tend to be product specific. Do you know the difference between a unique index and a unique key? What about the difference between RI, FK and AK?

These concepts span data activities and it’s important that your team understand each other and where they, their tools and approaches need to support these features.

We’ll look at the generic and proprietary terms for these concepts, as well as where they fit in the database design process. We’ll also look at implementation options in SQL Server and other DBMSs.

Speaker(s):

Karen Lopez

Track and Room: Application Database Development - Health Sci. 131

Title: How to successfully virtualize critical SQL servers

Abstract: Today, many enterprise organizations have already virtualized most of their non critical applications, these organizations are now employing a “Virtual First” policy, harnessing the efficiency and cost savings of virtualization for their most critical applications. Still, many IT architects and DBA’s are hesitant of virtualizing their SQL workloads, they are worried about performance, scale, availability and support for what is usually considered their most critical applications. In this session we will review the guidance for successfully virtualizing critical SQL databases, we will cover the best practices, real world customer experience and what to watch out for when virtualizing the most critical SQL databases. The session is delivered by the same person writing the official SQL on VMware best practices guides.

Speaker(s):

Niran Even-Chen

Track and Room: Enterprise Database Administration Deployment - Humanities 303

Title: Better Report Development and Management Techniques

Abstract: Are you already using Reporting Services (SSRS) but just not loving it? Has it become clumsy, hard to manage or just plain not great? In this session designed for intermediate users with some SSRS knowledge you will see how you can simplify and unify your implementation making your reports pop with polish while shortening your development time and maintenance efforts. An exploration of Shared Data Sets will show how to reduce data discrepancies and improve performance. Learn how to leverage the power of Linked Reports to reduce the number of reports needed and to streamline report publication. Come discover how the ultimate Report Footer can tell you all you need to know about that report, its performance and the users who are running it.

Speaker(s):

Ted Stathakis

Track and Room: BI Platform Architecture, Development Administration - Humanities 206

Title: New Capabilities on top of Microsoft SQL SSAS

Abstract: We will speak about the current BI Market, current BI trends and we will explain how the capabilities of Necto on top of the Microsoft SQL SSAS are a game changer for the BI market and specially for the Microsoft segment.

Speaker(s):

Rony Ross

Track and Room: BI Information Delivery - Health Sci. 131

Title: DB “Time Machine” Never lose more than 1 second of transactions ever again!

Abstract: If you’re like the rest of us, don’t miss the chance to learn how to forget about snapshots and consistency groups forever with Reduxio’s database time machine at SQLSaturday.

Never lose more than 1 second of transactions ever again. Reduxio will showcase their breakthrough Backdating technology that obsoletes existing database backup technologies by providing the ability to instantly recover and clone from any second in the past with no upfront planning or data copy.

Speaker(s):

Ken Smallwood

Track and Room: Other - Humanities 206

Title: How to Bully Your Query Execution Plans

Abstract: Sometimes bad execution plans happen to good queries. You may have heard that it’s better to rewrite complex TSQL– but is using a temporary table better than using query hints? In this session you’ll learn the pros and cons of using hints, plan guides, and the new Query Store feature in SQL Server 2016 to manipulate your execution plans. You’ll take away a checklist of things to do every time you decide to bully an execution plan.

Speaker(s):

Kendra Little

Track and Room: Enterprise Database Administration Deployment - Health Sci. 131

Title: Thinking in SQL

Abstract: SQL is conceptually different than most programming languages. Join us for a conversation about SQL, why it’s different from traditional procedural languages, and how to effectively use this truly elegant programming language. Rather than focus on the kinds of information easily located on the Web, we’ll concentrate on how to use SQL for the tasks that it’s really good at. Beginners will get a great introduction to the style of thought that gets the most out of SQL. Experienced developers will find a good refresher and an opportunity to share their experiences with others.

Speaker(s):

Robert Hatton

Track and Room: Application Database Development - Humanities 305

Title: The Power of Partitioning

Abstract: Overview of Table Partitioning -What is Partitioning?

When to use it? –ETL (Parallelism and Table Locking) –Performance – Data Archiving –Auditing and compliance –Backup and Piecemeal Restore -How to Plan and implement it? -Demo -Union Bank’s Use case

Speaker(s):

Ranjay Singh

Track and Room: Strategy and Architecture - Humanities 303

Title: Understanding Parameter Sniffing

Abstract: Parameter sniffing is a good thing: it is used by the Query Optimizer to produce an execution plan tailored to the current parameters of a query. However, due to the way that the plan cache stores these plans in memory, sometimes can also be a performance problem. This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well. The session will also include details on how the Query Optimizer uses the histogram and density components of the statistics object and some other advanced topics.

Speaker(s):

Benjamin Nevarez

Track and Room: Application Database Development - Health Sci. 117

Title: Flash Storage 101: How Flash Storage Modernizes Database Design

Abstract: NAND flash storage is the new wave of technology hitting data centers and solutions design. With a new technology comes a new set of pros versus cons, new economics and changes in solutions architecture that highlight what it has to offer. This session will give an overview of how the technology works, what to look out for, how to properly POC/test each vendor’s solution and how to modernize your database architecture with this new technology.

Speaker(s):

Matt Henderson

Track and Room: Strategy and Architecture - Health Sci. 120

Title: Optimizing your data warehouse for OLAP Processing

Abstract: Analysis Services have become a major part of upper management daily decision making activities. However, with our DW sizes reaching multiple terabytes minimizing time required to process our data has become our top priority. In this session, we will cover the options we have as DBA’s to improve the performance of our DW processing time. We will look at features and general best practices available to us within SSAS as well as enterprise level features within the database engine itself and how aligning them to work side by side would yield us at least 200% improvement in our processing time.

Speaker(s):

Konstantin Melamud

Track and Room: BI Platform Architecture, Development Administration - Health Sci. 120

Title: Things You Should Never Do In Microsoft SQL Server

Abstract: In this fun session we’ll review a bunch of problem implementations that have been seen in the real world.

Most importantly we will look at why these implementations went horribly wrong so that we can learn from them and never repeat these mistakes again.

Speaker(s):

Denny Cherry

Track and Room: Professional Development - Humanities 305

Title: Effortless Backups with Minion Backup

Abstract: Let’s take the new, free backup tool out for a spin. We can hop through a quick installation, glance at the multi-install PowerShell script, and dance around the table-based schedules, for a start. Afterward we’ll have a long, leisurely walk through some of the best things you can do with MB: backup ordering, pre- and postcode, live insight, striping and mirroring, and of course so much more. Feel free to download MB and follow along on your own laptop!

Speaker(s):

Jennifer McCown

Track and Room: Enterprise Database Administration Deployment - Humanities 305

Title: Managing Hierarchial Data in a Relational Database

Abstract: Managing hierarchical data (such as Budgets, Bills of Material, or Organization Charts) can be a real challenge in a relational database. This session will feature a design pattern that makes it seem almost simple. We’ll see a database schema that is flexible and efficient. We’ll also take some time to discuss common design mistakes. Finally we review a recursive CTE that will allow you to traverse large hierarchies with surprising speed!

Speaker(s):

Robert Hatton

Track and Room: Strategy and Architecture - Humanities 206

Title: Introduction to SQL 2016 Temporal Tables

Abstract: SQL Server 2016 introduces the concept of temporal tables, also called system-versioned tables. This new feature allows SQL Server to automatically keep track of the history of rows in any table for which it is enabled. In this session we’ll cover the basics on how to create and work with temporal tables, including the new FOR SYSTEM_TIME query clause, and we’ll discuss some of the ways that they may or may not fill a need in your environment.

Speaker(s):

Vicky Harp

Track and Room: Application Database Development - Humanities 206

Title: Power BI for the Enterprise

Abstract: Sure, Power BI is a terrific self-service data analysis tool but it’s also an enterprise-class reporting and dashboard tool for serious business data. Learn how to build serious business solutions with on-premises data sources; SQL Server, Analysis Services and other business systems. You’ll also see how you can architect solutions with security and user access control utilizing groups and content packs.

Speaker(s):

Paul Turley

Track and Room: BI Platform Architecture, Development Administration - Health Sci. 120

Title: Data Migrations (using SSIS)

Abstract: We will focus on important concepts, methodologies and do some demos if there is time at the end. If you would like to have an advanced sessions, please send me an email.

Agenda

Infrastructure - What do you need to get started with SSIS?
Methodology, Concepts, Best Practices
If we have time, we may jump to some SSIS demos and share some tips.

Speaker(s):

Eduardo Favio Angeles

Track and Room: Professional Development - Humanities 307

Title: Reporting Services 2016 Solutions: The New Awesome

Abstract: Your old favorite reporting tool just got a lot better. In the new world of SSRS, traditional RDL reports integrate with mobile dashboards, Power BI and Excel. You’ll receive guidance and learn best practices to design and orchestrate integrated reporting and BI solutions with improved Reporting Services features and the new report portal.

Speaker(s):

Paul Turley

Track and Room: BI Information Delivery - Health Sci. 120

Title: Tired of looking for query performance optimizations? Try the Query Store!

Abstract: This session will discuss the fantastic new capabilities of Query Store with SQL Server 2016. It will illustrate what it is, why we want it, how we would use it, and how it is BETTER than any other available performance tuning tools. This session will walk through enabling this feature, leveraging its capabilities, and modifying some of the available options. If attendees walk away with nothing else from this session, remember the LIVE Query Statistics (or Execution Plan). This is a game changer and will greatly impact any on-demand query optimization.

Speaker(s):

Sean Werick

Track and Room: Application Database Development - Humanities 206

Title: Introduction to Azure Machine Learning

Abstract: We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it. This session includes demonstration and use case scenarios. The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.

Speaker(s):

Warren Sifre

Track and Room: Advanced Analysis Techniques - Health Sci. 117

Title: Production SQL Server 2016–Lessons from the Field

Abstract: SQL Server 2016 is almost here–there a ton of new features whether you are a business intelligence pro, a DBA or a developer. In this session you will learn practical lessons learned supporting 2016 in early production environments.

You will learn about:

–AlwaysOn Availability Groups and how they’re better –Columnstore Index changes –What features are for you –Backing up to Azure –The joys of dealing with a rapid release cycle

This session will present a candid view of the 2016 process and why it will be ready for you to roll out on RTM day.

Speaker(s):

Joseph D’Antoni

Track and Room: Enterprise Database Administration Deployment - Humanities 305

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

Abstract: Although technologies have been changing rapidly since the creation of databases, the basic tasks that a database administrator (DBA) has performed have been a stable foundation of professional database design and support. But now NoSQL technologies, the cloud, and new SQL Server features are affecting DBA jobs, tasks, and careers.#160;

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

Speaker(s):

Karen Lopez

Track and Room: Professional Development - Health Sci. 131

Title: Introduction to Azure Streaming Analytics

Abstract: This session will cover what is Streaming Analytics and the various use cases. We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review. The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.

Speaker(s):

Warren Sifre

Track and Room: Cloud Application Development Deployment - Humanities 208

Title: Microsoft Business Intelligence 2016 – More Love for Your Data

Abstract: Heartbroken over Microsoft’s neglect of SSRS over the years? Well the 2016 release might start healing that broken heart. This upcoming release boast a handful of great new items; from connecting SSRS PowerBI to mobile report publishing. Join me while I walk you through the best of 2016 for Business Intelligence and help you fall in love with Microsoft BI again.

Speaker(s):

Tamera Clark

Track and Room: BI Information Delivery - Health Sci. 120

Title: Building Your Way to Better Database Testing

Abstract: Test Data Builders. Ever heard of them? That’s ok. Neither did I before I went looking for a convenient way to set up test data in SQL Server. I will show you what they are and how they work. More importantly, you will learn an easy way to get started and what you can do with them that could make your professional value grow and earn more money. I will also cover some of the design decisions you need to make so that they’ll fit your needs.

Speaker(s):

Phil Helmer

Track and Room: Application Database Development - Humanities 303

Title: How to Get Lightning Fast Answers with Power BI QA and Cortana

Abstract: How to interact with your corporate data right from within the Cortana experience including voice integration for querying your data. How QA can resolve our day today question from organization. How to Use natural language queries to find answers in your own data. Start with a question, and have fun traveling through your data refining or expanding your question, uncovering trust-worthy new information, zeroing in on details and zooming out for a broader view

Speaker(s):

Vishal Pawar

Track and Room: Analytics and Visualization - Humanities 206

Title: Habits of Highly Effective SQL Development Teams

Abstract: t its most fun, software development is a team sport. Think of an NFL team. Does the quarterback know where the running back or tight-end will be? Does he do his job in a vacuum or with coordination and support from his teammates?

However, if the teammate isn’t doing what they’re supposed to do, the play dissolves and leads not only to losing a game, but also individual dissatisfaction. Come to this session to learn how to coordinate and communicate as a team, improving individual and overall developer effectiveness. Learn how to overcome particular obstacles unique to SQL Developers.

Speaker(s):

Ike Ellis

Track and Room: Other - Humanities 305

Title: Building a PowerPivot BI Dashboard

Abstract: Demonstrate the steps to import raw data from text file, Access database and Excel file into Excel 2013, and then build a BI dashboard using PowerPivot and Power Map.

Speaker(s):

Vazi Okhandiar

Track and Room: Analytics and Visualization - Humanities 208

Title: Managing Your Schema with Database Projects in Visual Studio

Abstract: Integrating databases schema changes into a Software Development Lifecycle Management (SDLC) process can be a daunting and often tedious proposition. Adding the complexity of version control to the mix complicates this scenario. Fortunately, beginning with Visual Studio 2012, Database Projects add an “easy” button to this process. In this session, you will learn about the features and capabilities of VS Database Projects and how to use them to improve the lifecycle of your database structures, even if your organization does do code management.

Speaker(s):

Kerry Tyler

Track and Room: Enterprise Database Administration Deployment - Math Sci. 118

Speakers

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

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

Contact: http://joeydantoni.com

Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.

Ed Cho

LinkedIn: Ed Cho

Strategic Partner Marketing Manager who oversees Cisco#39;s partnership with Microsoft.

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.

David McCarter

Contact: http://dotnettips.com

David McCarter is a Microsoft MVP and a principal software engineer/architect in San Diego. He is the editor-in-chief of dotNetTips.com… a web site dedicated to helping programmers in all aspects of programming. David has written for programming magazines and has published three books (the latest is quot;David McCarter#39;s .NET Coding Standardsquot;). He is one of the founders and directors of the 20 year old San Diego .NET Developers Group (www.sddotnetdg.org)

Andrew Karcher

Twitter: - @akarcher

Contact: http://www.andrewkarcher.com

Andrew is a Data Professional that is super passionate about the ability of data to drive change in our world, work, and personal lives. He has over 15 years of experience across multiple roles, companies and technologies. A passion for learning is core to how I approach life. Over 10+ years I have spoken at User Groups, Code Camps, SQLSaturdays and Conferences along with supporting my local community as a SQLSaturday Organizer, User Group leader, and advocate for community involvement for all technology professionals. I was also recognized by Microsoft as a four-time SQL Server MVP for my technical community contributions.

Jennifer McCown

Twitter: - http://www.Twitter.com/MidnightDBA

LinkedIn: Jennifer McCown

Contact: http://www.MidnightDBA.com/Jen

Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.

Phil Robinson

Phil Robinson is an independent consultant focused on developing Business Intelligence solutions using Microsoft Reporting Services and Power BI. He is founder of the San Diego SQL Business Intelligence Group and co-founder of SQLSaturday – San Diego.

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.

Sean McCown

Twitter: - @KenpoDBA

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

Vicky Harp

Twitter: - vickyharp

Contact: http://vickyharp.com

Vicky Harp is the Group PM Manager for the SQL Server Tools Team, which is responsible for the full set of experiences from drivers and scripting libraries, to GUI tools, to the Azure Portal. She has been building tools for SQL Server for 15 years.

Kalen Delaney

Twitter: - sqlqueen

Kalen Delaney is a Data Platform MVP who has worked with SQL Server for more than 32 years. She has provided performance consulting services and taught advanced courses on SQL Server to thousands of people and organizations. In addition to her courseware development, Kalen has been writing about SQL Server for decades. She is the primary author of SQL Server Internals and the Inside SQL Server series. Kalen is also one of the primary editors for the Red Gate SQL Server Stairways tutorials.

Jennifer McCown

Twitter: - http://www.Twitter.com/MidnightDBA

LinkedIn: Jennifer McCown

Contact: http://www.MidnightDBA.com/Jen

Vicky Harp

Twitter: - vickyharp

Contact: http://vickyharp.com

Kerry Tyler

Twitter: - AirborneGeek

LinkedIn: Kerry Tyler

Contact: http://airbornegeek.com

Ranjay Singh

LinkedIn: Ranjay Singh

I have more than 15 years of experience in IT, and a certified MCSD. Currently, working with Union Bank, as Business Intelligence and Data Architect.

I am responsible for conceiving, developing, supporting, and maintaining the bank#39;s 15+ TB data warehouse which is built on the top of Microsoft technology.

I am passionate about educating users on SQL Server by speaking at user groups, conferences,.

I enjoy working on Data Modelling, Partitioning, Performance tuning, SSRS, Power BI, BIML and ALM.

David McCarter

Contact: http://dotnettips.com

Eduardo Favio Angeles

Twitter: - @inkaboy

Senior Software Developer and Systems Architect with extensive experience in designing solutions for complex problems and leading Development Departments or IT Teams, hands on experience in Systems Integration, Application Logic, software design, enhancing human workflows, application programming utilizing best practices, and testing software and database solutions.

Rony Ross

LinkedIn: Rony Ross

Rony Ross is the Founder amp; Executive Chairman of Panorama Software Ltd. Rony previously held the position of Chief Executive Officer since its inception in 1993 and has been the driving force behind Panorama’s success to date. As Executive Chairman, Rony plays a significant role in expanding Panorama’s global presence, leveraging her over 25 years of industry experience and in-depth knowledge of the business intelligence industry. Rony has a strong background in both software development and marketing, and holds a successful track record of managing research and development centers for a number of multi-national software companies before starting Panorama Software in 1993. By 1996, Panorama had become the leading developer and marketer of s

Vijayakumar Thurupathan

Twitter: - thurutweets

LinkedIn: Vijayakumar Thurupathan

Contact: http://www.thuru.net

Thuru is a versatile technical person who has diversified experience in many areas of Information Technology for 6 years. Cloud computing, security, software development, business intelligence and databases are his most preferred technology areas.

He is a frequent speaker in Sri Lanka .NET forum and Sri Lanka SQL Server Universe user groups. Thuru is the founder of Colombo Cloud Meet Up where he often talks about various cloud computing topics. Also he is a Microsoft MVP for Microsoft Azure.

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.

Jennifer McCown

Twitter: - http://www.Twitter.com/MidnightDBA

LinkedIn: Jennifer McCown

Contact: http://www.MidnightDBA.com/Jen

Yevgeniya Mushkatblat

LinkedIn: Yevgeniya Mushkatblat

Contact: http://mask-me.net/Blog_news

Virginia Mushkatblat has 20 years of development and architectural experience with critical data-intensive applications. She has worked in companies ranging from start-ups to international conglomerates with the range of requirements, including those of 24/7 and batch processing, and lead teams of DB developers, architects and administrators. She has worked in entertainment, technology and financial industries. Lately her interests include research in data de-identification and extension of SSIS components.

Vishal Pawar

Twitter: - Vishal_BI

LinkedIn: Vishal Pawar

Contact: http://bimentalist.com/

Vishal Pawar is a Microsoft Data Platform MVP, Microsoft Certified Trainer (MCT), founder of the Global Power BI User Group and co-leader of the PASS Business Analytics Virtual Group. He is a Principal BI Architect in Green House Data, with decades of experience in BI solution architecture and best practices. He has published more than 1000 articles since 2011 in SQL and BI. Vishal teaches a free Power BI course through Udemy, which has more than 65K students from the glob. Vishal is an exceptional technology community of leaders worldwide who actively share their high quality, real-world expertise with the technical communities.

Phil Helmer

Twitter: - @philhelmer

LinkedIn: Phil Helmer

Contact: http://www.philhelmer.com

Phil has been designing and building relational databases in a variety of industries ever since he first realized how many people don’t understand the limitations of Excel and sticky notes as databases. When he was a poor college student, that meant teaching himself MS Access. After moving to SQL Server 13 years ago, he found out about the PASS community and never looked back. He now spends his days developing databases using T-SQL, exploring data management tools techniques and trying to make sense of Microsoft’s marketing.

Benjamin Nevarez

Twitter: - @BenjaminNevarez

Contact: http://www.benjaminnevarez.com/

Benjamin Nevarez is a SQL Server independent consultant based in Los Angeles, California, who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning amp; Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals.quot; Benjamin has also been a speaker at many SQL Server conferences, including PASS Summit, SQL Server Connections, and SQLBits. His blog can be found at http://www.benjaminnevarez.com.

Vishal Pawar

Twitter: - Vishal_BI

LinkedIn: Vishal Pawar

Contact: http://bimentalist.com/

Niran Even-Chen

Twitter: - @niranec

Contact: http://cloud-abstract.com

Niran Even-Chen (@niranec) is a Staff Solution architect at VMware Inc. In his role as a Microsoft enterprise applications architecture specialist Niran is responsible for developing solutions for SQL Server with VMware solutions, writing white papers and is also a frequent speaker in different venues such as VMUG conferences, SQLSaturday user groups, VMworld conferences and more. Niran is certified as VMware certified design expert (VCDX) #142 for datacenter virtualization and Cloud with 15 years of experience in the industry designing and architecting enterprise level solutions.

Daniel Upton

LinkedIn: Daniel Upton

Contact: http://www.slideshare.net/DanielUpton

Daniel is an independent data warehousing implementation consultant based in San Diego. He specializes in Lean Data Warehouse Design. Central features of a Lean Data Warehouse are a loosely coupled, ensemble-based relational data model and generic, pattern-based ETL logic, which together afford transparency and fuller auditability to source data, a robust adaptability by design, simple integration with NOSQL data, and increased automate-ability.

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!”

Phil Helmer

Twitter: - @philhelmer

LinkedIn: Phil Helmer

Contact: http://www.philhelmer.com

Benjamin Nevarez

Twitter: - @BenjaminNevarez

Contact: http://www.benjaminnevarez.com/

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.

Warren Sifre

Twitter: - WAS_SQL

LinkedIn: Warren Sifre

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

Ken Smallwood

Twitter: - @KenSmallwood1

LinkedIn: Ken Smallwood

U.S. Navy Veteran 1977-1990, Navy trained on Combat Systems left service for the Manufacture FMC and continued work on Navy Weapon Systems as Field Engineer, after working in the Defense Industry I decided it was time to transition from Defense. Soon after the gulf war, and worked for a software manufacture. Later I developed a system that formatted five QIC-80 tapes simultaneously. Medionix was formatting data cartridges for Sony, Verbatim, 3M amp; Gigatek. From there disk storage subsystems, Xiotech (A Seagate Company), Dell EqualLogic, HP 3Par, VCE and presently at quot;Reduxio Systemsquot; Patents include World Intellectual Property Organization Patent # WO 98/50920. Published Storage Network Performance Analysis. Degree#39;s from NYIT amp; SUNY.

Jeff Prom

Twitter: - @JeffProm

LinkedIn: Jeff Prom

Contact: http://www.jeffprom.com

Jeff Prom is a Data and BI Developer with over 19 years experience. From a wide variety of industries, he has worked with corporations both large and small including several global fortune 50 companies. Jeff is an active member in the SQL community and regularly speaks and attends user groups and conferences. He has earned MCTS certifications for Database Development, Administration, and BI. Jeff is currently employed at Bridgepoint Education as a Business Intelligence Data Architect.

Benjamin Nevarez

Twitter: - @BenjaminNevarez

Contact: http://www.benjaminnevarez.com/

Warren Sifre

Twitter: - WAS_SQL

LinkedIn: Warren Sifre

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

Kalen Delaney

Twitter: - sqlqueen

Ted Stathakis

Twitter: - fishheadted

LinkedIn: Ted Stathakis

Contact: http://fishheadted.com

Ted Stathakis is a data professional passionate about the presentation layer. He has worked with SQL Server since the turn of the century, has mastered Reporting Services since he began working with it when it was released in 2004, and is super excited about Mobile Reports and Power BI. Ted hosts the local PASS user group, is the organizer of SQLSaturday Orange County and presented on SSRS at Summit in 2019. As a 40+ year veteran of the restaurant industry, he is been an advisor, speaker and panelist at national trade shows. When he isn’t consulting on Business Intelligence projects he can be found presenting at a conference, enjoying some live music or teaching kids, both young and old, fishing and archery at a nearby Scout camp.

Sapna Jeswani

LinkedIn: Sapna Jeswani

Sapna Jeswani is a software engineer at Microsoft in the Data Platforms team, working on StretchDB team in database systems – part of the SQL Server 2016 release. She has been part of the SQL team for 12 years and has experience with both, on premise SQL and SQL AzureDB.

Andrew Karcher

Twitter: - @akarcher

Contact: http://www.andrewkarcher.com

Jennifer McCown

Twitter: - http://www.Twitter.com/MidnightDBA

LinkedIn: Jennifer McCown

Contact: http://www.MidnightDBA.com/Jen

Jeff Prom

Twitter: - @JeffProm

LinkedIn: Jeff Prom

Contact: http://www.jeffprom.com

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!”

Kendra Little

Twitter: - Kendra_Little

LinkedIn: Kendra Little

Contact: http://littlekendra.com

Kendra Little is a Microsoft Certified Master and a Microsoft MVP. Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to become a database administrator for performance critical databases at Microsoft Corporation. Since then, Kendra has worked internationally as a teacher and consultant, and founded the training site SQL Workbooks. She joined Redgate as a Product Evangelist in 2018.

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

Contact: http://joeydantoni.com

Tamera Clark

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

LinkedIn: Tamera Clark

Contact: http://tameraclark.com

Tamera Clark has been involved in the IT industry for greater than ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter, Co-leading the Nashville BI Chapter, assisting the Nashville PASS Chapter and serving as a Regional Mentor. Tamera is also the event chair of SQLSaturday Nashville.

Sean McCown

Twitter: - @KenpoDBA

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

Warren Sifre

Twitter: - WAS_SQL

LinkedIn: Warren Sifre

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

Vazi Okhandiar

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

LinkedIn: Vazi Okhandiar

Contact: https://vaziok.wordpress.com/

Microsoft Certified and CTT+ Certified Trainer with over 20 years of experience in proving Information Technology (IT) training and consulting services to both small and large companies. Corporate Training included in Software Development, Project Management, Database Design and Database Administration at NR Computer Learning Center, mLogica, National University, DeVry Institute of Technology, Orange Coast College and Irvine Valley College. Extensive experience in Software Development, Mobile Application Development, Databases Design amp; Development and Project Management. Previously worked for Toyota, General Motors (GM), Computer Science Corporation (CSC) and Electronic Data Systems (now HP).

Mickey Stuewe

Twitter: - @SQLMickey

LinkedIn: Mickey Stuewe

Contact: http://www.MickeyStuewe.com

Mickey Stuewe has been working with SQL Server since 6.5. That gives her over 20 years of experience. She has not only been a database developer, but also an application developer, even before Visual Studio existed. She is now thankful to be focusing on database design, t-SQL development, and query optimization. She also has a habit of enjoying SSIS and data warehouse design.

She blogs regularly on her website mickeystuewe.com and contributes to sites such as SQL Server Central and SQL Server Pro. She enjoys presenting at PASS Summit, SQLSaturdays, User Groups and other events.

When she is not immersed in SQL related activities, she enjoys action movies, art, reading, and laughing. She laughs loudly and often…just ask her children.

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.

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!”

Matt Henderson

Twitter: - @DatabaseMatt

LinkedIn: Matt Henderson

DBA and architect for over 15 years focusing on high performance SQL Server applications and large scale data warehouses. Matt has been working with SQL on all-flash databases for several years and heads the program at Violin Memory for high performance database tuning for flash devices.

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.

Mickey Stuewe

Twitter: - @SQLMickey

LinkedIn: Mickey Stuewe

Contact: http://www.MickeyStuewe.com

When she is not immersed in SQL related activities, she enjoys action movies, art, reading, and laughing. She laughs loudly and often…just ask her children.

Robert Hatton

LinkedIn: Robert Hatton

Contact: http://www.RobertJHatton.com

Rob Hatton is the author of the Business Intelligence Team Handbook.

Rob is also a past president of the PASS Business Intelligence User Group here in Tampa. He is a veteran B.I. developer with more than 30 years of database experience and dozens of successful B.I. project deployments.

Denny Cherry

Twitter: - mrdenny

LinkedIn: Denny Cherry

Contact: https://www.dcac.com

Robert Hatton

LinkedIn: Robert Hatton

Contact: http://www.RobertJHatton.com

Rob Hatton is the author of the Business Intelligence Team Handbook.

Sahaj Saini

Sahaj is a Program Manager in the SQL Server team at Microsoft. Sahaj works on PolyBase, a big data technology in SQL Server 2016 and other features in Microsoft’s data warehouse offerings Azure SQL Data Warehouse and Analytics Platform System (APS).

Ted Stathakis

Twitter: - fishheadted

LinkedIn: Ted Stathakis

Contact: http://fishheadted.com

Rushabh Mehta

Twitter: - @rushabhmehta

LinkedIn: Rushabh Mehta

Contact: http://blogs.solidq.com/RushabhMehta

Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.

Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data

Konstantin Melamud

Twitter: - @kmelamud

Sean Werick

LinkedIn: Sean Werick

Contact: http://www.seanwerick.com

I have been in the data industry for 15 years, specializing in Microsoft business intelligence for the last decade. I have architected, developed and integrated end to end solutions for customers in various sectors including finance, government, health care and retail. I am extremely passionate about data and the endless possibilities for companies utilizing it in the best ways. I enjoy data science and business intelligence because the possibilities and magnitudes of impact are immeasurable.

Niran Even-Chen

Twitter: - @niranec

Contact: http://cloud-abstract.com

Konstantin Melamud

Twitter: - @kmelamud

Paul Turley

Twitter: - paul_turley

LinkedIn: Paul Turley

Contact: http://www.sqlserverbiblog.com

Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.

Konstantin Melamud

Twitter: - @kmelamud

Kendra Little

Twitter: - Kendra_Little

LinkedIn: Kendra Little

Contact: http://littlekendra.com

Paul Turley

Twitter: - paul_turley

LinkedIn: Paul Turley

Contact: http://www.sqlserverbiblog.com

SQLSaturday #497 - Huntington Beach 2016

Sessions

Title: Mastering Master Data Services

Title: Rock Your Technical Interview (Part 2)

Title: Protecting your data in the Cloud

Title: SQL Injections and How to Stop Them

Title: Rock Your Technical Interview (Part 1)

Title: Monster Text Manipulation: Regular Expressions for the DBA

Title: Data Modeling for Integration of RDBMS with NOSQL

Title: Mastering and Enhancing Company Data

Title: PolyBase in SQL Server 2016: Query Hadoop with ease

Title: Be a Role Model for Women in Tech through Blogging

Title: VLDB: Partitioning in SQL Server Standard Edition.

Title: Query Processing in In-Memory OLTP (Hekaton)

Title: Power BI Desktop – A BI developer’s view

Title: Connecting Power BI to On-Prem Data with SSAS

Title: 3 Skills Every Junior DBA Must Know

Title: Cisco and Nimble Storage: Partners to Create a Next Gen SQL Server Solution

Title: Mysteries of Data Masking Revealed - in Azure, SQL Server, and beyond.

Title: A NoSQL Primer for the SQL Server Developer

Title: Understanding and Monitoring Tempdb

Title: Are You Optimistic About Concurrency?

Title: SQL and VMware - more than just virtualization demos

Title: Keeping your SQL Objects Safe In Development

Title: SQL Stretch Database

Title: The Key to Keys

Title: How to successfully virtualize critical SQL servers

Title: Better Report Development and Management Techniques

Title: New Capabilities on top of Microsoft SQL SSAS

Title: DB “Time Machine” Never lose more than 1 second of transactions ever again!

Title: How to Bully Your Query Execution Plans

Title: Thinking in SQL

Title: The Power of Partitioning

Title: Understanding Parameter Sniffing

Title: Flash Storage 101: How Flash Storage Modernizes Database Design

Title: Optimizing your data warehouse for OLAP Processing

Title: Things You Should Never Do In Microsoft SQL Server

Title: Effortless Backups with Minion Backup

Title: Managing Hierarchial Data in a Relational Database

Title: Introduction to SQL 2016 Temporal Tables

Title: Power BI for the Enterprise

Title: Data Migrations (using SSIS)

Title: Reporting Services 2016 Solutions: The New Awesome

Title: Tired of looking for query performance optimizations? Try the Query Store!

Title: Introduction to Azure Machine Learning

Title: Production SQL Server 2016–Lessons from the Field

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

Title: Introduction to Azure Streaming Analytics

Title: Microsoft Business Intelligence 2016 – More Love for Your Data

Title: Building Your Way to Better Database Testing

Title: How to Get Lightning Fast Answers with Power BI QA and Cortana

Title: Habits of Highly Effective SQL Development Teams

Title: Building a PowerPivot BI Dashboard

Title: Managing Your Schema with Database Projects in Visual Studio

Speakers

Sponsors