SQLSaturday #650 - Sacramento 2017

Event Date: 07/15/2017 00:00:00

Event Location:

Patrick Hays Learning Center
2700 Gateway Oaks Drive, Suite 2600
Sacramento, 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: Designing High Availability Database Systems using AlwaysOn Availability Groups

Abstract: Are you looking for a high availability solution for your business critical application? You’re heard about AlwaysOn Availability Groups and they seem like a good solution, but you don’t know where to start. It all starts with a solid design. In this session we introduce the core concepts needed to design a Availability Group based system. Covering topics such as recovery objectives, replica placement, failover requirements, synchronization models, quorum, backup and recovery and monitoring. This session is modeled after real world client engagements conducted by Centino Systems that have lead to many successful Availability Groups based systems supporting tier 1 business critical applications.

Speaker(s):

Anthony Nocentino

Track and Room: Enterprise Database Administration Deployment - VMware (Placer)

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. quot;Virtualize Firstquot; 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 quot;criticalquot; 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 i

Speaker(s):

Deji Akomolafe

Track and Room: Enterprise Database Administration Deployment - VMware (Placer)

Title: Hybrid Data and Analytics via a SQL Server 2017 Azure Drone

Abstract: Hybrid Data and Analytics via a SQL Server 2017 Azure-Controlled Drone

Using SQL Server 2017, we will control a drone via NodeJS. With the help of Python and ML we will then make the drone fly in the “Safe Zone”.

Join me in a presentation on how to create your Azure environment for data and analytics using the first ever drone controlled by SQL Server 2017.

creating a template to make proofs of concept possible
real world situations and lessons learned in Azure
consumption of that data through Power BI

This presentation will include creation of a hybrid solution for operational analytics both on-prem and cloud using Azure SQL Database in-memory and temporal tables to create the ultimate data and analytics experience.

Speaker(s):

Joseph Barth

Track and Room: Cloud Application Development Deployment - Sacramento

Title: Inside the SQLPS PowerShell Module

Abstract: SQLPS has been evolving since 2012 and the SQL Provider/cmdlets have been around since 2008. Have you taken advantage of the PowerShell infrastructure that is on your servers? This session takes you behind the scenes of the SQLPS and the new SqlServer module that is installed with the tools. We will cover how to get it without the tools, how to use it once you have it and why you will want to use it for simple tasks or complex ones. When you learn how to navigate SQL Server and all its services using Paths, you won’t go back. Join me for a fun filled hour and learn how to keep SQLPS from becoming frustrating and a black box. You will be glad you did. Let’s continue the journey to becoming a PowerShell DBA.

Speaker(s):

Ben Miller

Track and Room: Application Database Development - San Joaquin

Title: Effective Communication and Self Promotion for the IT Introvert (YOU!)

Abstract: Self-promotion is often confused with bragging, but most of the time it is the best tool to advance your career. In this session we talk about how self-promoting is the first step to creating your brand. Many IT Professionals struggle with how to stand out in a room, be noticed in a pile of resumes or maneuver for promotions. By learning to network and communicate effectively, these hurdles are converted into advancement ladders. Self-Promotion and Networking are skills and therefore can be taught and learned. We will discuss ways to use social media, communities and other avenues to increase your brands visibility online. Equally important is your ability to interact with co-workers, clients and management face to face. We will discuss ways to meet and network with other individuals and give you the tools to stand out from your peers. Building and engaging with a large network will increase your worth to both your current and future employer. Transform into a Networking Master.

Speaker(s):

Mitchell Bottel

Track and Room: Professional Development - Zerto (San Francisco)

Title: A DBAs guide to the proper handling of corruption

Abstract: Corruption can strike at any time. As DBAs how we alert, investigate, and respond can have profound impact on our company. In this session we will learn how to detect and respond to various types of corruption. First we will be focus on ways to detect corruption early. This will include understanding tools available to us like DBCC CheckDB as well as the importance of testing your backups. We’ll look at some sample scripts to automate corruption checks and common alerts we should have set up on our instances.

Then we will move onto how to respond to some common example of corruption through live demos. We’ll look at how we can analyze the situation safely as well as point out various pitfalls that trip people up. We’ll also discuss when and how we may be able to fix corruption vs restoring the database.

