SQLSaturday #389 - Huntington Beach 2015

Event Date: 04/11/2015 00:00:00

Event Location:

  • Goldenwest College
  • 15744 Goldenwest Street
  • Huntington Beach, California

PDF of Schedule

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

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: (Near) Zero-Downtime Upgrades!

Abstract: SQL Server upgrades bring enticing new features and much needed enhancements, but can you perform them while maintaining high availability of your SQL Server infrastructure? You can actually do this, by leveraging rolling upgrades, which are upgrades performed with minimal downtime or service disruptions.

In this session you will:

  • Understand how rolling upgrades are better than in place upgrades
  • Learn how to use database mirroring or AlwaysOn Availability Groups for rolling upgrades
  • Explore how you might use Log Shipping to perform a simpler type of rolling upgrade

This is a demo-intensive session, so you can see rolling upgrades live and up close. If you are considering upgrading to a major version of SQL Server, or just applying a Service Pack or a Cumulative Update, this session is for you.

Speaker(s):

  • Argenis Fernandez

Track and Room: Track 2 - Math Science 118


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: Track 5 - Math Science 109


Title: Interactive Actionable Data Visualisation With Power View

Abstract: Historically, users have been constrained to consume data in fixed platforms, with one specific dimension for digital viewings and a couple of printed layouts. Nowadays, with the ubiquitous mobile devices available, Management expects to know key business indicators and day-to-day operation performance on the go. Using well-designed data models and visualization techniques, Power View can leverage timely and quick dashboards for analysis on the go.

This session will discuss how to design the appropriate data model to enable self-service data exploration and insightful analysis in Power View, and how to create pixel perfect visualization for mobile devices. You will also learn how the techniques differ from traditional platforms. Using live demo, we will walk through ways to channel users focus on actionable analytics.

Speaker(s):

  • Julie Koesmarno

Track and Room: Track 3 - Health Science 117


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: Other - Math Science 123


Title: 10 Handy Tips On SQL Server Dates

Abstract: Are you working with an application supporting different time zones and international date formats? How does your choice of storing date / time values differ if you are using Windows Azure SQL Database instead of on-prem SQL Server database? Did you know that SQL Server Database Engine, Integration Services (SSIS) and Analysis Services (SSAS) all have slightly different date / time data types? How can you bullet proof your system for the ever growing data in your organization with much more date and time data to come?

With time being the one thing that constantly changes, date and time calculations are widely used and essential to all business transactions. Yet, most systems only use one or two date data types; Is this a wise decision? Quite often data retrieval relating to a period of time does performs poorly, or worst of all, is not accurate. These 10 tips will help you bridge the gap, and provide the techniques to build bulletproof systems the users demand and DESERVE!

Speaker(s):

  • Julie Koesmarno

Track and Room: Track 3 - Health Science 117


Title: Top 10 Admininistrator Mistakes on SQL Server

Abstract: SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy, nor does it mean is problem free. After all, many apps are growing from small, home-grown applications every year, with green IT professionals encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. There is a short list of mistakes that, if you know of them in advance, will make your life much easier. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.

Speaker(s):

  • Kevin Kline

Track and Room: Track 1 - Math Science 123


Title: Convince Me – Persuasion Techniques That Get Things Done

Abstract: This was the top scoring professional development session from the PASS Summit 2013.

Ever wanted to convince the boss try something new, but didn’t know where to start? Ever tried to lead your peers only to fail to achieve your goals? This session teaches you the eight techniques of influencing IT professionals, so that you can innovate and achieve change in your organization.

  1. Learn about the fundamental difference between influence and authority and how you can achieve a high degree of influence without explicit authority.
  2. Learn the eight techniques of influencing IT professionals, when to apply them, and how to best use them.
  3. Discover the communication and procedural techniques that ensure your ideas get a hearing by bosses and peers, and how to best win support for them.

Speaker(s):

  • Kevin Kline

Track and Room: Track 1 - Math Science 123


Title: Getting Started with Reporting Services

Abstract: Do you wish you could quickly and easily get some or your data into the hands of your end users? Well… SQL Server Reporting Services (SSRS) is part of SQL: You’ve already paid for it, so put it to use! In this introductory level session designed for users with no exposure to SSRS we will cover the basics of developing, publishing and using SQL Server Reporting Services. From building a dataset through automating report delivery you will learn how you can return to the office and present meaningful data to your end users with minimal time and effort. Come learn how this very powerful and easy to use tool can relieve you from data delivery tasks and thrill your end users all at the same time.

