SQLSaturday #740 - Orange County 2018

Event Date: 04/14/2018 00:00:00

Event Location:

Golden West College
15744 Goldenwest St
Orange County, 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: Well, actually… How to not be THAT guy in IT

Abstract: Unless you’ve been in a cave, you’ve seen articles lately on what it’s like to be a woman in tech. In 2017, waves of blogs and news articles tell us about those extreme examples of misogyny. Only they aren’t fringe, one-off stories. It’s happening to women you know. IT can be an inhospitable place for women. Some call it a “bro-grammer” culture. Compared to men, women are leaving IT at 2.5x and are interrupted 3x as often. Our credentials are called into question. We’re called emotional or aggressive. We have our own job explained to us. Sometimes its subtle. Other times it’s overt. There’s always that one guy who ruins it for the rest of you. It doesn’t have to be that way. Most of the guys we work with are stand-up, respectable WIT allies. The problem is, you don’t always notice when it happens. Learn what those subtle forms of sexism look like at work. Learn how you can stop that guy in his tracks. Learn how to not BE that guy, even when you’re just trying to help.

Speaker(s):

Rie Irish

Track and Room: Professional Development - Health Science 131

Title: Stop Wasting Valuable Time and Resources - Performance Tune Your Jobs

Abstract: We all know that execution plans and indexes are important pieces to performance tuning jobs. However, they are definitely not the only tools in the toolbox. This session will take a more high-level, holistic, approach to performance tuning jobs and their components. We will talk about where to start, how to identify problem areas, and many ways to improve performance. Many of the topics covered in the presentation come from real-world situations I’ve encountered. One example describes how we stopped a job after 13 hours and were able to tune it down to 8 minutes. Adding additional hardware is not always an option or the answer. Do more with what you have and tune your jobs. I’ll show you how.

Speaker(s):

Jeff Prom

Track and Room: Database Development - Health Science 118

Title: Data Wrangling for Reporting Analytics using Power BI

Abstract: In today’s world reporting and analytics are no longer focused exclusively on internal data from transactional systems and the data warehouse. Mashups using data from partners, commercial and public sources are fast becoming the new normal. Do you have a csv file too big to open, is a non-windows format or generates errors on import or opening? Need to determine the quality of a file downloaded from the internet or supplied by another party? In this presentation we will review tools to examine/repair schema issues and explore Power BI Desktop features that provide insights into your datasets along with the M language for building mashups and data models.

Speaker(s):

Phil Robinson

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

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: Database Administration - Health Science 117

Title: [StepbyStep] SQL server Index operation for beginner to expert.

Abstract: Understanding Index internal operation is very important. It is a fundamental knowledge of performance tuning and troubleshooting. However, Index internal seems very hard to understand because many materials explain it a very complicated way.

This presentation covers from basic concept of index to all of internal index structure. I will explain the index structure very simple concept. Therefore, all developer who attends this session could understand how index work with a Clustered index and a Non-clustered index together. Furthermore, this presentation will share very important tip how to troubleshooting index issue. This presentation would very help not only who does not know index but also, who know very well index internal.

Speaker(s):

Simon Cho

Track and Room: Database Development - Health Science 118

Title: Performance Troubleshooting made easier - new features in Management Studio !

Abstract: SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools. Which enabled rapid enhancement to Execution Plan.

Do you know that you can now see how many pages are spilled to disk for a sort, as well as the memory statistics for the operator? Are you aware that you can see the top 10 waits for an execution and what trace flags were active during compilation and which ones influenced compilation? Have you ever analyzed a big plan and wish you could search for table name, index name or column name without opening XML plan? When you see a clustered index was used do you know for sure which statistics were used by the Query Optimizer to estimate the number of rows?

In this demo intensive session, I will show you how to find and use new features introduced into SSMS and Showplan. You will walk out of this session equipped to make Query Performance Troubleshooting easier and ready to tackle those nasty, hard to solve query plans.

Speaker(s):

Taiob Ali

Track and Room: Database Administration - Humanities 206

Title: Azure Data Catalog – Turning Unused Assets into Usable Knowledge

Abstract: Data is today’s currency. Azure Data Catalog (ADC) is a relatively unknown resource in the IT community. This is an unfortunate state since ADC is an incredibly useful tool that is easy to implement and use. Companies that are able to leverage their data have seen the greatest gains in growth and market capitalization. The reason for this is simple: We live in the information age. Being able to leverage the data you gather is the invitation you need just to compete in information age. ADC is an indispensable tool that helps companies organize and make sense of the mountains of data they collect every day. By walking participants through an implementation of ADC, I will introduce them to the product, and show how easy it is to use. By presenting concrete examples of how ADC is used, I will demonstrate its importance. Participants should leave this session determined to introduce ADC to their team and resolute in their intention to implement it within their company.

Speaker(s):

Melody Zacharias

Track and Room: Azure Cloud - Humanities 305

Title: Data Protection Privacy in the World of Database DevOps

Abstract: Ensuring the ongoing protection of personally identifiable information is mandatory in today’s business, helping you to guard against data breaches, and comply with the GDPR. In a climate where cyber attacks are all too frequent, and data is spread across a growing number of different environments, the challenge of protecting your data can seem daunting. This session will address the implications of the GDPR on database management, and demonstrate a privacy-first approach to controlling and protecting data as it changes and moves through your SQL Server estate. As well as offering guidance for assessing your data estate for GDPR readiness, this session will include some great tools and tips for building data protection and privacy into your development processes, and dispel the myth that database DevOps and compliance can’t go hand in hand. With the right preparation, you can build compliance into your processes, keep sensitive data safe, and deliver value quickly to your end users.