Speaker(s):

Brandon Leach

Track and Room: Enterprise Database Administration Deployment - Alameda

Title: Treating Tables Like Legos: Table Partitioning Basics

Abstract: Have your tables and indexes that have grown rather large? Are they taking longer to query? Are your windows for maintenance getting tighter? If you answered yes to any of these questions, table partitioning may be for you! With table partitioning, you can break a table or index down into smaller more manageable chunks. It can help you perform maintenance on just part of a table or index. You can even move data in and out of tables with quick and easy metadata only operations. We’ll go over basic partitioning concepts such as horizontal vs. vertical partitioning, and techniques like partitioned views and sliding windows. You’ll see how we can make our index and statistics maintenance easier. At the end of this session you’ll have a firm understanding of how partitioning works and be able to make decisions on how and when to implement.

Speaker(s):

Brandon Leach

Track and Room: Enterprise Database Administration Deployment - Zerto (San Francisco)

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 - VMware (Placer)

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 full day 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.

You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE. Take advantage

Speaker(s):

Jason Brimhall

Track and Room: Enterprise Database Administration Deployment - Zerto (San Francisco)

Title: SQL Server on Containers – Part 2

Abstract: Please attend Part 1 before to get full usage of this session

Those of you remember physical server consolidation phase started with VM, and struggle to run SQL server on VM with predictable performance…. Since than this is biggest change in the way SQL will be installed. Windows 16 introduced containers support, headless NANO servers and SQL server 2017 with complete support for creating containers using Dockers, a defacto industry standard API for container packaging is to allow running SQL Server as micro-services. No matter you want to deploy SQL server on Linux or windows containers are the way…

Will show you how can you install 5 SQL server implementations in 5 minute with each dedicated SQL implementation taking 15 GB of space. Will show you how containerization solves the “dependency hell” problem by incorporating software dependencies into a container image and provide smooth application deployment…

This session is designed for seasoned SQL Server DBA Developers

Speaker(s):

Prakash Heda

Track and Room: Enterprise Database Administration Deployment - Sacramento

Title: Bare Naked Skinny on SQL Server

Abstract: Ever feel like there are just too many layers with SQL Server? You peel off a layer and behold there is yet another layer. SQL Server is rather complex. The complexities can be rather frustrating from time to time.

Join this NSFW (not safe for whining) session as we strip SQL down to the bare bones. I will help you undress the complexities of a few of the basic SQL Server concepts. These concepts will include locks, principals, query directives and deadlocks.

In this session I will disrobe misunderstandings related to the aforementioned topics. I will show the different types of principals in SQL Server. I will also show various scenarios involving locks and deadlocks along with some of their effects with and without query directives. The goal is to better understand these topics and to hopefully stop using and perpetuating common mis-uses of terminology and common misconceptions about the technology.

Speaker(s):

Jason Brimhall

Track and Room: Enterprise Database Administration Deployment - VMware (Placer)

Title: SQL Server on Containers – Part 1

Abstract: Windows 16 introduced containers which has started a new era which will help with VM consolidation big time, the future of SQL Implementations is about installing SQL Server on Windows 16 NANO Server running as containers. It provides an isolated, resource controlled, predictable and portable operating environment inside a VM.

SQL server 2017 with complete support for creating containers using Dockers, a defacto industry standard API for container packaging is to allow running SQL Server as micro-services. Docker has industry-wide support with hosted services on Azure/AWS, monitoring, logging, orchestration. No matter you want to deploy SQL server on Linux or windows containers are the way…

This introductory session will help seasoned SQL Server DBA/Developers understand the basics of containers and windows 16 NANO servers running SQL Server 2016 17. in subsequent session Prakash will cover several demos and share scripts to start with containers

Speaker(s):

Prakash Heda

Track and Room: Enterprise Database Administration Deployment - Sacramento

Title: Build your Key Performance Indicator data warehouse

Abstract: Your business or organization likely has Key Performance Indicators (KPIs) to measure business performance, A KPI data warehouse solution can help you collect KPI data, store it over time, and support analytics. You executives and management will appreciate Analytics and Reports that rollup and present KPIs. During this session, you will see an overview of a Key Performance Indicator data warehouse architecture successfully deployed at a large California state agency. You will learns some ways to bring parts, or all, of it into your organization to expand your Business Intelligence and Analytics offerings.

