Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type



Sessions Found: 45
Consistent and predictable performance is critical for any successful deployment of Microsoft SQL Server. All-Flash arrays have been available for years and sub-millisecond response times should be the expectation. Maximize the performance and agility of your environment and learn how to automate and leverage self-service for snapshots of your databases for protection and re-purposing. Test/dev infrastructures can be refreshed from production DBs in minutes rather than hours or days. Stop working harder and slower than you need to be, learn how you can leverage Dell EMC. Whether storage, servers, networking, data protection, converged or hyper-converged… we have you covered.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: April 06

Time: 9:30 AM - 10:30 AM

Room: 115A

Join this demo heavy session to get up and running on Snowflake in 60 minutes on Azure.  You will learn how to quickly setup a data warehouse that can scale-up to support any data size, or scale-out to support any number of uses. Just as important is scaling-down to save on cost.  We will first cover an overview of the Snowflake platform, and key enterprise capabilities.  Demos will include loading data into Snowflake, exploring data, data time travel, and provisioning for various end users without eroding performance.  Best practices will be discussed throughout the session, and we will conclude with a use case.  Ross McNeely is a certified SnowPro.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 06

Time: 2:45 PM - 3:45 PM

Room: 308

Always Encrypted was introduced in SQL Server 2016, and it was a big step forward for encryption - but it had a very long list of exclusions which prevented it from being adopted by many organizations. Now, with SQL Server 2019, Always Encrypted is getting some much-needed improvements to its functionality. By utilizing the secure enclave capabilities of Windows 2019, SQL Server adds some impressive new abilities to work with data while it is encrypted. In this session, we’ll explore the secure enclave, and we'll see how you can leverage the new capabilities of Always Encrypted in your environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: April 06

Time: 1:15 PM - 2:15 PM

Room: 313

Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: April 06

Time: 11:00 AM - 12:00 PM

Room: 115A

In this session we will discuss Data Strategy around data lake ingestion and how that shapes the design of a framework to fuel Azure Data Factory. This session will take you through the development of a Metadata database designed using Data Vault modeling, the collection of the metadata, as well as building a fully automated Data Factory pipeline.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 06

Time: 11:00 AM - 12:00 PM

Room: 307

Azure Data Factory V2 is relatively new in Azure and has a lot of great new SSIS-like features but is it good enough to replace SSIS? In this session we will go over some of the new control flow, branching, and scheduling features in Azure Data Factory and see how to make a fully cloud capable data orchestration engine. As a bonus we'll also show how you can run SSIS packages directly in Azure!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: April 06

Time: 9:30 AM - 10:30 AM

Room: 307

Are you looking to incorporate CI/CD into your data warehouse solution? Azure DevOps provides tools to help automate deployment of DB and Analysis Services projects (and more).  We'll demonstrate how to create a Build and Release pipeline to manage promotion across environments.  We'll also discuss tips and tricks that provide greater control over deployment configurations with a little help from PowerShell.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 06

Time: 4:00 PM - 5:00 PM

Room: 118

CosmosDB is Microsoft’s globally distributed, massively scalable, cloud based database that is hosted in AZURE.  Who cares?  You should if you need to support thousands of transactions a second, global distribution and redundancy, and different consistencies.  

Do you need to support JSON, Graph, et al?  Done.  Join me and see how easy it is to get started.  We will set up a local instance of CosmosDB, load JSON data and build a PowerBI visualization. Along the way I’ll point out a couple of things to watch out for.  At the end of the session you will then learn how, with a couple of commands, to switch your visualization to the cloud.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: April 06

Time: 11:00 AM - 12:00 PM

Room: 306

In this live demo I would like to show you how to create an effective and interactive dashboard using Power BI, I will also talk about and show some Power BI best Practices.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: April 06

Time: 2:45 PM - 3:45 PM

Room: 122

This is a 100 level sessions intended for the folks that are just starting their career as a data professional working with SQL Server. In the session we will go over the common data types and limitations associated with each of them.  We will review how to determine the most appropriate data type to use in common situations.  This sessions will not only cover the basic of a number of data types, but also review data type precedence, auto type conversions and the performance implications of data types.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
SQL 101

Level: Beginner

Session Code:

Date: April 06

Time: 9:30 AM - 10:30 AM

Room: 118

You know how locking works in SQL Server, but now you are tasked with diagnosing and fixing deadlocks. How do you take the knowledge you have and apply it to address deadlocks in your production database?

In this session, we will discuss how you can use free tools to detect and analyze deadlocks in your system. We will do a deep dive on deadlock XML with an eye toward interpreting the information automatically collected by SQL Server when the free tools fall short. 

