SQLSaturday #449 - San Diego 2015

Event Date: 09/19/2015 00:00:00

Event Location:

UCSD Extension - University City Center
6256 Greenwich Dr.
San Diego, 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: Universal SQL Installations – Script Review Demo

Abstract: This session is mostly demo-focused. I will cover prerequisites for scripts and show how to do multiple SQL Server installations using scripts and demonstrate how to Streamline SQL Server implementations.

You’ll take-away script to install different versions of SQL Server on supported OS systems. This script allows anyone in IT to install SQL systems with best practices baked into it which ensure all SQL installation can be streamlined.

You’ll see PowerShell scripts where a single line script can install any of these combinations: • Windows 2008R2/2012/2012R2 • SQL 2014/2012/2008R2 (Enterprise/Standard/Developer editions) • Implement best practices and configuration based on available resources for dedicated SQL Server environments

Speaker(s):

Prakash Heda

Track and Room: Enterprise Database Administration Deployment - 316

Title: Execution Plans: What Can You Do With Them?

Abstract: There’s just so much to do to get your systems to run in an optimal fashion, but where do you start. This session will walk you through an extensive checklist of things you can do to better manage your servers, databases and code. We’ll start with server configurations and what you can do with them. We’ll then move through standard administrative tasks that will help with performance. Then it’s off to the intricacies of database design and how that can affect performance. We’ll finish up with T-SQL and where it can hurt or help your systems. All examples in the session will use readily available tools that are a standard part of SQL Server. Get your own systems to run faster with the information you’ll receive.

Speaker(s):

Grant Fritchey

Track and Room: Application Database Development - 306

Title: Building Perfect SQL Servers, Every Time

Abstract: One of the biggest challenges in any large SQL environment is maintaining consistent configurations and meeting the pressures from the business for rapid server deployments. Additionally by default, SQL Server does not install with the best practices for every environment. You will learn best practices for system settings, file system layout and scheduling maintenance tasks. You will learn about what the best practices are for most SQL Server configurations, and how to automate your SQL Server builds in both a physical and virtual world. You will learn about the tradeoffs and benefits to completely automating the build process. You were hear about lessons learned building a private cloud at a Fortune 100 telecommunications company. You will also learn how use these same methods to ensure consistency with your servers whether they are in the cloud, or on-premises.

Speaker(s):

Joseph D’Antoni

Track and Room: Enterprise Database Administration Deployment - 308

Title: SQL 2016 Changes and Enhancements for BI and Beyond

Abstract: Operational Analytics: Insights on operational data, works with in-memory OLTP or on disk

In-memory OLTP enhancements: Greater T-SQL surface area, terabytes of memory supported and greater number of parallel CPUs

Query Data Store: Monitor and optimize query plans with full history of query execution

Native JSON: Parsing storing of JSON as relational data exporting relational data to JSON

Temporal Database: Track historical changes

PolyBase: Manage relational non-relational data with the simplicity of T-SQL

Power Query for Analytics and Reporting: Pull data from countless sources into data models and reports

Enhanced SSIS: Designer support for previous SSIS versions and support for Power Query

Enterprise-grade Analysis Services: Enhanced performance and scalability for Analysis Services

Single SSDT in Visual Studio 2015: Build richer analytics solutions as part of your development projec

Speaker(s):

Charles Hyman

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

Title: The Database: The Elephant in the ALM Room

Abstract: Many teams and individuals are still building their databases and maintaining them through old-fashioned manual processes. This, even as these same teams move towards an automated Application Lifecycle Management (ALM) through the adoption of DevOps best practices. These manual processes are hurting the ability of your database deployments to keep up with modern development. Is there a technical reason for this slow adoption of ALM best practices in the database world, or is there a cultural problem preventing a reassessment of these manual processes? Or, could it be both? This session will address these questions as it explores the challenges presented by ALM for databases. We will discuss the necessary first steps required to move from a manual database deployment process to a fully automated one. You will learn about tooling that can assist you in implementing these new processes. Your database deployments can take advantage of the same processes you use for application deployments.

Speaker(s):

Grant Fritchey

Track and Room: Application Database Development - 306