Speaker(s):

Christopher Anderson

Track and Room: BI Information Delivery - Zerto (San Francisco)

Title: Zerto: Keeping the Enterprise Always On with IT Resilience

Abstract: Grab your lunch and join the Zerto experts in the Zerto (San Francisco) room for an informative presentation while you eat!

Your organization is always running and can’t afford downtime during a disaster or the traditional time it takes to recover from one. Backup solutions don’t solve these problems as they are not true disaster recovery for the business. What types of disasters will impact the business? Learn about disaster recovery scenarios, and also the questions to ask and answer when planning your disaster recovery solution to drive true IT resilience. Learn about which decisions impact the business in which ways, and how to avoid making sacrifices for your always-on organization.

Speaker(s):

SQLSAT650 Sponsor

Track and Room: Enterprise Database Administration Deployment - Zerto (San Francisco)

Title: Intro to Azure from a DBA’s Perspective: How to Cover Your a.a.s.

Abstract: Head in the “cloud”? Looking for a “cloud” with a silver lining? There are many clichés that can be used when talking about “cloud” technology but really, how does Microsoft’s “cloud” offering, called Azure, actually work? Let’s take a look at some basics and maybe even take a dive into the deep end. We’ll look at terminology (“subscriptions”, “Infrastructure as a service”, “resource manager” etc.), how to create various resources (virtual machines, databases, virtual networks etc.) and maybe even log into a “cloud” database. I’ll present a solid foundation that will enable you to get comfortable with the technology and allow you to expand your “cloud” skills.

Speaker(s):

Dan Hess

Track and Room: Enterprise Database Administration Deployment - Sacramento

Title: Why Should I Care About … Partitioned Views?

Abstract: Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views are not sexy but there are still plenty of applications where they are critical. And not necessarily just for standard edition who aren’t on the new service pack yet. If your data is time stamped, do you see different queries run against older data than new data? Do you with you could segment your data across multiple columns? Do you have data you need to partition horizontally? It’s possible partitioned views may still be for you. Come hear why this is still an important topic long after cargo pants and trucker hats went away … and possibly even after 2016 SP1.

Speaker(s):

Rick Lowe

Track and Room: Application Database Development - San Joaquin

Title: Dive into Azure Data Lake

Abstract: In this session, we’ll show the power of this Azure MPP solution. T-SQL is a great data language that makes parallelism easy. C# is a fantastic statically typed language that taps into the power of the .NET framework, but parallelism has a big barrier to entry. Learn how U-SQL combines the best of both worlds to clean and analyze data at incredible levels. Azure Data Lake Analytics makes Hadoop affordable and easy by leveraging your existing knowledge of T-SQL and C#.

Speaker(s):

Ike Ellis

Track and Room: Analytics and Visualization - Sacramento

Title: Lightning Talks

Abstract: Glenn Burnett: Destroyer of Databases. How I accidentally overwrote multiple production databases, and how you can avoid doing the same.

Caroline Ward: It’s amazing how a Massive Open Online Course (MOOC) can jumpstart your learning! MOOC tips and recommendations, and the best learning advice I have picked up from a MOOC!

Dilip Nayak: Lessons learned in hiring short-term DBA contractors. Do your expectations match the services you’re purchasing?

Robert Muir: How your database design can impact performance, what to watch out for when using Entity Framework queries, and tips for sharing this information with application and database developers.

Speaker(s):

Glenn Burnett

Track and Room: Enterprise Database Administration Deployment - Zerto (San Francisco)

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 - San Joaquin

Title: Unleashing Stretched Databases

Abstract: This is a deep dive session full of demos about SQL 2016 stretched databases feature. It will go from pre-reqs and blocking factor through deployment and disaster recovery. Everything you need to know and when to use this new cloud-based exciting capability.

Speaker(s):

Armando Lacerda

Track and Room: Enterprise Database Administration Deployment - Sacramento

Title: SQL Server Containers and Clones

Abstract: “Containers and Clones for SQL Server Development and Test”