Attendees will leave with the understanding they need to develop solutions to deadlocks in their systems.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 06

Time: 2:45 PM - 3:45 PM

Room: Auditoriumm

Ever considered giving a presentation of your own? Pondered how your favorite speakers got their start? Contemplated whether you could ever do that too, but were not sure where to begin?

Well I say you can and will show you how to get started! In this session, I will teach you how to develop your idea and create session content, and share tips & tricks that I have learned along the way. 

You will leave armed with a wealth of resources (and hopefully some inspiration) to venture forth and develop your first presentation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 06

Time: 9:30 AM - 10:30 AM

Room: 313

When done right, data visualization informs users quickly and efficiently with a minimum of distraction.  When done wrong, we end up with spinning 3D pie charts.  In this talk, we will look at techniques for effective dashboard design, minimizing noise and clutter (like spinning 3D pie charts) while providing relevant information to the intended audience.  We will see how different types of charts work, build out rules of thumb around which charts to use, and integrate visuals to create a coherent dashboard image.  When it comes to dashboards, we will compare and contrast dashboards based on their intended uses, such as interactive dashboards versus TV dashboards.  Finally, we will take an awful dashboard and turn it into something which end users will appreciate.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: April 06

Time: 2:45 PM - 3:45 PM

Room: 115B

Every expert has their own set of tools they use to find and fix the problem areas of queries, but SQL Server provides the necessary information to both diagnose and troubleshoot where those problems actually are, and help you fix those issues, right in the box. In this session we will examine a variety of tools to analyze and solve query performance problems.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 06

Time: 4:00 PM - 5:00 PM

Room: 308

Building a data warehouse that is effective and efficient is a constant challenge to designers and developers, and this session will highlight some of the fundamental guidelines to use during the life cycle of a data warehouse. With a broad range of topics, both business reporting users and developers & architects will find this session informative.  We will review the importance of each phase of the lifecycle, including analysis, design, development, testing and maintenance. We will discuss the expected outcomes for each phase, as well as the stakeholders who should be involved in the decision making process along the way. We will provide examples of documentation to help guide each step and discuss issues that commonly arise when building a Data Warehouse. At the conclusion of the session, attendees will receive a Data Warehouse checklist that provides a comprehensive overview of everything discussed and can serve as a resource beyond the session.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 06

Time: 2:45 PM - 3:45 PM

Room: 118

Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? You need to get the updates in your OLTP database to the Data Warehouse quickly, but with minimal impact on your application. This session will demonstrate how to keep your data warehouse updated in near real-time using Service Broker messages from your OLTP database.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 06

Time: 1:15 PM - 2:15 PM

Room: 115A

Have you ever thought about becoming a Consultant, but just didn't know if it was the right fit for you?  In this session, I touch on various aspects of what being a consultant means, be it working for a consulting firm or independently for yourself.  I'll cover some skills that are necessary to succeed in this field, touch on aspects of owning your own business, discuss ways to build up a network, and draw attention to some questions you should be asking yourself and others before you make the leap.  By the end of the session, I hope you have enough information to know if becoming a consultant is the right choice for you or not.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: April 06

Time: 4:00 PM - 5:00 PM

Room: Auditoriumm

Most data models contain at least one situation requiring role playing dimensional behavior. For example,  Order Date, Ship Date, and Invoice Date all linked to the Date table. The tabular model, available in Power BI, Power Pivot, and SQL Server Analysis Services, provides multiple methods for handling role playing dimensions. In this session, we will implement examples of each of these alternatives, including the DAX expressions required to fully exploit each one. We will explore the strengths and weaknesses of each approach as well as best practices when implementing each of these alternatives. Special emphasis will be given to model maintainability as well as the experience created for users exploring and analyzing the model.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: April 06

Time: 1:15 PM - 2:15 PM

Room: 306

Stay on track with your version control tool and learn the transition from TFVC to Git. We will demonstrate the migration process from TFVC to Git along with some things to consider before your migration. Stick around for some Git best practices that will get you off to a fast start with your new version control tool!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 06

Time: 11:00 AM - 12:00 PM

Room: 308

This session covers the "101" issues of security within SQL Server. It covers authentication (AD, SQL Server, and Application Roles) and the basics of security declarations. This is targeted at entry and mid level database administrators and application designers that need an introduction or a refresher on how to grant access to the database engine and permissions at the SQL Server and database levels.  NOTE: this presentation does NOT cover hacking, security work-arounds, etc.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 06

Time: 1:15 PM - 2:15 PM

Room: 115B

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