Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type

Sessions Found: 41
Testing is a critical part of the release process and vital to a high-quality data management lifecycle. Unfortunately, Integration Services (SSIS) does not have built-in support for testing and the tools for relational database testing are limited. As a result, most organizations forgo automated testing and focus entirely on manual user testing, which is both expensive and often occurs too late in the process to address all of the issues discovered. 

In this session, a new approach to unit testing (focusing on verifying the correctness of individual packages, tasks, or dataflows) and integration testing (focusing on validating that the data produced by an entire sequence of transformations) will be discussed. This development pattern uses metadata authored by analysts to automatically generate testing logic within the corresponding packages or to automatically generate standalone test packages that contain all of the necessary validation logic.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 24

Time: 3:45 PM - 5:00 PM

Room: ARP 114

Now that you've developed solid patterns for SSIS, how do you communicate that to your junior team members? How do you ensure they are following your practices? Let's look at what SQL Server 2016 has to offer the busy architect. We'll address some basic recipes for SSIS and how innocuous deviations from that pattern can lead to disastrous results. With fear fresh in your minds, we'll then cover the great new features like Control Flow Templates. Finally, we'll look at other systematic approaches for standardizing solution development.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
Biml

Level: Intermedia

Session Code:

Date: September 24

Time: 12:45 PM - 2:00 PM

Room: ARP 224

Your end users want to analyze data in your data warehouse. They could deal with the learning curve of SSAS but they'd prefer to utilize a familiar application like MS Excel. Welcome PowerPivot, a tool that retrieves data from your data warehouse by combining the power of SSAS models and your SQL Server Data warehouse within the familiar interface of MS Excel. In this presentation well explore SSAS BI Semantic model, PowerView, PowerPivot in Excel.
Speaker:

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: September 24

Time: 10:00 AM - 11:15 AM

Room: ARP 218

So you have made first contact with Biml and are excited? Good!

You're wondering, if Biml can do more than just transfer data from SQL table to another? Great!

Because Biml does so much more than just simple SSIS packages. We'll explore the potential on how to improve your existing packages using BimlScript and LINQ.
Topics covered, amongst others, are derived columns, incremental changes and how to handle flat files. 

You'll leave with sample code and hopefully a couple of ideas on how to bring your Biml development to the next level.
Speaker:

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
Biml

Level: Intermedia

Session Code:

Date: September 24

Time: 10:00 AM - 11:15 AM

Room: ARP 114

In this demo-heavy session, you will learn about the basic concepts of increasing productivity by creating your SSIS packages using Biml.

We will look into manual Biml code to understand the general idea of Biml, then take it from there and generate a whole staging area from scratch and end with a complete manageable solution to completely maintain your staging process using SQL tables.

Have you ever spent hours fixing your SSIS due to a schema change on the source? Ever wanted to add a "load timestamp" to 370 tables in your staging area but refrained because it would have taken you weeks to do so? If so, this is the session for you!
Speaker:

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
Biml

Level: Beginner

Session Code:

Date: September 24

Time: 8:30 AM - 9:45 AM

Room: ARP 114

Developers today face an onslaught of data storage applications.  Various NoSQL offerings promise performance, scalability and easy development on commodity boxes.  How does one get these benefits in SQL Server?  What does a SQL Server application built today using the newest features and best practices look like?  This session will discuss client applications, new SQL Server features and application architectures to support a modern, high-throughput transaction environments.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: September 24

Time: 12:45 PM - 2:00 PM

Room: ARP 316

Many companies scale out their databases horizontally, partitioning data by customer (or some other identifier) into separate databases or instances.  Sometimes, it becomes important to move that data from one database to another.  SQL Server Integration Services is a fantastic tool for ETL, but creating and maintaining dozens or hundreds of data flows by hand is exhaustingly tedious.  Instead of doing it the hard way, use the BI Markup Language (BIML) to automate package development.  This talk will show how we can use metadata tables and BIML to auto-create SSIS packages to migrate data from one database to another, handling foreign key constraints along the way.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
Biml

Level: Intermedia

Session Code:

Date: September 24

Time: 12:45 PM - 2:00 PM

Room: ARP 114

Dimensional modeling is one of cornerstones of successful Business Intelligence initiatives. Even with new technologies like PowerPivot and Analysis Services Tabular models, you need to represent your organization’s data in a way that is accessible for end users and IT staff alike. An effective dimensional model will also ensure that your data warehouse or data mart will be responsive and capable of accommodating emerging requirements.
In this session, we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables, Including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After attending this session you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes. Bring your toughest quandaries to help make this an interactive and engaging session.
Speaker:

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 24

Time: 3:45 PM - 5:00 PM

Room: ARP 212

Recovery in the cloud is now easier and more convenient than ever.  This session describes some common scenarios and reviews the steps needed to prepare for a disaster with a recovery in Azure.  We will focus on the IAAS offerings.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 24

Time: 8:30 AM - 9:45 AM

Room: ARP 212

How often do you review your SQL Servers for basic security, maintenance, and performance issues?  Many of the servers I "inherit" as a managed services provider have quite a few gaping holes. It is not unusual to find databases that are never backed up, servers with constant login failures (is it an attack or a bad connection string?), and servers that need more RAM/CPU/etc. (or sometimes that even have too much!) 

Come learn how to use freely available tools from multiple layers of the SQL Server stack to check your servers for basic issues like missing backups and CheckDB as well as for more advanced issues like page life expectancy problems and improper indexing. If you are responsible in any way for a Microsoft SQL Server (DBA, Windows Admin, even a Developer) you will see value in this session!
Speaker:

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 24

Time: 8:30 AM - 9:45 AM

Room: ARP 210

Survivability of data should be the #1 priority for any database administrator. Corruption can happen to any database at any time. How soon corruption is detected and a quick response is key to minimize lost data and recovery in a timely manner. Have a plan ready when it happens, as this is one time you don’t want to “learn on the job”. In addition to daily and monthly maintenance that should be performed, other topics discussed will include e-mail notification when data becomes corrupt and Service Level Agreements.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 24

Time: 3:45 PM - 5:00 PM

Room: ARP 316

You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated?  In this session, we will examine details the query optimization process that are not very well known.  We will discuss how SQL Server parses a T-SQL statement then and begins applying rules to make it more efficient.  Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos?  We'll do just that, and then take it a step further with a unique visualization tool that I have created.  With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn't do it as well as might be hoped), you can write more efficient SQL statements.
Speaker:

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: September 24

Time: 2:15 PM - 3:30 PM

Room: ARP 316

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 (75 minutes) (75 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 24

Time: 2:15 PM - 3:30 PM

Room: ARP 116

Many organizations are interested in the cost savings, ease of maintenance, and other benefits of hosting data solutions on Microsoft Azure.  For most, moving to the cloud is easier said than done, especially when they have a large existing solution that is being actively used by stakeholders.

In this session, we will examine various strategies for incrementally moving your solution to the cloud. This will include strategies that incorporate the use of:
1) New value-added features and services, such as machine learning and big data
2) Hybrid approaches where portions of your existing solutions can be moved to the cloud without requiring everything to be moved
3) Failover and surge approaches that enable the cloud to supplement on premises resources
4) and much more

Business Intelligence Markup Language (Biml) will be central to our approach, enabling the rapid movement of assets back and forth between on premises and cloud hosting.

All code will be shared with attendees.
Speaker:

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
Biml

Level: Advanced

Session Code:

Date: September 24

Time: 2:15 PM - 3:30 PM

Room: ARP 114

You have a lot of data to move and a lot of pieces to manage. Perhaps you're a developer and know that SSIS is the best way to move it, but you naturally dislike GUI-based development or you're just not looking forward to the tedium.

Or perhaps you're a team lead/architect and are looking for an efficient platform that best utilizes the development skills of your team.

Jeremy Marx will introduce BIML, a language you can quickly pick up to develop SSIS solutions with code, and BIMLscript, intelligently mixing in C# to make your BIML practically build itself.

Jeremy will demonstrate how to build a simple, single-table SSIS package using BIML, then extend it to many tables with just a few lines of code, and finally apply a more robust data flow designed for reuse. You'll leave with tools and resources to begin coding SSIS solutions faster and more efficiently.
Speaker:

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 24

Time: 12:45 PM - 2:00 PM

Room: ARP 314

Data Science, Azure Machine Learning, and Analytics are all becoming core pieces to the success of every business.  As data professionals we need to know how these will affect what we do, and how we can use it to help our business and clients.  In this session we will take a look at these hot topics and learn how it helps us turn data into intelligence that will lead to actions that drive profits.  We will take a look at how Microsoft’s Cortana suite is the central hub for learning and implementing each of these core pieces.  An easy to follow example showing the flow from Data to Data Intelligence and thru to Action will be presented using Cortana Intelligence Suite.
Speaker:

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: September 24

Time: 10:00 AM - 11:15 AM

Room: ARP 316

In this session we will review Isolation levels and how they affect applications that run on SQL Server.  We will explore what happens when multiple applications accessing the same data use different isolation levels, and how that effects the server as a whole.   We will also explore different ways to relieve these tantrums, and make your applications play nice together.
Speaker:

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 24

Time: 12:45 PM - 2:00 PM

Room: ARP 212

Kerberos delegation is often needed for SQL Server Reporting Services security. Many DBAs avoid Kerberos because of the complexity and come up with workarounds that may violate security policies in their shops. They also may not understand why Kerberos delegation is even required. 
Configuring Kerberos for SSRS can be broken down into three simple steps: SPN registration, setting delegation properties, and application configuration. It’s really not so difficult, and there are a number of tools that can help you troubleshoot when things don’t go as planned.
Attend this session to learn why Kerberos is necessary and how to configure and troubleshoot it.

Speaker:

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 24

Time: 2:15 PM - 3:30 PM

Room: ARP 210

This is a talk on my own experience rewriting the locking mechanism that my company has used. Migrating from a locking table to using sp_getapplock. The ups and downs that I experienced in the transition.
Also to talk about how this can be a great streamline and better performing approach to gaining locks that could be used by the application or other queries. 
Speaker:

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 24

Time: 2:15 PM - 3:30 PM

Room: ARP 218

Applications continue to get more complicated and distributed as inexpensive hardware becomes more and more ubiquitous. Currently the trend is to lead more towards a microservice paradigm when ti comes to large scale application development. 

The missing piece of the puzzle for most companies when it comes to micro services is "How does data fit in?" I hope to answer that question and give you and your organization some strategies on handling massive amounts of data and massive amounts of productivity in a highly concurrent/maintainable way. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes) (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 24

Time: 12:45 PM - 2:00 PM

Room: ARP 218

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