Conference Sessions

Advanced Filters:
  • Track

    clear all





  • Learning Path








  • Speaker


  • Level


  • Session Type




Sessions Found: 232
** Please note Pre-Conference sessions are available for an additional registration fee of $495 **

Have you heard about Power BI and Microsoft Azure? These services can take many forms, such as cloud virtual machines (VMs), database as a service (DBaaS), Power BI in the cloud, and a myriad of other services. In this full-day pre-conference session, you learn about building business intelligence (BI) solutions using Microsoft Azure, Power BI, and the Microsoft BI stack (on premises, in the cloud, or both). This session gives you a foundation for determining when incorporating cloud components into your BI solution makes sense and how to get started. 

In this full-day workshop, you learn:
• How to use Azure components to build a BI infrastructure completely or partially in the cloud
• Which changes to your solution architecture are necessary when you move components to the cloud
• Best practices for configuring and networking Azure resources
• How to integrate your cloud-based solution with your on-premises Active Directory
• How to securely connect Power BI to your Azure and on-premises data sources
• How to configure supported data sources for scheduled refresh
• Best practices for administering Power BI components in Office 365
Speaker:

Accompanying Materials:

No material found.

Session Type:
Pre-Conference Session (full day)

Track:
BI Platform Architecture, Development & Administration

Level: 200

Session Code: BIA-299-P

Date: October 26

Time: 8:30 AM - 4:30 PM

Room: 606-607

I do a lot of SQL Server health checks in a year for new clients. Sadly, I can almost copy and paste the report for most of the findings. I bet your environment is guilty of at least a third of the findings, too. I know this because I bet my environments were too when I was a full-time DBA.

In this session we'll explore the ten most frequent findings I bump into and wish I never bumped into again. Let's talk about best practices, look at some scripts to get on track with best practices and talk about these crucial issues. 

You'll leave with scripts, anger about the findings and hopefully will take the time to knock those findings out of existence in your environments in the first week back from the PASS Summit. You want to leave proving you got something out of the Summit? Come to this session and go tackle these ten environment killers. You'll be well ahead of most of the environments we encounter in the field. 
Speaker:

Session Type:
General Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: 100

Session Code: DBA-105

Date: October 29

Time: 4:45 PM - 6:00 PM

Room: TCC 301-302

The 2014 SQL Server Integration Services (SSIS) Project Deployment Model introduces new opportunities for the delivery of SSIS solutions. Gone are decisions about logging providers, configuration approaches, and deployment targets. Now, you need to focus on the creation of an .ispac, the approaches to deploying the project, and applying configurations to ensure expected behavior.

This session begins by exploring mapping between elements in an SSIS project and their counterparts in the compiled file, the .ispac. The session then covers three approaches for automating the deployment of this unit into SSISDB We then cover the administration side of the SSIS Catalog. You create SSIS environment variables and apply them to configure run-time behaviour. Finally, you work through the native tooling to troubleshoot failed SSIS packages. We'll cover SQL Server Management Studio (SSMS) reports, Catalog views, and data taps for run-time collection of values.
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: 300

Session Code: BIA-300

Date: October 30

Time: 3:30 PM - 4:45 PM

Room: 606-609

This session covers three approaches to using tracing and Extended Events:
* The long running query (LRQ)
* The thousand paper cuts (TPC)
* The sounds of silence (SOS) 

For each of these approaches, we go over how to script both a classic server-side trace and a newer Extended Events session to capture the information you need for analysis. You learn how to use T-SQL to query and make sense of the captured data from both collection types. We look at the results from each method of capture, side by side. The session includes plenty of demos and great take-away scripts.
Speaker:

Session Type:
General Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: 300

Session Code: DBA-305

Date: October 30

Time: 8:00 AM - 9:15 AM

Room: 606-609

** Please note Pre-Conference sessions are available for an additional registration fee of $495 **

This demo-oriented, full-day pre-conference session answers the questions that database administrators (DBAs) and developers often have about performance tuning and query optimization. Some problems have straightforward answers, but others are often invisible or need attention without even a problem statement. This session is divided into these three major components:
- Identify common patterns and antipatterns for database performance tuning; for example, slow-running queries, I/O-intensive operations, CPU bottlenecks, memory optimizations, tempdb contention, and more
- Resolve optimization hindrances and issues proactively; for example, indexing strategies, file growths, server deployment best practices, statistics, wait stats and queues, and more 
- Avoid query performance surprises when upgraded to the most recent version of SQL Server 2014; for example, new cardinality engine, ColumnStore indexes best practices, live plans, Azure enhancements, in-memory online transaction processing (OLTP) optimizations, and more

