Pre-Register for 2020

Pre-Conference Sessions

Make the most of your experience at PASS Summit with a full-day, hands-on Pre-Conference Session. These sessions are demo-filled and interactive; the best method to propel your learning and grow your skills.

Data Science in a Day: Preparation, Patterns, and Predictions

Natasha Balac
Analytics

This one-day Data Science training is designed for attendees seeking to acquire Machine Learning and Artificial Intelligence skills and are ready to expand their knowledge in the area of Data Science. In this training, attendees will obtain the practical Data Science approaches to discover patterns and relationships from complex data.

Mastering T-SQL Querying Fundamentals

Itzik Ben-Gan
Data Management

Does your work involve interacting with Microsoft SQL Server or Azure SQL Database? If so, writing T-SQL code is probably an integral part of your work. You will naturally learn about T-SQL querying tools like joins, subqueries, table expressions, recursive queries, APPLY, set operators, and many others. This seminar will help you write correct and robust T-SQL code, avoid bugs, follow best practices, think in set-based/relational terms, and get a better mastery of T-SQL querying.

AI and Power BI: The Realm of the Impossible

Leila Etaati
Analytics

There are tons of ways to do machine learning in Power BI. From using pre-built AI services such as Cognitive Services and custom visuals, to custom AI tools such as writing R, Python scripts, or using Azure ML Studio (a drag and drop service). In this Pre-Conference session, all of these Machine Learning services will be explored in great detail.

Architecting a Big Data Analytics Solution in SQL Server 2019

Kevin Feasel
Architecture

In this full-day training, you will learn about the tactics and techniques surrounding Big Data Analytics, particularly on the Microsoft stack. By the end of the day, you will have an understanding of how to scope and design a Big Data Analytics project from beginning to end.

Advanced Virtual SQL Server Performance

David Klee
Architecture

This full-day boot camp covers all aspects of performance engineering for virtualized SQL Servers. You will understand how to review your critical SQL Servers for both their performance and availability as they relate to the virtualization and physical compute layers underneath, and work with your infrastructure team to implement and streamline any of your findings.

Database Privacy and Security for Developers

Ed Leighton-Dick
Architecture

In this one-day session, we will discuss a range of topics that developers need to know in order to improve their applications' data security and privacy.

Redgate SQL in the City Summit Seattle

Kendra Little, Grant Fritchey, Steve Jones, Ike Ellis and Hamish Watson
Architecture

Redgate SQL in the City Summit Seattle brings together database, IT, operations, and development leaders together to discuss Compliant Database DevOps. Stay ahead of the competition and discuss what's needed for IT to effectively balance the demand for delivering software faster, while protecting and preserving business critical data. 

The SQL Server DBA’s Guide to Docker Containers

Edwin Sarmiento
Architecture

This whole-day workshop is specifically designed for senior SQL Server database administrators and systems engineers responsible for automating deployment, scaling, and management of containerized applications.

SQL Server Administration Made Easy with dbatools

Rob Sewell
Data Management

dbatools is an open-source cross-platform PowerShell toolkit for SQL Server DBAs. In this Pre-Conference session you will learn many practical examples of how dbatools can help you to save time in your DBA administration duties. 

Performance Tuning With Query Store in SQL Server

Erin Stellato
Data Management

We’ll cover Query Store end-to-end in this full day workshop using real-world examples based on customer issues resolved over the last 2+ years. You'll learn how to find and leverage important information in Query Store to make solving common performance problems easier the moment you walk back into the office. 

SOLD OUT

The SQL Server 2019 Workshop

Bob Ward
Data Management

You may have heard or seen something about SQL Server 2019, but the best way to learn is to try it yourself. Bob Ward, Principal Architect for the SQL Server Engineering Team, will lead you through a day-long workshop on how to maximize the new capabilities of SQL Server 2019.

How to Build 5 Azure-Powered Apps to Automate Your Job

Tim Corey
Data Management

Azure is an incredibly large, ever-changing landscape that can sometimes feel overwhelming. Even if you are using one or two services, you might still feel like you are just barely scratching the surface of what you could be doing. In this full day pre-con, we will be building five different applications as an excuse to explore the various services Azure has to offer in a practical manner.

Move a Successful Legacy On-Premise OLTP SQL Server Database to Azure

Ike Ellis
Architecture

This session will calm the process of moving a legacy OLTP SQL Server database to Azure. We will cover all aspects of the move, including networking, security, data movement, compatibility, project planning, risk assessment, refactoring, removing on-premises dependencies, and future enhancements.

From 0 to DAX

Alberto Ferrari
Analytics

During this one-day workshop, Alberto will guide you in the process of learning the DAX language through many examples and scenarios that will help you understand the important concepts of DAX and how to leverage them in your everyday work. 

Bigger Hardware or Better Code and Design?

Jonathan Keyahias
Data Management

This session will take a look at many of the new features of SQL Server and how they can best be leveraged for performance tuning your workload. From In-Memory OLTP to Columnstore Indexes, Query Store, and Extended Events, this session will guide you in finding the source of the problems and solutions available to make your workload faster and consistently reliable.

How to Architect Successful Database Changes: Source Control and Release Patterns for Performance and Availability

Kendra Little
Architecture

Learn how to frequently release quality database changes while maintaining high performance and availability standards in this full day Pre-Conference Session. 

SQL Server Performance Tuning and Optimization

Monica Rathbun
Data Management

In this full-day session, you will learn how to identify problems using a variety of tools and best practices across your environments. You’ll leave this demo-filled session better prepared to tackle many issues that can plague SQL Server performance along with the knowledge of how to resolve them.

An Introduction to Data Driven Storytelling: Data Visualization for All!

Jonathan Stewart
Analytics

In this session, we will have fun discussing the ins and outs of data driven visualizations. We will discuss the theory that becomes the practical. We will learn not only the how, but the WHY! Get hands on experience as we work through multiple scenarios and learn how to build impactful data driven visualizations! 

SOLD OUT

The SQL Server 2019 Workshop

Bob Ward
Data Management

You may have heard or seen something about SQL Server 2019, but the best way to learn is to try it yourself. Bob Ward, Principal Architect for the SQL Server Engineering Team, will lead you through a day-long workshop on how to maximize the new capabilities of SQL Server 2019.

Practical Azure Databricks: Engineering & Warehousing at Scale

Simon Whiteley
Architecture

You've probably heard the buzz - there's a thing called Azure Databricks that is going to solve all your problems? Surprisingly, it just might. By the end of the day, you will understand how Azure Databricks sits at the core of data engineering workloads and is a key component in Modern Azure Warehousing.

Modernizing your Database with Azure SQL

Sanjay Mishra
Architecture

Azure SQL provides the most comprehensive set of capabilities on a cloud relational database. Whether you are building a new application or migrating an existing application, whether you are a SaaS provider or an Enterprise business, Azure SQL is the best choice. SQL in a virtual machine, Azure SQL Database, Managed Instance, Elastic Pools, Azure SQL Hyperscale, Azure SQL DB Serverless – Azure SQL family of services provide you a variety of choices to build and run your SQL environment in the most cost-effective, secured and performant manner.

Are You Ready?

Pre-Register for 2020

cage-aids
cage-aids
cage-aids
cage-aids