Microsoft is emphasizing the use of containers for development and test on SQL Server 2017, and new solutions from Red Gate and Windocks add support for containers and SQL Server database fast cloning, for the full range of the SQL Server family. We’ll explore use of Docker based tooling for delivery of container environments, and their pros and cons. We’ll also look at SQL Server cloning, and how clones enable Dev and Test teams to work on large database environments for containers as well as existing SQL Server instances.

Speaker(s):

Paul Stanton

Track and Room: Enterprise Database Administration Deployment - Alameda

Title: Data Wrangling for Reporting Analytics

Abstract: This session will review common challenges encountered when preparing new data sets for use in analytics and reporting. We will look at tools for exploring and modifying large CSV/TXT files and discuss design patterns for cleaning and repair.

Speaker(s):

Phil Robinson

Track and Room: BI Information Delivery - Alameda

Title: A Survey of the Azure Data Platform

Abstract: Choosing where to store your data is far more difficult than ever. We can be paralyzed with choice! This session seeks to ease that anxiety and provide direction for application developers and DBAs. You’ll learn the differences between DocumentDB, Azure Table Storage, Azure Blob Storage, Azure SQL Database, Azure SQL in a VM, Azure SQL Data Warehouse, Azure Data Lake Analytics, Azure Data Lake Store, and more. See demos and review case studies so you’ll have a complete view of how data is stored in Azure and how to choose between these great tools.

Speaker(s):

Ike Ellis

Track and Room: Cloud Application Development Deployment - VMware (Placer)

Title: Welcome To the 2016 Query Store!

Abstract: One of my favorite new features in SQL Server 2016 is the Query Store. The Query Store houses valuable information on performance of your queries as well as gives you great insights into your query workload. This presentation will take a look at the Query Store, how it works and the type of information it holds. You will learn how to use the Query Store to quickly find plan changes and analyze performance issues caused by them. New DMVs will be introduced and the performance impact of enabling the Query Store will be discussed. Both DBAs and developers can increase their performance tuning skills by attending this session.

Speaker(s):

Janis Griffin

Track and Room: Enterprise Database Administration Deployment - San Joaquin

Title: VMware Lunch and Learn Series: Microsoft SQL Server on vSphere

Abstract: Grab your lunch and join Deji Akomolafe of VMware in the VMware (Placer) room for an informative presentation while you eat!

VMware Lunch and Learn Series: Microsoft SQL Server on vSphere

Speaker(s):

SQLSAT650 Sponsor

Track and Room: Enterprise Database Administration Deployment - VMware (Placer)

Title: Intro to the DBATools PowerShell module

Abstract: The DBATools PowerShell module is the premiere open source PowerShell project designed to automate, and encourage best practices. In this talk we will walk through setting up the module and review examples from the 180 commandlets available.

Speaker(s):

Eric Courville

Track and Room: Enterprise Database Administration Deployment - VMware (Placer)

Title: SSIS Process Automation Design for the T-SQL Developer

Abstract: This session is geared towards T-SQL developers who are interested in ETL framework or process automation. In this session we will go over how to create a single SSIS package that can be used for process flow automation without the need to constantly update the SSIS package whenever there is a change. When something happens, something or multiple things need to happen. The architecture that will be presented is powered by tables, stored procedures and recursive CTEs.

Speaker(s):

Eric Freeman

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

Title: Linux OS Fundamentals for the SQL Admin

Abstract: SQL Server and PowerShell are now available on Linux and management wants you to leverage this shift in technology to more effectively manage your systems, but you’re a Windows admin! Don’t fear! It’s just an operating system! It has all the same components Windows has and in this session we’ll show you that. We will look at the Linux operating system architecture and show you how to interact with and manage Linux system. By the end of this session you’ll be ready to go back to the office and get started working with Linux with a fundamental understanding of how it works.

Speaker(s):

Anthony Nocentino

Track and Room: Enterprise Database Administration Deployment - San Joaquin

Title: Intro to Availability Group

Abstract: In this session, I will walk you through every steps to set up SQL Server Availability Group. After a brief introduction to the basic components of Availability Group (AG), We will set up a primary AG with 2 secondary. This session will be mostly demo with opportunity to ask questions. Come and learn how to set up AG.

