Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 28
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:

Session Type:
Regular Session (60 minutes)

Track:
Data Platform Administration, Performance Tuning & Optimisation

Level: Intermedia

Session Code:

Date: February 22

Time: 11:15 AM - 12:15 PM

Room: WK239

Evaluate Session

DBAs and sysadmins never have time for the fun stuff. We are always restoring a DB for a dev or setting up a new instance for that new BI project. What if I told you that you can make all that time consuming busy-work disappear?
In this session we will learn to embrace the power of automation to allow us to sit back and relax..... or rather focus on the real work of designing better, faster systems instead of fighting for short time slots when we can do actual work.
Along the way we will see that we can benefit from the wide world of automation expertise already available to us and avoid re-inventing the wheel, again!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Platform Administration, Performance Tuning & Optimisation

Level: Intermedia

Session Code:

Date: February 22

Time: 10:00 AM - 11:00 AM

Room: WK239

Evaluate Session

Azure Cognitive Services are APIs, SDKs, and services available to help developers build intelligent applications without having direct AI or data science skills or knowledge. Azure Cognitive Services enable developers to easily add cognitive features into their applications. The goal of Azure Cognitive Services is to help developers create applications that can see, hear, speak, understand, and even begin to reason.

However, there might be cases in which our customers need a non-cloud AI solution (because of limited Internet access or data compliance).Container support in Azure Cognitive Services allows developers to use the same rich APIs that are available in Azure, and enables flexibility in where to deploy and host the services that come with Docker containers. Using containers, we can still deliver ML-driven solutions while keeping the data in-house.

In this talk, we’ll explore what it takes to configure and use containers support in Azure Cognitive Services. Demos will be
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
AI, Data Science, Machine Learning & IoT

Level: Beginner

Session Code:

Date: February 22

Time: 11:15 AM - 12:15 PM

Room: WK254

Evaluate Session

Have you heard about Azure Data Studio? In this fast-paced arena of Data Professionals, this new, light weight, cross platform tool from Microsoft is released on a monthly cycle, providing ever increasing new features to assist you with managing and maintaining your Data Platform fleet.

In this demo heavy, introductory session we will introduce you to ADS, discuss its origins, and explain why this tool is not just for SQL Server. We will even show you some useful tips and tricks to make your life easier as a data professional!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Platform Administration, Performance Tuning & Optimisation

Level: Beginner

Session Code:

Date: February 22

Time: 10:00 AM - 11:00 AM

Room: Room 1

Evaluate Session

Meet the two newest pricing tier for Azure SQL Database from the opposite end of the spectrum. One has the best price for performance advantage and one is a completely re-architected SQL Database designed for creating Very Large Data Applications with limitless growth. In this session we'll discuss and demonstrate what is special with these new tiers and how you can take advantage of it for your Modern Data Application.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Platform Administration, Performance Tuning & Optimisation

Level: Beginner

Session Code:

Date: February 22

Time: 1:00 PM - 2:00 PM

Room: WK239

Evaluate Session

This session focuses on the new features to unblock/accelerate cloud migration of legacy SSIS, such as 2008 or earlier versions, with Azure Data Factory (ADF). We will first show you how to provision Azure-SSIS Integration Runtime (IR) – dedicated ADF servers for running SSIS – and extend it with custom/Open Source/3rd party components. We will next show you how to enable the following scenarios: running SSIS packages stored in Azure Files as first-class activities in ADF pipelines, accessing Azure SQL DB/Managed Instance with OLEDB connectors that are configured for Azure Active Directory authentication with ADF managed identity, testing SSIS packages in ADF from SSDT, scheduling SSIS jobs in ADF from SQL Server Agent/3rd party orchestrators that invoke Azure-enabled dtexec.exe, etc. We will finally show you the complete SSIS Migration Playbook to perform batch package assessments and batch package/job migrations using Data Migration Assistant/Service, dtutil.exe, scripts, etc.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence, Analytics & Visualization

Level: Advanced

Session Code:

Date: February 22

Time: 1:00 PM - 2:00 PM

Room: WK254

Evaluate Session