Speaker(s):

  • Ted Stathakis

Track and Room: Track 7 - Humanities 208


Title: Power BI Hands-On Micro-Workshop

Abstract: Bring your laptop and let’s build a BI solution using the components of Power BI! You’ll need Office 2013 ProPlus (you can install the trial) and the Power Query add-in. I’ll provide everything else. This 95% demo and uber-fast hands-on lab session will show you how to cleanse and transform data from multiple sources with Power Query, model data for reporting with Power Pivot and then explore the model and build interactive dashboards with Power View. You’ll leave with a working BI solution. Office ProPlus 60 day trial: http://www.microsoft.com/en-us/evalcenter/evaluate-office-professional-plus-2013 Power Query add-in: http://www.microsoft.com/en-us/download/details.aspx?id=39379

Speaker(s):

  • Paul Turley

Track and Room: Track 7 - Humanities 208


Title: Increase your SSIS productivity with Biml

Abstract: Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.

This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand.

Speaker(s):

  • Reeves Smith

Track and Room: Track 8 - Health Science 118


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: Track 4 - Health Science 120


Title: Multidimensional vs Tabular - May the Best Model Win

Abstract: Are multidimensional models dead on arrival? Are tabular models the future of analysis? Come to this session to learn the similarities and differences between these two approaches to analytical modeling first introduced in SQL Server 2012 Analysis Services. We’ll explore the pros and cons of each type of model and review how to select the appropriate model to your analytical requirements.

Speaker(s):

  • Stacia Varga

Track and Room: Track 1 - Math Science 123


Title: Turbo Charged SQL Development With SQL#

Abstract: Turbo charge your SQL Server development with the amazing SQL# CLR library. We will do a quick overview of the SQL# library and then jump into examining a few real world implementations of some of the functions and procedures. Some examples will include string manipulation, file handling, as well as some RegEx usage. There are over 245 procedures and functions, user defined aggregates, and user defined types … and counting. Come explore some of the interesting problems that SQL# can solve. If you’d like to download and view the CLR library ahead of the presentation, you can get most of the CLR features for free at www.sqlsharp.com.

Speaker(s):

  • David Sumlin

Track and Room: Track 6 - Humanities 206


Title: PowerShell for the Reluctant DBA / Developer

Abstract: This presentation will provide a brief overview of how to get started with powershell and will be demo intensive. Demo topics will include common challenges that database professional’s face including: basic code generation, deployment automation, and database discovery. We will also attempt to touch on automation and general script development best practices.

Speaker(s):

  • Jason Horner

Track and Room: Track 2 - Math Science 118


Title: Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Abstract: Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. “Virtualize First” is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too “critical” to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments. Got an SQL virtualization or performance question? Bring it!

Speaker(s):

  • Deji Akomolafe

Track and Room: Track 6 - N/A


Title: Near Real-Time Data Warehouse Updates with CDC SSIS

Abstract: If you need to keep a data warehouse up-to-date in near real-time, Change Data Capture (CDC) is a solution! If you are looking for a way to setup auditing of database changes, CDC is a solution! CDC has been around since SQL Server 2008, but has been underused because it was difficult to fully implement. SSIS 2012 now provides support for CDC with new components that make consuming the captured data very easy to apply. This session will define what CDC is and with live demos show how it is configured. Once it has been setup then you need to consume and apply those changes, this will be demonstrated with live demos using SSIS 2012 to create packages that apply the changes in a way that can be run quickly and keep your data warehouse up-to-date.

Speaker(s):

  • Steve Wake

Track and Room: Other - Humanities 208


Title: SSIS Design Patterns

Abstract: Business Intelligence is what you get when you take raw data and transform it into the valuable information that organizations use to make strategic decisions. But how do you take data from disparate systems, mold it, and bring it together in one place where you can begin the important work of data analysis? Learn about some common SSIS (SQL Server Integration Services) design patterns for loading data into a data warehouse.

Speaker(s):

  • Demian Quinonez

Track and Room: Track 8 - Health Science 118


Title: (Way Too Much) Fun with Reporting Services

Abstract: Head starting to explode from all the technical information you’re absorbing? Come spend a session with us while we play games with Reporting Services…literally! Come watch as Stacia Misner and a special guest introduce you to some word play, all wrapped up in SQL Server Reporting Services. She’ll push the limits with what can be built in SSRS and show you how to have fun while doing it. Board games and SQL…who could ask for more?

Speaker(s):

  • Stacia Varga

Track and Room: Other - Math Science 109


Title: Date Dimension: Past Future in One Script