Speaker(s):

Grant Fritchey

Track and Room: Database Administration - Health Science 131

Title: Database Security in an Insecure World

Abstract: Database security is a hot topic, especially with all the recent breaches of major public companies. We know that behind every application or website somewhere lies a database with sensitive information. We also know that companies are pushing data access to an ever growing number of devices, including tablets, cell phones and smart watches. The Internet of Things (IoT) only heightens security concerns. So how do you protect your databases? What are your options, and what ramifications exist with each option? This presentation will provide a high level summary of prevailing database security options along with their pros and cons. Furthermore, an ideal two factor authentication solution is presented for education and consideration.

Speaker(s):

Omar Masri

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

Title: Python in SQL Server 2017

Abstract: SQL Server 2017 has finally arrived, bringing with it a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let’s get started!

In this introductory session we’ll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We’ll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We’ll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we’ll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!

Speaker(s):

Chris Hyde

Track and Room: BI Analytics, Visualization Presentation - Health Science 120

Title: Azure Automation: Your SQL Agent in the Cloud

Abstract: You want to migrate your on premise SQL Database to cloud, and soon recognize that SQL Agent is not available. You heard the promise of spinning up databases on demand and turn off/dial down when not in use. Do you want to do this manually each time? Azure Automation comes to rescue. It is a service for simplifying cloud management. Using Azure Automation long-running, manual, error-prone, and frequently repeated tasks can be automated to increase reliability, efficiency, and time to value for your organization. In this demo intensive session I will show you how to setup Azure Automation, walk you through a runbook example (a compilation of routine procedures and operations), execute runbook on demand and also show how to schedule the same. At the end of this session you will have solid understanding about how to automate Azure services including replacing SQL Agent functionality using Azure automation, and conveniently encapsulate within the common Azure portal experience.

Speaker(s):

Taiob Ali

Track and Room: Azure Cloud - Humanities 305

Title: Let Her Finish: Supporting Women’s Voices in Technology

Abstract: Next time you attend a meeting, watch what happens when women at the table offer ideas. If your office is like most in America, you’ll notice women are interrupted almost three times as often as men. Some interruptions are to assert dominance but sometimes people do it to be helpful offer affirmation. Regardless of the intent, the results are the same. Women are being left out of the conversation. The consequences are real. Male executives that speak more frequently in meetings are rewarded with 10% higher competence ratings from peers better performance reviews from bosses. This translates into $ when raises and bonuses are handed out. This discussion will cover positive solutions that help women’s voices be heard. Women need to be more assertive. We need to learn to say “Stop interrupting me.” and “I just said that.” However, men can be, no HAVE to be, part of the solution. They can help women become part of the conversation.

Speaker(s):

Rie Irish

Track and Room: Professional Development - Health Science 131

Title: The Query Store and Query Tuning in SQL Server

Abstract: For the most part, query tuning in one version of SQL Server is pretty much like query tuning in the next. SQL Server 2016 introduces a number of new functions and methods that directly impact how you’re going to do query tuning in the future. The most important change is the introduction of the Query Store.

This session will explore how the Query Store works and how it’s going to change the methods you use to tune and troubleshoot query performance. With the information in this session, not only will you understand how the Query Store works, but you’ll know everything you need in order to put it to work with your own SQL Server 2016 tuning efforts, as well as your Azure SQL Databases.

Speaker(s):

Grant Fritchey

Track and Room: Database Development - Health Science 131

Title: New SQL Server 2016 Security Features for Developers

Abstract: With the release of SQL Server 2016, the database engine has been greatly enhanced for security, with three new features that you’ll learn about in this demo-packed session. With dynamic data masking (DDM), you can fully or partially conceal sensitive columns from query results. Masking does not modify data on in the table, it simply hides data from users that don’t have permission to see it. Row-level security (RLS) also hides data from unauthorized users, but at the row level. With RLS, you can create your own security policy to control which users can read or write specific rows in the table. Finally, Always Encrypted (AE) uses client-side encryption to ensure that data is encrypted in flight, not just at rest. Furthermore, the encryption keys are accessible only to the client. This guarantees that data cannot be decrypted on the server, easing the migration path to the cloud for users with highly sensitive data.

Speaker(s):

Leonard Lobel

Track and Room: Database Development - Humanities 208

Title: Building a Dashboard in an Hour using PowerPivot Power BI

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

Speaker(s):

Vazi Okhandiar

Track and Room: BI Analytics, Visualization Presentation - Health Science 120

Title: Transforming Your Brain with SQL 2017 with Linux

Abstract: By now, most of us heard of SQL on Linux when it was first released. It was also on the announcement of SQL 2017 which caught most of us by surprise, being that SQL 2016 was just released 16 months prior. Most of us were still using SQL 2008 and barely getting our organizations to adopt SQL 2012. The IT infrastructure we serve today probably wouldn’t benefit from Linux since most of our servers are tightly woven with the Microsoft platform solution. So why bother learning SQL 2017 on Linux? Attend this session to find valuable lessons for every data professional should know whether Linux or Windows.

Speaker(s):

Andrew Nakamura

Track and Room: Database Administration - Humanities 206

Title: It’s Time for a Change: Temporal Table Support in SQL Server 2016/17

Abstract: Without temporal tables (AKA history tables), we can only see the current version of data. We can’t see rows that have been deleted or rows as they existed before the latest update. The temporal table support in SQL Server 2016 gives us the ability to create system-maintained “history” tables to track all changes to the table data.

