Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 25
The Azure SQL Datawarehouse is intended for large-scale data processing in the cloud, but it’s not just a really big managed SQL Server instance. 

In this session, I’ll take you through the architecture of Azure SQL Datawarehouse, how it differs from a regular SQL Server and what those differences mean for database design, query design and usage patterns.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 08

Time: 10:00 AM - 11:00 AM

Room: Congo

This is an introduction to machine learning in Azure, and how to use Azure ML Studio - the IDE for machine learning in the cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: September 08

Time: 10:00 AM - 11:00 AM

Room: Orange

With the rapid advance in analytic features and the increased capabilities to produce more informative reports, SQL Server 2017 opens a plethora of new and exciting opportunities.
In the hands-on presentation we shall be constructing a few simple analytic reports (from background financial data). More importantly we shall see how our conclusions help us target new prospective business opportunities.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: September 08

Time: 3:00 PM - 4:00 PM

Room: Zambezi

A significant issue for enterprises moving to private or public clouds is how to trust the infrastructure and providers with their sensitive workloads. Customers need the ability to assess security standards, trust security implementations, and prove infrastructure compliance to auditors.
This session will highlight the issues with cloud architectures and discuss ways to achieve visibility, compliance, and security. We will examine solution stacks that enable trusted computing and illustrate several usages that demonstrate policy enforcement, compliance, and end-to-end trust in the cloud. 
The session will also examine how organizations can monitor and enforce geolocation restrictions, ensuring that their workloads in the cloud are deployed on trusted hardware in known locations to meet security policy compliance. Trusted geolocation allows organizations to establish security and physical boundaries that limit which systems process and store sensitive information and applications in th
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: September 08

Time: 3:00 PM - 4:00 PM

Room: Berg

Xamarin enables C# devs to become native iOS, Android, and Windows mobile app dev overnight. Learn how to leverage your existing .NET and C# skills to create iOS and Android mobile apps in Visual Studio. In addition to allowing you to write your iOS and Android apps in C#, Xamarin lets you reuse existing .NET libraries and share your business logic across iOS, Android, and Windows apps. 

During this session we cover the Xamarin platform and how to create native iOS, Android, and Windows apps in C#. See what's new and next for Xamarin development inside of Visual Studio.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 08

Time: 3:00 PM - 4:00 PM

Room: Congo

Have you ever been in the situation that an application performed well the last day and - suddenly - you run into problems? Although you have Index Maintenance jobs and statistics up to date you will monitor a big degrade of performance! This session will demonstrate in a over 80 percent demo based presentation the following scenarios which happend this way in real life!
- Why performance degradation in spite of maintenance jobs?
- just one more database in the result set and the query runs really bad - why?
- usage of literals is completely different from the usage of variables - why?
- identical data types but the query runs in part perfect and in part bad...
- your execution plan shows an INDEX SEEK - but the table will be scanned!
- you get a query from the business which performs really bad but when you test it it runs pretty cool - why?
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 08

Time: 9:00 AM - 10:00 AM

Room: Berg

Deadlocks are a swear word in DB world. They always tend to happen at the worst possible time, are extremely difficult to recreate and the deadlock graph looks like some sort of abstract art.

So when your DBA tells you that you need to fix a deadlock: what is it and how should you go about resolving it?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 08

Time: 1:00 PM - 2:00 PM

Room: Orange

In 2009 John Allspaw and Paul Hammond delivered the session "10 deploys per day - Dev & ops cooperation at Flickr." In forty six minutes they changed the way millions of people would think about the software delivery process for years to come. It didn't have a name yet, but DevOps was born. DevOps folk preached about the cloud, automation, rapid delivery and any database technology that wasn't relational.
 
In 2013 Kenny Gorman declared "The DBA is Dead".
 
For the record, I don't believe that, but a lot of people do. What is certain is that the world of IT is changing and traditional roles are changing with it. We all need to adapt.
 
In this interactive talk I'll explain what DevOps is, where it came from, and its implications for SQL Server. I'll demo example solutions to some of the foundational technical challenges (source control and test/deployment automation) and will leave plenty of time at the end to answer your questions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 08

Time: 10:00 AM - 11:00 AM

Room: Tugela

It’s an age-old problem: developers want prod data for dev and test purposes.

It helps them to write better code and to test it effectively. Self-service access to usable test-data aligns well with DevOps principles that encourage teams to adopt a shift-left mentality to testing.

Unfortunately, in the age of data breaches and tighter regulation it's unwise to give developers access to some types of sensitive production data.

So what do you do?

In this session I’ll talk about the GDPR, anonymisation, pseudonymisation and 5 techniques you can use to provide appropriate data that is as “production-like” as possible (within the legal and technical constraints). I’ll demo these techniques both in raw T-SQL and using some of the Microsoft and third party tools that are available to make the task easier.

After this session you’ll be equipped to discuss the problem with your colleagues in an informed manner and you’ll be able to suggest several solutions and their relative pros and cons.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 08

Time: 2:00 PM - 3:00 PM

Room: Tugela

This session will focusing on providing a  SQL/BI developer with the basics to rapidly getting started working with data generated from Internet of Things(IoT) devices using  Windows 10 IoT core running on a Raspberry Pi as an IoT source collect data and send data to Azure IoT hub. Some of the aspects that will be looked at is getting the development environment setup, getting Windows 10 IoT core running on a Raspberry Pi , connecting IoT device to Azure and the challenges faced, then we will move on to getting an app running that sends data to IoT hub and visualizing this data in Power BI
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 08

