Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 35
Even with the increased simplicity of plan forcing using Query Data Store in SQL Server 2016 and above, plan guides remain a very powerful but often overlooked feature of SQL server. There is a misconception in the community that plan guides are really only useful for situations where the DBA "cannot change the code" but actually plan guides have much broader applicability than simply fixing problems with poorly designed ISV code. However, for the DBA, working with plan guides can often be a confusing and frustrating experience. 

In this session we will cover what plan guides are, how they work and demonstrate scenarios where they can be successfully used to solve a number of problems DBAs experience on a day to day basis.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 27

Time: 8:30 AM - 9:30 AM

Room: Odyssey 2410

tSQLt is a database unit testing framework for Microsoft SQL Server.  tSQLt is ideal for the database developer because tests are written in TSQL and is easy to use.

In this session you’ll learn how to use tSQLt to add automated tests to your database to ensure your code produces desired results even after modifications.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 27

Time: 8:30 AM - 9:30 AM

Room: Origami 2370

Azure SQL DW is powerful MPP cluster for processing a big amount of structured data. But, it still requires optimization to maximize performance and optimize resource usage. Some technics almost similar to what we do with our regular SQL Server, some of them not due to MPP architecture. In this session, I will cover next topics:
 - how to minimize the time of data loading
 - how to choose a right distribution type
 - data movement minimization
 - how scaling and resource class could help to improve data processing performance
 - maximize Column Store index performance
 - update statistics
 - partitioning strategy
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: April 27

Time: 9:45 AM - 10:45 AM

Room: Stinger 2400

Azure SQL DWH is based on MS SQL Server and supports T-SQL. It helps to DB/DWH developers start using it without many efforts. Unfortunately, there are several limitations that could bring difficulties in your job. For example, we can't use MERGE statement for Upsert tasks in DWH, there is no IDENTITY or SEQUENCE, differences in implementing partition switching  and so on. In this session, I'm going to cover several tips and tricks how we can handle with this limitations using available possibilities.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 27

Time: 11:00 AM - 12:00 PM

Room: Stinger 2400

It has been said that “novices absorb knowledge like a sponge, intermediates hoard it for themselves, and masters just simply give it away.” 
The community spirit of PASS is for like-minded professionals to interact and share knowledge. But how do you do this in your own workplace? IT people are notorious about being siloed and not sharing their knowledge. That may be, but you have to move past all of that in order to truly move forward in your career and your life. There are many barriers in place to giving away your knowledge, but we will help you be ready to do so. 
The only way to truly become a master at your craft is to share your precious knowledge with your peers and workmates. We will discuss past and new trends in learning and knowledge transfer, the reasons why you should pass on knowledge, and methods for making this happen in your workplace and in your life.
By passing on your knowledge, you are leaving behind a legacy that extends beyond your tenure at an organization
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 27

Time: 11:00 AM - 12:00 PM

Room: Odyssey 2410

When the SQL Server optimizer evaluates a query to determine how best to execute it, the statistics are quite possibly the most important tool at its disposal. But SQL Server statistics objects aren’t perfect because they only contain estimated summary information. In this session, we’ll start with an overview of what the statistics objects are, how the optimizer uses them, and some general guidelines for their maintenance. Then we’ll look at some of the issues, how to find them, and how to solve them, that can arise due to their imperfection: ascending keys (the most prevalent statistics based performance killer?), skewed distribution, or downright bad summary information. There’ll be many examples, and even a stored procedure to help you find ascending keys. By applying the techniques we’ll discuss, you WILL see improved query performance.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 27

Time: 8:30 AM - 9:30 AM

Room: Normandy 2350

Creating a blog worth reading is no easy task. It’s a fine balance between consistency, topic choice, readability and SEO magic. Join marketing expert Blythe Morrow as we discuss how to build content for technical audiences that generates reads that connects you deeper into the SQL Server Community. Learn what it takes to eliminate confusion for your readers and connect people in a way that solves their problems. We'll also have a cameo or two from SQL celebrity bloggers who can lend advice and tips.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 27

Time: 3:15 PM - 4:15 PM

Room: Odyssey 2410

Modern Data Warehouse solution patterns require moving classic DW data, processes, and methods to the Cloud and to incorporate Big Data. In this session, I will demonstrate how to accomplish those goals using Azure Data Factory.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: April 27

Time: 9:45 AM - 10:45 AM

Room: Odyssey 2410

With heavily consolidated instances and competing workloads, the Enterprise only Resource Governor feature is an incredibly useful tool for any DBA to have in their toolbox. It allows for the effective throttling and control of CPU, memory and I/O consumed by multiple workloads running on a single SQL Server instance. In this session, we will cover the fundamental concepts of the SQL Server Resource Governor and provide demonstrations of practical scenarios where Resource Governor can control resources for specific workloads. Some of these demonstrations include how to limit the amount of memory consumed by memory-optimized tables and how to prevent poorly-written queries from overwhelming your storage subsystem. We will also discuss cases where Resource Governor can mitigate parameter sniffing problems. Finally, we will look at ways to leverage the useful information contained in the Resource Governor DMVs for monitoring and reporting.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 27

Time: 3:15 PM - 4:15 PM

Room: Normandy 2350