Title: Introduction to SQL Server Reporting Services

Abstract: Are you tired of users constantly coming to you for data? Would like to be able to quickly and easily enable your uses to go get the data themselves? Do you simply not have the budget/executive buy in to buy a solution? In this session you will see how easy this often overlooked and underutilized feature of SQL Server is to use. This session will start with a quick overview of some reporting examples and will then cover the basics of developing, publishing and using an SSRS report. It will cover all aspects from connecting to the data source through putting the data on the page to publishing to the report server. You will learn how you can return to the office and present meaningful data to your end users with minimal time and effort with this very powerful and easy to use tool that can relieve you from data delivery tasks and thrill your end users all at the same time.

Speaker(s):

Ted Stathakis

Track and Room: BI Information Delivery - 316

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 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 Backup scales 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: Enterprise Database Administration Deployment - 306

Title: A Masters Passport to Extended Events

Abstract: As is commonly the case, all good things come to an end. And now is as good a time as any for the use of SQL Trace and Profiler to come to an end. Let’s face it, Trace was a good tool and had some wonderful uses. Profiler for that matter was a good tool and was useful at times. It is time to let those old tools retire gracefully and move into the world of XE. This full day workshop will provide you the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer.

This session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties. This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact.

Speaker(s):

Jason Brimhall

Track and Room: Enterprise Database Administration Deployment - 309

Title: Designing Stored Procedure Solutions

Abstract: With a little T-SQL experience, you can create a stored procedure that completes a task. But it’s harder to formulate a stored procedure solution with the big picture in mind. In this session, we will work through a real world scenario to develop a thorough solution. You will learn about:

Asking the right questions to set yourself up for success Making the case for stored procedures over ad hoc code and other objects Pro tips for standardization and cross-version compliance Reevaluating and expanding on your solution Limiting inputs to reduce unexpected behaviors and errors Choosing between alternate solutions Evaluating for performance

This session is for data professionals who can write T-SQL, but haven’t spent a lot of time in SQL development.

Speaker(s):

Jennifer McCown

Track and Room: Application Database Development - 308

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 - 307

Title: Universal SQL Installations - Part 1

Abstract: In this session Prakash will walk through the process he has implemented to alleviate many of the pain points for deploying, managing, and supporting multiple SQL Server deployments from development to production. There are several variables to consider when supporting SQL Servers in the real world, including Cloud/VMware/Physical systems, Different SQL server versions, OS/Memory/Disk related configurations. You will learn…- A process which help configure SQL servers with optimal performance considerations- Consistent SQL support Env’s help improve DBA productivity and reduce production issues- Configuration changes to be requested from windows admin/ network admin/ storage admin to be planned in advance- Flexibility to easily add new SQL configurations to support new applications

Session 2 will cover script review and demo…

Speaker(s):

Prakash Heda

Track and Room: Enterprise Database Administration Deployment - 316

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: Enterprise Database Administration Deployment - 306

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 Information Delivery - 316

Title: Master Data Management with SQL Master Data Services (MDS) and Maestro

Abstract: In this session, we will focus on how to formulate a Master Data Management (MDM) strategy and build a solution to find the single version of the truth, aka the Golden Record. While these techniques can apply to any data domain, we will demonstrate building a sample customer domain, showing how to leverage SQL Server Master Data Services (MDS) and other tools for data quality, matching, and de-duplication across multiple data sources.

Speaker(s):

Pam Matthews

Track and Room: Information Delivery - 309

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 - 313

Title: Architectural Designs Driving SQL Server Performance Availability

Abstract: DBAs are often asked to design database infrastructure for new applications or upgrade existing systems. Therefore, they must have a keen understanding of the application’s requirements, operational environment, and infrastructure so they can recommend the best approach.

In this session, you’ll learn about the latest advancements in storage technology, the various ways flash can be deployed (flash caching, server-side PCIe flash, hybrid, and all-flash), and the pros and cons for each. We’ll also discuss how a well-designed infrastructure can drive efficiencies and help your organization save on licensing and maintenance costs.

Speaker(s):

Sumeet Bansal

Track and Room: Strategy and Architecture - 307

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 - 309