In this session we’ll discuss how you can benefit from temporal support in your tables, how to implement temporal tables in SQL Server 2016, and how to write “time travel queries” using the new FOR SYSTEM_TIME clause in a SELECT statement to easily query historical information.

Speaker(s):

Vern Rabe

Track and Room: Database Administration - Humanities 206

Title: SQL Server plays a pivot role in data sciences and business intelligence

Abstract: Data science, Artificial Intelligence (AI), machine learning or Big Data are currently hot topics. there are many applications are claimed to provide full fledged functions on these fields and to cover the all the business users’ need. In this session we will provide demo that how SQL server plays a pivot role for data analyst (developer, data scientist) to start over. As the first step is to get and store the relevant data from and to SQL Server, we will present how some of most popular data analysis applications (including Qlikview, Tableau, PowerBI, SAS, R and Python) connect to SQL server and run some basic data analysis procedures.

Speaker(s):

PEIXIN WANG

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

Title: SSIS Project Deployment: The T-SQL Way

Abstract: Do you deploy SQL Server Integration Services (SSIS) Projects using the Integration Services Deployment Wizard? If you’re looking for a repeatable deployment method that can be source controlled, there’s another way…the T-SQL way! In this session, you will see a demonstration of T-SQL script deployment of SSIS projects, using stored procedures in the SSISDB database. You’ll learn how to query the SSIS catalog to find your project configurations so they can be captured and source controlled. Take control of your SSIS deployments…the T-SQL way!

Prerequisites: You should have previous experience with SQL Server Integration Services (SSIS) package deployment and/or development.

Speaker(s):

Peter Kral

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

Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming

Abstract: This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.

Speaker(s):

Diane Schuster

Track and Room: BI Architecture, Development Administration - Humanities 208

Title: Reporting Services 2016: New Features Smart Migration Strategy

Abstract: With the release of SQL Server 2016, Reporting Services finally got some love! In this session, you will get an overview of some of the new features and functionality in SSRS 2016: A look at the new Report Manager interface, Mobile reports, KPIS and the new control we have over the placement of parameters. We will also look at the new Mobile Report Publisher app and see how easy it is to take an existing report and make it mobile friendly.

The session will then dive into how to use the data in the ReportServer database tables to see which reports in your environment are being used and how well they are performing. With this understanding you can determine which reports, data sets and data sources to migrate to a new 2016 installation. Come see how to leverage PowerShell to extract the reports from the database, instead of having to download them from Report Manager, to facilitate an easy migration to a new SQL Server 2016 Reporting Services implementation.

Speaker(s):

Ted Stathakis

Track and Room: BI Architecture, Development Administration - Humanities 208

Title: Introduction to BI Architecture

Abstract: There is a ton of buzz in the market about BI, but do we really know what is BI Architecture? We will go over an ideal architecture design and explain the various elements and tools that make up this architecture. We will use the Microsoft BI Stack as a perspective, but architecture can be replicated with various vendor tools.

Speaker(s):

Warren Sifre

Track and Room: BI Architecture, Development Administration - Humanities 208

Title: RedGate: Extending DevOps to SQL Server

Abstract: Most organizations are under pressure to speed up the software delivery cycle, whether that’s to respond more quickly to the needs of the business, the needs of your customers or just to keep up with the competition. Unfortunately the database is commonly considered a bottleneck. Without the right processes in place, database change management can slow things down, adding risk, uncertainty, and getting in the way of development and operations working together to deliver. Any organization that wants to fully benefit from a DevOps approach is going to have to overcome some specific challenges presented by the database. This session will teach you how to take DevOps principles and practices and apply them to SQL Server so that you can speed up the database delivery cycle at the same time you protect the information contained within.

Speaker(s):

SQLSaturday Orange County

Track and Room: Database Administration - Health Science 131

Title: Introduction to powershell for the SQL Server DBA

Abstract: In this introductory session we will introduce the basic concepts of powershell and show how we can utilize it to begin automating common tasks. In addition to the concepts below, we will also delve a bit into how the DBA role is changing and what we can learn from developers in regards to automation.

Tooling (Getting your developer environment setup) Variables Parameters Working with Strings Using Invoke-SQL and the SQL Server Management objects (SMO) Extensibility (installing and managing third party cmdlets) A brief introduction to the DBAtools.io cmdlets

Finally we will tie all this together with real world examples.

Speaker(s):

Brandon Leach

Track and Room: Database Administration - Health Science 117

Title: The Mac DBA, using Docker and SQL Operations Studio

Abstract: In this session we will go over the steps involved with getting a Database Dev environment set up on your Mac using SQL Server on Linux,Docker and SQL Operations Studio. We will go over installation of Docker and SQL Server, tips and tricks on data persistence in Docker, and how to connect and work with SQL Server running Docker using SQL Operations Studio.

Speaker(s):

Charles Embry Jr

Track and Room: Database Development - Health Science 118

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: Database Administration - Health Science 117

Title: SQL Solutions Group: The DBA Is Dead. Long Live the Remote DBA.

Abstract: Over the past decade, the rate of change in the industry has accelerated exponentially and the always fluid role of a DBA has morphed to the point where many organizations don’t even have the role anymore or it is combined with other duties. What does this mean for the DBA? For developers? For organizations? While we certainly don’t have all the answers, we’ve been doing this for a very long time and have seen lots of trends and buzzwords come and go. This session will be a fun and open discussion on these trends and how outsourcing the mundane so your key people can focus on the highest value activities may be the best way to go for many organizations.

Speaker(s):

SQLSaturday Orange County