We discuss 42 tips, tricks, and scripts in this session. Every attendee will have those scripts handy upon completion of the session. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Pre-Conference Session (full day)

Track:
Application & Database Development

Level: 400

Session Code: AD-499-P

Date: October 26

Time: 8:30 AM - 4:30 PM

Room: 6C

** Please note Pre-Conference sessions are available for an additional registration fee of $495 **

What problematic patterns and anti-patterns are most likely to trip up SQL Server developers on a daily basis? What sort of Transact-SQL (T-SQL) challenges does every SQL Server developer encounter? This full-day pre-conference session takes a tour of the most common and challenging issues that database developers face; learn how to conquer them in the lab today so that they do not take you by surprise in the future. 

Loaded with live demos and useful techniques, this session teaches you how to take your SQL Server queries from mundane to masterful. You'll learn:
- Internal operations of the optimizer and caching mechanisms and their impact on T-SQL performance, including ways to change default behavior by using settings, trace flags, and hints
- Techniques and metadata analysis to make T-SQL code, including queries and stored procedures, achieve top performance and maximum reliability
- Tricks to better simulate production on your workstation or test box, to avoid "But it worked fine on my machine" syndrome
- A variety of T-SQL coding patterns and anti-patterns that create challenges for all but the most advanced database developers

With these 50 tricks and techniques in your coding toolkit, you’ll be able to write T-SQL code that consumes less system CPU, memory, and I/O while being easier to maintain and offering faster performance. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Pre-Conference Session (full day)

Track:
Application & Database Development

Level: 200

Session Code: AD-299-P

Date: October 27

Time: 8:30 AM - 4:30 PM

Room: 611-614

In this session, we discuss the fundamentals of human visual perception, including the important distinction between pre-attentive and attentive processing. We use examples from feature films such as "Jaws", "Alien", "Sneakers", and "The Incredibles" to show important aspects of visual analysis around color, form, position, and motion. We then put these concepts into practice via demos in Excel and Power BI, as well as audience participation. By the end of this session, you will have a solid understanding of the importance of data visualization and how to use it to expose the story in your data to enable better decisions.
Speaker:

Accompanying Materials:

Session Type:
General Session (75 minutes)

Track:
BI Information Delivery

Level: 100

Session Code: BID-101

Date: October 28

Time: 1:30 PM - 2:45 PM

Room: 615-617

The statistical language R has many ways to visualize data, as does SQL Server Reporting Services (SSRS). In this session, we take our two favorite methods and show you concepts to standardize and support these languages under the focus of a centralized information-design management. We take ICB standards and proposals for a conceptual, perceptual, and semantic information design and apply it to both languages, with the help of Master Data Services. You will see the concepts, techniques, and visual output in live demos and take away a concept that you can apply to your own SSRS reports or R output. 
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Information Delivery

Level: 300

Session Code: BID-302

Date: October 28

Time: 4:45 PM - 6:00 PM

Room: TCC 305

Query plan operators are where the work is done when you run a query. Some operators are more significant than others. You might have learned about Seeks and Lookups and about different Join operators, but certain operators convey a lot more information than you might realize. This session looks at operators such as Merge Join (Concat), Top N Sort, Filter, Hash Match (Flow Distinct), and more. Explore the significance of some of their properties, and raise your game when it comes to performance tuning.
Speaker:

Session Type:
General Session (75 minutes)

Track:
Application & Database Development

Level: 300

Session Code: AD-302

Date: October 28

Time: 3:15 PM - 4:30 PM

Room: TCC 303

With the advent of SQL Server Integration Services Catalog (SSISDB) a new place to store, execute, and monitor SSIS packages came into existence. 

This session shows the different aspects of programmability in the context of SSISDB. Beginning with a short overview of the underlying database objects, a deeper look at SSISDB's stored procedures follows. A side-step from T-SQL to C# and the available SSIS SDK illustrates a different view of SSISDB access. In conclusion, the analysis and reporting aspects of SSISDB programmability are shown with some exemplified SQL Server Reporting Services (SSRS) reports. The different examples are based on industry-based project experiences. 