Abstract: All data warehouses need a date and time dimension to enable proper analysis across time. Most Data Warehouse designers will just use one provided by tools or create it in Excel, but what if you need to set up custom holidays or want different calendars, such as Fiscal or Julian? You can have any date and time dimension you need by using a single SQL script that can be modified and rerun as necessary. Learn what it takes to design a date and time dimension that does all of the calculations and formatting up-front so the reports can be easier to create. Sample script will be provided that creates the date and time dimensions and can be reused as often as necessary without breaking your data warehouse and it only take seconds to run!

Speaker(s):

  • Steve Wake

Track and Room: Track 3 - Health Science 117


Title: Turbo Boost Performance: In Memory Tables index optimizations

Abstract: With the introduction of in-memory based tables in SQL Server 2014, it’s natural to expect significant increases in query performance. But what do we do when queries which utilize in-memory tables actually start to perform same or, in some cases, even worse than their equivalent disk based table predecessors? In this session, we are going to take a look at the changes to the indexing design for in-memory based objects and how it differs from existing disk based table indexing. Also, we are going to cover how to choose the appropriate indexes for your in-memory object to give you the performance boost that you have been expecting.

Speaker(s):

  • Konstantin Melamud

Track and Room: Track 8 - Health Science 118


Title: Building a Modern Data Warehouse and Analytics Solution in Azure

Abstract: For years, data warehouses have required a significant investment in hardware and software. We frequently planned for the three year lifecycle. As virtual machines started to handle the load, we gained additional flexibility. In this session, we will look at the various services in Azure and how they can be leveraged to handle various workloads and capabilities. By blending IaaS, PaaS, and even SaaS in the Microsoft Cloud, we can build highly flexible and scalable solutions to meet our needs large and small. We will look at some designs and their strengths and weaknesses including cost, maintenance, scalability, and elasticity.

Speaker(s):

  • Steve Hughes

Track and Room: Track 4 - Health Science 120


Title: Predicting the future with Machine Learning

Abstract: Machine Learning is Microsoft’s big entry in to the predictive analytics arena. . In this introductory session we will discuss the growing new field of predictive analytics and how Machine Learning is used to predict future results. Instead of staring into crystal balls, Machine Learning provides the ability to experiment to determine which algorithm or R code best analyzes the data to determine if past performance is indicative of the future or use scoring to find a more appropriate model.

Speaker(s):

  • Ginger Grant

Track and Room: Track 4 - Health Science 120


Title: Rock Your Technical Interview (Part 2)

Abstract: Have you ever not gotten a job due to not being prepared for the technical interview? Do you want a big raise? 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. This session will include advice from hiring managers, recruiters and engineers that were recently hired at a new company! Maybe some crazy interview stories for fun.

Speaker(s):

  • David McCarter

Track and Room: Track 7 - Humanities 208


Title: Get Testing with tSQLt

Abstract: tSQLt is a testing framework that is designed to help you write repeatable, isolated tests against your database code. In this session we will briefly examine the goals of testing, where it can be used in an automated deployment pipeline, and introduce you to the tSQLt framework. We’ll show you how to design and write tests to enforce standards, check calculations and other DML operations as well as check exception handling. You will see how a real world refactoring task can be tested in a repeatable manner. Learn how you can incrementally write tests that help you build higher quality code and minimize the introduction of errors against your existing objects.

Speaker(s):

  • Steve Jones

Track and Room: Track 2 - Math Science 118


Title: Top 10 SSIS Tuning Tricks

Abstract: Interested in making SSIS perform faster? Do you wonder what the best practices for writing Packages really are? This session reviews how to create SSIS packages to perform as quickly as possible by revealing the Top 10 things you can do to improve the performance of your packages.

Speaker(s):

  • Ginger Grant

Track and Room: Track 3 - Health Science 117


Title: Rock Your Technical Interview (Part 1)

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. This session (62.5% new material for 2014) will include crazy and strange interview stories from engineers just like you! This session includes 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! Sit close and you just might catch a custom dotNetDave guitar pick. Some of some of them will win you free software!

Speaker(s):

  • David McCarter

Track and Room: Track 7 - Humanities 208


Title: Overview Hadoop for Windows (HDP2.2)

Abstract: As the defacto platform for Big Data Apache Hadoop has matured to occupy a central place in the next generation data architecture. Hadoop does not replace existing technologies rather complements them by adding and enhancing what is possible in the enterprise. In this talk we will dive into the details of Hadoop on Windows exploring each of the components and their functions within an Enterprise Hadoop distribution. He will also discuss some of the common use cases, applications and data types that are being enabled with this new capability.