Time: 9:00 AM - 10:30 AM

Room: Congo

The Intelligent Edge: Make hybrid cloud and Internet of Things (IoT) solutions a reality with Azure IoT Edge, a fully managed service that delivers cloud intelligence locally. Seamlessly deploy and run artificial intelligence, Azure services, and custom logic directly on cross-platform IoT devices—from a small Raspberry Pi to large industrial machines. And manage it all centrally in the cloud with the security of Microsoft.

Use the same programming models you use in the cloud to create and test your IoT applications and then push them to your edge devices.  This session is an introduction to Azure Iot Edge and what it can do for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: September 08

Time: 1:00 PM - 2:00 PM

Room: Congo

PowerBI is a powerful business analytics platform created to support both self-service and enterprise-class reporting.

In this session, you will see how easily great looking reports can be created using multiple data sources and easily shared within your organisation. We will also discuss licensing options available ranging from free through to Premium licencing.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: September 08

Time: 9:00 AM - 10:00 AM

Room: Zambezi

One of the new features in SQL Server 2017 was Graph tables. These represent a different way of storing data to what we’re use to in the relational model.

In this session, I’ll take you through the design process for graph tables, and then implement and query some graphs in both SQL Server 2017 and Cosmos DB using its graph model.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 08

Time: 2:00 PM - 3:00 PM

Room: Congo

You have heard about machine learning, but are not sure what it is actual all about. How does it fit into the bigger picture of AI? What are labels, features, and examples? What is a model and how can it be used to make predictions? What is the difference between regression and classification?

Join this session for a look at the practical benefits and philosophy of machine learning. We will go through the concepts that you need to understand and apply machine learning to produce useful predictions on never-before-seen data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: September 08

Time: 9:00 AM - 10:00 AM

Room: Orange

SQL Server is a high frequently used piece of software which need to serve single requests and/or hundreds of thousands of requests in a minute. Within these different kinds of workloads Microsoft SQL Server has to handle the concurrency of tasks in a fashion manner. This demo driven session shows different scenarios where Microsoft SQL Server has to wait and manage hundreds of tasks. See, analyze and solve different wait stats due to their performance impact:
- CXPACKET: when a query goes parallel
- ASYNC_IO_COMPLETION: speed up IO operations (Growth / Backup / Restore)
- ASYNC_NETWORK_IO: What happens if your application refuses data?
- THREADPOOL starvation: crush of requests for Microsoft SQL Server
- PAGELATCH_xx: How does Microsoft SQL Server protects data?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 08

Time: 3:00 PM - 4:00 PM

Room: Tugela

In this talk we'll discuss how to do Machine Learning with R inside Power BI with a brief explanation on different algorithms.

We'll cover:
* How to do machine learning inside power query using R
* How to write R scripts to create functions inside Power Query for data transformation
* A brief description of some algorithms with some R sample code
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: September 08

Time: 2:00 PM - 3:00 PM

Room: Orange

Master Data Services can look complicated. In this session I will take you through how to install MDS to having a complete solution that will work for you. This session will include installing MDS, setting up a model with entities and attributes, integrating with Excel and setting up security.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 08

Time: 9:00 AM - 10:00 AM

Room: Tugela

Data preparation is often the most labour-intensive component of an analytics project and getting this right is vital if the results are to be accurate. While the growth of self-service BI has empowered users to answer important questions, ensuring well managed data is available to all employees remains one of businesses biggest challenges. 
Dataflows is an extension of the Power BI ecosystem, providing a low code approach using Power Query to create curated datasets that can be easily consumed by business analysts, thereby improving the speed at which business value can be delivered. Dataflows provides a single-version-of-the-truth which was traditionally attained by building a data warehouse. 
You will learn
-How Dataflows can be used to create rich, vetted datasets
-How Dataflows can be created with the click of a button, ingesting data from many well knows SAAS solution such as Dynamics and Salesforce
-How to manage Dataflows using advanced data preparation tools such as Databricks
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: September 08

Time: 1:00 PM - 2:00 PM

Room: Zambezi

The August release of Power BI Desktop features a preview of Python integration. Python script is now available in the Query Editor, and a new Py visual supports Python script. Come and learn how to get started with Python in Power BI. Lots of demos in this session that cover some basic, yet useful patterns.  

Between demos we will chat a bit about the importance of Python integration and why it is a significant step for Power BI. Python is widely used and runs across platforms and applications. Any investment you have made in learning Python (or are planning to make), means that you are on the road to build skills considered to be the universal data science and utility language ... often referred to as the Swiss army knife of programming. 

When you wrap your Python script in the best business analytics tool on the market (no prizes for guessing its Power BI ... and yes I am biased), you are well on your way to become a "Power Py" guru!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: September 08

Time: 3:00 PM - 4:00 PM

Room: Orange

Reporting requests that are required ‘yesterday or sooner’, oft times necessitate working more efficiently and effectively. We have all been through this at one time or another.
In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models. 
We shall be utilizing concepts of  ‘Openquery()’ and ‘linked servers’ as a means to extract data,  in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions;  AND YET maintain the  flexibility and the ability to utilize all those wonderful techniques that may  be done with T-SQL.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: September 08

Time: 10:00 AM - 11:00 AM

Room: Berg

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