After this session, you will have a deeper knowledge about SSISDB's content and programming interfaces, and you will know how to start SSIS packages using T-SQL and C#. The pros and cons of these programming techniques will also be discussed. 
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: 300

Session Code: BIA-308

Date: October 28

Time: 10:45 AM - 12:00 PM

Room: TCC 301-302

Business Intelligence (BI) solutions need to move at the speed of business.  Unfortunately, roadblocks related to availability of resources and deployment often present an issue.  What if you could accelerate the deployment of an entire BI infrastructure to just a couple hours and start loading data into it by the end of the day.  In this session, we'll demonstrate how to leverage Microsoft tools and the Azure cloud environment to build out a BI solution and begin providing analytics to your team with tools such as Power BI.  By end of the session, you'll gain an understanding of the capabilities of Azure and how you can start building an end to end BI proof-of-concept today.
Speaker:

Session Type:
Half-Day Session (3 hours)

Track:
BI Platform Architecture, Development & Administration

Level: 100

Session Code: BIA-102-HD

Date: October 30

Time: 2:00 PM - 5:00 PM

Room: 6E

Indexing is about balance. The decision of clustered versus non-clustered indexes is only the first step. In this session, you complete the journey, from index nightmares to index paradise. Leave this session knowing why indexes are just as important as table design and with the confidence and skills to improve the performance of your database.

We start with an understanding of the different index types and review the common pitfalls of indexing. Then, we quickly move to showing how you can identify index usage to determine whether there are not enough, too many, or even duplicates in the databases you manage.  Our balance is achieved when we look at SQL Server 2014 and the options provided.
Speaker:

Session Type:
General Session (75 minutes)

Track:
Application & Database Development

Level: 100

Session Code: AD-102

Date: October 30

Time: 8:00 AM - 9:15 AM

Room: 611-614

Although Availability Groups are relatively easy to implement, there are many complexities when it comes to administering and optimizing them--especially if you are familiar with Failover Clustering. In some cases, your existing database solutions perform slower. In this session, we examine the various potential problems you can have when implementing Availability Groups and the potential solutions to these problems. This session covers areas such as performance, administration, and security management. You learn how to manage complex jobs, backup strategies, and logins within an Availability Group environment. You also learn how Availability Groups might dramatically affect your application performance, how to recognise such performance problems, and how to resolve them. With a number of real-world examples, this practical session enables you to maximize the benefits of Availability Groups.
Speaker:

Session Type:
General Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: 400

Session Code: DBA-400

Date: October 29

Time: 4:45 PM - 6:00 PM

Room: 6C

R is the world’s most widely used statistics programming language and the first choice of data scientists, supported by a vibrant and talented community of contributors. However, in order to fully embrace R in enterprise settings, one must consider a range of aspects including performance, scale, security, manageability and application development. In SQL Server 2016 we enable these scenarios by delivering advanced analytics as an additional workload with proven technology from Revolution Analytics. During the session we highlight the benefits of bringing the compute closer to the data. We will also share the value proposition for data scientists, developers and administrators, and we will see demos illustrating data exploration and predictive application development on top of your SQL Server data. 
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: 300

Session Code: BIA-329-M

Date: October 29

Time: 3:15 PM - 4:30 PM

Room: 602-604

You might have been introduced to Common Table Expressions (CTEs) and understand the WITH syntax, but  want to know more. Learn how recursive queries work with CTEs and how to display hierarchical data. Did you know that you can INSERT, UPDATE, and DELETE data from CTEs? This session covers some common use cases for CTEs, including finding holes in patterns, finding and removing duplicate data, string parsing, and more. Get an in-depth understanding of the performance behind a CTE and learn when a CTE is the right (or wrong) solution. Finally, take a look at some classic recursive algorithms and how they can be implemented with CTEs.
Speaker:

Session Type:
General Session (75 minutes)

Track:
Application & Database Development

Level: 200

Session Code: AD-210

Date: October 30

Time: 8:00 AM - 9:15 AM

Room: TCC 303