Failing to deliver a well-designed Power BI Report can be a common reporting pitfall.  What good is quality data if it is not presented in a way that is meaningful or easily understood? Someone without any prior knowledge should be able to quickly understand a report without explanation and be quickly drawn to the key elements you want them to view.  This talk will walk through many elements of bad report design. Learn about visual cues and how certain chart types can convey data more accurately than others. Also, learn about the basic dos and don’ts of report design and layout, using easy-to-learn techniques that bring data to life.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: April 27

Time: 9:45 AM - 10:45 AM

Room: Nexus 2340

Tempdb has been a source of configuration confusion since the very first version of SQL Server. Each SQL Server instance only has one tempdb database used by all users in all databases. In this session, we’ll look at all the different uses of tempdb and how to configure your tempdb to support them. We’ll look at all the different kinds of temporary tables and see when you should use each type. We’ll talk about the difference between global and local temp tables, table variables and work tables. We’ll explore the various tools available that let you monitor the use (and abuse) of your tempdb database and we look at some best practice guidelines for how to keep your tempdb as healthy as possible.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 27

Time: 8:30 AM - 9:30 AM

Room: Nexus 2340

You probably already know that indexes make your queries go faster. But do you know all the different types of indexes in SQL Server and when to use them? Also with each new release of SQL Server, there are new features that can impact how indexes function and are maintained. Finally, knowing how the different types of indexes work can help you make better indexing choices when tuning your queries.
This presentation will review current SQL Server index structures and options, discuss how they work, when they should be used and how to maintain them. Examples of all the index types such as hash, in-memory, columnstore, filtered, etc… will be shown.
This presentation is a must see for DBAs, Developers, Application Architects and anyone else who is interesting in maintaining high performance SQL Server applications.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 27

Time: 3:15 PM - 4:15 PM

Room: Nexus 2340

If you want to communicate your technical knowledge or want people to actually your emails, you’re going to need strong written communication skills. Writing is something most of us do every day, but it’s a difficult skill worth mastering. Join Blythe Morrow, Data Platform Marketer and life-long communicator, for a tips and tricks session that will take your written communication to the next level. We’ll review the most common business communication mistakes and learn a few tips to make your words stand out.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 27

Time: 1:30 PM - 2:30 PM

Room: Odyssey 2410

Discussion of the best practices and considerations for security, governance, and administration of Power BI. Not only of the available options, but tips and tricks for how to navigate those options and set yourself and your organization up for success down the road.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: April 27

Time: 9:45 AM - 10:45 AM

Room: Gandalf 2390

SQL Server 2017 and Azure SQL DB introduced capabilities to store and query directed graphs in the database, with further improvements in SQL Server 2019 and recent Azure SQL DB releases. As with any new feature, scalability is a top question. In this session, we will demonstrate the features and scalability of SQL Graph by using a publicly available graph dataset: the Open Academic Graph - OAG - (https://www.openacademic.ai/oag/). The OAG graph includes over 166 million academic publications and over 1 billion citations. We show you how to efficiently import such large-scale graphs into SQL and then fully leverage the SQL Graph features to accomplish common graph query tasks (finding citations) and advanced analytics (PageRank, Shortest Paths etc.) on this large-scale graph. After this session, you will be amazed by the functionality, performance and scalability of SQL Graph!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 27

Time: 1:30 PM - 2:30 PM

Room: Gandalf 2390

As a data analyst, you need to analyze data and address business problems.  In order to make your analysis have more impact, you can use machine learning to understand data correlation and predict business trends based on past patterns.

Through my presentation, I will talk about the classification problem in machine learning and how machine learning improves the business.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: April 27

Time: 3:15 PM - 4:15 PM

Room: Gandalf 2390

You develop an SSIS package to load a flat file.  You meticulously identify each of the columns and map the columns to the target table.  Your package runs fine for months.  Then the file format changes.  It is back to the drawing board, selecting each column, setting the data types (type, length, etc.).  In many cases, you actually have the file structure in an electronic form.  Wouldn't it be nice to simply regenerate your SSIS package using that metadata? 

In this session I will demonstrate how to automate the generation of SSIS packages using the open source BIML and BIMLScript. 

I will then demonstrate how to use this technique to handle changes in file structure.  I will generate an SSIS package  from a simple Excel workbook I will represent the structure of a flat file and its relationship to a staging table.

Finally, I will use BIMLScript to handle changes from one version of SSIS to the next and from SSIS to Azure data factory.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 27

Time: 11:00 AM - 12:00 PM

Room: Nexus 2340

SQL Server’s table partitioning gets interesting at the extremes: namely the initial (often “before”) partition, as well as the last (often “future”) partition. In this session you’ll learn how to manage partitioned tables at these extremes based on choices concerning the partition key, files and filegroups, archiving, and adding future partitions.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 27

Time: 11:00 AM - 12:00 PM

Room: Gandalf 2390

No matter the complexity of your BI application, Master Data Management can provide your organization the tools needed to conform, manage and simplify your dimensions. Attend this session and learn how Analytical MDM can forge quicker and more valuable insights.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 27

Time: 3:15 PM - 4:15 PM

Room: Origami 2370

In this session, attendees will learn a few things: 

- What is Premium Capacity 
- How to read & use the Capacity Management App ( understand bad vs. good )
- How to customize this App to highlight data-sets that are performing the worst!

If you are a premium user, a Power BI Service Admin, or just interested in premium capacity - you don’t want to miss this session!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 27

Time: 1:30 PM - 2:30 PM

Room: Trident 2320

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