Audience Key Learning: Key components of Hadoop on Windows and their functions within an Enterprise Hadoop distribution. Use cases, applications and data types that are being enabled with Hadoop.

Speaker(s):

  • Anoop Sunke

Track and Room: Track 6 - Humanities 206


Title: [Sponsor] - SQL Server Monitoring with Spotlight for SQL Server Enterprise

Abstract: Learn about the easiest way to monitor your SQL Server and Windows environment including data collection, historical and real time diagnostics, alarming, notifications, reporting and more.

Speaker: David Swanson

David Swanson is a graduate of the University of Arizona. He has worked in the software industry for 15 years. He has been a developer, a DBA, worked in support, product management and is currently a Database Systems Consult for Dell Software. He assists in product proof of concepts and production implementations with organizations ranging in size from very small to some of the biggest companies in the United States. He lives in the greater Boston area.

Speaker(s):

  • Andrew Karcher

Track and Room: Other - Math Science 123


Title: Locks, Blocks, and Deadlocks Oh My!

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

Speaker(s):

  • Randy Knight

Track and Room: Track 1 - Math Science 123


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

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

Speaker(s):

  • Mike Tutor

Track and Room: Track 5 - Math Science 109


Title: Transaction

Abstract: More likely Transaction logging level inside of LDF file other than just simple rollback and commit transaction. Transaction related issues in real world. Look at inside of Transaction details. And check what’s the best solution for each case. A little bit of minimal logging information.

Speaker(s):

  • Simon Cho

Track and Room: Track 8 - Health Science 118


Title: Visualization Choices: What, When, and How?

Abstract: When do you use a sparkline, column, or line chart? How do you create a business scorecard – and with what tool? Using Excel, Power View, and Report Builder, this session will guide you through the choices and help you apply the right visual to your business data. Come see what well-known industry experts have to say about the correct use of visualization choices and techniques, colors, backgrounds, borders, and 3-D effects. Then see demonstrations of how to create those rich visuals in the different reporting tools, used with PowerPivot and tabular semantic models.

Speaker(s):

  • Paul Turley

Track and Room: Track 6 - Humanities 206


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: Track 7 - Humanities 208


Title: How to Automate SSIS and SQL Agent Job Deployments

Abstract: Are you trying to implement Continuous Integration for your DB? This session will equip you with the basics and tools needed to approach automating SSIS and SQL Agent Job deployments.

There are many blog postings and articles about this but it is not easy to find good working examples of this automation. In this session, I will go over the basics of this automation and discuss the necessary components and possible options that you can use, including a working example of SSIS and SQL Agent Job deployment.

Speaker(s):

  • Yong Ji

Track and Room: Track 8 - Health Science 118


Title: SSIS 2012 Management Considerations and Best Practices

Abstract: SQL Server 2012 introduces a number of exciting new features that will change the way we design, deploy and manage SSIS packages. We will explore the new features, understand how to take advantage of them and formulate some best practices for efficient management of these packages

Speaker(s):

  • Rushabh Mehta

Track and Room: Track 7 - Humanities 208


Title: Continuous Integration for Databases

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

Speaker(s):

  • Steve Jones

Track and Room: Track 2 - Math Science 118


Title: The Ritual of Restoration

Abstract: Through out your journeys as a DBA one thing is inevitable. One day a database will fall in battle and it will be up to you to resurrect it. So do you know the different rituals of restoration that can save your company’s data, and possibly your job? In this session we will discuss; disasters, backups and demo the various ways you can restore a database for production use.

Speaker(s):

  • Tim Hidalgo

Track and Room: Track 6 - Humanities 206


Title: 45 Minutes to Your First SSAS Tabular Model

Abstract: Have you heard about SSAS Tabular, maybe even know a couple things about it, but haven’t had a chance to dive in and figure out how to develop one yourself? Now is the time! SSAS Tabular is a new form of business intelligence model released with SQL Server 2012, intended as an alternative to more traditional Multidimensional cubes. In this session, we will talk briefly about what Tabular is and what it does, before exploring the development process of creating a tabular model ready for ad-hoc querying.

Speaker(s):

  • Kerry Tyler

Track and Room: Track 5 - Math Science 109


Title: Using Premium Data for Analysts

Abstract: Did you know that you can verify business names, addresses and credit status from within Excel?  Big Data also means premium data, but what is it and how do you use it?  Come to this session to learn via demonstrations, what types of premium data are out there, how to get the right data easily (usually from inside of Excel) and how to estimate costs accurately.  We’ll look at Dun Bradstreet, Melissa Data, Strike Iron and more.

