Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 45
Constraining everything in development and testing is database size.  Storage is a bottleneck, and while faster SSD/Flash is available, it is still too expensive due to the size of many databases, especially in DEV and TEST.  More to the point, it takes a lot of time to push terabytes around, and time itself is expensive.  The old joke about "good, fast, and cheap -- pick any two" is so true with data.

Providing full databases for each developer or tester on each task of each project seems unrealistic, when each copy might require terabytes of storage, so for decades everyone has limited themselves to working in shared dev/test environments that are refreshed only every few months, where conflicts occur,  quality suffers, and things move slowly.

Come learn why data virtualization is the solution to a problem everyone knows.

Good, fast, and cheap -- have all three with data virtualization.  Be able to clone data quickly, and remove the biggest constraint to development and testing.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 07

Time: 4:00 PM - 5:15 PM

Room: 335

To create a successful data culture Business needs the freedom to explore and analyze data. At the same time IT needs to understand what is being used for a variety of reasons such as access and data security. When Power BI is used as the analytics solution, companies need a clear understanding of how to best implement Power BI and make it work for the entire organization. This session will explore key administrative functions, such as, how to monitor the environment, how & why you want to control certain features, and granting access & permission. We'll also walk through several key strategies for a successful deployment within your organization and analyzing some Pros and Cons with sharing implementations.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 07

Time: 10:30 AM - 11:45 AM

Room: 225

Administration tasks for a PaaS service like Azure SQL Database are different than for a regular SQL Server.  This session will walk you through the unique management tasks for administering an Azure SQL Database.  
Topics covered will include: 
•	How you manage an Azure SQL Database differently than a SQL Server
•	Securing the Azure DB
•	Monitoring the database
•	High Availability
•	Scaling 
•	Automation
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: April 07

Time: 9:00 AM - 10:15 AM

Room: 335

Publications across the globe have called “data the new oil.”  However, the value of oil is what the oil can be turned into.  Similarly, the value in data is in what you derive from it, not the data itself.

Regardless of the title you carry, DBA, developer, report writer, ETL developer, manager etc., now is the time to make an acquaintance of Analysis Services.  Come, join in as we define basic terms, investigate a few uses cases and see some simple examples.  You will soon see that if data is the new oil, Analysis Services, on-premises or in the cloud, is a key component in the new refinery.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 07

Time: 1:00 PM - 2:15 PM

Room: 213

This presentation will briefly go over the history of OLAP and Microsoft's contribution to the technology.  The bulk of the conversation will then be an introduction to Azure's analysis services implementation - how to use it, how much it may cost, a comparison to on-premises implementations, and how to migrate from on-premises.  Then more intermediate subjects will be discussed, such as analysis of best practices and automation techniques, future features Microsoft is working on, and future research considerations for a more advanced look at Azure Analysis Services.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: April 07

Time: 1:00 PM - 2:15 PM

Room: 335

When using Azure SQL Database, you're paying for performance. In this session, you'll learn what tools and techniques are now available to help you be cost-effective. You'll see how to use features such as scaling, in-memory OLTP, and columnstore to minimize query run times and optimize resource use. Query Performance Insight and Automatic Tuning will be covered so you know how to monitor your environment and automate tuning. You'll be ready to get the most performance for the least amount of money from SQL Database.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: April 07

Time: 10:30 AM - 11:45 AM

Room: 335

Overview of the Microsoft BI Technologies
BI Solution Topology
BI solution requirements
Data Modeling
Relational Dimensional Data Warehouse
ETL
Tabular and Multidimensional Models.
Insights and Visualization
Agile methodologies
Tips for success
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 07

Time: 9:00 AM - 10:15 AM

Room: 213

In today's world, technology is a pervasive part of our lives. We have "smart" appliances everywhere: from cars, thermostats, and even refrigerators contain built-in systems to collect, store, and transmit data. Small embedded devices can also be used for scientific purposes as well, offering new and exciting ways to collect data for studies or projects at home.

The High-Altitude SQL Server Project, or HASSP, is one such project.

The HASSP team has created a high-altitude balloon that uses sensors to collect various data points and store the results in an embedded version of SQL Server!

In this session, you'll hear about how this is possible: we'll discuss the hardware used, the custom device that we built, and the software used to make it all work together. Best of all, you'll see how to recreate (and hopefully improve!) the project on your own.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: April 07

Time: 9:00 AM - 10:15 AM

Room: 226

While Columnstore Indexes were introduced with SQL Server 2012, their popularity and general use haven't increased nearly as much as their functionality since then.  If you're someone that's not had much experience with Columnstore Indexes and want to learn more about them, this session is perfect for you as I plan to cover the Five Ws of Columnstore Indexes: what they are, when to use them, where they are best utilized, and most importantly why they work so well.  You'll be the "who" and after the session, I expect you'll feel more confident and excited to use this great feature.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 07