Track and Room: Database Administration - Health Science 120

Title: Ledgent : Resume Best Practices

Abstract: In this session on Resume Writing and Interview Preparedness, you will learn how to craft the perfect resume to capture your dream employer’s attention! We will cover the Do’s and Don’ts for writing your Resume, Cover Letters, and how to make yours stand out. We will also discuss the Interview Process. Having a great Resume to get selected for an Interview is the first step, but then what? We will talk through all the most common steps of the Interview process, how to prepare, and how to follow up to give yourself the best shot of landing your dream job. We will wrap the Session with Questions and Answers to leave everyone feeling confident about their ability to write a Resume and prepare for an Interview.

Speaker(s):

SQLSaturday Orange County

Track and Room: Professional Development - Humanities 307

Title: Azure Infrastructure

Abstract: In this session, we’ll review all the various infrastructure components that make up the Microsoft Azure platform. When it comes to moving SQL Server systems into the Azure platform having a solid understanding of the Azure infrastructure will make migrations successful and making support solutions much easier.

Designing your Azure infrastructure properly from the beginning is extremely important. An improperly designed and configured infrastructure will provide performance problems, manageability problems, and can be difficult to resolve without downtime.

As Azure scales around the world many more companies, no matter where they are located, will be begin moving services from on-premises data centers into the Azure Cloud, and a solid foundation is key to successful migrations.

Speaker(s):

Joseph D’Antoni

Track and Room: Azure Cloud - Health Science 117

Title: Introduction to Big Data

Abstract: We will discuss what exactly is Big Data. How it is defined? What technologies are involved? How it is leveraged? Why is it so exciting? What does this mean to me?

Speaker(s):

Warren Sifre

Track and Room: BI Architecture, Development Administration - Humanities 208

Title: Dell: #GetModern with Dell EMC

Abstract: Consistent and predictable performance is critical for any successful deployment of Microsoft SQL Server. All-Flash arrays have been available for years and sub-millisecond response times should be the expectation. Maximize the performance and agility of your environment and learn how to automate and leverage self-service for snapshots of your databases for protection and re-purposing. Test/dev infrastructures can be refreshed from production DBs in minutes rather than hours or days. Stop working harder and slower than you need to be, learn how you can leverage Dell EMC. Whether storage, servers, networking, data protection, converged or hyper-converged… we have you covered.

Speaker(s):

SQLSaturday Orange County

Track and Room: Database Administration - Humanities 206

Title: Storage For the DBA

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

Speaker(s):

Denny Cherry

Track and Room: Database Administration - Health Science 117

Title: Mom Rules for Managing Enterprise Database Environments

Abstract: Have you ever looked at an environment and wondered how the heck they ever got anything done because it is so disorganized? The first thing I do for newly inherited environments is implement some organization and do some database clean up. Not only does organization make the environment easier to maintain, it can help speed up trouble shooting. Good organization can even help with some performance issues.

Speaker(s):

Marsha Pierce

Track and Room: Database Administration - Humanities 206

Title: Microsoft Azure for SQL Server Professionals - Get your head in the cloud

Abstract: Lift and shift is an utopia many IT professionals have about moving on-prem resources to the cloud. The truth is we must understand how the cloud works so we adjust, design accordingly and deliver to expectations. As SQL DBAs we have options. We can choose between IaaS or PaaS, between SQL in a VM or SQL DB, NoSQL options, Azure Data Warehouse some more. In this session we will dive into these options and understand some key points on the platform through some demos.

You will learn: • Basic elements of Azure cloud ecosystem • VM disks specifics for SQL 2016/2017 • Azure SQL Database and Elastic pools • Azure Data Warehouse and Cosmos DB

Speaker(s):

Armando Lacerda

Track and Room: Azure Cloud - Humanities 305

Title: Quest: Realtime Monitoring Workload Analysis with Spotlight on SQL Server

Abstract: In this overview you’ll see how Spotlight on SQL Server gives you real-time performance alerts and brings together all of your critical SQL Server metrics into a single dashboard-style screen, color-coded for problem severity and clickable for rapid diagnostics. You’ll also see how Spotlight’s Wait Event and Workload Analysis screens enable a deep dive into which queries caused exactly how much of each type of workload at particular times.

Speaker(s):

SQLSaturday Orange County

Track and Room: Database Administration - Health Science 117

Title: Concurrency in SQL Server - Managing More Than 1 User

Abstract: Have you ever worked on a database used by more than one person? ;-) If so, then this session is for you! In this session we’ll talk about what happens when multiple processes compete for the same resources (aka “Concurrency”). We’ll break down SQL Server’s isolation levels, and the trade-offs between concurrency and such scary-sounding things as “dirty”, “phantom” reads. There will be practical demo’s and some real-life examples “from the trenches”. There are a lot of misconceptions out there about this topic, you may be surprised!

Speaker(s):

Thomas Hull

Track and Room: Database Administration - Humanities 206

Title: Insights with massive data ingestion and Power BI

Abstract: We all love Power BI and its abilities to show data insights through its interface. But Power BI has its limits when it comes to massive data ingestion and near real time dashboards. In this presentation we will evaluate some out of the box solutions to render metrics and KPIs from massive loads that extrapolates Power BI limits.

You will learn:

• Power BI limits for accommodate data refresh and streaming datasets • Develop strategies for continuous and discrete data capturing for Power BI • Azure services options for near real time dashboards Power BI • SQL Server features to source discrete dataset for Power BI

Speaker(s):

Armando Lacerda

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

Title: Modern ETL with Azure Data Factory, Data Lake, and SQL Database