Speaker(s):

  • Lynn Langit

Track and Room: Track 3 - Health Science 117


Title: Common TSQL Mistakes

Abstract: We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application’s performance. I have given this talk over SEVENTY times now and it is always very highly rated!

Speaker(s):

  • Kevin Boles

Track and Room: Track 4 - Health Science 120


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

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

Speaker(s):

  • Mike Tutor

Track and Room: Other - Humanities 206


Title: $#*! Your Database Says About Me

Abstract: Does your data sit around mocking your best attempts to support good data practices? Databases are also bound by the GIGO rule: Garbage In is Garbage Out. In this presentation, Karen shows you examples of the types of mistakes, misunderstandings and outright cheats that lead to poor data quality, mistrust in IT systems and overall smelliness in our IT solutions– using real-life evidence of her own data in your systems.

Speaker(s):

  • Karen Lopez

Track and Room: Track 2 - Math Science 118


Title: Table Indexing for the .NET Developer

Abstract: In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2012 databases. We will also be looking into the new indexing features that are available in SQL Server 2012 (and SQL Server 2005-2008) and how you the .NET developer can make the best use of them to get your code running its best.

Speaker(s):

  • Denny Cherry

Track and Room: Track 1 - Math Science 123


Title: Merge Replication 101

Abstract: Merge replication – Some people hate it and some people love it.
Merge replication can be used to provide an autonomous (writable) copy of a database. It is easy to set up and is very failure-resilient. It can be used as a database high-availability method. I will explain why I am a lover of merge replication. I will demonstrate merge replication set up, explain conflict resolution, and tell stories from my experience to illustrate its resilience.

Speaker(s):

  • Diana Dee

Track and Room: Track 8 - Health Science 118


Title: You Wouldn’t Let HR Manage Your DBs…

Abstract: So don’t let them manage your career. This session will be a panel discussion with three long term IT professionals representing several different career tracks in IT. Learn about how your HR organization works, what salary levels and midpoints are, and get great career advice from our expert panel. Presented with Karen Lopez.

Speaker(s):

  • Joseph D’Antoni

Track and Room: Track 2 - Math Science 118


Title: Introduction to Wait Types and Response Time Analysis

Abstract: Using Response Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Response time performance analysis to solve the most difficult performance related issues. 

Speaker(s):

  • Jonathan Shaulis

Track and Room: Track 5 - N/A


Title: Treating Tables Like Legos, Partitioning Basics

Abstract: Partitioning allows us to isolate parts of our table as small chunks called partitions. In turn, these partitions allow us to do some really cool tricks for manageability and performance. In this session we’ll look at the concepts surrounding partitioning and how we can apply them. We’ll reinforce what we cover with some cool demo’s showing some really neat tricks.

Speaker(s):

  • Brandon Leach

Track and Room: Track 5 - Math Science 109


Title: Stored Procedures vs. Ad-Hoc SQL: Performance Showdown!

Abstract: Still not sure of which is faster? Let us put this matter to rest once and for all. We will measure every single aspect of the execution of a stored procedure vs. its Ad-Hoc query counterpart, and only one will prevail! We will look at raw performance, memory consumption, plan cache usage, and network bandwidth utilization. We will also discuss options for environments on which the code cannot be modified.

Speaker(s):

  • Argenis Fernandez

Track and Room: Track 3 - Health Science 117


Title: [Sponsor] The Red Gate Database Lifecycle Management Story w/ Ste

Abstract: We all want a strong and steady engineering process for our database development that allows us to deploy our code in a consistent and safe manner. Come see an overview of how a complex database lifecycle process can work to ensure changes made in development environments are always tested and reviewed, before being deployed in an automated fashion. Learn to Ship Safe, and Ship Often.

Speaker(s):

  • Andrew Karcher

Track and Room: Other - Math Science 118


Title: [Sponsor] Light Up Your SQL Investments with Pyramid Analytics w/

Abstract: Overview of Pyramid Analytics and Demonstration on our BI Office

Speaker(s):

  • Andrew Karcher

Track and Room: Other - Health Science 117


Title: SQL Server Defaults SUCK!!

Abstract: If you just click next-next-next and think you have a good-to-go SQL Server THINK AGAIN!! :-) There are umpteen things you just GOTTA change right out of the box if you want your potentially very expensive and always precious SQL Server resource to perform and behave optimally. This session will cover a laundry list from High Power Setting to data file growth and many useful items in between.

