Please note: our site will be undergoing scheduled maintenance on April 21, 2019, starting at 07:00 UTC and ending at April 22, 2019 04:00 UTC. During this period, you will not be able to log in to your PASS account. To register for PASS Summit, select the Register as Guest option. If you require assistance, please email helpdesk@pass.org. Thank you for your patience.

Build Schedule

Advanced Filters:
  • Track

    clear all













  • Speaker


  • Level


  • Session Type


Sessions Found: 47
SQL Server has many build in T-SQL functions. This session will introduce you to 42 of them and explain how they can make your life easier. To name just a few TRANSLATE(REVERSE(DIFFERENCE(STATS_TIME(STRING_SPLIT(…))))
Speaker:

Accompanying Materials:

No material found.

Session Type:
Double Session (120 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 04

Time: 2:20 PM - 4:20 PM

Room: K

Somehow you managed to get yourself voluntold to take care of the company’s SQL Server installation. Over time, you picked up the basic knowledge of how to use indexes to make queries perform better. 
But there are still cases where things just don’t appear to work as expected. Cases where SQL Server seems to ignore existing indexes. Situations where you just can’t figure out how to create a fitting index in the first place.
If that describes you, this session is for you. In it you’ll discover:
- What index selectivity is and how it impacts index selection
- The ominous “tipping point” and how it can lead to surprising index choices by the optimizer
- How to improve Aggregate Performance with indexes
- How to improve Join Performance with indexes
- Indexes on heaps and the Forwarded Records trap
- Filtered Indexes
After attending, you’ll have a set of new tools and techniques in your SQL Server toolbox that you can take home and use to increase performance in your database right away.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 04

Time: 2:10 PM - 3:10 PM

Room: C

In the last releases,  SQL Server development was enriched with new T-SQL features, such as STRING_AGG, STRING_SPLIT, TRANSLATE array of Ranking and Windowing functions (ROW_NUMBER, RANK, DENSE_RANK, TILE), MERGE statement, OUTPUT clause, EXCEPT and INTERSECT just to name a few. For various reasons some DBA/Developers do not utilize these new features. In this session, the audience will see demonstrations of the different practical use cases where these features can make T-SQL coding more efficient. This 100% code-based demo session highlights efficiency to utilize the latest T-SQL functions over conventional methods with the same functionality. The session will cover in depth live scenarios where these features have proven performance efficiency, code re
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 04

Time: 11:40 AM - 12:40 PM

Room: F

Data Science is currently the hottest topic among data analysts and technologists, but getting started can sometimes be daunting or confusing to many data professionals.  We aim to change that with this full-day, hands-on course in which you will be introduced to data science and its basic methodologies using the Python programming language!

Together we will work through some real-world data analyses using several of the most popular Python libraries, such as NumPy, pandas, Matplotlib, and SciPy.  We'll cover collecting and importing data, and introduce basic statistics around our data.  We'll then move on to create some simple visualizations of our data to help us identify trends and patterns.

Note that as this is a hands-on pre-con, participants will be required to bring a laptop with a working Python installation.  Full details on this will be provided prior to the session.

More Details and Sign-Up: https://sqlsat835precon2.eventbrite.com
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
PreCon (Friday)

Level: Beginner

Session Code:

Date: May 03

Time: 9:00 AM - 10:00 AM

Room: Q

In the modern world of information technology, SQL Server DBA tasks exceed typical Administration and T-SQL development. Each new SQL Server version brings additional technologies that help streamline and improve its functionalities. Within the last decade, SQL Server has evolved into a sophisticated Enterprise RDBMS tool, and it continues to grow by providing more functionalities to store and manipulate data reliably.

PowerShell, .NET, XML and JSON skills often appear in SQL Server DBA job requirements because the ability to work with those allow the DBA to adapt faster and more efficiently when solving different types of problems. This session designed to bring you up to speed with several of these technologies.

More Details and Sign-Up: https://sqlsat835precon1.eventbrite.com
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
PreCon (Friday)

Level: Advanced

Session Code:

Date: May 03

Time: 9:00 AM - 10:00 AM

Room: P

Are too many systems hitting your SQL Servers? Do you know who they all are? Are you under attack?
When it comes to this type of problem the consensus is to get with your network and domain admins to adequately configure access options. 
What happens when you can't wait or don't even have folks in that role to get the configuration right? 

A blacklist is a list of what cannot access something you are trying to protect. (Like the TSA no-fly list. If you are on the list, you are not getting anywhere fast.)

A whitelist is just the opposite. It is a list of what is permitted to access something. If whatever is attempting access is not on the list, it isn’t getting in.
In this session, we will go through the process to create and test your own SQL based whitelists and blacklists and also take a look at how whitelisting is being used in SQL 2017 to control what CLR objects can be trusted to run in your environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 04

Time: 11:50 AM - 12:50 PM

Room: K

In this case study, I detail how I went about designing and implementing a Speaker Database for the Project Management Institute using SharePoint, Flow, Power Apps, and Microsoft Forms. We will do a brief intro of what each technology is and it's pros and cons, and then dive into what I learned about each, each strengths and weaknesses, and how I was able to build a functional Speaker Database.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 04

Time: 3:35 PM - 4:35 PM

Room: G

Python is the one of the most popular programming languages used today and one of the most useful tools in the data scientist's tool belt especially for machine learning. Python is integrated into the Microsoft stack in tools like Azure ML and now SQL Server 2017.

The session will be an introduction to the Python language including: 

1.) Installing and Configuring Python
2.) Access and Manipulate Data
3.) Install and Manage Packages
4.) Create and Use Objects/Variables
5.) Control Flows and Functions
6.) Managing the Python installation in MSSQL