Abstract: The modern data warehouse architecture is changing, and the world of Azure tools that are enabling these changes are also forcing us to reevaluate the patterns we’re using to load these warehouses. In this session, we’ll discuss some of the prescient design patterns and technologies used to implement a scalable data warehouse ETL pipeline using Azure technologies such as: Data Lake, Data Factory V2, and SQL DB. We’ll cover everything you need to know to architect your next cloud data warehouse and dive into the technical details of implementing each of these components.

Speaker(s):

Eric Bragas

Track and Room: Azure Cloud - Humanities 305

Title: Power BI: What you need to know

Abstract: This session will explore every aspect of Power BI…from the technology used behind the scenes and the tenant/service in Azure, to data refresh options and development best practices. We’ll cover everything you need to know (and more) before you embark on your first Power BI project.

Speaker(s):

Martin Schoombee

Track and Room: BI Analytics, Visualization Presentation - Health Science 120

Title: The Magic of SSISDB

Abstract: The purpose of this presentation is to provide a better understanding of SSISDB and how it can be utilized to make the lives of developers and DBAs easier. This presentation will demonstrate how to use SSISDB to script out deployments of folders, projects, environments and packages, and dynamically assign environment variables. We will write scripts to run our SSIS packages and use SSRS to kick them off. We will learn how to create SSRS Reports that recreate the All Executions and All Messages built-in reports and make them available to user developers.

Speaker(s):

Elaena Bakman

Track and Room: Database Development - Health Science 118

Title: Power BI Adoption Framework

Abstract: One of the most critical areas of any application is Adoption. Power BI is no exception. In this session, I’ll speak about some of the strategies, best practices, and experiences to increase adoption

Speaker(s):

Suresh Datla

Track and Room: BI Analytics, Visualization Presentation - Health Science 120

Title: Confidence: The Fuel For Action

Abstract: Confidence is the fuel for action. How often have you thought about wanting to do something and thought you may not be successful at it, so it then became too much work to try? The American Pastor Robert Shuler famously asked a very powerful question: “What would you do if you knew you could not fail?” Come explore this exciting topic with me, and we will see what we can accomplish together!

Speaker(s):

Melody Zacharias

Track and Room: Professional Development - Health Science 131

Title: Data Pages, Allocation Units, IAM chains… Best Practice Edition

Abstract: Learning the internals of a data file can seem like a daunting task… So lets make it fun and practical. In this session we will look at some common best practices and see what is actually going on under hood. I’ll even share a few stories of the crazy things I’ve seen and dealt with in my career.

Speaker(s):

Brandon Leach

Track and Room: Database Administration - Humanities 206

Abstract: Come learn what DesignMind can do for you!

Speaker(s):

SQLSaturday Orange County

Track and Room: BI Analytics, Visualization Presentation - Health Science 120

Title: Fundamentals That Will Improve Your Query Performance!

Abstract: Time and time again the same misunderstandings by developers and query writers appear when query performance issues arise. In this demo heavy presentation, we will review these specific topics such as data types, implicit conversions, sargability, and some others that all have an impact on query performance. Come join me and by the end of this session you will have the knowledge to boost your query performance!

Speaker(s):

John Wells

Track and Room: Database Development - Health Science 118

Title: Making the Leap from Developer to DBA

Abstract: You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.

Speaker(s):

Amy Herold

Track and Room: Professional Development - Health Science 117

Title: Foundations of a Data Driven Organization

Abstract: What is Data Driven? You might have heard someone at your organization say you need to be more data driven, but what does it mean? How does your organization need to change to be able to support being data driven?

As you might imagine it is a little bit more complicated that just saying the words or putting together a few charts. This session will talk about the fundamental things that you need to think about to move to being more data driven. It is a combination of people, process, policy and technology. This session will give you a lot to think about how to apply the principles of being data applies to your company.

Speaker(s):

Andrew Karcher

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

Title: 60 Reporting Tips in 60 Minutes

Abstract: In this session, we’ll share tips for report creation, including tips about gathering requirements, creating dashboards, understanding business drivers, implementing machine learning quickly and easily, judiciously using coloring, delivering reports strategically, and learn when it’s time to retire a report. Each tip is about sixty seconds and most have demos. All code will be available for download.

Speaker(s):

Ike Ellis

Track and Room: BI Analytics, Visualization Presentation - Health Science 120

Title: Deep Dive in Azure Data Factory V2

Abstract: Azure Data Factory V2 represents a major new release to the Microsoft’s cloud data integration tool, and a complete paradigm shift from V1. We’ll discuss which changes are the most significant and which features have stayed the same. Then, we’ll dive into the inner workings of Data Factory V2 so we can discuss common usage patterns, such as loading data from multiple tables with a single pipeline, incrementally pulling data from source systems, and other data warehouse loading techniques.

Speaker(s):

Eric Bragas

Track and Room: Azure Cloud - Humanities 305

Title: 3 Lessons Learned in Successful Consulting

Abstract: I would like to share the 3 lessons I learned that helped me become a much better consultant. These lessons were crucial in helping me make that “mind shift” from thinking like a regular “9 to 5 DBA” to thinking like a consultant. The goal of this session is to help those who are interested in becoming a consultant. Hopefully these 3 lessons will help make that transition successful as it did for me.

Speaker(s):

Mohammad Darab

Track and Room: Professional Development - Humanities 208

Title: Azure Basics for the DBA

