Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 20
What you feared has come upon you: You’ve been happily building business intelligence solutions the traditional way for years; Finally, the big data curse has caught up with you. Your organization wants to exploit their big data along with their day-to-day transactional data. You are now tasked with storing all this in one place and working your analytics magic on it. You start wondering how and where you would store this data, what kind of hardware you would need and and how you would learn everything from storing to processing to analysis in a short time – after all big data is a different type of beast from transactional data.
Fear not, all you need to do is look to the heavens; with Azure Data Lake and Azure Data Lake Analytics, you could get started quite fast. After an introduction to Azure Data Lake, we will dive into how you could perform simple yet power analytics using methods that are familiar with Azure Data Lake Analytics.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: July 07

Time: 2:50 PM - 3:50 PM

Room: Angry Koala room

Azure SQL Data Warehouse is a cloud-based massively parallel database platform, based on the concepts that the Analytics Platform System/Parallel Data Warehouse uses for on-premises extreme performance. While it appears at first glance to be a familiar SQL Server environment, Azure SQL Data Warehouse has a few gotchas and design implications that can bite you (and your data warehouse's performance!) if you're not aware of them.  This session will teach you the basic concepts of Azure SQL Data Warehouse, and provide tips and guidance on how to get the most of it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: July 07

Time: 9:00 AM - 10:00 AM

Room: SQL room

The scope of the Data Platform is changing with the number of data sources available to businesses today growing and becoming more complex.  Data today comes in many shapes, sizes and rates and in many cases no longer can business wait till data is landed before analysing it for business decisions.  This session introduces the concept of the Lambda Architecture and the alignment to Microsoft Azure Cloud Services for managing high velocity streaming data.  The session will talk to each of the key Azure services that form part of a streaming data pipeline, how they work and demonstrate how a streaming solution can be easily and quickly deployed.  The session will walkthrough several examples of real streaming solutions and provide the relevant knowledge and information on how you can easily build your own streaming data architectures!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: July 07

Time: 10:10 AM - 11:10 AM

Room: SQL room

When the number of services is more than 600 in Azure, many questions arise surrounding the different services that can be included in a Business Intelligence Architecture. This session will cover traditional as well as modern Business Intelligence solutions taking advantage of technologies such as Azure HDInsight, Azure Data Lakes or Azure Event Hubs. 

I will go over the characteristics of the main services that can be implemented in a Business Intelligence solution in the cloud. The demo will include 5 of these services.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: July 07

Time: 9:00 AM - 10:00 AM

Room: ACS room

Nothing beats having a correctly structured data model - DAX calculations are a breeze. Having the wrong data model can result in slow performance, convoluted expressions or potentially even block you from achieving your desired output all together. This session includes demos of different modelling patterns and shows you how to implement them to solve real world business problems. These techniques apply to Power BI and Analysis Server Tabular
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: July 07

Time: 9:00 AM - 10:00 AM

Room: Angry Koala room

If you are a DBA and want to get started with Data Science, then this session is for you. This demo-packed session will introduce you to the field of Data Science. You will start with R in SQL Server. Then you step into the world of R using R Studio and realise the power of Data Science using Azure Machine Learning. 

You will learn the basics of R programming language, Machine Learning, real-world analytics and visualisations that businesses need today. In this session you will get a head start about each component and the possibilities that can be achieved with them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: July 07

Time: 1:30 PM - 2:30 PM

Room: Angry Koala room

Many people (business and IT) already use Power Pivot, Power BI and SSAS Tabular to produce reporting and analytics tools.  But did you know that these tools also have their own query language?   In traditional databases such as SQL server, it is possible to extract data into a new table.  The same is possible using DAX as a query language with a tabular data model.

In this session, Matt will introduce the topic and show how you can use DAX Studio to connect to a data model.  Once connected, DAX studio can be used to write queries over the tabular data model to start to interrogate the data itself (as opposed to simply aggregating the values into a pivot table or a Power BI report).  The learning can then be used to write more complex DAX measures or alternatively it can be used to extract tabular data directly into a table for further analysis.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: July 07

Time: 10:10 AM - 11:10 AM

Room: ACS room

In this session, I am going to discuss a few DAX best practices, illustrated by examples derived from real projects. Attendants are going to see why they should follow the prescribed DAX best practices. There are going to be PowerPoint slides and live screen demos.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: July 07

Time: 1:30 PM - 2:30 PM

Room: ACS room

Powershell has been part of Windows for > 10 years and has been part of SQL Server since 2008.
In spite of this the adoption among Database Professionals for use in investigating and managing their environments has been low.

With the release of the open source DBA Tools module from DBATools.IO, with its 300+ commands, the time has arrived for Database Professionals to embrace PowerShell and upgrade their skills to support the modern Hybrid environment.

In this session we will look how to download, install and begin using the power within both this module and Powershell.

No prior experience with Powershell required!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 07

Time: 1:30 PM - 2:30 PM

Room: Wardy room

Azure Machine Learning is integrated, end-to-end data science and advanced analytics solution. It enables data scientists to prepare data, develop experiments, and deploy models at cloud scale. In this session, the audience will learn how to install the Azure ML workbench and how to set it up. Moreover, an introduction on how to write Python code inside it and what packages can be used will be presented. Next the process of importing data from different resources will be explained. The audience will learn how to deploy and how to check the run log inside Azure ML workbench. Two main components of Azure ML workbench: Azure Machine Learning Experimentation and Management Services will be explained. This session contains demos for each practice and all steps will be shown.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: July 07

Time: 11:30 AM - 12:30 PM

Room: Angry Koala room

Power Query is the transformation engine in Power BI. This is the engine that you do all data preparation before loading data into the model. This is the keystone of your Power BI solution. In this session, you will learn what things Power Query can do. M is the language behind the scene of Power Query, you will learn how M can be more beneficial than the Power Query Graphical interface. You will see demos of transformations that you can do with M Code. This session is full of live demos. Prepare to be amazed with what Power Query can do with heaps of demos in this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: July 07

Time: 10:10 AM - 11:10 AM

Room: Angry Koala room

More and more Transact-SQL code is using temporary tables and table variables constructs. These constructs leverage the tempdb system database, which in turn becomes a severe performance bottleneck. This will be particularly "felt" when moving on-premise database solutions into the cloud. In this session we will cover the best practices in how you should be implementing these temporary constructs in your database solutions. We will discuss the differences between temporary tables and table variables, their impact on query performance and tempdb before looking a different implementations and best practices. We will examine a variety of techniques to improve temporary object performance, from hardware to the database engine configuration. Finally we will cover a number of key, proven techniques that can improve substantially performance. With lots of examples and case studies we will show how you can improve query performance by 20x or more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: July 07

Time: 2:50 PM - 3:50 PM

Room: SQL room

Power BI has become the new Excel for many business users and its ease of use has made it viral within businesses of all shapes and sizes. 
Many Business Users started using Power BI with minimum / no IT collaboration that started causing concerns especially within larger organisations regarding security, governance, change management, etc.  With the risk of facing another spreadsheet hell in a different form, organisations have become increasingly aware of the need to put a governance and control process in place. 

In this presentation Iman will use his extensive experience in implementing and rolling out Power BI for many organisations to share some tips from his adoption framework for mid to large size organisations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: July 07

Time: 2:50 PM - 3:50 PM

Room: ACS room

Have your users ever asked if it is possible to update a record in a report, and see the results almost immediately?

In this session I will demonstrate how to integrate write back using Power Apps, within a Power BI report.

The session will be almost entirely demo based, in which I will demonstrate how to integrate the Power App with the Power BI report. And then show by updating a record, that the data is almost instantly updated within the Power BI report.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: July 07

Time: 11:30 AM - 12:30 PM

Room: ACS room

SQLOpsStudio is the new kid in town for the data professional. Is it a replacement for good old SSMS? 
In this session we will take you on a journey of comparing SSMS and SQLOpsStudio so that you can understand the ins and outs of both these tools, making it easier to know what each brings to the table. In this demo heavy session we not only hear about the differences but we match them up against each other to better learn what each can do.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 07

Time: 10:10 AM - 11:10 AM

Room: Wardy room

Test Driven Development (TDD)  is a design approach which has enabled application developers to write cleaner code. It is relevant for database development as it ensures that code produced using TDD and unit tests will be of higher quality which means interactions with data will be safer. 

TDD is not a new method of unit testing, it is an essential design practice for improving the quality of your deployed code.

In this session it will be shown how we can use TDD to design and write better unit tests using open-source frameworks and industry standard tools. These tools can be run within SQL Server Management Studio which means DBAs can also take advantage of TDD and unit test, to ensure more reliable code is deployed to databases. 
TDD can result in code that can be deployed more reliably and faster when using DevOps processes such as Continuous Integration and Continuous Delivery. 

A comprehensive DEMO will reveal how Test Driven Development can help you deploy database code safer.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: July 07

Time: 9:00 AM - 10:00 AM

Room: Wardy room

Previously restricted to Enterprise Edition, partitioning was one of the features pushed down to all Editions in SQL 2016 SP1. With greater availability comes greater responsibility to make sure it is implemented appropriately.
This session will demonstrate some of the common pitfalls with implementing partitioning:
•	how excessive data movement can kill performance
•	how poor maintenance can negate the performance gains
We’ll then look at how to plan and implement partitioning appropriately and some of the corresponding benefits that can be realised from a well implemented and managed partition scheme:
•	how to automatically maintain a partition scheme
•	how to implement a sliding window for data loading and archiving
•	how to plan and implement partitioning to limit data movement
Finally, we will consider the additional options open to us with partitioned tables from both the maintenance perspective, and the coding and tuning perspective.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 07

Time: 11:30 AM - 12:30 PM

Room: Wardy room

Most SQL Server developers and DBAs work with SQL Server Management Studio (SSMS) all the time. But SSMS is a very capable tool and most users only know how to use a fraction of its features. 

Join Greg to see his favourite tips and tricks for working with SSMS.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: July 07

Time: 2:50 PM - 3:50 PM

Room: Wardy room

This session is dedicated to a thoroughly examination of Always On Availability Groups in action. Various demos show how to analyze functionality and performance in the different stages in the life of an Availability Group: Initialization, Synchronization, and even Failover. We will follow the streams of data from insert on the primary to redo on the secondary and thereby gain a deep understanding of the architecture of availability groups with its special queues. We will also see the potential of the performance overhead on the workload and lag of a synchronous replica.  Get ready for a pure demo-session using DMVs, Extended Events, Perfmon and Wait Stats methodology.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 07

Time: 1:30 PM - 2:30 PM

Room: SQL room

If you like an interactive and lively sessions them this is the place for you.
We’ll look at the background of this term – and see how it has transformed to bring focus to the data professional.
We’ll take a peak at what it means for the technology professional as well as what it means for the business professional - and we'll see Visual Studio Team Services (VSTS) and the cloud in action.
We’ll look at the different kinds of disciplines that lead to a well-rounded DevOps set up.
We’ll have a run through some of the motivations for developing a DevOps mindset and we’ll also hear about some of the arguments for non-adoption.
We’ll look at some of the other IT methodologies that we’ve seen emerge over the years and examine exactly what sets DevOps apart from these.
Regardless of if you’re never heard this term before or you have strong feeling about the subject – either way – you’ll leave the room with a new perspective and quite likely you’ll have contributed to your fellow delegates kn
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: July 07

Time: 11:30 AM - 12:30 PM

Room: SQL room

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