Attend this session to learn how to use Python to take your data analytics to the next level. We will use Python, SQL Server and the Anaconda distribution of Python to learn the basics of Python and how it is integrated in the Microsoft stack! We will walk through a simple deployment of a machine learning model to see how it all works together and learns some basic data science fundamentals.

No prior statistics knowledge needed.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: May 04

Time: 2:15 PM - 3:15 PM

Room: F

In this fun, interactive presentation, Je'Anna Abbott gives tips for handling those conversations you know you need to have, but you've been avoiding because it seems too difficult or dangerous. By the end of the presentation, participants will be able to: • Recognize where you are stuck because you are unwilling or unable to have a difficult conversation, and become comfortable with initiating and conducting those conversations effectively. •	Develop a strategy to ask for what you want and need without alienating other people or damaging your brand. •	Reframe and recognize the motivations of others to create the most effective responses in yourself. • Acknowledge and mitigate the effect of the conversations that are left unspoken. •	Practice dialogue techniques designed to make others receptive to your constructive conversation, and practice listening techniques designed to build true understanding and support. •	Create a strategy to conduct a constructive conversations in your person
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 04

Time: 10:10 AM - 11:10 AM

Room: G

This is the advanced part 2 of Innovative Data Modeling.  Learn how to leverage Master Data Management and Azure Technologies to extend your model for performance, history and reference unstructured data. We will explore how you can use continuous integration and delivery to further maximize value.   Let's look at platform specific techniques and also explore design options for Azure SQL Data Warehouse.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: May 04

Time: 3:30 PM - 4:30 PM

Room: B

Any new database design, normalization process or just simple research starts from data profiling. At first you determine number of rows in the data set. After that you run multiple similar queries against each column to determine Max and Min values, maximum length for text columns, number of nulls, distribution of data, and more.
When all these queries are already pre-set or dynamic or you are doing profiling via SQL Server Data Tools, it is not a problem on relatively small data set, but what if your table contains billions of records, and stretches for multiple gigabytes? All queries against that large data set will do a full table scan, which will produce very heavy I/O, and take forever.
In order to make the process faster, we will use a hidden gem of SQL Server:  Statistics. Only one table scan will be needed to generate them, and then we can use the science behind them to do research over our data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 04

Time: 8:50 AM - 9:50 AM

Room: K

The gross world national product has been hovering around 3.5 percent for the last decade. Therefore, many companies are trying to derive new business from the current data that they have. How can a company consolidate data in one central place to allow for data exploration and business intelligence?

