Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type



Sessions Found: 44
You're a developer or DBA who wants to get your database code into source control, but you're not sure how to work with it. Should you use release branches? Feature branches? How do you handle emergency hotfixes? There are quite a few discussions and patterns available online for branching application code, but special considerations apply when it comes to database code. In this session, you'll learn to design the simplest branching strategy that meets the needs of your organization, based on the size of your team and your requirements for release practices. We will discuss multiple popular branching models along with “fit notes” describing the strengths and weaknesses of each model.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 12

Time: 10:15 AM - 11:15 AM

Room: 187

If you heard of some of the data analytics products on AWS but unsure where to start, this session may help. Amazon Web Services offers analytics tools to enable data ingestion, storage, analysis, and visualization. From this session, take home an introduction to services such as AWS Data Migration Services, S3, Amazon Athena and take an introductory look into Amazon QuickSight, visualization on AWS. Learn how to leverage Amazon’s cloud infrastructure, platform and software as a service to build an analytics and insights solution on the cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: October 12

Time: 9:00 AM - 10:00 AM

Room: 379

TSQL is one of the most valuable tools any SQL Server professional can add to their tool-set. More aptly, TSQL is a whole chest of tools for the SQL Server professional. One of the most important tools in that TSQL chest is a good understanding of the SELECT statement.

When was the last time you sat down to evaluate a SELECT statement? What actually goes into the processing of that teeny little word? There might be a fair bit more to this simple term than just fetching data from the database. This session covers the simplicity of the select. Then we take it a step further to dive into some of the complexities tied directly to this particular statement.

This session will help the attendee better understand the Select statement. With a more solid understanding of this statement, the attendee can return and implement some of this new knowledge to help improve processing and query response times in their own environments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: October 12

Time: 9:00 AM - 10:00 AM

Room: 287

DBAs agree, Access databases should be converted to SQL Server, but that sounds a lot easier than it turns out to be in most cases. In this session we will discuss when it is appropriate to migrate to SQL Server, migration strategies, how to manage the transition, whether to move to on premises or Azure and finally how to accomplish the task.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 12

Time: 10:15 AM - 11:15 AM

Room: 379

Virtually all of today’s data solutions are hybrid solutions – partially in the cloud, partially on premises – as organizations attempt to fulfill an ‘all in the cloud’ mandate.  The reality is that cloud platforms like Azure do many things very well, but not all things, and functional gaps remain which complicate and sometimes prevent a full migration away from on premises environments.

Azure Analysis Services (AAS) is a good example of this reality – it works very well for many applications but is limited to Tabular Models and cost can explode if those models are not created thoughtfully.  And, what is the path to Azure for my multidimensional cubes? Do I care about Azure Analysis Services if I use Power BI?  As always the answer to these questions is a clear and absolute ‘it depends’.

In this session we’ll explore Azure Analysis Services functionality, fit in various solutions, and gaps and techniques that are important to consider when implementing AAS.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 12

Time: 12:45 PM - 1:45 PM

Room: 253

Are you struggling to get you analytics and data projects started on Azure? Overwhelmed by where to start or which services to choose? or perhaps just interested in learning more about the options to move your current BI platform to the cloud.  This hands-on session is for you. We will start with a brief overview of the Azure platform then we will guide you through getting an environment setup. Along the way will answer any questions and talk about specific pitfalls and decision that need to be made to ensure you are able to continue to build on this newly acquired knowledge.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 12

Time: 3:15 PM - 4:15 PM

Room: 254

Interested in working with large and varied data sets but don't know where to start? Wondering if your team knows enough to apply advanced analytic techniques?  Not sure if you can use your SQL skills in Big Data world?
Come and learn about Azure Databricks. This service combines power of Apache Spark large scale workloads with fully managed Azure cloud services to build data engineering pipelines, interactively run analytical tasks and implement machine learning algorithms. But what really sets it apart from other cloud analytical services, is that it is a truly collaborative environment that allows you to take advantage of diverse skills in your organization and let everyone work with data.
By the end of this session you will know how to easily connect to various data sources in data lake, quickly spin up Spark clusters, use notebooks to share your code and mix languages like SQL, R, Python, and build visualizations to drive business insights.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 12

Time: 10:15 AM - 11:45 AM

Room: 254

You have probably worked as a direct hire for a company.  You get medical benefits, vacation, and possibly a good 401k.  On occasion you might have accepted a contract.  The pay might be nicer, but you are concerned because you have less job security, no vacation, and no benefits.  Yet, there are some who prefer contracts.  We will cover how to negotiate a wage, appear professional, a look at finances, contractual gottchas, taxes and paperwork.  Since most are experienced at being a direct hire with a company, this presentation will show the benefits of consulting/contracting, so that you can decide what is right for you and your career path.  Presenter has been contracting for 18 of the last 20 years and will share many of his experiences - the successes and the falls along the way.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 12

Time: 9:00 AM - 10:00 AM

Room: 187

Data collection and usage is all around us, it is what we do. But is what we do with the data ethical? Are we collecting and processing biased data?  We will take a look at ethical data collection and usage, what it means to your models and forecasts, and how being aware of possible biases can impact your bottom line. You might be training on extremely biased data and not know it, skewing your forecasts in the wrong direction.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 12

Time: 2:00 PM - 3:00 PM

Room: 187

Power BI Desktop is often shown as a self-service reporting and analytics tool, but it can also be used earlier in the development cycle for prototyping and data modeling, doing it quicker and easier than other tools made for this purpose. 