Time: 9:00 AM - 10:15 AM

Room: 225

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at runtime without the need to change and redeploy the package. Columns and fields are mapped automatically at runtime. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 07

Time: 10:30 AM - 11:45 AM

Room: 325

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:

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Advanced

Session Code:

Date: April 07

Time: 9:00 AM - 10:15 AM

Room: 325

Unit Testing and Test-Driven Development are common practices in application development.  In SQL development we’ve even got tSQLT! In the realm of BI with desperate systems, integration layers, data warehouses and even cubes we need a better approach.

In this session, we’ll discuss different problem scenarios and practical solutions. We’ll identify the need to look at the data from the business perspective and define specific integrity checks to ensure our data is accurate.  Then the fun part!  Using the Microsoft BI tool-set, we will walk-through a working solution demonstrating a way to efficiently centralize this process.  

At the end of the session, we’ll all still agree that we can’t use a unit test or record counts to ensure that data is accurate.  You will have a simple solution that you can start with to work in your environment and look at data testing & integrity differently.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 07

Time: 10:30 AM - 11:45 AM

Room: 213

As Dan Linstedt, the creator of Data Vault 2.0, describes it as follows:
The Data Vault Model is a detail oriented, historical tracking and uniquely linked set of normalized tables that support one or more functional areas of business. It is a hybrid approach encompassing the best of breed between 3rd normal form (3NF) and star schema. The design is flexible, scalable, consistent and adaptable to the needs of the enterprise.
Data Vault 2.0 is not an app but a database modeling methodology that overcomes many of the shortcoming of DW warehouse modeling. Data vault attempts to solve the problem of dealing with change in the environment by separating the business keys from the descriptive attributes of those keys. This class will go over the basic parts of the Data Vault 2.0 model along with examples of each.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: April 07

Time: 2:30 PM - 3:45 PM

Room: 235

Database Experimentation Assistant (DEA) is Microsoft's new tool to help you collect, replay, and analyze a production workload against several configurations of SQL Server to compare performance. It even provides graphs of queries that performed worse after a change so that you can revisit those before making your change! Microsoft PFE, Jared Karney, will show you how to install, configure, and run this new tool and demonstrate how easy it can make your future upgrades and configuration changes.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: April 07

Time: 2:30 PM - 3:45 PM

Room: 326

Take your T-SQL skills to the next level.  Regardless of your current level there will be something here you'll be glad you didn't miss.  Basics like avoiding cursors in iterative tasks and multi-database executions are the tip of the iceberg.  If queries are basic arithmetic then this is basic algebra.  First we see how coding style affects maintainability then dive into several types of encapsulation, parameterization and tricks with values, cross apply, pivot and more .
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: April 07

Time: 4:00 PM - 5:15 PM

Room: 225

Most of the time pilots are learning to fly, they're actually learning how to recover from emergency conditions. While we as Database Administrators focus on taking backups, how much time do we actually spend practicing recovering with those backups? This session will focus on the kinds of situations that can dramatically affect a data center, and how to use checklists to practice recovery processes to assure business continuity.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: April 07

Time: 1:00 PM - 2:15 PM

Room: 332

Ever considered giving a presentation of your own? Pondered how your favorite speakers got their start? Contemplated whether you could ever do that too, but were not sure where to begin?

Well I say you can and will show you how to get started! In this session, I will teach you how to develop your idea and create session content, and share tips & tricks that I have learned along the way. 

You will leave armed with a wealth of resources (and hopefully some inspiration) to venture forth and develop your first presentation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 07

Time: 4:00 PM - 5:15 PM

Room: 226

Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them.  This session will cover the basics of Extended events as well as an introduction to the system_health session.  This session will give someone who has never used Extended events before the skills to start using them!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 07

Time: 1:00 PM - 2:15 PM

Room: 225

You've read all the Books Online articles about Columnstore indexes for data warehouses, but everything sounds too good to be true. Can you really get the promised 10X query performance without changing any code? In this demo-packed session, you'll learn real world lessons from deploying Columnstore indexes in production, and how you can avoid many query performance issues by following four simple rules. This is an advanced session recommended for attendees who already know the basics of Columnstore technology.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: April 07

Time: 2:30 PM - 3:45 PM

Room: 225

Join me in the quest to become a PowerShell DBA! Learn how to improve your career by quickly accessing logistical information within a database rich environment. Discover how PowerShell tools can enable you to gather and store information in a functioning repository, placing views and functions from a day, a week, or even a year ago, right at your fingertips!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 07

Time: 1:00 PM - 2:15 PM

Room: 325

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