Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type



Sessions Found: 38
SSIS has many great built-in tasks and components. Sometime, though, you need to go further than what they allow. Come to this session to see how far you can stretch the scripting capabilities of SSIS. 
SSIS offers significant capabilities out-of-the-box. However, many data movement projects have needs that go above and beyond the common scenarios. Have you ever needed to calculate running totals during your ETL process? What about using dynamically updated business rules during processing to determine what data is valid? These things, and much more, can be accomplished using the script task and component within SSIS. During this session, we will demonstrate several scripts in SSIS (including the ones mentioned above) that show how to take full advantage of the capabilities of SSIS. This session is intended for people who have worked with and understand SSIS, and have a basic understanding of .NET development.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Integration

Level: Intermedia

Session Code:

Date: September 26

Time: 9:30 AM - 10:30 AM

Room: 170

This is an absolute beginner session on Azure Data Factory. I will cover basic terms and operations and show how to move your data the Azure way.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Integration

Level: Beginner

Session Code:

Date: September 26

Time: 3:45 PM - 4:45 PM

Room: 150

Every company has a backup strategy. That backup strategy is worthless and will cause your business to fail miserably while losing valuable customer data and more importantly you will lose my order of chicken wings! In this session you will learn why backup strategies are for losers, what can I do to keep from being a loser, and how can I build a winning strategy! 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 26

Time: 1:15 PM - 2:15 PM

Room: 270

If you are a working professional there is a chance that your career has interrupted your life and you've forgotten about you and/or your family.  How do you create a healthy balance between the two so that you are happy and everyone else is to? In the session, you will learn how to properly manage time, erase stress, advance at work, address common marriage and family Issues, and ultimately create a  better you.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 26

Time: 2:30 PM - 3:30 PM

Room: 270

For most of us, our career in technology was and is the result of our combined education, experience, opportunities, and luck. In this presentation we will explore approaches to creating the career we want instead of the one we stumble into.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 26

Time: 10:45 AM - 11:45 AM

Room: 270

Existing SSIS automation solutions are focused on forward-motion activities: creating packages and pushing them to the server.  Little or no thought is given to the management of the packages once they are in production - existing tooling offers nothing to help you understand and manage a live, money-printing ETL workflow based on SSIS packages.

BIPS is an open source project that allows you to manage a live SSIS package tree from PowerShell.  It closes the automation loop, providing the ability to learn and discover the features of an existing package deployment tree as well as manipulate it.  In short, the goal of BIPS brings a devops perspective to managing your SSIS packages.

In this session, you will learn how to leverage BIPS in your own environment.  Specific attention will be given to searching and filtering tasks and data flows on arbitrary criteria and manipulating specific parts of the ETL workflow from the shell. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: September 26

Time: 2:30 PM - 3:30 PM

Room: 260

Beginning with a two node Windows cluster with shared storage, I will walk you though setting up SQL Server as a clustered resource.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 26

Time: 10:45 AM - 11:45 AM

Room: 160

The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or the incorrect version. Each database is made up of a lot of objects in different environments.  When you create an object like a table or stored procedure, you need to get this object deployed into each environment.  Together we will discover how to separate each object for proper order deployment while releasing only objects which have changed. Deployments can cause you trouble but we will provide a reliable deployment and version control process.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DevOps

Level: Beginner

Session Code:

Date: September 26

Time: 1:15 PM - 2:15 PM

Room: 260

Understanding how SQL Server organizes your data under the hood can seem like a daunting task. In this session we’ll take a look at how objects such as tables and indexes are stored in the data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions.

We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: September 26

Time: 9:30 AM - 10:30 AM

Room: 150

Continuous Integration & Delivery isn’t a new concept.  Application Developers have been doing it for quite a while and now it’s time for Database Professionals to catch up.  Whether you are a database administrator, database developer, or even an application developer, database continuous delivery can help you find your salvation. I'll show you how to apply these concepts to areas of security, collaboration, testing, support and deployments.   We will look at what continuous delivery means, demonstrate some tools that can help you easily get it into place, and dive into why it’s important.  
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DevOps

Level: Beginner

Session Code:

Date: September 26

Time: 9:30 AM - 10:30 AM

Room: 180

With more entry level DBA positions becoming available, and non-DBA’s shifting into DBA roles, you may find yourself in a position where you need to become familiar with a new server environment quickly and efficiently but not know where to begin. In this session we will review some standard practices and personal experiences that have helped efficiently identify and spec out a new environment.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 26

Time: 2:30 PM - 3:30 PM

Room: 180

The SQL Server optimizer is an engineering marvel.  The intelligence that is built into the product is mind bending.  But, sometimes queries don't run as expected.  Without a basic understanding of statistics and the cardinality estimator you'll never know why.

This session will walk through an anomaly of the cardinality estimator called The Ascending Key Problem.  A major focus of the discussion will include how the optimizer uses statistics to estimate row counts, which is ultimately used to build optimal query plans.

At the end of this session you will know how to assess the state of the statistics for your indexes and columns; you will know how to look at your query plans in a way that will help prevent poor query performance BEFORE the query executes; and you will better understand how the optimizer estimates row counts.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 26

Time: 3:45 PM - 4:45 PM

Room: 170

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:
Data Integration

Level: Intermedia

Session Code:

Date: September 26

Time: 8:15 AM - 9:15 AM

Room: 170

For most users, you will sign up to use Power BI and  never know that Office 365 is the background.  For organizations that want to leverage the advanced features of Power BI,  you MAY need to perform certain configurations within Office 365.  Since most people do not realize that Office 365 is used under hood of Power BI, we will show you how to properly prepare your organization for the new Power BI service.  In this demo heavy session we will dispel the myth that you may not need Office 365 to access the full capabilities Power BI.  For most users, you will sign up to use Power BI and  never know that Office 365 is the background.  For organizations that want to leverage the advanced features of Power BI,  you MAY need to perform certain configurations within Office 365.  Since most people do not realize that Office 365 is used under hood of Power BI, we will show you how to properly prepare your organization for the new Power BI service.  In this demo heavy session we will dispel t
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: September 26

Time: 10:45 AM - 11:45 AM

Room: 150

For beginning database professionals, execution plans can be intimidating. This  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:

Session Type:
Extended Session (90 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 26

Time: 8:15 AM - 9:45 AM

Room: 260

The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI.  In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson introduces Microsoft Business Intelligence 2012 and the Business Intelligence Semantic Model ("BISM").  He then overviews the Tabular model, beginning with the creation of a project with SQL Server Data Tools (“SSDT”), and continuing from the data import steps to the creation and management of calculations, measures and Key Performance Indicators (“KPIs”).  Finally, he provides insight to the creation and maintenance of perspectives and hierarchies, as well as other considerations involved in working with Tabular.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: September 26

Time: 8:15 AM - 9:15 AM

Room: 150

In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.   This session applies equally to Analysis Services 2008, 2008R2 and 2012.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: September 26

Time: 9:30 AM - 10:30 AM

Room: 160

Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering.  This session will cover how you can keep your sanity, get stuff done, and still love your job. We'll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too.  When you finish this session, you'll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 26

Time: 3:45 PM - 4:45 PM

Room: 180

In this session we will explore
1. Installation of R and R Studio
2. R basics 
3. Power of R
3. Getting data from databases and other sources.
4. Managing Data frame using package dplyr
5. Visualization of Data using Graphic  package ggplots
6. In-Database R in SQL Server 2016
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: September 26

Time: 1:15 PM - 2:15 PM

Room: 160

Most of us are overwhelmed with data from all the different applications that we use on a daily basis.  Bringing all the data together is often a very time-consuming and sometimes a challenging process.  Even further, attempting to analyze and visualize the data poses new challenges that is sometime difficult or impossible to overcome.  Now with Power BI this can all be made very simple.  Individuals, ranging from novice information workers to advanced IT professionals can quickly and easily transform, analyze and visualize data using a single tool, Power BI Desktop.   In this course we will work through four main topics: Shaping Data, Building a Data Model, Visualizing Data and Using the Power BI Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: September 26

Time: 3:45 PM - 4:45 PM

Room: 260

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