Abstract: It’s not a question on whether or not the landscape for the common DBA is changing. Without a doubt, it is. Azure offers up a new world of possibilities for DBA’s and we should all strive to learn it. In this session we’ll cover some basic knowledge and terminology of Azure as well as how easy it is to incorporate Azure into your environment. We will stand up a new Azure virtual machine as well as a setup SQL DB. You will see how easy it is to accomplish this. This new found knowledge will help propel your career into the new landscape.

Speaker(s):

John Morehouse

Track and Room: Azure Cloud - Humanities 305

Title: From problem to Power BI: A journey in data visualization

Abstract: Power BI is all the rage right now in visualizing data on the Microsoft BI stack. We’ve seen multiple how tos and presentations on the features, but in this hour, we will actually go through the journey of a specific problem, research it, storyboard it, work through how we solve it (before we ever open Power BI) and then build the Power BI visualization. Make your visualization count. Come join us on the journey.

Speaker(s):

Jonathan Stewart

Track and Room: BI Analytics, Visualization Presentation - Health Science 120

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

Abstract: If you’ve ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why “SQL that works” is not good enough. Understanding indexes, execution plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that “worked great in dev” but caused major issues when it hit production.

Speaker(s):

Randy Knight

Track and Room: Database Development - Health Science 131

Title: Introduction to SQL Server Integration Services, what’s new in SSIS 2016, and a test-drive

Abstract: We will have an introduction to ETL, ETL software landscape and Microsoft SQL Server Integration Services a.k.a. SSIS in greater details. We will also discuss what’s new in SSIS 2016. For the hands-on section, we will create a simple SSIS package and test-drive some selected features, like Balance Data Distributor, Control parts, and Expression Task.

Speaker(s):

Steve Rezhener

Track and Room: BI Architecture, Development Administration - Health Science 118

Title: An introduction to the magical world of BIML!

Abstract: Ever feel like you are just doing busy work while creating new SSIS packages? Feel like you are doing the same thing over and over while changing the names to protect the innocent? Ever wonder if there is a better way? Well wonder no more. Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors. Come with intrigue and leave with a fundamental understanding of BIML!

Speaker(s):

Jonathan Stewart

Track and Room: BI Architecture, Development Administration - Humanities 208

Speakers

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

Jeff Prom

Twitter: - @JeffProm

LinkedIn: Jeff Prom

Contact: http://www.jeffprom.com

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

PEIXIN WANG

SQL SERVER DBA/DEVELOPER; ORACLE DEVELOPER/DBA; SAS PROGRAMMER/ADMIN; QLIKVIEW DEVELOPER/DBA; JAVA PROGRAMMER

Thomas Hull

Twitter: - @sdsql

LinkedIn: Thomas Hull

Thomas AJ Hull is a database professional based in San Diego, with 20+ years of SQL Server experience (since v6.5). AJ has worked as a consultant in the financial and biotech industries, and is currently a DBA Team Lead at Union Bank. He earned a BS in Engineering at Cornell University, and a master’s at Rochester. His certifications include MCSE: Data Platform MCSE: Data Management and Analytics. AJ enjoys mentoring developers and junior DBAs, and is always striving to learn more through continuing education and involvement in the SQL Server community. His goal is to pass along hard-earned knowledge with practical actionable advice, and believes that the best way to learn something is to teach it.

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.

Jonathan Stewart

Twitter: - sqllocks

LinkedIn: Jonathan Stewart

Contact: https://sqllocks.net/

Jonathan Stewart is a Business Intelligence consultant specializing in data visualization, data warehousing, and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments.

Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and Business Intelligence at numerous SQLSaturday events, local user groups, and conferences throughout the United States and around the world. He participates in webcasts, podcasts, and on

Peter Kral

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

LinkedIn: Peter Kral

Peter Kral is a Premier Field Engineer (Data AI) at Microsoft. He holds SQL Server MCSA 2012/2014/2016 and Data Platform MCSE certifications, and was the winner of the Speaker Idol Award at PASS Summit 2016. Peter lives in the San Diego area where he is an active member of the local PASS chapter. He has spoken at many SQLSaturdays, SoCal Code Camps, and at PASS Summit 2017 and 2018.

Eric Bragas

Twitter: - @ericbragas

LinkedIn: Eric Bragas

Contact: http://ericbragas.io

Business Intelligence Consultant passionate about leveraging new and cutting edge technologies to discover new data insights.

Rie Irish

Twitter: - IrishSQL

LinkedIn: Rie Irish

Rie lives with her family just north of Atlanta, Georgia. She worked as a SQL Server DBA, manager director for over 20 years. She’s worked in many industries including the non-profit sector, education, big pharma, and e-commerce. She was awarded the MVP in the Data Platform 3 times beginning in 2017 and gave that up to accept her role as a Senior Program Manager with Microsoft in 2019. She is very involved with the Atlanta MDF User Group, SQLSaturday Atlanta and is co-leader of the PASS Women in Tech virtual group.

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.

Jonathan Stewart

Twitter: - sqllocks

LinkedIn: Jonathan Stewart

Contact: https://sqllocks.net/

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.

Marsha Pierce

Twitter: - MarshaPierceDBA

LinkedIn: Marsha Pierce

Marsha Pierce lives in Nashville, TN. She studied Computer Science, Mathematics, and French at Belmont University. She has 23 years of experience as a DBA, which means she has broken and fixed a lot of stuff. Before joining Pure Storage, she was an architect at HCA and Asurion. She is passionate about DevOps, Storage, Performance Tuning, and Standardization.

Leonard Lobel

Twitter: - @lennilobel

LinkedIn: Leonard Lobel

Contact: http://lennilobel.wordpress.com

