Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 37
DevOps is the merger of app development, testing, and IT ops.  All tasks from coding to testing to operations should be automated so new features and fixes can be continuously quickly.

Test Data Management (TDM) is the optimization of the process of software quality, ensuring that applications properly work according to their specifications.

Constraining both DevOps and TDM is database size. "Storage is cheap" is not merely a lie, but more to the point it takes a lot of time to push terabytes around from place to place, and time itself is expensive and dear.

Providing full databases for each developer or tester on each task of each project seems unrealistic, when each copy might require terabytes of storage, so for decades everyone has limited themselves to working in shared dev/test environments that are refreshed only every few months, where conflicts occur,  quality suffers, and things move slowly.

Come learn why data virtualization is the solution to a problem everyone knows.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: September 16

Time: 10:00 AM - 11:15 AM

Room: 287

Agility and Business Intelligence are two good things that often struggle to be good together. A primary cause of this struggle is the inability of traditional Data Warehouse models to respond to change in a (business) timely manner. Data Vault is an evolution of Enterprise Data Warehouse modeling that removes the barriers to Data Warehouse agility. A Data Vault warehouse eliminates re-engineering both of the data schema and ETL as the model evolves in response to changing business needs and definitions.
In this session we’ll compare modeling techniques in real world scenarios to understand how Data Vault can make your EDW more capable and agile.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 16

Time: 12:45 PM - 2:00 PM

Room: 254

Are you wanting to make more SQL Servers but don't want to invest in more hardware? Then Relational Database Service (RDS) in Amazon Web Services (AWS) maybe the right choice for you. We will begin with creating a server using the Amazon Web Console, explore how to automate installation through Cloud Formation, show how to administrate the service, and walk through advanced features. Whether you are familiar with AWS or are brand new to it, this presentation should at least give you a good overview to decide if RDS is the right service for you.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: September 16

Time: 12:45 PM - 2:00 PM

Room: 287

SQL Server is often I/O bound - but why? Do you feel lost when talking to your storage administrator?  Are your storage subsystems like a mysterious black box where your databases live but you can’t go visit? This session will get you up to speed with the fundamentals of storage subsystems for SQL Server. You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 16

Time: 8:30 AM - 9:45 AM

Room: 253

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?  What happens when Bob takes off with one day of notice?  How do you manage when Jane unfortunately has to spend a month in the hospital?
All joking aside, 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 current trends in knowledge transfer, the reasons why you should (and shouldn’t) pass on knowledge, and methods for making this happen in your workplace and in your life.
Be prepared for an interactive and lively discussion and to walk away with some new concepts that are going to make you think about how you too can become a Master!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 16

Time: 12:45 PM - 2:00 PM

Room: 275

Behavior-Driven Design (BDD) and test automation are key practices that allow data warehouse and business intelligence teams to be more successful in their agile journeys. While there are lots of test practices and automation tools out there for software development teams to leverage, very few are targeted to data-related development and testing. Agile analytics practitioner Lynn Winterboer and DW/BI architect Cher Fox will share essential agile test foundations, describe BDD, and identify data-focused test automation technologies to help data warehousing and business intelligence teams get a leg up on these important agile practices, including a BDD exercise and a test automation demo!
Speaker:

Session Type:
Half Day Session (240 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: September 16

Time: 12:45 PM - 4:45 PM

Room: 210

Biml (Business Intelligence Markup Language) is a programming language for creating business intelligence objects. It is a simple XML that can be extended with small nuggets of C# or VB code to automatically generate SQL scripts, SSIS packages and SSAS cubes. It will allow you to turn tedious repetitive tasks into reusable scripts - no more drag-and-dropping! Using Biml will significantly cut down development time, reduce errors and improve quality of your code. In this session, you'll find out everything you need to know to start with Biml development. Our focus will be on SSIS solutions.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 16

Time: 8:30 AM - 9:45 AM

Room: 235

Dynamic Management Views and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session presents, demonstrates and explains a complete set of diagnostic DMV queries that you can easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases. 

This session goes into exhaustive detail on how to interpret the results of each of the diagnostic queries, including relevant background information on how to properly configure your hardware, storage subsystem, operating system, SQL Server instance and databases in order to avoid performance and scalability issues.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 16

Time: 12:45 PM - 2:00 PM

Room: 253

Power BI Desktop is so intuitive when it comes to creating reports that even a 13 year old can do it.  In fact I'm 13 and I can do it! Don't believe me?  Come to my session as I demonstrate how to import data, create dashboards, and publish them to the Power BI service.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 16

Time: 12:45 PM - 2:00 PM

Room: 233

If you’ve dabbled in PowerShell, you probably know that there are many ways to use it in conjunction with SQL Server. While using the provided tool set has been a challenge for many data professionals, recent upgrades and improvements to the PowerShell module for SQL server provide a solid tool set for new and experienced users. This session will cover the SqlServer module in detail, exploring the various commands and demonstrating various use cases for the tool set. Attendees will get a solid overview of the module and real world examples of how users can get the most out of their code.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 16

Time: 2:15 PM - 3:30 PM

Room: 287

Your personal brand is how you distinguish yourself from other people but how you develop and nurture your brand can be the difference between stagnation and opportunity in your career. We'll discuss your branding, the importance of taking control of your brand, and how to begin developing your personal brand. By the end of this session, you'll have a better idea of how to begin building your personal brand into something that can take your career to the next level.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 16

Time: 8:30 AM - 9:45 AM

Room: 275

Have you ever thought to yourself  “All these people think I’m smarter than I really am" or "I really don’t know what I’m doing, they're going to figure out I'm a fraud!”  If yes, then you suffer from the Impostor Syndrome. And despite all the accomplishments, awards and accolades, you still doubt yourself. It’s rampant in the modern day tech workplace, and the fear will make you shrink back from opportunities. You dismiss praise. You overcompensate by working harder, being charming and demanding perfection from yourself. What would happen if you were released from this bondage, and kicked your impostor to the curb? In this session, learn 3 powerful techniques that can help to improve your confidence and silent that annoying voice in your head!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: September 16

Time: 10:00 AM - 11:15 AM

Room: 275

This session is a very basic introduction to Integration Services (SSIS).  We’ll cover the basics; what it’s used for and the various parts and pieces to get you started creating your own projects in no time.  We’ll talk about packages, connections and project parameters and their respective tasks/properties.  We’ll also cover some basic performance tuning to make your packages run faster.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 16

Time: 8:30 AM - 9:45 AM

Room: 254

You have been wanting to using SQL Server Analysis Services, but just don't have the physical resources on-premises to set one up.  Analysis Services has typically shipped with SQL Server on premises, but now it has been implemented as a fully managed service in Azure. Join this session to learn how to create a and deploy a model, load and refresh data using Azure functions, secure the model, view the model and a little about pricing.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 16

Time: 3:45 PM - 5:00 PM

Room: 233

Kerberos delegation is often needed for SQL Server Reporting Services security. Many DBAs avoid Kerberos because of the complexity and come up with workarounds that may violate security policies in their shops. They also may not understand why Kerberos delegation is even required. 
Configuring Kerberos for SSRS can be broken down into three simple steps: SPN registration, setting delegation properties, and application configuration. It’s really not so difficult, and there are a number of tools that can help you troubleshoot when things don’t go as planned.
Attend this session to learn why Kerberos is necessary and how to configure and troubleshoot it.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 16

Time: 12:45 PM - 2:00 PM

Room: 234

Is your Biml solution starting to remind you of a bowl of tangled spaghetti code? Good! That means you are solving real problems while saving a lot of time. The next step is to make sure that your solution does not grow too complex and confusing - you do not want to waste all that saved time on future maintenance!

Attend this session for an overview of Biml best practices and coding techniques. Learn how to centralize and reuse code with include files and the CallBimlScript methods. Make your code easier to read and write by utilizing LINQ (Language-Integrated Queries). Share code between files by using Annotations and ObjectTags. And finally, if standard Biml is not enough to solve your problems, you can create your own C# helper classes and extension methods to implement custom logic.

Start improving your code today and level up your Biml in no time!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 16

Time: 3:45 PM - 5:00 PM

Room: 235

Power BI makes accessing data from various sources and building advanced visualizations for analytics easy to do. Behind the scenes Power BI is built on standard technologies and APIs that allow it to be customized in multiple ways to fit in with your environment the way you need it to. In this session we will walk though samples and demos that show how you can extend Power BI with custom visualizations, access custom data sources, embed various Power BI elements in your applications, and be able to push your data into a Power BI report/dashboard. Each of these items take advantage of the Power BI APIs in different ways and we will discuss each and provide the code samples for you to take back and get a head start. This session will be showing code to access the Power BI REST API using C# and NodeJS along with some M for accessing and manipulating custom data sources.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 16

Time: 3:45 PM - 5:00 PM

Room: 234

The longer I've been coding, the less time I want to spend coding - at least, the boring, repetitious bits. In this talk, I'll share the approaches I've used to systematically generate SQL artifacts based on metadata and templates. 

The approach is basic: Get data. Process through some templating engine. Collect output.

The specifics scenarios we'll cover
* Biml/C#: we'll build SSIS packages, tables and stored procedures
* Python: we'll use pyratemp to build tables and CLR stored functions
* Versioning: Version your templates and your data
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 16

Time: 10:00 AM - 11:15 AM

Room: 235

Standing up a highly scalable data infrastructure can be a very time-consuming task especially in larger enterprises with multiple teams and data needs across multiple teams. In this session, we will see how to leverage containers and storage spaces in Windows Server 2016 to create highly reliable, highly scalable database deployments in just a few minutes.

You will be able to leave this session with some great thoughts on how to leverage containers for infrastructure and state management within your organization and have the knowledge to hit the ground running.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 16

Time: 8:30 AM - 9:45 AM

Room: 287

A "Disaster" doesn't need to be on a massive scale to cause widespread destruction in your enterprise. Simple things like failing hardware, strange storage bugs, a forgotten WHERE clause, or an angry employee can either cause devastation or be just a nuisance to the properly-prepared DBA. This session is a survey of recovery techniques that should be in every DBA's toolbox.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 16

Time: 3:45 PM - 5:00 PM

Room: 275

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