Do you know all about heaps, clustered indexes, and nonclustered indexes, but still aren't satisfied? Then this is the session for you! Learn about advanced features such as included columns, indexed views, and filtered indexes. Discover how they are stored on disk and how SQL Server uses them to satisfy queries. Then, see the tools SQL Server hands you to help identify just the right subset of indexes. Finally, get an stunning demonstration of just how badly you can hurt performance by creating too many indexes.
Speaker:

Session Type:
General Session (75 minutes)

Track:
Application & Database Development

Level: 300

Session Code: AD-306

Date: October 30

Time: 2:00 PM - 3:15 PM

Room: 606-609

** Please note Pre-Conference sessions are available for an additional registration fee of $495 **

Most people are familiar with simple availability solutions that protect their instances or databases by using SQL Server failover clustering instances (FCIs) and availability groups (AGs). However, deploying advanced architectures and solutions that span multiple subnets, datacenters, and even the cloud requires a lot of knowledge and planning that is not easily revealed through a simple web search. Understanding the building blocks for advanced networking,  storage, and Windows concepts and how SQL Server fits into them all is the only way to be successful.

Covered topics, which apply to multiple versions of SQL Server and Windows,  include: 
- Multi-subnet FCI and AG architectures that span multiple datacenters and the cloud
- Advanced cluster quorum for complex architectures
- Network and storage design for advanced SQL Server availability solutions

Attendees get hands-on experience via labs, using their own laptops to reinforce advanced concepts such as forcing quorum and bringing an AG online after failing an AG over to a non-preferred replica. Laptop requirements will be sent a few weeks before the session.

This advanced session is not for beginners. The basics of SQL Server availability are covered, but prior knowledge of clustering, FCIs, and AGs is assumed.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Pre-Conference Session (full day)

Track:
Enterprise Database Administration & Deployment

Level: 400

Session Code: DBA-499-P

Date: October 26

Time: 8:30 AM - 4:30 PM

Room: 608-609

Agile projects tend to make traditional project managers nervous. Adopting lean practices generally means that planning more than a few weeks in advance is considered wasteful, so how can you assure your stakeholders that things are getting done? This session looks at techniques that have proven successful in large and small projects, such as work item tracking, project backlogs, burndown charts, task boards, Kanban, and plain old paper charts. We'll use tools such as Visual Studio Online, Excel, paper, markers, and stickers to adopt these techniques, bringing greater visibility and transparency to your projects and helping your stakeholders sleep at night, informed about the reality of what is done and not done.
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: 200

Session Code: BIA-205

Date: October 30

Time: 2:00 PM - 3:15 PM

Room: 611-614

Join us in this demo-filled session where we will cover new investments for AlwaysOn Availability Groups in SQL Server 2016.
Speaker:

Session Type:
General Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: 300

Session Code: DBA-321-M

Date: October 28

Time: 4:45 PM - 6:00 PM

Room: 6C

"It's slow" are probably the two most dreaded words for any database professional (right behind "You're fired!") What's slow? Since when? Compared to what?

Join this "something-everyone-should-be-doing-but-isn't" session, in which we will discuss baselines and performance monitoring for your SQL Server Analysis Services (SSAS) environment. We'll cover what a baseline is, what information it needs to include, and how it can help you troubleshoot immediate problems and proactively avoid them in the future. Walk away from the session with a plan that you can implemented next week to help avoid being caught off guard by SSAS performance issues and to make troubleshooting a breeze.
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: 200

Session Code: BIA-200

Date: October 30

Time: 11:00 AM - 12:15 PM

Room: 6C

In the first half of the session we will present a few Data Analytics customer scenarios, both mentioned COEs worked on in the last months, and discuss customer requirements, pain points and solutions. In the second half we will review features of the latest version of Analytics Platform System (APS), new migration tools available, and provide an outlook how these might influence customer scenarios in the future.
Speaker:

Accompanying Materials:

Session Type:
General Session (75 minutes)

Track:
Application & Database Development

Level: 300

Session Code: AD-311-M

Date: October 30

Time: 8:00 AM - 9:15 AM

Room: TCC 301-302

If you've been to PASS Summit before, you know that social media channels such as Twitter go wild during the keynote speeches. Many people comment on what's being said: Some comments are positive, some ... not so positive. How can you make sense of it all? Which announcements did attendees like and which ones didn't they like? When were the attendees engaged and when were they bored? Who are the thought-leaders in the SQL Server community? Do database administrators (DBAs) behave differently that business intelligence (BI) pros?