Title: Dive into the Query Optimizer - Undocumented Insight

Abstract: This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.

Speaker(s):

Benjamin Nevarez

Track and Room: Application Database Development - 313

Title: DBA Monitoring and Maintenance Fundamentals

Abstract: The key to becoming a great DBA is time. The best way to regain some time is by spending less time doing the daily mundane work. Let this mundane effort work autonomously. We will introduce the basics in monitoring and maintenance. The how and why certain things should be done at a minimum and what things can be done to help improve the quality of life in larger dynamic environments.

Speaker(s):

Warren Sifre

Track and Room: Enterprise Database Administration Deployment - 316

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 - 308

Title: Silent Killers Lurking in Your Database Design

Abstract: A good database design goes deeper than the rules that Codd gave us. We need to leverage SQL Server to help enforce these rules. In this class we’ll look at some common questions like: I have foreign keys, why do I need foreign key constraints too? Why are smart keys not so smart? If I use an identity field, do I still need to declare it as a primary key? The wrong answers to these questions can slow your queries down over time and even create bad data. Join me in my session as we look at demos to understand how silent killers can begin to lurk in your database.

Speaker(s):

Mickey Stuewe

Track and Room: Application Database Development - 313

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: Application Database Development - 306

Title: Understanding the SQL Server Transaction Log

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

Speaker(s):

Randy Knight

Track and Room: Application Database Development - 313

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 - 309

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

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

Speaker(s):

Ami Levin

Track and Room: Application Database Development - 307

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: Application Database Development - 313

Title: Database Administration for the non-DBA

Abstract: So you are a developer or a systems admin and you’ve just been handed a SQL Server database and you’ve got no idea what to do with it. I’ve got some of the answers here in this session for you. During this session we will cover a variety of topics including backup and restore, recovery models, database maintenance, compression, data corruption, database compatibility levels and indexing.

While this session won’t teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to better know what to look for.

Speaker(s):

Denny Cherry

Track and Room: Enterprise Database Administration Deployment - 306

Title: Configuring SQL Server for a successful SharePoint Server Deployment

Abstract: In this session we will introduce some of the main features of SharePoint Server 2013 and explain how to optimize SQL Server platform for a successful SharePoint Server deployment. Come and learn those SQL configuration settings that will make the difference when people start using and adopting SharePoint.

Speaker(s):

Haaron Gonzalez

Track and Room: Enterprise Database Administration Deployment - 316

Title: In-Memory Columnstore Indexes–Make Your Data Warehouse Fly

Abstract: Columnstore indexes were introduced in SQL Server 2012, along with a new type of query processing “batch mode”. In SQL 2014 they get even better–we can use a Columnstore index as a clustered index and update it. In this session we will explore the basics and beyond of Columnstore indexes and how they can help your warehouse performance. We will also examine their impact to insert and update performance, and the best use cases for implementation.

Speaker(s):

Joseph D’Antoni

Track and Room: BI Platform Architecture, Development Administration - 308

Title: Murder They Wrote

Abstract: Join Microsoft Certified Master, Jason Brimhall, as he examines numerous database design and coding implementations that they have seen over the years. They will explore these implementations and show how they can be murder on SQL Server in terms of performance, security, storage and even accuracy. You will learn how you can identify these “killers” and how you can implement alternatives that will keep data professionals, management, and end-users happy. All while keeping your databases happy, secure, turbo-charged and healthy. This is the Solo version of the Joint version normally done as an all-day precon.

Speaker(s):

Jason Brimhall

Track and Room: Enterprise Database Administration Deployment - 309

Title: Code Sins

Abstract: It’s impossible to follow every best practice all the time. “Code sins” are those things we do to our code that are either so horrendous that they can’t be borne, or that have such tremendous consequences that your stored procedures wish they’d never been created. Attendees will hear about the most common code sins that make code difficult to read, support, run and extend, and practical strategies for reversing the trend.

Speaker(s):

Jennifer McCown

Track and Room: Application Database Development - 308

Title: SQL 2012 Programmability Enhancements

Abstract: With SQL 2012 comes a slew of enhancements on the Programmability side. This session will explore some of those new features such as Analytic Functions, Over Clause (Window Functions), Date Functions, Conversion Functions, Sequence Objects, Paging and FileTables to name just a few. If you want to get a jump on those features you will be seeing in SQL 2012 this is the session for you.

Speaker(s):

Andrew Karcher

Track and Room: Application Database Development - 308

Title: Overview of Open-Source Tools of the Hortonworks Data Platform

Abstract: I will present an overview of the open-source tools of the Hortonworks Data Platform for Hadoop applications development. In particular, we will examine (1) Sqoop for moving data between relational databases and Hadoop, (2) Pig as a platform for complex data transformations and (3) Hive as a tool for data analysis that allows writing ad-hoc SQL-like queries against large datasets.

Speaker(s):

Svetlana Marinova

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

Title: Extended Events - Better than Profiler

Abstract: Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.

Speaker(s):

Jason Brimhall

Track and Room: Enterprise Database Administration Deployment - 309

Title: Changing Your Habits to Improve the Performance of Your T-SQL

Abstract: Do you dread handing your T-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your T-SQL? In this demo heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn about formatting T-SQL for readability and why top down design is not the best solution for writing T-SQL. You’ll learn why implicit conversions slow queries down and how to leverage simple techniques for minimizing the performance impact of explicit conversions. By changing some of your T-SQL writing habits you can improve performance of queries from the very beginning.

Speaker(s):

Mickey Stuewe

Track and Room: Application Database Development - 313

Title: Physical Join Operators

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

Speaker(s):

Ami Levin

Track and Room: Application Database Development - 307

Speakers

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

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.

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.

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.

Denny Cherry

Twitter: - mrdenny

LinkedIn: Denny Cherry

Contact: https://www.dcac.com

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

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.

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.

David Dye

David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa

Charles Hyman

Mr. Hyman is an IT professional with over twenty years experience, currently specializing is Business Intelligence, Data Warehousing and Back-End Process IT systems. Mr Hyman currently splits his time, between consulting assignments, and mentoring/training assignments. Mr. Hyman is considered an Expert in the Microsoft SQL Server Products as well as the ETL and Reporting tools, BizTalk and SharePoint. Building Data Warehouses from disparate systems is his specialty

Ami Levin

Twitter: - ami_levin

LinkedIn: Ami Levin

Contact: http://www.amilevin.com

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

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

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.

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Ami Levin

Twitter: - ami_levin

LinkedIn: Ami Levin

Contact: http://www.amilevin.com

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.

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

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

Denny Cherry

Twitter: - mrdenny

LinkedIn: Denny Cherry

Contact: https://www.dcac.com

Benjamin Nevarez

Twitter: - @BenjaminNevarez

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

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.

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.

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.

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

Contact: http://joeydantoni.com

Prakash Heda

Twitter: - @prakashheda

LinkedIn: Prakash Heda

Contact: http://www.sqlfeatures.com/

Prakash Heda works as Manager (Data-IT) at SSC Advent. His expertise encompasses the work of automation, performance tuning/troubleshooting, high availability, san configuration and windows administration. Heda has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Heda holds certifications for MCDBA and MCITP. His background includes administration development using VB/ASP/SSIS with SQL server 2000 to 2017. He is an active member of PASS, SQLSaturday, and as well a frequent presenter at user groups, SQLSaturdays, and other community events. He is also an avid tweeter, blogger and runner.

Sean McCown

Twitter: - @KenpoDBA

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

Ted Stathakis

Twitter: - fishheadted

LinkedIn: Ted Stathakis

Contact: http://fishheadted.com

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.

Svetlana Marinova

Svetlana Marinova is Hortonworks Data Platform Certified Developer and Microsoft Certified Professional with more than 10 years of experience in object-oriented programming. Her expertise includes data modeling, database development and data warehousing with focus on T-SQL. She authored a doctoral dissertation in the area of parallel algorithms with database application.

Warren Sifre

Twitter: - WAS_SQL

LinkedIn: Warren Sifre

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

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.

Jennifer McCown

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

LinkedIn: Jennifer McCown

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

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

Sean McCown

Twitter: - @KenpoDBA

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

Ted Stathakis