In this session, we will go through multiple examples showing how Power BI Desktop is the perfect tool to quickly model data from multiple data sources (including web sites, databases, cubes, online services, and even flat files), and perform quick actions to cleanse and connect these various sources to each other using M and DAX functions built-in to Power BI Desktop. Once this model has been built, it can be used to create some quick reports to show how this will be used to help get a project approved/funded. Best of all, using Power BI Desktop to do all of this is completely free, no licensing or Power BI login required!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: October 12

Time: 2:00 PM - 3:00 PM

Room: 187

Data is everywhere and Data Science is a very popular topic among data analysts and BI professionals. In this session, I will cover the basic data science principles and methodologies using the Python programming language. I will also present some real-world data analysis case studies using the Python libraries, such as NumPy, pandas, Matplotlib, and SciPy.  This session will benefit to anyone who is looking to get started in the data science/ Data Analytics field.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: October 12

Time: 9:00 AM - 10:00 AM

Room: 186

Are you thinking about runing Azure in SQL but don't understand all your options.  Do you find the terms DTU and Elastic Pools confusing.  Want to understand the difference between Azure SQL, Azure SQL Data Warehouse and Azure SQL Managed Instances.  If you answered yes to any of these questions, this session is for you.
In this session I will cover all of the SQL options you have available, the pros and cons of each and how to create and use each of these options.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery

Level: Beginner

Session Code:

Date: October 12

Time: 12:45 PM - 1:45 PM

Room: 287

DevOps automation can be intriguing to learn and overwhelming to implement. This session will take a real life use case of a multi-tier and complex environments, with various stake holders to a successful conclusion. Unlike a session on concepts, this session surrounds itself with a real-life situation and how automation was used with DevOps practices to build a solution. The session will demonstrate the reasons to automate, along with the steps required to make it possible, offering insight into concepts that are often too vague to employ. The attendee will see multi-platform and cloud tool demonstrations on how to take the DevOps methodology and continuous delivery to actuality in their own projects, no matter if small or large.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: October 12

Time: 3:15 PM - 4:15 PM

Room: 380

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:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 12

Time: 10:15 AM - 11:45 AM

Room: 253

A DBA's suite of scripts is worth its weight in gold.  As Azure moves the SQL DBA to a more Linux focused environment, the opportunity to learn Linux scripting and to add these valuable skills to your pre-existing Powershell skills is a great goal.  This session will teach you how to build out proper shell scripts, tips and tricks, along with how to learn faster.

This session is the second session in the Linux for SQL Server Professionals Learning Pathway. For more information please visit our Learning Pathways page.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: October 12

Time: 9:00 AM - 10:00 AM

Room: 253

ETL (Extract, Transform and Load) is the backbone of any data project and can be upwards of 70% or more of the effort. The tools you have access to allow you to make progress in a hurry. However, are you implementing best practices and techniques that will scale to the demands you need? Or will you be refactoring far too quickly than you should to meet performance requirements?

Gian helpful insights from decades of lessons learned and walk away with best practices you can implement in your own ETL solution.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 12

Time: 9:00 AM - 10:00 AM

Room: 380

Databricks is a very popular environment for developing data science solutions.  More and more companies are interested in Databricks as it is very simple to set up and contains a collaborative workspace for working with a team of people. In this session you will see how to create Machine Learning Solutions with multiple workflows starting with ETL, to data exploration, model experimentation, and lastly to a production release of a data science solution. 

Today, more and more development is performed on very large datasets. Attendees will learn how to use Apache Spark, which is part of Databricks, to rapidly analyze lots of data.  Learn how to use Databricks to reduces operational complexity to create solutions which can be scaled up or down depending on the amount of data needed to process without having to change the underlying code. 
Python, Jupyter Notebooks, and Apache Spark are the technologies used to create solutions within this session.  No experience is required.
Agenda
Speaker:

Accompanying Materials:

No material found.

Session Type:
Precon (480 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: October 11

Time: 9:00 AM - 5:00 PM

Room: Room3

How do you design a SQL Server 2019 infrastructure in order to meet specific Recovery Time Objective (RTO) and Recovery Point Objective (RPO) service levels? There are many aspects to consider, from technology choices and licensing, to policies and procedures. This session outlines and compares the various HA/DR technologies available in SQL Server 2019, showing how you can combine them to design and build a solution to help meet your HA/DR goals. This session also teaches you how to formulate policies that enable effective use of technology in your organization.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 12

Time: 2:00 PM - 3:00 PM

Room: 380

You want to frequently release quality database changes while maintaining high performance and availability standards, but how do you do it? While the term ‘DevOps’ has just turned 10 years old, database architects and DBAs have been developing patterns and practices to standardize and automate delivery of database code quickly and reliably for far longer.  
 
In this session, you will learn how to choose between state and migrations-based approaches to database code management in source control on a per-project basis, and what this choice means for your release practices. You’ll learn what release automation means for ‘rollbacks’ with database code and get to join the debate on the pros and cons of different approaches to handling post-release disasters in production. We’ll discuss release patterns and how to measure success, including the blue/green deployment model when applied to databases, the expand/contract pattern, feature flags, and special cases for releases including repli
Speaker:

Accompanying Materials:

No material found.

Session Type:
Precon (480 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 11

Time: 9:00 AM - 5:00 PM

Room: Room2

There is much more to life than 3rd normal form and dimensional modeling. Come explore how you can build a data warehouse solution or hybrid solution that is agile in nature with Data Vault. Discover this highly audit-able modeling technique used in international banking, manufacturing, insurance and many more industries.  Made a mistake? No worries, own your model. Design changes happen and it can be addressed quickly avoiding pain and project delays and ultimately keeping your business happy.  Let us bust the myth that data warehouses take too long to build and are too hard to modify by adding value to your environment and decreasing delivery time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 12

Time: 2:00 PM - 3:00 PM

Room: 275

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