Leonard Lobel (Microsoft MVP, Data Platform) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner.

Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences.

Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.

Omar Masri

LinkedIn: Omar Masri

Omar is a software entrepreneur with over 20 years of experience in successfully bringing innovative products to the market. He led Strategy and Architecture for Database Products at Quest Software and Toad BI Suite at Dell Software. Omar is CTO of Cirro Inc. and Partner at Toba Capital.

Suresh Datla

LinkedIn: Suresh Datla

Worked on the Microsoft stack for 19 years now. Built successful Data Analytics Practices before. Currently focused on Data Platform, Data Analytics, Power BI and ML. I do Dashboard in a day sessions at Irvine MTC once every month. I also, conduct OC power BI user group to build a strong Power BI Community. Worked with SQL Server product since it was version 7 and Power BI since its inception.

Steve Rezhener

Twitter: - SteveRezhener

LinkedIn: Steve Rezhener

Contact: https://www.datasteve.com

Steve Rezhener is a database professional most enthusiastic about Microsoft BI stack. He started his IT career trying to outsmart Excel using VBA, moved to VB 6.0, VB.NET, C# and suddenly got addicted to SQL Server 2005 and related tools. His lunch menu for 10+ years consisted of SSIS SSRS with some occasional SSAS for breakfast. Steve is super excited about the innovation baked into AWS, Azure, PowerBI, and SQL Server 2017. Steve is a holder of relics such as DBA Microsoft certifications on SQL Server 2005 and SQL Server 2008. He is an organizer of SQLSaturday in Los Angeles (#SQLSatLA), LA Data Platform (aka SQLMalibu) and is an SQLSaturday speaker. When he isn’t dealing with data, he fixes a kitchen, plays an XBOX and enjoys his kids.

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.

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.

Warren Sifre

Twitter: - WAS_SQL

LinkedIn: Warren Sifre

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

Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.

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.

John Wells

Twitter: - @SQLServerDBA318

LinkedIn: John Wells

Contact: https://sqlrookieinthe318.wordpress.com/

I’m a DBA at Lamar Advertising in Baton Rouge. I’m a member of the Baton Rouge User Groups Board as well as a co-organizer for the ONLY SQLSaturday that serves Jambalaya for lunch! I started speaking in 2018 and enjoy everything about this powerful community! I enjoy performance tuning, helping developers with best practices and DBATools.

Rie Irish

Twitter: - IrishSQL

LinkedIn: Rie Irish

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

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

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.

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.

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.

Taiob Ali

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

LinkedIn: Taiob Ali

Contact: http://www.sqlworldwide.com

Taiob Ali, MVP Data Platform, is an accomplished technical leader with a proven record of success. For 14 years, he has worked with the Microsoft Data Platform and MongoDB both on-premise and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare. Taiob has hands-on experience in managing large database projects, massive data migration, intricate process design, testing and deployment, performance tuning, long term capacity planning. Taiob is currently working at “GMO LLC” as a Database Solution Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He is a regular speaker at local and virtual PASS chapters, SQLSaturdays, and Azure conferences.

John Morehouse

Twitter: - SQLrUs

LinkedIn: John Morehouse

Contact: http://www.sqlrus.com

John Morehouse is currently a Consultant with Denny Cherry Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member Community Ambassador, and 2016 Idera Ace. John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible. He is a user group leader, SQLSaturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQLSaturday’s as well as other conferences.

Mohammad Darab

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

LinkedIn: Mohammad Darab

Contact: https://mohammaddarab.com

Mohammad Darab is a Microsoft Data Professional, speaker and blogger with over 19 years of IT professional experience, 10+ years of that working with SQL Server. Some areas of his focus are the database engine, HA/DR, and security. He is currently an MCITP, MCP, as well as an IDERA ACE Class of 2019.

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

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.

Melody Zacharias

Twitter: - SQLMelody

LinkedIn: Melody Zacharias

Contact: http://sqlmelody.com

Melody is the Sr. Microsoft Solutions Manager at Pure and has been in love with data since 1991. She has been sharing her passion with the community in technical sessions and blogs since 2014. She has been a Microsoft MVP since 2016, including winning Rookie of the year for Canada that year. This last year, she was elected to the board of directors for PASS.org, the professional association for SQL Server and was awarded Regional Director by Microsoft. She has co-authored 3 books, including, SQL Server 2019 Administration inside out by Microsoft Press.

Elaena Bakman

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

LinkedIn: Elaena Bakman

For the first 15 years of my IT career I worked as a CRM Developer, but have been passionate about SQL since SQL Server 6.4. Five years ago I finally made the switch to the dark side and never looked back. I currently work as a Sr. Database Architect specializing in SSIS, SSRS, RDS, EC2 and enterprise level cloud migration.

Eric Bragas

Twitter: - @ericbragas

LinkedIn: Eric Bragas

Contact: http://ericbragas.io

Business Intelligence Consultant passionate about leveraging new and cutting edge technologies to discover new data insights.

Vazi Okhandiar

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

LinkedIn: Vazi Okhandiar

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

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

Taiob Ali

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

LinkedIn: Taiob Ali

Contact: http://www.sqlworldwide.com

Amy Herold

Twitter: - @texasamy

LinkedIn: Amy Herold

Contact: http://www.sqlkitten.com/

Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQLSaturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.

Chris Hyde

Twitter: - ChrisHyde325

LinkedIn: Chris Hyde

Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.

SQLSaturday Orange County

SQLSaturday Orange County Organizer

SQLSaturday Orange County

SQLSaturday Orange County Organizer

SQLSaturday Orange County

SQLSaturday Orange County Organizer

