Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type




Sessions Found: 46
Join me for this session and learn how easily migrate and maintain a SQL data warehouse in the cloud.
We'd cover CDC on SQL server, full load, incremental loads, and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 06

Time: 10:45 AM - 11:45 AM

Room: 2115

Azure Data Factory V2 recently went GA 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: October 06

Time: 3:55 PM - 4:55 PM

Room: 2

Cross-platform, open source, and approachably extensible, Azure Data Studio is more than just another SQL Server tool. Previously known as SQL Operations Studio, Azure Data Studio is highly customizable and constantly evolving through extensions published by Microsoft and the community. This session will take the audience through the fundamentals of custom extension development for  Azure Data Studio. Our discussion will include available internal APIs, hosting your extension on GitHub, and sharing your work through the extension marketplace.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 06

Time: 3:55 PM - 4:55 PM

Room: 2115

Do you need to start building Tabular models but don't know SSDT from SSMS? Have you looked at Azure Analysis Services but don't know where to start? Did your company just upgrade from SQL 2012 to SQL 2017, and you want to best leverage the new features?
In this demo heavy session we'll cover how to create a new Tabular model with a solid foundation to support happy users. In addition to step by step instructions and best practices on loading data, formatting your columns and measures, clean model design, and making the DBA's life easier when it's time to deploy, we will cover the two most important properties you can set to save yourself a headache.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 06

Time: 2:15 PM - 3:15 PM

Room: 2215

Closing Remarks & Raffle
Speaker:

Accompanying Materials:

No material found.

Session Type:
General (30 minutes)

Track:
General

Level: Beginner

Session Code:

Date: October 06

Time: 5:05 PM - 5:35 PM

Room: Theater

As the tools available for BI and data warehousing continue to improve, it should change the way we ultimately deliver BI solutions. Microsoft's BI solutions help us keep data closer to the source. As data and BI architects, we need to design solutions that can support this model. Consumption Based Architecture is one such architecture. The goal of this architecture is to plan and design solutions that minimize ongoing maintenance and enable users quicker and more complete access to data. Some highlights are how tabular models and Power BI support this process and where does MDM for BI fit in. Ready to discuss the "death of enterprise data warehouses"? Join the conversation in this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 06

Time: 10:45 AM - 11:45 AM

Room: 2230

There are a lot of impressive out of the box capabilities with Azure Data Factory. Also, just like in SSIS, you can extend these capabilities using custom code (.Net in V1 or any executable in V2). We’ll discuss the prerequisites for Azure needed to implement these activities, as well as step through some code examples in C#, including how to setup your development environment. Prior experience with Azure Data Factory is highly recommend for this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Advanced

Session Code:

Date: October 06

Time: 9:30 AM - 10:30 AM

Room: 2225

I bet you thought all the cool kids were the "data scientists"...  Be even cooler and be a data engineer!  You can't have any predictions or cool visualizations without having the data in a useful form.  In this session we will use Azure Databricks with Spark SQL to transform data and put it into a form that BI tools can handle with ease.  Come see how you can enable data scientists and be part of the cool kid club!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 06

Time: 1:00 PM - 2:00 PM

Room: 2115

Have you moved your application to the cloud? Are you thinking about it? Great! Now… how are you securing it?

Security becomes paramount when you move your data to the cloud - after all, it is a much more public resource than the corporate network you’re accustomed to using. Depending on the platform you choose, the vendor may take care of part of the security needs, but they don’t handle all of them. So what, exactly, is your responsibility? And where do you start?