Speaker(s):

Harry Chandra

Track and Room: Enterprise Database Administration Deployment - Zerto (San Francisco)

Title: Managing Availability Groups with PowerShell

Abstract: SQL Server Always On Availability Groups are all the craze. When you have a need to failover or modify a configuration there are some things that you can only do with PowerShell. Aside from these items, PowerShell can completely manage an AG. Join me for a demo filled session where we will create an Always On Availability Group from scratch to management with PowerShell, including the Windows Server Failover Cluster. From changing parameters to failover, we will have a blast using PowerShell with ease of use to make your life better. Let’s work smarter and not harder when managing this great feature of SQL Server.

Speaker(s):

Ben Miller

Track and Room: Enterprise Database Administration Deployment - Zerto (San Francisco)

Title: Enabling Familiar, Powerful Business Intelligence

Abstract: This session focuses on Microsoft’s BI technologies and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. With the recent release of SQL Server, Microsoft dramatically enhanced the Microsoft BI platform. During this session you will explore the improvements to SQL Server reporting services and Power BI to show you how to create a blended value from your BI platform.

Speaker(s):

Sayed Saeed

Track and Room: BI Information Delivery - San Joaquin

Title: DBA Cheat Sheet

Abstract: Do you have trouble remembering common administrative T-SQL commands? Remember when you created a cheat sheet in school to help you study for an exam? Use that same principle with the DBA Cheat Sheet! The DBA Cheat Sheet is a document filled with some basic administrative TSQL commands you’ll need in your daily work. During the session I’ll show you a few SSMS tricks and review some of the topics in the DBA Cheat Sheet document. You’ll leave the session with a document that you can use as a reference every day. This is geared for developers or Junior DBAs.

Speaker(s):

Elizabeth Block

Track and Room: Enterprise Database Administration Deployment - Alameda

Title: Weird Stuff I Saw While … Working With Heaps

Abstract: We’ve all been told at some point that heaps are usually bad for select, update, and delete performance. But how bad are they really? Can they also be problematic for inserts? Are they ever a good idea? For this installment of Rick’s “Weird Stuff” series we will take a closer look at why heaps can cause issues and maybe see a deadlock or two.

Speaker(s):

Rick Lowe

Track and Room: Application Database Development - Alameda

Speakers

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

Janis Griffin

Twitter: - DoBoutAnything

LinkedIn: Janis Griffin

Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.

Glenn Burnett

Twitter: - SQLGB

Glenn Burnett is a Sacramento, California-based SQL Server professional working as a database administrator. A technical professional for over 25 years, he’s worked with SQL Server for over 20 years. Active in the Professional Association for SQL Server (PASS) and a board member of the Sacramento SQL Server User Group, he was recognized by PASS as an Outstanding Volunteer in December, 2013. He has spoken at Sacramento SQL Server User Group meetings and SQLSaturday events in Sacramento and Silicon Valley, and was the primary organizer for SQLSaturday 312 in Sacramento and assistant organizer for SQLSaturday 222, 399, 540, 650, 757 and 885, also in Sacramento. You can find him on Twitter as @SQLGB.

Christopher Anderson

Twitter: - @realworldis

Chris works as a Database Architect for the California Department of Corrections. In this role, he provides lead support for a large environment of SQL Server and Oracle database and plans the architecture of new systems. In past roles, he worked on COMPSTAT, a performance management method, by building out a Business Intelligence solution using the entire SQL Server stack. Chris has managed IT projects and developed applications.

Dan Hess

Twitter: - @SQLDCH

LinkedIn: Dan Hess

Contact: http://www.expressnetsolutions.com/sqldch

Dan has been in IT for the last 18 years, graduating from California State University, Chico with a computer science degree. He#39;s been focused on SQL Server since 2007 when he was given the quot;accidental DBAquot; title. After learning to swim in the deep end and moving jobs to Sacramento, he saw the need to help others who were in a similar position and helped to form the Sacramento SQL Server user group. Database administration is his primary focus.

Paul Stanton

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

LinkedIn: Paul Stanton

Contact: https://www.windocks.com/blog-2

Co-founder of Windocks, Paul is a former Microsoft engineer who is focused on delivering solutions for SQL Server development and test, including SQL Server containers and database cloning.