The solution to this problem is to design a modern data platform.

In this talk, I will be talking about two A.D.F. design patterns that can be used to achieve this goal. You will learn about how to combine components like Azure Data Lake Storage, Azure Data Lake Analytics, Azure Data Factory, Azure SQL server, Azure Analysis Services, Machine Learning and Power BI into a architecture that meets your companies needs.

Of course, we will go over how to use nomenclature to keep track of source systems and lineage within your data lake. We do not want any data swamps!

At the end of the class you will have a good understanding on how linked services, data sets, pipelines and triggers play a
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 04

Time: 11:30 AM - 12:30 PM

Room: D

Azure SQL PaaS offers different options? Which one should you choose when you move your SQL Server to Azure Cloud? This session will help you understand the difference between SQL Database Single DB, SQL managed instance and SQL Elastic Pool.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 04

Time: 3:35 PM - 4:35 PM

Room: F

Are you considering to move your databases to Amazon Web Services but unsure of your options? Understand the possibilities to leverage Infrastructure as a Service and Platform as a Service and what is the best for cloud solution your situation. Gain insights from years of lessons learned to minimize your maintenance and costs. Discover scaling possibilities for relational and NoSQL databases to petabyte size demands. I will demonstrate how to get started with the basics of managed services and platforms for running databases on AWS. DBAs, hear how to use managed relational databases such as MS SQL Server with minimal administration. Architects, Developers, DBAs, Managers or IT Professionals, discover other cloud options such as managed NoSQL or scaling your own instances with resizable elastic compute cloud. Take a dive from RDBMS to petabyte-scale data warehouse databases in the Amazon cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: May 04

Time: 2:20 PM - 3:20 PM

Room: H

Dynamic SQL at Design-time is a different beast than at Runtime, though it uses similar techniques. We'll talk about the differences between the two, go over techniques for code generation, and discuss the problems that we can more easily solve.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: May 04

Time: 2:20 PM - 3:20 PM

Room: M

An overview on Entrepreneurship using a PowerPoint presentation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 04

Time: 8:30 AM - 9:30 AM

Room: D

Extended Events was introduced in SQL Server 2008. Every release since then, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 04

Time: 11:50 AM - 12:50 PM

Room: L

The CEO just tasked you with moving all the SQL Server instances to Azure, or maybe you are deploying a brand new application and want to leverage Azure IaaS to host SQL Server. Beyond security and performance, your most pressing concern might be ensuring SQL Server running in Azure is highly available.
 
While on-prem high availability and disaster recovery options for SQL Server are well defined, moving those instances to Azure immediately presents some questions and challenges. Can I simply lift and shift my SQL Server Failover Cluster Instance to the cloud? Do I need to upgrade to SQL Server Enterprise Edition and us Always On Availability Groups? What about shared storage and failover clustering? What about disaster recovery, what are my options there? Load Balancers, Fault Domains, Availability Zones, Azure Site Recovery and Region Pairs, what are these things and why do they matter to me? 

Cloud & Datacenter MVP David Bermingham takes explains all this and more in the session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 04

Time: 3:40 PM - 4:40 PM

Room: M

we will explain in dept, how to build a cloud migration plan, Choose your level of cloud integration , Establish a clear leader and migration-architect role everyone can follow. Whether we have to Choose a single cloud or go multi-cloud. Establish cloud KPIs and performance baselines. Prioritize migration components, Create a data-migration plan, Switch over production. Review application resource allocation and Other considerations for your cloud migration
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: May 04

Time: 8:30 AM - 9:30 AM

Room: C

The Enterprise Edition of SQL Server 2016 contains 2 powerful features for database and data warehouse developers to improve performance and scalability. One is columnstore indexes and the other is in-memory optimized tables. In this presentation I'll show several examples with large databases on how you can get the most out of these 2 great features. I'll cover the scenarios and contexts where columnstore indexes and in-memory optimizes tables work best.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Double Session (120 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 04

Time: 2:10 PM - 4:10 PM

Room: A

Sessions Found: 47
Back to Top cage-aids
cage-aids
cage-aids
cage-aids