Microsoft MVP Ed Leighton-Dick will answer these questions and more in this full-day workshop on how to best secure your data in the cloud. Topics will include the most common vulnerabilities your data will face on a cloud platform; differences between the current offerings on the major cloud platforms; and the implementation of technical necessities like authentication, encryption, connection security, and monitoring.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Full Day Precon - Friday Session (480 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 05

Time: 9:00 AM - 5:00 PM

Room: D

Backups are a vital part of any DBA's job. Acting as the "last line of defense", we rely on backups to safeguard the company's most important asset: the data. But how do we know we're managing our backups appropriately? This session will cover the fundamental principles of building out our backup (and restore strategy), covering the "why" of backups and best practices for our data protection.
[Sponsored by Rubrik]
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 06

Time: 9:30 AM - 10:30 AM

Room: 2200

So many ways to handle database information on Azure: Table Storage, NoSQL, CosmosDB, SQL as VM’s, multiple flavors of SQL-as-a-service, open-source SQL-as-a-service, data lake, Azure Data Warehouse, etc. How and why should I choose one (or a particular combination) over the others? What’s so special about each one?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: October 06

Time: 2:15 PM - 3:15 PM

Room: 2220

The cardinality estimator in SQL Server is a massively complex piece of software that is responsible for calculating the estimated number of rows for query plans. We will derive some of the simplest and most important rules for cardinality estimation. Armed with that knowledge, we will address errors in cardinality estimates which can cause poor query performance. Demos include filtering on multiple columns, using local variables, dealing with ascending keys, and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 06

Time: 3:55 PM - 4:55 PM

Room: 3190

Selecting and sizing hardware for SQL Server can be challenging at times, especially when you don’t do it every day.  Come learn about the latest SQL Server hardware solutions and reference architectures, as well as a joint effort with Microsoft called “Data Warehouse Fast Track” which provides hardware solutions certified by Microsoft for SQL Server.
Speaker:

Session Type:
Platinum Sponsor Spot (20 minutes)

Track:
General

Level: Beginner

Session Code:

Date: October 06

Time: 3:25 PM - 3:45 PM

Room: Theater

SQL Server Integration Services (SSIS) is a powerful tool to help businesses standardize, consolidate, and automate their ETL processes. In this session, you will learn the basics of how to build an SSIS package while keeping in mind package performance, including parallelism, blocking, and data selectivity. Come join us and learn how to build a fast and efficient ETL process.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 06

Time: 2:15 PM - 3:15 PM

Room: 2225

Time and time again the same misunderstandings by developers and query writers appear when query performance issues arise. In this demo heavy presentation, we will review these specific topics such as data types, implicit conversions, sargability, and some others that all have an impact on query performance. Come join me and by the end of this session you will have the knowledge to boost your query performance!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 06

Time: 2:15 PM - 3:15 PM

Room: 3190

Few subjects in Microsoft SQL Server inspire the same amount of Fear, Uncertainty, and Doubt (FUD) as Extended Events. Many DBAs continue to use Profiler and SQL Trace even though they have been deprecated for years. Why is this?

Extended Events started out in SQL Server 2008 with no user interface and only a few voices in the community documenting the features as they found them. Since then, it has blossomed into a full feature of SQL Server and an amazingly low-impact replacement for Profiler and Trace.

Come learn how to get started - the basics of sessions, events, actions, targets, packages, and more.  We will look at some base scenarios where Extended Events can be very useful as well as considering a few gotchas along the way. You may never go back to Profiler again!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 06

Time: 9:30 AM - 10:30 AM

Room: 2215

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: October 06

Time: 1:00 PM - 2:00 PM

Room: 2225

How has your organization determined the Power BI architecture(s) you are using or want to move to?   Items like Power BI report server, Direct Query, Composite models, Imported models, AAS, SSAS Tabular, Embedding, Premium SKUs (A, EM, or P), licensing requirements, are your users internal or external, cost, etc. are things to consider.   All of these can have a significant impact on your implementations.   Join us for a review of common Power BI architectures and when they could be used, what we did and why.  This is a very interactive session designed to discuss the audiences scenarios and questions.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 06

Time: 3:55 PM - 4:55 PM

Room: 2225

Power BI and SQL Server Reporting Services both provide numerous features to enabling data interactivity. This session combines the more advanced interactive features to demonstrate a truly dynamic report viewing experience. Together we will explore the use of custom visualizations, bookmarks, advanced DAX and more, to dynamically change chart axes and even visualization measures with a selection from a slicer. We will even see how to completely change the presentation on a Power BI tab with the single click of a button. Come see how to take your reports from interactive to hyper-interactivity.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Advanced

Session Code:

Date: October 06

Time: 10:45 AM - 11:45 AM

Room: Theater

In this session we will give an overview of what Table Partitioning is, how can it be used to move large amounts of data quickly and how can it be used with a data archiving strategy to quickly and easily drop archived data from a table.  We will discuss the practical applications of table partitioning using scripts to generate new table partitions, move a partition to another table and discussion on how this can benefit you.   In this demo heavy session, attendees will be provided with scripts to get setup quickly so they can begin using the strategies to take control of rapid data archival
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 06

Time: 9:30 AM - 10:30 AM

Room: 2115

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