Twitter: - fishheadted

LinkedIn: Ted Stathakis

Contact: http://fishheadted.com

Warren Sifre

Twitter: - WAS_SQL

LinkedIn: Warren Sifre

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

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

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

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

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Denny Cherry

Twitter: - mrdenny

LinkedIn: Denny Cherry

Contact: https://www.dcac.com

Warren Sifre

Twitter: - WAS_SQL

LinkedIn: Warren Sifre

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

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

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.

Haaron Gonzalez

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

LinkedIn: Haaron Gonzalez

Contact: http://msmvps.com/blogs/haarongonzalez/

Consultant specialized in collaboration and content management devoted to design mission critical solutions for companies where content and knowledge management are their strategic investment. Since 1997 have been evolving with Microsoft Platform and today have the opportunity to engage with clients around the globe. Microsoft Most Valuable Professional in ASP/ASP.NET since 2005 and Microsoft Most Valuable Professional in SharePoint Server since 2009

Andrew Karcher

Twitter: - @akarcher

Contact: http://www.andrewkarcher.com

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.

Prakash Heda

Twitter: - @prakashheda

LinkedIn: Prakash Heda

Contact: http://www.sqlfeatures.com/

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

Contact: http://joeydantoni.com

Benjamin Nevarez

Twitter: - @BenjaminNevarez

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

Sumeet Bansal

Sumeet Bansal as a VP of IT and lead DBA implemented flash technology at wine.com in late 2009 to solve critical business problems. He has over 16 years of IT experience covering database platforms such as Oracle and SQL Server along with datacenter architectures. Sumeet has been the resident SQL Server and database expert at several top flash companies including: Fusion-io, Violin Memory and most recently Tegile.

Pam Matthews

Contact: http://www.profisee.com

Pam Matthews is Director of Customer Solutions with Profisee. Profisee is the successor to the company Stratature that built the SQL Server Master Data Services (MDS) product which Microsoft acquired in 2007. Profisee focuses on Master Data Management (MDM) solutions. Pam has spent the last 10 years providing training, support and implementation assistance to customers implementing master data management projects utilizing MDS.

Warren Sifre

Twitter: - WAS_SQL

LinkedIn: Warren Sifre

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

SQLSaturday #449 - San Diego 2015

Sessions

Title: Universal SQL Installations – Script Review Demo

Title: Execution Plans: What Can You Do With Them?

Title: Building Perfect SQL Servers, Every Time

Title: SQL 2016 Changes and Enhancements for BI and Beyond

Title: The Database: The Elephant in the ALM Room

Title: Introduction to SQL Server Reporting Services

Title: Minion Maintenance and Backup Solutions

Title: A Masters Passport to Extended Events

Title: Designing Stored Procedure Solutions

Title: Data Modeling for Integration of RDBMS with NOSQL

Title: Universal SQL Installations - Part 1

Title: Monster Text Manipulation: Regular Expressions for the DBA

Title: Better Report Development and Management Techniques

Title: Master Data Management with SQL Master Data Services (MDS) and Maestro

Title: Understanding Parameter Sniffing

Title: Architectural Designs Driving SQL Server Performance Availability

Title: Introduction to Azure Machine Learning

Title: Dive into the Query Optimizer - Undocumented Insight

Title: DBA Monitoring and Maintenance Fundamentals

Title: A NoSQL Primer for the SQL Server Developer

Title: Silent Killers Lurking in Your Database Design

Title: Things You Should Never Do In Microsoft SQL Server

Title: Understanding the SQL Server Transaction Log

Title: Building Your Way to Better Database Testing

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

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

Title: Database Administration for the non-DBA

Title: Configuring SQL Server for a successful SharePoint Server Deployment

Title: In-Memory Columnstore Indexes–Make Your Data Warehouse Fly

Title: Murder They Wrote

Title: Code Sins

Title: SQL 2012 Programmability Enhancements

Title: Overview of Open-Source Tools of the Hortonworks Data Platform

Title: Extended Events - Better than Profiler

Title: Changing Your Habits to Improve the Performance of Your T-SQL

Title: Physical Join Operators

Speakers

Sponsors