Speaker(s):

  • Kevin Boles

Track and Room: Track 4 - Health Science 120


Title: Poor Man’s AlwaysOn - Readable Secondary w/ Automatic Failover Capabilites on SQL 2008 R2

Abstract: This session will cover the process of creating a readable secondary with automatic failover capabilities. Not everyone can be on SQL 2012 right away or having more than one secondary server for reporting or failover by utilizing Database Mirroring\Log Shipping and Database Snapshot. After this session, you will be able to utilize your reporting/secondary server for more than 1 purpose.

Speaker(s):

  • Harry Chandra

Track and Room: Track 5 - Math Science 109


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: Track 1 - Math Science 123


Title: Azure 101 - Where Do I Start?

Abstract: Have you wanted to get started with Azure but don’t know where to start? Aside from the reasons why to learn Azure, what resources can you use to quickly ramp up your skills for little costs? In this session, you will learn the way to fast track your Azure knowledge. Learn how to either use it as an idea lab to test new features of SQL and other technologies.

Speaker(s):

  • Andrew Nakamura

Track and Room: Track 6 - Humanities 206


Title: SSAS Design and Performance Best Practices

Abstract: A journey through best practices in relation to scalable SQL Server Analysis Services cube design. From dimension design to SSAS engine internals we will explore SSAS multidimensional design patterns that will take you through steps to assist in getting your SSAS cubes better optimized to better match the needs of your organization. After this session you will be able to take these performance design patterns and apply them to new and existing cubes to tune your SSAS cube environment.

Speaker(s):

  • Alan Faulkner

Track and Room: Track 4 - Health Science 120


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: Track 6 - Humanities 206


Speakers

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

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.

Argenis Fernandez

Twitter: - DBArgenis

LinkedIn: Argenis Fernandez

Contact: http://blog.purestorage.com/author/argenisfernandez/

Argenis is a Principal Architect at Pure Storage. He works with customers around the world to make sure they don’t have to worry much about their infrastructure for Data. He is a former Data Platform MVP, former VMware vExpert, Microsoft Certified Master, and more recently worked in the Microsoft Azure Data/SQL Server engineering team as a Principal PM in the Tiger team.

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

Argenis Fernandez

Twitter: - DBArgenis

LinkedIn: Argenis Fernandez

Contact: http://blog.purestorage.com/author/argenisfernandez/

Argenis is a Principal Architect at Pure Storage. He works with customers around the world to make sure they don’t have to worry much about their infrastructure for Data. He is a former Data Platform MVP, former VMware vExpert, Microsoft Certified Master, and more recently worked in the Microsoft Azure Data/SQL Server engineering team as a Principal PM in the Tiger team.

Kevin Kline

Twitter: - kekline

LinkedIn: Kevin Kline

Contact: http://blogs.sentryone.com/author/kevinkline

Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.

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.

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.

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.

David Sumlin

LinkedIn: David Sumlin

David is currently a Senior Database Architect and Consultant within the Enterprise Data amp; Analytics group at Wells Fargo. He has been developing data driven applications and working with SQL Server and many other RDBMS for the last 15 years. He has implemented both small and large OLTP applications as well as large DSS data warehouses.

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.

Jonathan Shaulis

A

Andrew Nakamura

Twitter: - @andrewn2010

LinkedIn: Andrew Nakamura

Contact: http://andynakamura.com

Andrew Nakamura is a SQL DBA at Keck Medicine of USC. His experience spans enterprise wide level of support using Powershell, DBATools and other custom scripts to maintain 115 servers with over 1600 databases. He has expertise in both Financial and Healthcare worlds and knows the challenges they face. He has presented in all Southern California SQLSaturdays and will continue to push bleeding edge solutions. He enjoys the command line syntax and wish like to play with Core Editions of Windows and SQL 2017. He’s added to his current passions of Azure, Automation, High Availability, Family and Faith, Toastmasters, and now, SQL on Linux. Long live the command shell!

Stacia Varga

Twitter: - @StaciaV

LinkedIn: Stacia Varga

Contact: http://blog.datainspirations.com

Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology.

Since 2000, Stacia has provided consulting and education services for Microsoft’s Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.

Ginger Grant

Twitter: - desertislesql

LinkedIn: Ginger Grant

Contact: http://www.DesertIsleSQL.com

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

Stacia Varga

Twitter: - @StaciaV

LinkedIn: Stacia Varga

Contact: http://blog.datainspirations.com

Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology.

