Event Location:
Loyola Marymount University ("LMU")
1 LMU Drive, Los Angeles, California
Los Angeles, California
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,
Abstract:
When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment. Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls. In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!
Speaker(s): Jeff Mlakar,
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,
Abstract:
If you are going to do anything with data you are going to need to learn how to query data. And the language to query the majority of those systems is through SQL (Structured Query Language). The pull data from any systems you are going to be relying on the Select statement. The features in the statement may vary slightly from platform to platform, but the core capabilities are the same. In this session, we will dive deep in to the SELECT statement as the window to getting your data. In this session, we will be using one platform, but the lessons learned here will be applicable to querying any system that supports a SQL language interface. This session will cover things like querying, joins, functions, aggregation, sub queries, and much more. This session will give you the foundation to start analyzing data in any database system.
Speaker(s): Andrew Karcher,
Abstract:
Have you ever come across such business scenarios when you feel you have challenged your Reticular Activating System to find an “out-of-the-box solution for Master Data Management in your Reporting System”? Have you ever thought about a self-service BI system, designed and customized, only for your Master Data? Often times, in IT industry executives neglect the fact that 30% of their data visualization contains Master Data. Integrating Master Data Services with Power BI, and presenting analytics on top only Master Data, can provide a high-end leverage to your organization. Whether it is a location model, a product model, a customer model etc., executives can highly be insightful from a report that contains all master data domains consolidated with a better visualization. Using individual subscription views from Master Data Services(SQL Server 2017) in Power Query, and utilizing all the cross references entities across models in MDS – can lead to a great one page report via Power BI.
Speaker(s): Swagatika Sarangi,
Abstract:
Take a dive into SQL on Linux and take on some sea monsters that are lurking in your bathtub. We'll take on the biblical Leviathan and answer: Why learn SQL on Linux anyway? We'll hunt down Moby Dick by sharpening our harpoons, by using tools you're probably already using with on Windows. After getting our feet wet, we'll go after the legendary beast, The Kraken, by leveraging your existing skills with Linux. Don't be eaten alive by Jaws and all the new fast-paced piranha-like features of SQL 2017. You can sail safely into the sunset by making SQL on Linux fun, memorable and learning lasting skills that will future proof your career. If you can install, backup, and restore SQL on Windows in your sleep, then perhaps now is the time to jump in. Be careful, you might get wet in the splash zones so dress accordingly or at least bring weather proof gear. Anchors Away!
Speaker(s): Andrew Nakamura,
Abstract:
Have you ever had a manager standing over your shoulder, wanting to know why a server is running slowly? Or if a server can handle additional workload? What information would you use to answer these questions? How would you share this information with your manager? If only you had performance metrics from your existing servers to answer these questions. In this session, we will be combining three open source tools (Telegraf, InfluxDB, and Grafana) into an inexpensive system that collects performance metrics you can use to troubleshoot and answer important questions about your SQL Server instances, including your SQL Server on Linux instances. We will learn what data to collect, how to use the tools mentioned to collect that data and then we'll put it all together in an interactive dashboard for easy visualization.
Speaker(s): Tracy Boggiano,
Abstract:
This session presents an overview of Azure Cosmos DB, a globally distributed, massively scalable, low (single-digit millisecond) latency, fully managed NoSQL database service that is designed specifically for modern web and mobile applications. Like other NoSQL platforms, Cosmos DB supports a schema-free data model, built-in partitioning for sustained heavy-write ingestion, and replication for high availability. But only Cosmos DB offers turnkey global distribution, automatic indexing, and SLAs for guarantees on 99.99% availability, throughput, latency, and consistency. We tour many features of Cosmos DB, including its multi-model capabilities which allow you to store and query schema-free JSON, graph, key/value, and columnar data models. You’ll learn about global distribution, scale-out partitioning, tunable consistency, custom indexing, and more. We’ll also explore client development using the many available SDKs and APIs. Attend this session, and get up to speed on Cosmos DB toda
Speaker(s): Leonard Lobel,
Abstract:
Microsoft’s Power BI service has allowed end users and business analysts to exercise their creativity as developers. The expansion of department resources to create elegant and visually appealing reports for themselves and their organization at a fast pace, has taken some of the burden off developers, or has it? Are you hoarding your environment with unorganized piles of data to feed your wonderful Power BI reports? In this life of point and click, drag and drop reporting, we sometimes lose sight of cohesive business standards, data integration and data modeling. In this session, we will look at potential data management concerns that include but are not limited to; overlapping data, inconsistent naming conventions, undocumented transformations, mismatch data types and varying granularity. We will focus on the importance of having a solid data model and managing data governance using Power BI as well as traditional tools and best practices.
Speaker(s): Jeremy Frye,
Abstract:
Analysis Services have become a major part of upper management daily decision making activities. However, with our DW sizes reaching multiple terabytes minimizing time required to process our data has become our top priority. In this session, we will cover the options we have as DBA’s to improve the performance of our DW processing time. We will look at features and general best practices available to us within SSAS and the database engine to ensure optimal performance, as well as enterprise level features within the database engine and SSAS available to us and how aligning those to work side by side would yield us significant improvement in our processing time.
Speaker(s): Konstantin Melamud,
Abstract:
Performance troubleshooting is a required skill for every DBA. Knowing the deep internals of how a query functions and why SQL Server chose to run it in a certain way is important. Knowing how to design a table or configure a database to squeeze every ounce of performance is our lifeblood. What if I told you that you may be doing this all wrong? What if all the work and laborious effort put into design or configuration don't improve the situation because the issue was never in SQL to begin with? Truth be told, the biggest differentiator between a good DBA and a great DBA is knowing the hardware and O/S; not just SQL. Join me as I guide you through troubleshooting SQL Server performance from tip to toe to demonstrate the common performance problems you never knew you had.
Speaker(s): Daniel Janik,
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,
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,
Abstract:
Join our interactive discussion on diversity and inclusion. This WIT talk is open to all attendees. Let’s share our perspectives in career growth in this inevitable diverse industry. Learn some tips and tricks on how you can grow your potential and help others to grow as well. Session format: * Improve style, no PowerPoint required * Multiple speakers, 10 to 15 minutes each * Talk about your career, how you got started, what worked for you, what didn’t, advice on getting ahead, and what you love most about your job Speakers: Amy Herold, Mindy Curnutt, Swagatika Sarangi, Amie Mason, Tracy Boggiano, Marsha Pierce
Speaker(s): SQL Saturday in LA,
Abstract:
This session will explore how to host your SQL Server databases on Amazon Web Services (AWS), comparing the Relational Database Service (RDS) SQL Server platform to hosting your databases on EC2. We will explore the versions supported, provide an overview of how licensing works, explain options around High Availability, and also explore migration options from on-premise, EC2, or other hosted SQL Server solutions.
Speaker(s): Richard Waymire,
Abstract:
Way, way back in SQL 2008 Microsoft added the capability to store and work with geospatial data types. (Wait...what's this you say?!?) Well, yes...it's been there for quite some time now. You can actually store spatial data in SQL tables (in the form of points, lines and polygons). There are also many powerful, built-in functions that allow the manipulation and calculation of results around this data. This is a powerful, but sadly underused feature of the product given that IoT tends to be so focused around the location of things. Come to this session to learn about: ● The two elusive data types (geography and geometry) ● T-SQL Spatial routines and functions ● How to load spatial data ● Spatial Indexes - how they work and when they're useful ● Where you can get lots and lots of free spatial data to supplement your existing systems
Speaker(s): Mindy Curnutt,
Abstract:
The way you tune your SQL Server workloads are changing. In the past, you would rely on dynamic management views, execution plan cache, and server-side traces or extend events. In SQL Server 2012 we were introduced to Columnstore indexes; In SQL 2014 the cardinality estimator got a huge overhaul. With SQL Server 2016 we were given query store to allow us to get more insight into our performance pains and execution plan changes. SQL Server 2017 gave us Automatic Tuning and Adaptive Query Processing to help automate performance improvements. In this session, we will harness the ways you improve performance into the new so you can automate the pain away and spend more time identifying and tuning pain points that cannot be automated.
Speaker(s): John Sterrett,
Abstract:
In this session, we will start with an overview of Azure Data Factory V2 concepts, then show you how you can use metadata to quickly build scalable serverless pipelines to move data from disparate data sources including On-Premises and Platform As A Service. Next, we will look at how to integrate the solution using continuous integration and deployment techniques. Finally, we will look at how to schedule, monitor and log our solution. Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.
Speaker(s): Jason Horner,
Abstract:
One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we'll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We'll start to demonstrate the power of R by showing you how to create and run simple R 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 R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!
Speaker(s): Chris Hyde,
Abstract:
The General Data Protection Regulation (GDPR), which took effect on May 25, 2018 heralds a new era of enhanced personal privacy rights and adds additional duty to companies for protecting data. However, it’s not just about protecting the privacy of personal data of EU citizens. Data breaches such as at Target, Equifax, Uber and many others, result in loss of customers, loss of profits and cost executive jobs. A survey by Forrester reveals that 74% of individuals are ready to switch to a competitor if their bank or insurer suffers a data breach. Security and Privacy capabilities ranks as the number 1 initiative by 55% of organizations in a 2017 Customer Priorities Journey Survey. In this session, we will discuss all things data protection with the Microsoft Data Platform. Whether it is to comply with the requirements of GDPR or ensuring that your data is the most secure it can be.
Speaker(s): Rushabh Mehta,
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.
Speaker(s): Armando Lacerda,
Abstract:
Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.
Speaker(s): Amy Herold,
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,
Abstract:
Amazon web services offers a befuddling number of of different services. Among these are the two major options for running SQL Server on AWS - Elastic Compute Cloud and Relational Database Services. Why would one be picked over the other? What are the limitations and trade offs? We will discuss these questions among others while working through the process of restoring a sample database under both services.
Speaker(s): Rick Lowe,
Abstract:
SQL Server is now available on Linux but you only know Windows, now what? During this session we'll introduce the Linux version of Windows commands you use on a daily basis for administering SQL Server. We'll look at updating Linux, updating SQL Server, moving files between Windows and Linux, and backing up and restoring databases from one system to another. We'll also look at default file locations for SQL Server and what can be moved and how to accomplish that. NOTE: This is an intro to Linux for Windows users, only brief references to SQL Server on Linux will be made.
Speaker(s): Jay Falck,
Abstract:
This session will discuss the trials and tribulations encountered when shifting from on-premise databases into AWS. We will cover topics such as: permissions, EC2 RDS setup, Database Migration Services, using Amazon S3 to transfer and restore databases, and cost analysis.
Speaker(s): Nathaniel Payumo,
Abstract:
Many organizations have over- or under-utilized assets in their cloud infrastructure. While running infrastructure in the cloud can yield many benefits in terms of agility and innovation, it can also lead to increased costs. In this session we will walk you through the process of rightsizing, as well as how to take advantage of Reserved Instances once your infrastructure is running efficiently. This session will be beneficial for anyone using AWS, Azure, or both!
Speaker(s): SQL Saturday in LA,
Abstract:
Learn about Azure SQL Data Warehouse (SQL DW) which is a fully managed elastic database built for data warehouse workloads supporting up to petabytes of data. It has unique features like disaggregated compute and storage allowing customers to be able to utilize the service to match their diverse needs. In this session, we take a look at the architecture of SQL DW and features such as elastic scale (grow, shrink, and pause) and Polybase and how you take advantage of them for your data warehousing solution.
Speaker(s): Kevin Ngo,
Abstract:
In a cloudy, virtualized world where we have less physical deployments of SQL Server, those responsible for SQL Server still need to understand basic infrastructure concepts whether you are deploying on Windows Server or Linux. Without them, your VMs and IaaS deployments will not scale, will underperform, and most likely will have poor availability. This session will cover the basics of what you need to know whether you are deploying SQL Server on premises or in the public cloud to go from SQL Server zero to SQL Server hero and be able to have better working relationships with the other administrators in your organization.
Speaker(s): Allan Hirt,
Abstract:
Parameter sniffing is a good thing: it is used by the Query Optimizer to produce an execution plan tailored to the current parameters of a query. However, due to the way that the plan cache stores these plans in memory, sometimes can also be a performance problem. This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well. The session will also include details on how the Query Optimizer uses the histogram and density components of the statistics object and some other advanced topics.
Speaker(s): Benjamin Nevarez,
Abstract:
Integration Services (SSIS) can be a very powerful tool for data loading as well as many other functions. In this demo we'll cover some methods for getting started with this program.
Speaker(s): Brodie Brickey,
Abstract:
Everyone wants a great job that they enjoy, but few of us know how to take charge of our career. Learn why it's important to raise your profile in today's highly competitive world where there are often more candidates than positions for great jobs. This session will help you build a strong brand that allows you to attract potential employers or clients and start to convince them ahead of time that you are the person they want to hire.
Speaker(s): Steve Jones,
Abstract:
For most DBAs virtualization is no longer a matter of "If" but "When". This means it is critical for DBAs to understand how this technology works and how we can ensure we get the most performance and scalability out of it. In this session we will look at some of the best practices and gotchas when Designing Standalone and Highly Available SQL deployments in a vSphere environment. We'll also cover how to troubleshoot performance issues when they arise.
Speaker(s): Brandon Leach,
Abstract:
Dexter and Dee Dee are at it again! They managed to save the city with his super intellect and sister's hyperactive charm. We won't have to keep our lab a secret as you attend this session. Learn how to build your own Machine Learning Lab, without the keeping it underground. We will cover the fundamental knowledge to get started because you don't want you blowing up things in production. Learn step-by-step in my demo to build a full lab so you too can save the city…or at least get started with Machine Learning today.
Speaker(s): PEIXIN WANG,
Abstract:
In one small step, SQL Server 2016 has taken a giant leap...to JSON! In this session, we'll launch a probe into a JSON data file containing profiles of NASA astronauts using new JSON T-SQL functions in SQL Server. With each astronaut we meet, we'll learn to validate, read, and manipulate "unstructured" JSON data. We'll get The Right Stuff to start developing, no previous JSON experience required. Let's go where NoSQL has gone before! Prerequisites: You should have experience writing queries in T-SQL. No previous knowledge of JSON is needed.
Speaker(s): Peter Kral,
Abstract:
We will be discussing the lifecycle of a Power BI Dashboard beginning from Accessing data, Data preparation, and cleansing, consuming the data for reports and deploying the reports to Power BI services, configuring security and making the Dashboards available to end users.
Speaker(s): Suresh Datla,
Abstract:
Amazon Web Services (AWS) is the world's largest public cloud hosting provider, with many companies successfully running SQL server on AWS infrastructure, but trying to make sense of the available options can be daunting. In this session, we will explore the options available for running SQL server in AWS, either as a managed service or using dedicated EC2 instances. We will document the different storage options, High Availability strategies, as well as important security and maintenance caveats. We will also cover various licensing approaches available when running SQL server in AWS.
Speaker(s): Brian Carrig,
Abstract:
TBD
Speaker(s): SQL Saturday in LA,
Abstract:
Microsoft report authors work in several tools, including T-SQL, SSMS, SSRS, and Power BI. Come to this session to learn 60 rapid fire tips that will make you not only be better, but increase you enjoyment working with those tools.
Speaker(s): Ike Ellis,
Abstract:
A general discussion about storage and how it affects DBA's. We will discuss how to monitor for performance as well. We will also discuss what DBA's need to consider when talking to their storage administrators.
Speaker(s): Marsha Pierce,
Abstract:
TBD
Speaker(s): SQL Saturday in LA,
Abstract:
If you like being the surly IT geek who lives in a dark office and gets fed pizza under the door (i.e. a flat boxer) this session is NOT for you. However, if promotion, appreciation for what you do, and the adoration of your peers and management are appealing to you, you might want to participate in this one.
Speaker(s): Randy Knight,
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,
Abstract:
TBD
Speaker(s): SQL Saturday in LA,
Abstract:
Every Power BI model has dates and the need of calculation over dates to aggregate and compare data, like Year-To-Date, Same-Period-Last-Year, Moving Average, and so on. Quick measures and DAX functions can help, but how do you manage holidays, working days, weeks based fiscal calendars and any non-standard calculation’ This session provides you the best practices to correctly shape a data model and to implement time intelligence calculations using both built-in DAX functions and custom DAX calculation for more complex and non-standard requirements.
Speaker(s): Marco Russo,
Abstract:
Discover the ways Azure transforms AI and Predictive Analytics making it easier and more accessible through services like Azure Machine Learning and pre-built Cognitive Services, while also supporting custom development and deep-learning.
Speaker(s): Amie Mason,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/jeffmlakar/
Contact: http://www.mlakartechtalk.com/
Jeff Mlakar is a database professional specializing in Microsoft SQL Server. He has worked the past 15 years as a database developer and administrator (admini-loper or develo-strator…take your pick), analyst, and with Business Intelligence. A technology enthusiast – he is interested in data security and privacy topics. Jeff lives in the Raleigh-Durham area of NC.
LinkedIn: http://www.linkedin.com/in/aherold
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 SQL Saturday 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.
LinkedIn: http://www.linkedin.com/in/jasonhorner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I'm a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I'm fluent in several languages including: SQL, C#, Python, and PowerShell. I'm a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years. In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
LinkedIn: http://www.linkedin.com/in/ikeellis
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.
LinkedIn: https://www.linkedin.com/in/chris-hyde-3803706
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.
LinkedIn: https://www.linkedin.com/groups/13514278
Contact: http://www.instagram.com/sqlsatla
What is SQL Saturday? http://www.sqlsaturday.com/773 @SQLSatLA #SQLSatLA PASS SQL Saturday is a free 1-day training event for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Hundreds of SQL Server and other IT professionals will be in attendance. With 6 simultaneous tracks potentially offering 40+ sessions in anything from database administration to performance tuning as well as business intelligence and professional development conducted by MVP-grade speakers. SQL Saturday is an invaluable learning and networking opportunity for SQL professionals and a great way to spend a Saturday.
LinkedIn: http://www.linkedin.com/in/tedstathakis
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.
LinkedIn: http://www.linkedin.com/in/way0utwest
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
LinkedIn: https://www.linkedin.com/in/jeffprom
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.
LinkedIn: https://www.linkedin.com/in/brodie-brickey-b074988/
Over eighteen years in Information Technology developing solutions for companies. I specialize in integrating information from disparate systems for legal and financial firms. PMP ITIL certified.
Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQL Saturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.
LinkedIn: https://www.linkedin.com/in/nathanielpayumo/
Nathaniel Payumo is a database engineer engaged in numerous platforms including: T-SQL, SSIS, SSRS, and numerous AWS Cloud Services. He has built numerous applications using AWS Serviceless Framework and has developed APIs using Python, Application Front-Ends using JavaScript and ReactJS. He has explored Machine Learning Tools and integrated them within business applications and ETLs.
LinkedIn: http://www.linkedin.com/in/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.
LinkedIn: https://www.linkedin.com/groups/13514278
Contact: http://www.instagram.com/sqlsatla
What is SQL Saturday? http://www.sqlsaturday.com/773 @SQLSatLA #SQLSatLA PASS SQL Saturday is a free 1-day training event for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Hundreds of SQL Server and other IT professionals will be in attendance. With 6 simultaneous tracks potentially offering 40+ sessions in anything from database administration to performance tuning as well as business intelligence and professional development conducted by MVP-grade speakers. SQL Saturday is an invaluable learning and networking opportunity for SQL professionals and a great way to spend a Saturday.
LinkedIn: https://www.linkedin.com/pub/allan-hirt/1/b72/673
Contact: http://www.sqlha.com/blog
SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.
LinkedIn: https://www.linkedin.com/groups/13514278
Contact: http://www.instagram.com/sqlsatla
What is SQL Saturday? http://www.sqlsaturday.com/773 @SQLSatLA #SQLSatLA PASS SQL Saturday is a free 1-day training event for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Hundreds of SQL Server and other IT professionals will be in attendance. With 6 simultaneous tracks potentially offering 40+ sessions in anything from database administration to performance tuning as well as business intelligence and professional development conducted by MVP-grade speakers. SQL Saturday is an invaluable learning and networking opportunity for SQL professionals and a great way to spend a Saturday.
LinkedIn: http://www.linkedin.com/pub/daniel-janik/12/15b/606/en
Contact: http://www.sqltechblog.com
Daniel Janik has been supporting SQL Server for 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQL Saturdays.
LinkedIn: https://www.linkedin.com/in/jayfalck
I started as a night shift computer operator out of high school. I moved to applications development after graduation from SAC. After a few years with the State as an applications developer, the manager of Systems Programming decided it would be better to have me on the inside looking out rather than on the outside trying to get in. I spent the next 14 years as a mainframe system programmer for two state agencies. In 1996 I moved to Healthcare IT and have been that ever since. I’ve spent most of the past 14 years doing ETL, performance and HIPAA security. In these various jobs, I’ve used all manner of databases including InfoTec IMP, IBM VSAM and DB2, Interbase, Informix, Universe, Oracle 9i and SQL Server from 6.0 to 2008 R2.
LinkedIn: https://www.linkedin.com/in/tracyboggiano
Contact: http://databasesuperhero.com
Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC. Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com. Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.
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.
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 SQL Saturday – San Diego.
LinkedIn: https://www.linkedin.com/in/richardwaymire/
Richard Waymire is a technical expert on Microsoft SQL Server. He has been involved in numerous Microsoft early adaptor projects and new technologies. Richard has broad ranging experience from the relational data modeling phase through the production implementation of database solutions built with SQL Server, including data loading, monitoring, and performance tuning. Richard has worked on SQL Server for more than 26 years, including 12 years as part of the SQL Server team at Microsoft. In his role with Amazon Web Services, Richard is the Americas specialist for SQL Server, as well as for Amazon Aurora.
LinkedIn: http://www.linkedin.com/pub/rick-lowe/a/228/441/
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.
LinkedIn: https://www.linkedin.com/in/sarangiswagatika/
Contact: https://www.jazzintelligence.com/
*** AWS - SA Informatica - MDM Certified, Solutions Architect *** I have had nearly a decade of experience in leading Data Governance, Master Data and Data Quality oriented efforts, strategizing business plan, implementing all phases of SDLC and Agile for clients/projects including Telecommunication, Oil Gas, Sporting goods, Logistics, Consulting, Insurance, Restaurant Education etc. domain. I have extensive experience with developing effective business roadmaps and business models across E-Commerce, B2C, B2B, B2B2C with a major focus in effectively evaluating/and aligning Business Intelligence Analytics Data Warehousing with the appropriate KPI's.
LinkedIn: https://www.linkedin.com/in/ki6bjv
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 SQL Saturday events in Southern California, he has also presented at the Aeries User Conference and CETPA Annual Conference.
LinkedIn: https://www.linkedin.com/in/ngovkevin/
Kevin Ngo is a Program Manager on the Azure SQL Data Warehouse engineering team with a BS in Computer Science from UC San Diego. He is currently working in areas of the service related to tooling and manageability.
LinkedIn: https://www.linkedin.com/in/mindycurnutt
Contact: http://www.mindycurnutt.com
Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQL Saturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.
LinkedIn: http://www.linkedin.com/in/johnsterrett
Contact: https://johnsterrett.com/community/
John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQL Saturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John's community activities can be found at https://johnsterrett.com/community/
LinkedIn: http://www.linkedin.com/in/lennilobel
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.
LinkedIn: https://www.linkedin.com/in/jeremyilfrye
Contact: https://jeremyfrye.net
Jeremy Frye is the manager of the Business Intelligence and data warehousing team at RDX. He is a Business Intelligence architect and developer with a background in database administration as well. Jeremy has over 9 years of experience in SQL Server. He has spoken on BI topics at many SQLSaturday's throughout the country, webinars, and local and remote SQL user groups. In his spare time, Jeremy often spends time trying to bridge the gap between keyboard strokes and workout reps.
LinkedIn: http://www.linkedin.com/in/sqlbi
Contact: https://www.sqlbi.com/blog/marco
Marco is a Business Intelligence consultant and mentor. He wrote several books about Power BI, Analysis Service, and Power Pivot. He also regularly writes articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services. Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide. Marco is a regular speaker at international conferences like Microsoft Ignite, PASS Summit, and SQLBits. He also enjoys delivering evening sessions at local user groups during his trips.
LinkedIn: http://www.linkedin.com/pub/andy-nakamura/18/12/709/en
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 SQL Saturdays 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!
LinkedIn: https://www.linkedin.com/groups/13514278
Contact: http://www.instagram.com/sqlsatla
What is SQL Saturday? http://www.sqlsaturday.com/773 @SQLSatLA #SQLSatLA PASS SQL Saturday is a free 1-day training event for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Hundreds of SQL Server and other IT professionals will be in attendance. With 6 simultaneous tracks potentially offering 40+ sessions in anything from database administration to performance tuning as well as business intelligence and professional development conducted by MVP-grade speakers. SQL Saturday is an invaluable learning and networking opportunity for SQL professionals and a great way to spend a Saturday.
LinkedIn: https://www.linkedin.com/groups/13514278
Contact: http://www.instagram.com/sqlsatla
What is SQL Saturday? http://www.sqlsaturday.com/773 @SQLSatLA #SQLSatLA PASS SQL Saturday is a free 1-day training event for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Hundreds of SQL Server and other IT professionals will be in attendance. With 6 simultaneous tracks potentially offering 40+ sessions in anything from database administration to performance tuning as well as business intelligence and professional development conducted by MVP-grade speakers. SQL Saturday is an invaluable learning and networking opportunity for SQL professionals and a great way to spend a Saturday.
Brian Carrig is a Microsoft Certified Master of SQL Server and is currently a Senior Program Manager on the SQL Server Tiger Team at Microsoft focusing primarily on persistent memory technology and replication. In a previous life, Brian spent some time as an academic and holds a PhD in Computer Science. He is a native of Dublin, Ireland but now lives with his wife and two daughters in Redmond, Washington. If he is not talking about, thinking about or working with technology you will usually find him watching Chelsea FC.
LinkedIn: https://www.linkedin.com/in/sqlservernerd
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.
LinkedIn: https://www.linkedin.com/in/elaena-bakman-473457a/
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.
LinkedIn: http://www.linkedin.com/in/randyknight
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 SQL Saturday and User Groups.
LinkedIn: https://www.linkedin.com/in/sureshdatla/
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.
LinkedIn: https://www.linkedin.com/in/chris-hyde-3803706
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.
LinkedIn: https://www.linkedin.com/in/peterkral
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.
LinkedIn: https://www.linkedin.com/in/marsha-pierce-1a020a2
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.
SQL SERVER DBA/DEVELOPER; ORACLE DEVELOPER/DBA; SAS PROGRAMMER/ADMIN; QLIKVIEW DEVELOPER/DBA; JAVA PROGRAMMER
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, SQL Saturdays and Conferences along with supporting my local community as a SQL Saturday 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.
LinkedIn: https://www.linkedin.com/in/rushabhbmehta
Rushabh is a Principal Architect at SolidQ and the Founder/CEO of Matchbook Services. With over 20 years of experience in the data management, mastering and analytics space, Rushabh has developed a keen understanding of the role of good data management strategies and their impact to an organization.
LinkedIn: http://www.linkedin.com/in/amiemason33
Consultant with a demonstrated history of working with clients across multiple verticals to leverage their data to improve reporting and decision making in their business. Able to quickly assess business requirements and skilled in report design and predictive analytics enabling a direct translation from those requirements to business impact. Broad background includes experience in the public sector, survey design, and grassroots campaign management.
The following is a list of sponsors that helped fund the event.