Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type

Sessions Found: 67
Backlogs! Standups! Burndowns! If you ever find yourself - as a data professional - immersed in an organization that follows an agile methodology, you're going to want to have a basic understanding of typical roles, artifacts, events, and nomenclature associated with that methodology. In this session, you'll get a quick overview of agile methodologies (focusing on Scrum) and how they apply to the way data professionals work as part of a software development team. You'll leave with an understanding of the goals that agile methodologies try to achieve, resources to learn more, and confidence in knowing a PBI from a PBR.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 15

Time: 3:30 PM - 4:30 PM

Room: 1109

Successful reporting and transactional systems start with proper architectural principles and considerations.  Learn how to design new database systems for optimal performance and how to discover, document and prove when performance issues are caused by the system configuration.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Optimization & Performance

Level: Beginner

Session Code:

Date: July 15

Time: 11:45 AM - 12:45 PM

Room: 1319

Windows Azure Machine Learning and Data Analytics platform offers a streamlined experience, from setting up with only a web browser to using drag-and-drop gestures and simple data-flow graphs to set up experiments. Azure Machine Learning Studio is a GUI-based integrated development environment for constructing and operationalizing Machine Learning workflow on Azure and features a library of time-saving sample experiments, R and Python packages, and best-in-class algorithms from Microsoft businesses like Xbox and Bing. Learn how the Azure Machine Learning service in the cloud lets you easily build, deploy, and share advanced analytics.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics & Visualization

Level: Intermedia

Session Code:

Date: July 15

Time: 9:15 AM - 10:15 AM

Room: 1313

Up and running with Azure SQL Database already? This session will provide a grab bag of 12 how-to items you'll need to know to successfully keep your database running. Among those, we'll cover PowerShell for Azure SQL DB, geo-replica and other disaster recovery features and monitoring. As Azure SQL DB rapidly gains capabilities, rest assured that this session covers the latest!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: July 15

Time: 3:30 PM - 4:30 PM

Room: 1105

You want Enterprise Edition of SQL Server? Not gonna happen!  When we are limited by having just the Standard version we have to dig into our “Blue Collar” roots, we need to become more creative and squeeze every penny it has to offer out of it.

In this session, we will review some of the limitations that Standard has.  Then review items such as basic normalization and  High Availability options available to Standard.   You will also learn Blue Collar techniques to implement partitioning using techniques like as indexed views and partitioned views.

Let’s dig in and learn to make use of all we have until we beg our bosses enough to get Enterprise Edition!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: July 15

Time: 2:15 PM - 3:15 PM

Room: 1107

How do you know when your server is on fire?  Without a set known-good measurements to compare against to look at you don’t.  This session will show you how to capture a performance baseline for a SQL Server instance. The session will help you decide what and when to capture data and where to store it. Then we will walk through different tools and scripts to use.  Then walk you through a scenario of using that data to identify a problem.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Optimization & Performance

Level: Beginner

Session Code:

Date: July 15

Time: 8:00 AM - 9:00 AM

Room: 1321

DevOps lives at the fast paced intersection of developers and IT professionals. Our business partners are learning, expanding their toolkit, and putting more pressure on BI teams to deliver analytics at an accelerated operational cadence. I'm here to show you how to automate your production database code delivery even in large data warehouse environments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: July 15

Time: 8:00 AM - 9:00 AM

Room: 1318

On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and correcting data. In this session, we will look at different data cleansing and preparation techniques using both SQL Server and R. We will investigate the concept of tidy data and see how we can use tools in both languages to simplify research and analysis of a small but realistic data set.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics & Visualization

Level: Beginner

Session Code:

Date: July 15

Time: 1:00 PM - 2:00 PM

Room: 1313

Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming "difficulties" are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense. In this session I will give an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = 'A' is killing your performance, and more time for solving the next customer problem.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: July 15

Time: 10:30 AM - 11:30 AM

Room: 1107

The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT and Prod is a challenge whither on premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 15

Time: 2:15 PM - 3:15 PM

Room: 1321

The SSIS catalog is one of the best-evolved features in the SQL Server Integration Services ecosystem. With integrated package storage, Windows ACL-like security settings, built-in logging, and many other features, the SSIS catalog has become an anchor for many ETL architectures. With all this complexity, it is important to understand the inner workings of the SSIS catalog to keep it running smoothly.