Vern Rabe

Twitter: - @VernRabe

LinkedIn: Vern Rabe

Contact: http://www.rabedata.com

Vern Rabe is an independent SQL Server consultant and contract trainer in Portland, OR, and leader of the Oregon Data Community user group, formerly OregonSQL. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been passionate about databases since 1992 and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server knowledge gained from the mixture of academic and practical experiences acquired from his classroom instructing and varied consulting contracts. Vern regularly presents technical sessions at SQL Server user group meetings, SQLSaturdays, and PASS Summit.

Charles Embry Jr

Twitter: - dbacharles

LinkedIn: Charles Embry Jr

Mr. Embry is the current Database Administrator/Programmer for the Choice Medical group in Apple Valley, Ca. He has previously been the Database Administrator/Programmer at the Snowline Joint Unified School District.

Mr Embry has present at several SQLSaturday events in Southern California, he has also presented at the Aeries User Conference and CETPA Annual Conference.

Diane Schuster

LinkedIn: Diane Schuster

Diane has worked with COZYROC since 2012. She has attended numerous SQLSaturdays to shine the light on the time-saving and capability-extending components and tasks that COZYROC offers in it’s SSIS+ library. Without even having a background in databases or SQL Server, Diane successfully configures packages in live demonstrations that use COZYROC components and tasks. She believes that, if the toolkit is this easy to use for a novice, then just imagine what a SQL Server expert can do with it!

In Diane’s data networking days, Diane performed a variety of development-related and customer-facing roles for IBM, Lucent Technologies, North Carolina State University and Connectware.

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.

Armando Lacerda

Twitter: - arlacerda

LinkedIn: Armando Lacerda

Brandon Leach

Twitter: - SQLServerNerd

LinkedIn: Brandon Leach

SQLSaturday Orange County

SQLSaturday Orange County Organizer

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!

Warren Sifre

Twitter: - WAS_SQL

LinkedIn: Warren Sifre

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

Martin Schoombee

Twitter: - sqlmartin

LinkedIn: Martin Schoombee

Contact: http://www.martinschoombee.com

Martin is an independent Business Intelligence Analytics consultant, helping customers make sense of their data for more than 15 years.

Melody Zacharias

Twitter: - SQLMelody

LinkedIn: Melody Zacharias

Contact: http://sqlmelody.com

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

SQLSaturday Orange County

SQLSaturday Orange County Organizer

SQLSaturday Orange County

SQLSaturday Orange County Organizer

SQLSaturday #740 - Orange County 2018

Sessions

Title: Well, actually… How to not be THAT guy in IT

Title: Stop Wasting Valuable Time and Resources - Performance Tune Your Jobs

Title: Data Wrangling for Reporting Analytics using Power BI

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

Title: [StepbyStep] SQL server Index operation for beginner to expert.

Title: Performance Troubleshooting made easier - new features in Management Studio !

Title: Azure Data Catalog – Turning Unused Assets into Usable Knowledge

Title: Data Protection Privacy in the World of Database DevOps

Title: Database Security in an Insecure World

Title: Python in SQL Server 2017

Title: Azure Automation: Your SQL Agent in the Cloud

Title: Let Her Finish: Supporting Women’s Voices in Technology

Title: The Query Store and Query Tuning in SQL Server

Title: New SQL Server 2016 Security Features for Developers

Title: Building a Dashboard in an Hour using PowerPivot Power BI

Title: Transforming Your Brain with SQL 2017 with Linux

Title: It’s Time for a Change: Temporal Table Support in SQL Server 2016/17

Title: SQL Server plays a pivot role in data sciences and business intelligence

Title: SSIS Project Deployment: The T-SQL Way

Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming

Title: Reporting Services 2016: New Features Smart Migration Strategy

Title: Introduction to BI Architecture

Title: RedGate: Extending DevOps to SQL Server

Title: Introduction to powershell for the SQL Server DBA

Title: The Mac DBA, using Docker and SQL Operations Studio

Title: Why Should I Care About … Partitioned Views?

Title: SQL Solutions Group: The DBA Is Dead. Long Live the Remote DBA.

Title: Ledgent : Resume Best Practices

Title: Azure Infrastructure

Title: Introduction to Big Data

Title: Dell: #GetModern with Dell EMC

Title: Storage For the DBA

Title: Mom Rules for Managing Enterprise Database Environments

Title: Microsoft Azure for SQL Server Professionals - Get your head in the cloud

Title: Quest: Realtime Monitoring Workload Analysis with Spotlight on SQL Server

Title: Concurrency in SQL Server - Managing More Than 1 User

Title: Insights with massive data ingestion and Power BI

Title: Modern ETL with Azure Data Factory, Data Lake, and SQL Database

Title: Power BI: What you need to know

Title: The Magic of SSISDB

Title: Power BI Adoption Framework

Title: Confidence: The Fuel For Action

Title: Data Pages, Allocation Units, IAM chains… Best Practice Edition

Title: DesignMind: Sponsor Showcase Session

Title: Fundamentals That Will Improve Your Query Performance!

Title: Making the Leap from Developer to DBA

Title: Foundations of a Data Driven Organization

Title: 60 Reporting Tips in 60 Minutes

Title: Deep Dive in Azure Data Factory V2

Title: 3 Lessons Learned in Successful Consulting

Title: Azure Basics for the DBA

Title: From problem to Power BI: A journey in data visualization

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

Title: Introduction to SQL Server Integration Services, what’s new in SSIS 2016, and a test-drive

Title: An introduction to the magical world of BIML!

Speakers

Sponsors