Ike Ellis

Twitter: - @ike_ellis

LinkedIn: Ike Ellis

Contact: http://blog.ikeellis.com

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

Ike Ellis

Twitter: - @ike_ellis

LinkedIn: Ike Ellis

Contact: http://blog.ikeellis.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.

Joseph Barth

Twitter: - @sql_da

LinkedIn: Joseph Barth

Contact: http://sqlda.com

An eight year Microsoft SQL Server Specialist in SQL Server 2005-2016, Azure SQL DB, he has held many development positions, including SQL query tuner, SSIS and SSRS . Joseph’s early focus as an SQL tuning professional, fixing long running queries by techniques; join order,use of temporary object, also implementing Index optimization, maintenance and design to fix slowness. Joseph has focused on ETL solutions using SSIS for the last 4 years, data warehousing and cloud architecture using Azure. Currently working on a Modern Data Warehouse project involving Azure Data Lake and Azure SQL DW using external tables. MCSE Data Management and Analytics 2016 MCSA: SQL Server 2012 Co-found CASSUG Albany NY 2 yrs AZSSUG Chapter Leader 3 yrs

Prakash Heda

Twitter: - @prakashheda

LinkedIn: Prakash Heda

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

Ami Levin

Twitter: - ami_levin

LinkedIn: Ami Levin

Contact: http://www.amilevin.com

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

Mitchell Bottel

Twitter: - @SacSQLDude

Contact: http://www.mitchespitch.com

Mitchell Bottel is a senior database administrator with Sutter Physician Services, owner of Innovative IT Consulting and President of the Sacramento SQL Sevrer User Group. He has 14 years of IT experience, focusing on SQL Server for the last ten years with an emphasis on database administration and high availability solutions. He has authored blog posts on the SQLServerPerformance website and written White Papers on using Dynamic Management Views.

Ike Ellis

Twitter: - @ike_ellis

LinkedIn: Ike Ellis

Contact: http://blog.ikeellis.com

SQLSAT650 Sponsor

SQLSAT650 Sponsor

Phil Robinson

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

Rick Lowe

Twitter: - DataFLowe

LinkedIn: Rick Lowe

Contact: http://dataflowe.wordpress.com/

Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated… eventually specializing more on performance issues than code.

Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.

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.

Deji Akomolafe

Twitter: - @dejify

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