In this session, you'll see how a variety of Microsoft tools can be used to analyze this activity:
* Use Bing Pulse to capture real-time audience feedback during the keynote.
* Use Power BI to analyze data from Bing Pulse, Twitter, and other social media sources.
* Use NodeXL to perform network analysis on Twitter data.
* Use Azure Machine Learning (ML) to perform sentiment analysis.
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Information Delivery

Level: 200

Session Code: BID-202

Date: October 29

Time: 10:45 AM - 12:00 PM

Room: TCC 304

Are you faced with scaling up your high-end SQL Server environment and confused by your options?  Will I have enough capacity and performance to meet growing needs? Which performance metrics are important for my business? This session explores the various factors in determining a SQL server platform to fulfill business needs, along with performance considerations and best practices for achieving current business requirements. Specific reference information will be given based on recent scale-up and performance testing on both the HP Superdome X platform and the HP ConvergedSystem 300 for Microsoft Analytics Platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
General Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: 400

Session Code: DBA-409

Date: October 29

Time: 10:45 AM - 12:00 PM

Room: 401

Some ETL solutions have built-in mapping so that you can easily find the parts that need to change when you want to change something in the sources or destinations. Unfortunately, SQL Server Integration Services (SSIS) does not have this functionality, so finding which package uses which columns in your databases and source files is not always easy. Fortunately, PowerShell can do this task for you. This session shows you how to analyze a few hundred SSIS packages and even make changes, if needed. After this session, you will know how to more easily estimate how much work proposed changes to your sources or destinations require in your ETL solution.
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: 300

Session Code: BIA-301

Date: October 30

Time: 11:15 AM - 12:30 PM

Room: TCC 305

In this session, we look in depth at how the query processor works and show you what operations it performs during query optimization to generate equivalent query plans and find a “good enough” plan with limited time during  query optimization.
We demonstrate how to use documented  trace flags to look at the transformation rules that the optimizer has available.

With each SQL Server version, new transformation  rules  are introduced, changing the way the query  optimization process works and sometimes dramatically improving  performance.
We look in depth at  some of the most important transformation rules introduced in the SQL Server 2014  optimizer, explain their importance, and demonstrate how they work while comparing the results with older versions of SQL Server.
We explain why query optimization complexity increases exponentially  with the number of tables  included in the plan, and how to diagnose and remedy issues that relate to bad query plans.


Speaker:

Session Type:
General Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: 300

Session Code: DBA-309

Date: October 28

Time: 4:45 PM - 6:00 PM

Room: 6B

Join us to learn about many application patterns that are the most suitable for using Azure SQL Database. These patterns are formed by our experiences in deploying Azure SQL Database to various customers worldwide.
Speaker:

Session Type:
General Session (75 minutes)

Track:
Application & Database Development

Level: 300

Session Code: AD-316-M

Date: October 29

Time: 4:45 PM - 6:00 PM

Room: 602-604

Microsoft Analytic Platform System (APS) can easily scale to petabytes of data. Consider the business value if all that data was available to end users in a SQL Server Analysis Services (SSAS) cube or model that was always up to date. APS can quickly process huge data sets that previously took hours, enabling more up-to-date reporting. By leveraging the processing power of APS and real-time modes in SSAS tabular or multidimensional, business decisions can be made faster than ever. 

Learn APS best practices such as choosing the right distribution key for tables, laying out the data model for optimal data movement and taking advantage of APS features such as the clustered columnstore index to get the best possible performance from SSAS cubes. This functionality is not without its limitations. Come see how to work around those limitations and optimize SSAS models to work with APS.
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: 200

Session Code: BIA-212

Date: October 29

Time: 3:15 PM - 4:30 PM

Room: 606-609

Much of your ETL process flow consists of packages that are similar in structure, capturing data from a single source and transferring it to a single destination. Creating individual packages can be tedious, and it's easy to miss something in the process of generating the same basic package over and again. BI Markup Language (Biml) makes it easy to build new packages, and PowerShell makes creating Biml scripts easy. This session shows you how to use PowerShell to generate dozens of SQL Server Integration Services (SSIS) packages that perform similar tasks from a defined set of ETL sources.
Speaker:

Accompanying Materials: