Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type


Sessions Found: 20
Join this session if you want to see how Azure Data Factory, a web based SaaS service, could help you to create, orchestrate, and manage data-processing pipelines over a range of transformation services and diverse data sources. Data Sources could be relational and non relational, both on-premises and in the cloud, and custom code could be also used. Presentation will be complemented with demos in order to clarify the aspects of a potential adoption of this service.
Speaker:

Accompanying Materials:

Session Type:
Extended Session (90 minutes)

Track:
Azure Data Platform

Level: Beginner

Session Code:

Date: October 10

Time: 11:30 AM - 1:00 PM

Room: Azure Data Platform

Text mining is becoming more and more popular. Everybody would like to understand data from blogs, Web sites, and social media. Microsoft SQL Server in versions 2012 and 2014 enhances full-text search support that was substantially available in previous editions. Semantic Search, a new component in Full-Text Search, can help you understanding the meaning of documents. The Term Extraction and Term Lookup components from SQL Server Integration Services also help with text analysis. Free statistical package / language R is also useful for the text mining tasks. Azure ML is adding additional techniques to the big picture. However, the question arises: is all this enough? This presentation unveils the good and the bad side of text mining with the tools mentioned.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI & Analytics

Level: Intermedia

Session Code:

Date: October 10

Time: 1:30 PM - 2:30 PM

Room: BI & Analytics

If you want to accelerate the testing of your BI solutions, the best strategy is the automation of your tests with the help of a dedicated framework. During this session, we’ll take a look to the features of the open-source framework named “NBi” (nbi.codeplex.com). This framework is providing support for automated tests on the fields of databases, cubes, reports and ETLs, without the need of .Net skills. The demos will show us the best approaches to quickly and effectively assert the quality of BI developments. We'll go a step further, generating the tests by an interesting system of templates and test-cases sources. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI & Analytics

Level: Intermedia

Session Code:

Date: October 10

Time: 2:45 PM - 3:45 PM

Room: BI & Analytics

Azure Sql Datawarehouse is the first cloud enterprise solution for Multiple Parallel Process.
But how it works ? Why is it so fast ?
Data warehouses require fixed combinations of storage and compute, often underutilizing expensive resources. With SQL Data Warehouse, data and compute scale independently. You can dynamically deploy, grow, shrink, and even pause compute, taking advantage of best-in-class price/performance. Additionally, SQL Data Warehouse utilizes the power and familiarity of T-SQL to easily integrate query results across relational data in your data warehouse and non-relational data in Azure blob storage.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure Data Platform

Level: Beginner

Session Code:

Date: October 10

Time: 10:00 AM - 11:00 AM

Room: Azure Data Platform

Modern business is fast and needs to take decisions immediately. It cannot wait that a traditional BI task that snapshots data at some time. Social data, Internet of Things, Just in Time don't understand "snapshot" and needs working on streaming, live data. Microsoft offers a solution in Azure with Stream Analytics and SQL. In this session you'll see how this work.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure Data Platform

Level: Intermedia

Session Code:

Date: October 10

Time: 2:45 PM - 3:45 PM

Room: Azure Data Platform

In this session we'll see Azure ML from the inside out. After a gentle approach on Machine Learning, we'll see the Microsoft offering in this field and all the feature it offers, creating a simple yet 100% complete Machine Learning solution. We'll start from something simple and then we'll also move to some more complex topics like the integration with R and Python, IPython Notebook until the Web Service publishing and usage, so that we can integrate the created ML solution with batch process or even use it in real time with LOB application. I predict that all of this sound cool to you, yeah? Well it is, since with ML you can really give that "something more" to your customers or employees that will help you to make the difference. Guaranteed at 98.75%!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI & Analytics

Level: Intermedia

Session Code:

Date: October 10

Time: 11:30 AM - 12:30 PM

Room: BI & Analytics

Deep dive into the DMG and the hybrid architecture involved by Power BI.
How does it work ? Security, Firewall, Certificates,  Multiple gateways, Admin delegation, Scale out, Disaster Recovery.... All that topics will be covered during that technical session.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Advanced

Session Code:

Date: October 10

Time: 1:30 PM - 2:30 PM

Room: Power BI

What is NoSQL? What is DocumentDB? How this technology could change the way we manage data?
We’ll discover together how DocumentDB works, how we could use this new exciting product and which are its pros and cons compared to relational databases as SQL server.
This session covers how configure a new DocumentDB instance in Azure, how to save and query data and the basic guidelines about organizing complex data as JSON documents.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Azure Data Platform

Level: Beginner

Session Code:

Date: October 10

Time: 4:15 PM - 5:45 PM

Room: Azure Data Platform

This is an evergreen session, it follows Azure SQL Database evolution and each time is different: it looks at how to implement, maintain and evolve/update solutions developed on Azure SQL Database, through the use of the tools like SQL Sever Management Studio and Visual Studio. Through examples and case studies, will be presented the versatility, power and reliability of the database as a service in the cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure Data Platform

Level: Intermedia

Session Code:

Date: October 10

Time: 1:30 PM - 2:30 PM

Room: Azure Data Platform

In this session we will explore the new features introduced with SQL Server 2016 to enhance security. 
Always Encrypted is a new technology that protects your data not only at rest, but also throughout the whole interaction between the application and the database.
Dynamic Data Masking is another interesting feature that allows us to protect sensitive data by masking it to all users that don’t have enough privileges to see the actual contents.
Row Level Security allows showing to end users only the data they’re entitled to access, without changing the applications’ code.
We will demonstrate the use of these three features with example applications and we will explore the use cases where these technologies represent a big leap from previous custom implementations.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server 2016

Level: Intermedia

Session Code:

Date: October 10

Time: 10:00 AM - 11:00 AM