In this demo-heavy presentation, we will dive into the details of the SSIS catalog. We will start with a quick survey of catalog features, followed by an exploration of the moving parts (tables, views, and stored procedures) in the catalog database. We will also review the security capabilities in the catalog, and will discuss maintenance operations. Finally, we'll walk through the mechanics of deployment and execution, reviewing what happens under the covers during these operations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Dev, Delivery & Admin

Level: Intermedia

Session Code:

Date: July 15

Time: 8:00 AM - 9:00 AM

Room: 3310

Enterprise data integration changed with the introduction of the SSIS Catalog. Implementing enterprise data integration often requires functionality beyond the rich features provided by the SSIS Catalog. Building on his previous work in the field of Data Integration Life Cycle Management (DILM) and SSIS Frameworks development, a Data Integration Architect with 10 years of SSIS experience explains the what, why, and how of an SSIS Catalog-integrated Framework that delivers metadata-driven package execution, connections management, and parameter configuration.

In this session, you will learn:
- A method for migrating packages from Development, through the data integration life cycle, to Production without editing SSIS Connection Manager Properties.
- A metadata-driven approach to SSIS package execution.
- A method for customizing enterprise data integration reporting.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Dev, Delivery & Admin

Level: Intermedia

Session Code:

Date: July 15

Time: 9:15 AM - 10:15 AM

Room: 1307

In its origin, Hadoop was created as a distributed computing system designed to process data in batches, but the many advantages of the platform lead to an immediate desire to run interactive analytical queries against Data Lakes built on Hadoop.  So a few years back the Stinger initiative was created as an ongoing effort to bring interactive SQL querying capabilities to Hive, and its latest release has finally delivered! 
In this session, Luis Figueroa (Solutions Engineer @ Hortonworks) will walk you through the latest advancements that make Hadoop a powerful SQL engine that expands you EDW capabilities with unlimited scale and amazing flexibility. Luis will provide a technical overview of the Hive engine, an update on SQL compatibility with the ANSI standard,  real world use cases and a live demo. If you are a data pro this session is for you!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: July 15

Time: 10:30 AM - 11:30 AM

Room: 1105

If you’ve ever used the standard Excel Source or Destination components in SSIS, you know there are some limitations. Cozyroc’s Excel Source Plus and Excel Destination Plus components remove those limitations. In addition, Cozyroc’s Excel Task enables editing of Excel files from SSIS packages. In this session, I’ll talk about the capabilities of the Cozyroc components and demonstrate how easy it is use use these components with SSIS.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Dev, Delivery & Admin

Level: Beginner

Session Code:

Date: July 15

Time: 11:45 AM - 12:45 PM

Room: 1313

For beginning database professionals, execution plans can be intimidating. This 1-hour session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache. 

Reading execution plans becomes much less intimidating as we walk through the flow and process of a graphical execution plan. After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 15

Time: 3:30 PM - 4:30 PM

Room: 1319

In this session we will Learn R through an Example. We will Extracting Data from Multiple Excel sheets, transforming the data, Visualizing the data and Loading it into SQL Server Table.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics & Visualization

Level: Beginner

Session Code:

Date: July 15

Time: 8:00 AM - 9:00 AM

Room: 1313

With the cross-platform version of .Net, Microsoft has had to rewrite many of the core components that we have come to depend on. If you include data in your applications, chances are you have used Entity Framework in the past. In this session, you'll learn how to get started using EF Core and how to handle the changes in this version.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 15

Time: 3:30 PM - 4:30 PM

Room: 1321

Power BI is constantly evolving; this session is an overview of the current abilities and ways to implement Power BI, based on our experience in the field using it. Topics include the Power BI Service, Power BI Desktop, Pricing models, and intro to SSRS 2016 Preview with Power BI. Sample data set used in this presentation is from @DogRates
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Dev, Delivery & Admin

Level: Beginner

Session Code:

Date: July 15

Time: 10:30 AM - 11:30 AM

Room: 3310

This session will cover techniques and lessons learned in moving a 24X7 system to the cloud, and the changes needed to provide a Highly Available multi-regional cloud based environment.  

This session covers all the things that were needed to spin up and get into production including:
- Definitions
- Environmental setup
- Installation
- SAN setup
- Backups
- Clustering
- Cold\warm\Hot Standby
- Regional Fail-over
- Multi regional fail-over
- Multi Cloud Fail-over
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: July 15

Time: 9:15 AM - 10:15 AM

Room: 1109

Microsoft has recently streamlined the certification process and this session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for success.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 15

Time: 10:30 AM - 11:30 AM

Room: 1321

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