Deji Akomolafe (a member of the Office of the CTO Ambassador Program and Staff Solutions Architect within VMware#39;s Global Field and Partners Readiness Group) specializes in the virtualization of Microsoft Business Critical Applications on VMware#39;s vSphere platform. Deji is a regular speaker at VMworld, Partners Exchange Conference, VMUG, SQLSaturday and EMCWorld, presenting technical subject matters related to Microsoft Applications virtualization and providing technical guidance to help clients enhance their expertise and ability to optimally virtualize and operate their critical applications.

Eric Freeman

Twitter: - sqlelf

LinkedIn: Eric Freeman

Contact: http://sqlelf.blogspot.com/

Eric Freeman works as a Lead Business Intelligence Architect at John Burns Real Estate Consulting. He has 15+ years of experience working with Microsoft SQL Server and holds an MCTS in Business Intelligence with a strong emphasis on Performance Tuning, ETL and Data Warehousing. Former President of the Sacramento SQL Server User Group, and actively speaks at SQL Server events.

Anthony Nocentino

Twitter: - nocentino

LinkedIn: Anthony Nocentino

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

Anthony Nocentino is the founder and President of Centino Systems as well as a Pluralsight author, Microsoft Data Platform MVP, Linux expert, and corporate problem solver. Anthony designs solutions, deploys the technology, and provides expertise on business system performance, architecture, and security. Anthony has a Bachelors and Masters in Computer Science with research publications in high performance/low latency data access algorithms and spatial database systems.

Rick Lowe

Twitter: - DataFLowe

LinkedIn: Rick Lowe

Contact: http://dataflowe.wordpress.com/

Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.

Janis Griffin

Twitter: - DoBoutAnything

LinkedIn: Janis Griffin

SQLSAT650 Sponsor

SQLSAT650 Sponsor

Sayed Saeed

LinkedIn: Sayed Saeed

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

Sayed Saeed is the Business Intelligence Practice Director at Plus Consulting. He is highly proficient in developing targeted BI solutions for clients and offers solid knowledge and experience in BI products that help organizations better leverage information to effectively manage business. He is a Microsoft Certified Solutions Expert in Business Intelligence as well as Oracle Certified Professional.

Eric Courville

Contact: http://www.organicit.org

Eric Courville has been with Verizon for 15 years supporting and implementing Large Enterprise Resource Planning Applications from vendors such as Oracle, Microsoft and SAP. Specializing in application monitoring, and integrating SSO with third party applications. Eric is Also the founder of the Northern California PowerShell User Group with locations in San Francisco and the Sacramento area.

Phil Robinson

Armando Lacerda

Twitter: - arlacerda

LinkedIn: Armando Lacerda

Over 30 years in the computing field as a developer and system integrator; over 20 years working with SQL Server since version 6; cross platform experience with Oracle and IBM SQL/DS and DB2; Microsoft Certified Trainer for over 20 years.

Armando Lacerda

Twitter: - arlacerda

LinkedIn: Armando Lacerda

Anthony Nocentino

Twitter: - nocentino

LinkedIn: Anthony Nocentino

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

Rick Lowe

Twitter: - DataFLowe

LinkedIn: Rick Lowe

Contact: http://dataflowe.wordpress.com/

Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.

Eric Courville

Contact: http://www.organicit.org

Ben Miller

Twitter: - DBAduck

LinkedIn: Ben Miller

Contact: https://dbaduck.com

Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.

Ben Miller

Twitter: - DBAduck

LinkedIn: Ben Miller

Contact: https://dbaduck.com

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.

Ben Miller

Twitter: - DBAduck

LinkedIn: Ben Miller

Contact: https://dbaduck.com

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.

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.

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Brandon Leach

Twitter: - SQLServerNerd

LinkedIn: Brandon Leach

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Elizabeth Block

Twitter: - @sqlservermama

LinkedIn: Elizabeth Block

Elizabeth Block is passionate about using database technologies to solve business problems. Currently a Senior DBA at PeaceHealth in Springfield, Oregon, she’s on a team managing over 300 SQL Servers. Extensive experience in database design and analysis has helped her in her roles as database consultant, developer, and DBA. She’s worked with SQL Server for over 10 years.

SQLSaturday #650 - Sacramento 2017

Sessions

Title: Designing High Availability Database Systems using AlwaysOn Availability Groups

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

Title: Hybrid Data and Analytics via a SQL Server 2017 Azure Drone

Title: Inside the SQLPS PowerShell Module

Title: Effective Communication and Self Promotion for the IT Introvert (YOU!)

Title: A DBAs guide to the proper handling of corruption

Title: Treating Tables Like Legos: Table Partitioning Basics

Title: Dive into the Query Optimizer - Undocumented Insight

Title: A Masters Passport to Extended Events

Title: SQL Server on Containers – Part 2

Title: Bare Naked Skinny on SQL Server

Title: SQL Server on Containers – Part 1

Title: Build your Key Performance Indicator data warehouse

Title: Zerto: Keeping the Enterprise Always On with IT Resilience

Title: Intro to Azure from a DBA’s Perspective: How to Cover Your a.a.s.

Title: Why Should I Care About … Partitioned Views?

Title: Dive into Azure Data Lake

Title: Lightning Talks

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

Title: Unleashing Stretched Databases

Title: SQL Server Containers and Clones

Title: Data Wrangling for Reporting Analytics

Title: A Survey of the Azure Data Platform

Title: Welcome To the 2016 Query Store!

Title: VMware Lunch and Learn Series: Microsoft SQL Server on vSphere

Title: Intro to the DBATools PowerShell module

Title: SSIS Process Automation Design for the T-SQL Developer

Title: Linux OS Fundamentals for the SQL Admin

Title: Intro to Availability Group

Title: Managing Availability Groups with PowerShell

Title: Enabling Familiar, Powerful Business Intelligence

Title: DBA Cheat Sheet

Title: Weird Stuff I Saw While … Working With Heaps

Speakers

Sponsors