An applicant tracking system (ATS) is a software application that enables to handle candidate profiles and could scan and analyse the Resumes (CV's).

This session will answer some of the unspoken questions:
    - Can you trust ATS with your CV ?
    - Can ATS analyse your Resume correctly (with Real examples) ?
    - How ATS works?

Come along to this session and find out more about REAL DATA analysis and scanning mechanism by multiple ATS used in the NZ job market and to find out if you can trust AI with your own CV.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
AI, Data Science, Machine Learning & IoT

Level: Beginner

Session Code:

Date: February 22

Time: 3:30 PM - 4:30 PM

Room: WK240

Evaluate Session

With the introduction of Composite models and Aggregations, Power BI has unleash lots of capabilities including analyzing large data volumes. With these two features,  users who were struggling due to the limitations in power bi model size now can visualize all their organisational data without any performance impact. In this session, I will provide an introduction to Power BI composite models and aggregations,  how to use and when to use these features using comprehensive demos .
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence, Analytics & Visualization

Level: Beginner

Session Code:

Date: February 22

Time: 2:15 PM - 3:15 PM

Room: WK251

Evaluate Session

New advances in technology coupled with the rate of change in the data-driven world are placing the issue of Privacy and Ethics at the forefront of public consciousness – forcing a discussion around the ethical use of data within business and the role that each data professional must play in ensuring that the highest standards are reached, maintained, and constantly evaluated. Technologies such as machine learning, artificial Intelligence, and big data processing are providing new business opportunities that must also account for privacy and ethics issues while maintaining a balance with compliance, security, and integrity of data. 
But what are the issues that individual data professionals should be aware of to avoid reputational damage to their companies and themselves? And what are the tools that can help them in their endeavors? 

This session will take a close look at some of these challenges and the tools that are available to help mitigate these issues and risks.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy, Architecture, Application & Database Development

Level: Beginner

Session Code:

Date: February 22

Time: 10:00 AM - 11:00 AM

Room: WK251

Evaluate Session

Azure Cosmos DB is an awesome multi-model database service that allows us to distribute our data on a global scale. It's fairly easy to get started with Cosmos DB, but when it comes to implementing it for use within our Enterprise applications, there are many things that you will want to consider when developing a Cosmos DB database.

In this session, I'll cover important topics that you'll want to consider when developing and administrating Cosmos DB for Enterprise use, including security considerations, partitioning, provisioning throughput for your databases and collections, distributing your data and much more.

By the end of this session, you should be able to take these learnings and apply them when developing Cosmos DB applications for your business.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy, Architecture, Application & Database Development

Level: Intermedia

Session Code:

Date: February 22

Time: 3:30 PM - 4:30 PM

Room: WK254

Evaluate Session

Empower your Business Apps using Cognitive Services

Make your Business Apps more intelligent by using the APIs provided by Microsoft Cognitive Services.

In this session I will go through the following:

What are Microsoft Cognitive Services ?
How to use Cognitive Services APIs ?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
AI, Data Science, Machine Learning & IoT

Level: Beginner

Session Code:

Date: February 22

Time: 11:15 AM - 12:15 PM

Room: WK240

Evaluate Session

Azure Data Factory (ADF) is a hybrid data integration service that provides you with an intuitive visual drag-and-drop environment (data flow) for code-free ETL. 
In this session, we will talk about design patterns for building scalable data pipelines for Big Data workloads! We will not cover ADF basics in this talk so having background knowledge about ADF would be recommended.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy, Architecture, Application & Database Development

Level: Advanced

Session Code:

Date: February 22

Time: 2:15 PM - 3:15 PM

Room: WK254

Evaluate Session

Azure Synapse was just announced at Microsoft Ignite and PASS Summit in November 2019. It aims to join the two large requirements of the evolving data world - relational data and big data. To fully unleash the power behind your data, you need to be able to leverage both these types of data and apply machine learning and business intelligence on top of it. Azure Synapse combines ingestion, preparation and analytical capabilities with Azure Machine Learning and PowerBI.

Join me in a session to walk through what an end to end solution might look like for you in this brand new product. We will go through how Synapse enables you to prep the data, train models and generate reports without having to leave the workspace. You will leave with a better understanding of the product, it's capabilities and guiding principles on using it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence, Analytics & Visualization

Level: Beginner

Session Code:

Date: February 22

Time: 11:15 AM - 12:15 PM

Room: WK250

Evaluate Session

Even as many of the traditional DBA activities become automated or managed by Cloud providers, the ability to tune and optimize database query performance remains a desirable and marketable skill.

Central to ability to tune queries is an ability to use information provided from Execution plans, DMVs, Query Store and Extended Events.

In this demo based session we will look into:
- What information is available 
- How it can be used.
- Techniques to improve performance. 

Attendees will leave with an understanding of possibilities of turning queries and a roadmap for further learning.

This session will assume a basic knowledge of T-SQL and execution plans.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Platform Administration, Performance Tuning & Optimisation

Level: Intermedia

Session Code:

Date: February 22

Time: 3:30 PM - 4:30 PM

Room: WK251

Evaluate Session

When Microsoft released SQL Server 2017, it allowed us to run SQL Server in docker containers. This radical change provides a wider and open platform that data professionals can choose how to deploy and run SQL Server. 

This session will demonstrate how containers are a game changer for deploying and managing SQL Server. It  will also showcase how the Azure Kubernetes Service (AKS) is a scalable and highly available platform for SQL Server running in containers. 

Demonstrations will show how easy it is to create containers, deploy SQL Server in them, and how to automate and manage your SQL Server containers using Kubernetes on the Azure platform.

This session will show you the exciting future of SQL Server and you will walk away with knowledge of practical scenarios where SQL Server running in containers on Kubernetes may be the right deployment model for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DevOps, PowerShell, Containers, Infrastructure, Security & Deplo

Level: Beginner

Session Code:

Date: February 22

Time: 1:00 PM - 2:00 PM

Room: WK251

Evaluate Session

This session is for the DBA's and developers who know how to code and want to get into the 
PowerBI world. Detailed explanation for what goes where, how to connect, what is important to consider and which options are there to choose from when creating your PowerBI solutions. We will focus on the desktop and server abilities within the Pro license. DAX and SQL examples will be discussed and the connection to AZUE SQL DW.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Platform Administration, Performance Tuning & Optimisation

Level: Intermedia

Session Code:

Date: February 22

Time: 10:00 AM - 11:00 AM

Room: WK250

Evaluate Session

I’m sure we all have heard that using indexes is one way to tackle and solve those troublesome resource-heavy queries. In this talk we will be going through how indexes improve and sometimes hinder query performance. We will also look at a few different types of indexes and some use cases where they play best in query optimization. Will also be covering how indexes are structured, read by SQL Server and index fragmentation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Platform Administration, Performance Tuning & Optimisation

Level: Beginner

Session Code:

Date: February 22

Time: 11:15 AM - 12:15 PM

Room: WK251

Evaluate Session

In the realm of data storage and processing, there are two major technologies which we deal with every day. On one side, we have relational data that is stored inside SQL Server, and on the other side, non-relational or very large datasets that do not fit the relational model which are stored on big data clusters like Hadoop or Spark. 
This introduces challenges when having to combine datasets across both these technologies. SQL Server was never built to process huge datasets in a distributed fashion or to handle non-relational data very well, meaning that in many cases you would have to resort to bringing your relational data into Hadoop or Spark clusters. 
SQL Server 2019 has the answer with Big Data Clusters: it combines SQL Server with HDFS, further scale out capabilities and Spark! 

In this session, you'll get an overview of the architecture as well as the capabilities of this amazing new featureset!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy, Architecture, Application & Database Development

Level: Intermedia

Session Code:

Date: February 22

Time: 10:00 AM - 11:00 AM

Room: WK254

Evaluate Session

As an Excel user, you've probably been building Pivot Tables for years… but do you know the difference between a Fact and a Dimension? The reality is that PivotTables have done a great job of protecting us from needing to understand proper data modeling, but in modern Excel and Power BI that has changed.
In this session we will look at understanding the benefits of dimensional modeling. We will define and review key terms and best practices, and show you how to use Power Query to reshape, split and combine tables into their proper tabular formats for a model.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence, Analytics & Visualization

Level: Intermedia

Session Code:

Date: February 22

Time: 1:00 PM - 2:00 PM

Room: WK250

Evaluate Session

Block chain is very fast growing technology.It is going to transform industry , lot of R&D and initiatives going on in this area. In this session, We are going  to cover patterns and server-less tools for sending data to the ledger network with Azure Blockchain and understand data flow in Blockchain Consortium Network.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy, Architecture, Application & Database Development

Level: Intermedia

Session Code:

Date: February 22

Time: 2:15 PM - 3:15 PM

Room: Room 4

Evaluate Session

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