Since 2000, Stacia has provided consulting and education services for Microsoft’s Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.

Alan Faulkner

Twitter: - #FalconTekNik

LinkedIn: Alan Faulkner

Contact: http://falconteksolutionscentral.com/

I am an IT professional with over 20+ years of progressive technical experience with managing, consulting, software development, data integration architecture, data warehousing, and business intelligence development projects. The focus of my work is to work closely with stakeholders to develop architecture frameworks that align with organizational strategy, processes, and IT assets. Specializing in Business Intelligence (BI), Data Warehousing, database architecture, design and implementation.

Deji Akomolafe

Contact: http://blogs.vmware.com/apps/

Deji Akomolafe (a Staff Solutions Architect at VMware’s Global Center of Excellence) specializes in the virtualization of Microsoft Business Critical Applications on the VMware vSphere platform. Deji is a regular speaker at VMworld, PEX and EMCWorld, presenting technical subject matters related to virtualization and providing technical guidance to help customer enhance their expertise and ability to optimally virtualize and operate their critical applications.

Kevin Kline

Twitter: - kekline

LinkedIn: Kevin Kline

Contact: http://blogs.sentryone.com/author/kevinkline

Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.

Tim Hidalgo

Twitter: - digitalohm

i like computers and synthesizers and cats

Brandon Leach

Twitter: - SQLServerNerd

LinkedIn: Brandon Leach

A Microsoft Data Platform MVP, Brandon manages the DB Operations team for financial company x. With a data estate of several petabytes, he puts a high focus on performance tuning and automation. He is a frequent speaker at events like conferences and user groups.

Julie Koesmarno

Twitter: - @mssqlgirl

LinkedIn: Julie Koesmarno

Contact: http://www.mssqlgirl.com

Julie Koesmarno, MCSE Data Platform, and MCSE Business Intelligence, MCT, is a Senior Program Manager at Microsoft, with a Bachelor’s degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her past projects include delivering a SQL Server 2012 data warehouse and BI solutions in the US and Australia. She now works with hybrid, cloud and on-prem SQL projects.

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

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.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

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

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.

Diana Dee

Diana Dee has been a Microsoft Certified Trainer since 1996. Since 2005, she has specialized in training and consulting on SQL Server administration, Transact-SQL querying, and database design.
Diana lives in Huntington Beach with her husband and two Labrador retrievers. Diana is one of the authors of TribalSQL (tribalsql.com).

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.

Steve Hughes

Twitter: - dataonwheels

LinkedIn: Steve Hughes

Contact: http://www.dataonwheels.com

Steve Hughes is the Director of Consulting at Pragmatic Works. In his current role, Steve manages the consultant team at Pragmatic Works and directs implementation of our cloud practices for customers. He focuses on team development and company growth with this role. In his previous role as a Principal Consultant Lead, he focused designing solutions for customers on Microsoft technologies including SQL Server, Power BI, and Azure. He has been working with technology for over 20 years with much of that time spent on creating business intelligence solutions and helping customers implement leading BI and cloud solutions. He is passionate about using data effectively and helping customers understand that data is valuable and profitable.

Simon Cho

LinkedIn: Simon Cho

Contact: http://simonsql.com

Simon Cho is one of the founders of SQLAngeles.com, which is a Los Angeles Korean Tech PASS community group.

As a Local Group leader, he is a Microsoft SQL community speaker. He has presented many times at SQLSaturdays and to PASS Local Groups.

He moved his passion to VISA Inc, the largest credit card provider in the world, where he used database technology to build a strong solution and a secure environment, with new strategies and features to maintain thousands of SQL Servers.

He has now joined the Nowcom Corp, as a Director of DevOps, where he leads the DevOps team and DBA team.

He is pretty much working on SQL server running on kubernetes.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

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

Steve Wake

Twitter: - stevewake

LinkedIn: Steve Wake

Contact: http://blog.wakebi.com

Steve Wake is currently the Principal BI Developer at Brown and Caldwell and has experience in consulting, advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full on-premises Microsoft BI stack. Recent experience with the Azure services: Analysis Services, Logic Apps, Data Factory, Databricks, Snowflake and Power BI. Steve is also very involved in the SQL community, speaking at events around the world.

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.

Julie Koesmarno

Twitter: - @mssqlgirl

LinkedIn: Julie Koesmarno

Contact: http://www.mssqlgirl.com