Room: SQL Server 2016

SQL Server 2016 ships with Polybase, which was previously a feature available only in Microsoft APS. Polybase represents a bridge between the relational world and Hadoop. It makes it possible to query and Hadoop system using T-SQL!
 The session shows how to install, configure and take advantage of Polybase for querying the Hortonworks Data Platform on premises and an HDInsight cluster on Azure.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server 2016

Level: Intermedia

Session Code:

Date: October 10

Time: 11:30 AM - 12:30 PM

Room: SQL Server 2016

Power BI is a cloud service that lets you share, collaborate and access your Excel reports anywhere on any device. In this session, you will learn how to create data models, display visualizations, and synchronize cloud data with on premises data sources. In order to use these new features, you will continue to leverage existing skillsets, such as Tabular, Power Pivot, DAX, and you will be able to connect to database and semantic models you already built, such as existing databases in Analysis Services Multidimensional and Tabular. The goal is to create dashboards leveraging data and models that you have both on cloud and on premises.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Beginner

Session Code:

Date: October 10

Time: 10:00 AM - 11:00 AM

Room: Power BI

Power BI Desktop is the new BI development tool for self-service BI. It includes Power Query, Power Pivot and Power View in a single desktop application, along with capabilities to import from existing Power Pivot models and directly publish models on the Power BI portal.
In this session we will provide a deep dive in the new tool, highlighting the most important feature and showing how to connect from Excel to Power BI Desktop to debug your calculation. Finally, we will show how to use DAX Studio to query the Power BI model and analyze measure performance.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Beginner

Session Code:

Date: October 10

Time: 11:30 AM - 12:30 PM

Room: Power BI

Power Query is a core technology of Microsoft Power BI and Excel 2016, and it is also available as a free add-in of Excel 2010 and 2013. You can use it to read
and transform data from different data sources, populating tables in data models or in Excel. In this session, you will see the architecture and the connectors available, spending most of the time in demos and playing with the “M” language, expanding the capabilities
of this tool beyond the capabilities of its user interface.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Intermedia

Session Code:

Date: October 10

Time: 2:45 PM - 3:45 PM

Room: Power BI

There are many new features in SQL Server 2016, but the one we will focus on in this session:
•	Temporal Database Tables
One of the many new features in SQL server 2016 is the built-in support for temporal data tables. This is a feature that many developers have been urging to have as a “out of the box feature” – and therefore many have developed their own ways of implementing the capability to store information about how data looked in a certain period of time.
What is a Temporal Data Table?
The concept of a temporal data table is that the table will hold information about a records value in any point in time – thus meaning that we easily can read from the table and get values that are not current, but merely a historical view of the record.
There will be many demo's and script will be shown and shared.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server 2016

Level: Intermedia

Session Code:

Date: October 10

Time: 2:45 PM - 3:45 PM

Room: SQL Server 2016

SQL Server 2016 introduces a lot of new features. One of the most asked programmability enhancement in the platform is the native JSON support. We will discuss about limitations and advantages of this new kind of serialization and we will consider also the status of latest releases of SQL Server 2016.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server 2016

Level: Beginner

Session Code:

Date: October 10

Time: 1:30 PM - 2:30 PM

Room: SQL Server 2016

Have you ever experienced to have your system slowed down or completely down? What happens? Have you ever upgraded an application to the latest version of SQL Server and facing an issue with plan change that slows your application down? Query Plan choice change can cause these issues. SQL Server 2016, through a new feature called Query Store, let's make these problems easier to fix. Query Store retains all the execution plans used for each query; it captures the performance metrics for each plan over the time and allows you to force an execution plan easily. In this session, you will learn how the Query Store works and how it can help you to fix performance problems.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server 2016

Level: Intermedia

Session Code:

Date: October 10

Time: 4:15 PM - 5:15 PM

Room: SQL Server 2016

Language R for Statistical computing is powerful language for data analysis with all great features for data import from SQL environment. Using R with SQL server data will help data scientists and data analysts prepare, explore and validate data much easier, as well as to use wide range of statistics; from uni-variate to multivariate.Session will focus mainly on:1) on connecting R Language with SQL server using standard ODBC connectors and T-SQL procedures. 2) how to validate data with using classical statistical methods on SQL transactional data. 3) how to use R output in SSRS and bring extra information to reports.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI & Analytics

Level: Intermedia

Session Code:

Date: October 10

Time: 10:00 AM - 11:00 AM

Room: BI & Analytics

Power BI groups enable teams to collaborate on one set of Dashboards, Reports, and Datasets.
Organizations can create and publish content packs to their employees, leveraging data across on-premises and cloud data sources.
Groups and organizational content packs complement each other to create a powerful collaborative experience built on Office 365 groups. In this session, you will see how to use them effectively, making sure that the access security is always in place correctly.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Intermedia

Session Code:

Date: October 10

Time: 4:15 PM - 5:15 PM

Room: Power BI

We're all familiar with reports or dashboards that show you a static snapshot of the data
that has to be refreshed on an interval. And those are very important visualizations.
But sometimes you just have to have a real time view of your data streams and snapshots aren't enough.
What if you could monitor multiple servers with SQL Trace or Extended Events or had some other source of streaming data and 
be able to see it all happening live on a central monitoring website?
This is a scenario we'll take a detailed look at and build a system for such monitoring.
We'll do this by using Extended Events .Net provider to get the live data stream, 
SignalR to get the live stream from the server to the website and the D3 javaScript library 
for actual real time visualizations on any device.
After seeing all this in action, you'll definitely get a few ideas on where you could use this in your company.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI & Analytics

Level: Intermedia

Session Code:

Date: October 10

Time: 4:15 PM - 5:15 PM

Room: BI & Analytics

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