Julie Koesmarno, MCSE Data Platform, and MCSE Business Intelligence, MCT, is a Senior Program Manager at Microsoft, with a Bachelor’s degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her past projects include delivering a SQL Server 2012 data warehouse and BI solutions in the US and Australia. She now works with hybrid, cloud and on-prem SQL projects.

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

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

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

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

Mike Tutor

Twitter: - @SQLTutor

LinkedIn: Mike Tutor

Contact: http://www.sqlsolutionsgroup.com/category/sql-group/

Mike Tutor has been in the IT industry for over 30 years. He has worn many hats, including developer, systems admin, and project manager, but he has worked almost exclusively as a SQL Server DBA since the late 90s. He has worked as a development DBA in the medical research industry for many years, but is currently working as a Sr. consultant at SQL Solutions Group in Lehi UT.

Reeves Smith

Twitter: - SQLReeves

LinkedIn: Reeves Smith

Contact: http://reevessmith.wordpress.com

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

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

Lynn Langit

Twitter: - @lynnlangit

LinkedIn: Lynn Langit

Contact: http://www.lynnlangit.com

Lynn Langit is a Cloud and Big Data Architect. She’s been working with a team on an AWS IoT project this year. Lynn speaks, blogs and creates courses on technical topics for LinkedIn/Lynda.com.

She holds a number of partner awards - Microsoft MVP for Data Platform, AWS Community Hero, Google Developer Expert (Cloud). Her blog is at www.LynnLangit.com. She is also director of the non-profit Teaching Kids Programming (www.TeachingKidsProgramming.org).

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

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.

Benjamin Nevarez

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

Benjamin Nevarez is a SQL Server MVP and 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 Optimization”, “Inside the SQL Server Query Optimizer” and has contributed to other SQL Server books including “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits.

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.

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)

Yong Ji

LinkedIn: Yong Ji

Contact: https://speaksql.wordpress.com/

Yong Ji is a Certified Data Vault 2.0 Practitioner and Cloud big data specialist with expertise in Big data, DevOps, Data Engineering, BI, data modeling, automation, and process improvement. He was a speaker for several SQLSaturday and User group events. He contributed some open-source projects like digdag by developing a SQL Server plugin(digdag-plugin-mssql).

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.

Anoop Sunke

Anoop Sunke is a Solutions Architect at Hortonworks, leading vendor for 100% open-source Hadoop distribution. He works with companies based out of Southern California area helping them translate Big data problems in to workable and meaningful solutions. Prior to Hortonworks, He worked at Microsoft where he was responsible for designing and implementing Big Data solutions using Microsoft technology stack.

Demian Quinonez

Demian Quinonez has been a systems developer for more than a decade, with 8 years of SSIS development. His experience covers many technologies, from back-end systems to front-end applications. Currently, Demian is the Development department manager for CRMLS, Inc., a Real Estate Multiple Listing Service organization.

Ginger Grant

Twitter: - desertislesql

LinkedIn: Ginger Grant

Contact: http://www.DesertIsleSQL.com

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

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

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

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

Mike Tutor

Twitter: - @SQLTutor

LinkedIn: Mike Tutor

Contact: http://www.sqlsolutionsgroup.com/category/sql-group/

Mike Tutor has been in the IT industry for over 30 years. He has worn many hats, including developer, systems admin, and project manager, but he has worked almost exclusively as a SQL Server DBA since the late 90s. He has worked as a development DBA in the medical research industry for many years, but is currently working as a Sr. consultant at SQL Solutions Group in Lehi UT.

Steve Wake

Twitter: - stevewake

LinkedIn: Steve Wake

Contact: http://blog.wakebi.com

Steve Wake is currently the Principal BI Developer at Brown and Caldwell and has experience in consulting, advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full on-premises Microsoft BI stack. Recent experience with the Azure services: Analysis Services, Logic Apps, Data Factory, Databricks, Snowflake and Power BI. Steve is also very involved in the SQL community, speaking at events around the world.

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.

Harry Chandra

Twitter: - HarryChandraPDX

Contact: http://www.HarryChandra.com

Harry Chandra is a SQL Server, VMWare and PowerShell enthusiast working with various releases of SQL Server for over 10 years. His main focus is in Administration and High Availability for SQL Server, although he has always strived to expand his knowledge into other area of SQL Server.

Benjamin Nevarez

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

Benjamin Nevarez is a SQL Server MVP and 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 Optimization”, “Inside the SQL Server Query Optimizer” and has contributed to other SQL Server books including “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits.

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)

Jason Horner

Twitter: - jasonhorner

LinkedIn: Jason Horner

Contact: http://blog.jasonhorner.com

Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.

I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.

In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page