Build Schedule

Advanced Filters:
  • Track

    clear all




  • Speaker


  • Level


  • Session Type

Sessions Found: 20
Machine Learning is a complex area, but what if as easy as just calling an API? Let's take a deeper dive into how we can incorporate Azure Cognitive Services to allow your applications to see, hear, and understand.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application, DBA and Database Development

Level: Beginner

Session Code:

Date: September 07

Time: 11:00 AM - 12:00 PM

Room: PASS

Azure Data Studio is no longer the new kid on the block. How many of you have used Azure Data Studio? 
              In this session we will take you on a journey introducing you to Azure Data Studio so that you can understand the ins and outs and when you should consider using Azure Data Studio in place of SQL Server Management Studio. In this idemo heavy session we will look at how productive you can be with Azure Data studio and some of the features that are not available in SQL Server Management Studio.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application, DBA and Database Development

Level: Beginner

Session Code:

Date: September 07

Time: 12:50 PM - 1:50 PM

Room: Insight

In this session, we will cover how to best to architect SQL server environment to run on Azure. We will showcase and go through a number of different proven practices around the network, storage and other best practices running large-scale SQL deployments on Azure.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application, DBA and Database Development

Level: Intermedia

Session Code:

Date: September 07

Time: 11:00 AM - 12:00 PM

Room: Curtin

- Do you ever have trouble finding the latest version of a report?
- Do you want to see the changes to a database/cube/report over time?
- Do you need to identify where a field is used across your BI Environment?
- Do you have issues with parallel development?
- Do you work in a Business Intelligence environment with no source control?

If you answered yes to any of these questions then this session is for you! We will go through
1. Why source control is important.
2. The different Visual Studio project types (Databases, Analysis Services, Integration Services, and Reporting Services)
3. How to bring an existing business intelligence environment into Source Control
4. How to facilitate parallel development

Let's bring order to your chaos!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application, DBA and Database Development

Level: Beginner

Session Code:

Date: September 07

Time: 9:25 AM - 10:25 AM

Room: PASS

When implementing Power BI in any enterprise, there are many options that the project team faces, and the choices are not always obvious. The different approaches are often dictated by organisational constraints, which are often different for many organisations. In this presentation, Craig will take you on a journey of discovery about the different best practices and options you have when implementing Power BI in your enterprise. Among others, we will discuss topics such as:
•	The different data storage and connectivity modes.
•	Power BI Pro vs Power BI Premium.
•	Efficient use of workspaces and apps.
•	Security Considerations.
•	Content Governance.
•	How all of the above (and other) topics impact your implementation.
Craig will bring his extensive real-world experience to this presentation, in which the audience is encouraged to participate in the discussion.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 07

Time: 11:00 AM - 12:00 PM

Room: Velrada

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:
Application, DBA and Database Development

Level: Intermedia

Session Code:

Date: September 07

Time: 12:50 PM - 1:50 PM

Room: Curtin

Microsoft recently launched Data Flows in Azure Data Factory (ADF) to move the service beyond the pure orchestration space into the world of extract, transform and load (ETL). At roughly the same time, Microsoft also introduced dataflows into the Power BI service world, allowing users to leverage common query models across an enterprise. So, what do we do with these new offerings? What are they, really? Is Microsoft just trying to confuse us? This session untangles and explores ADF Data Flows and Power BI dataflows to help you to get a better understanding of how you may be able to apply them in your world.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Big Data

Level: Intermedia

Session Code:

Date: September 07

Time: 3:35 PM - 4:35 PM

Room: Curtin

Governance is essential for every organization and this session will cover the implementation of governance in Azure for an existing and a greenfield Azure deployment using Azure Scaffolding, Management Groups, Policy, and Blueprints.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy, Governance and Professional Development

Level: Beginner

Session Code:

Date: September 07

Time: 1:55 PM - 2:55 PM

Room: PASS

The CEO just tasked you with moving all the SQL Server instances to Azure, or maybe you are deploying a brand new application and want to leverage Azure IaaS to host SQL Server. Beyond security and performance, your most pressing concern might be ensuring SQL Server running in Azure is highly available.
 
While on-prem high availability and disaster recovery options for SQL Server are well defined, moving those instances to Azure immediately presents some questions and challenges. Can I simply lift and shift my SQL Server Failover Cluster Instance to the cloud? Do I need to upgrade to SQL Server Enterprise Edition and us Always On Availability Groups? What about shared storage and failover clustering? What about disaster recovery, what are my options there? Load Balancers, Fault Domains, Availability Zones, Azure Site Recovery and Region Pairs, what are these things and why do they matter to me? 

HA and DR professional Jason Aw with 20 years of experience explains all this and more in
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application, DBA and Database Development

Level: Beginner

Session Code:

Date: September 07

Time: 12:50 PM - 1:50 PM

Room: PASS

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:
Application, DBA and Database Development

Level: Intermedia

Session Code:

Date: September 07

Time: 9:25 AM - 10:25 AM

Room: Curtin

Introducing the new capability in SQL Server 2019 that is Big Data Clusters, this session will take you on a journey to understanding its Architecture, Purpose and Capabilities (all in 1 hour).

We will be asking pertinent questions such as

“Why is Big Data Clusters needed… ”
“What challenges will it solve... “
“How can this be integrated with my existing SQL Servers…”
“What are its components...”
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Big Data

Level: Beginner

Session Code:

Date: September 07

Time: 3:35 PM - 4:35 PM

Room: Insight

Azure Cosmos DB is Microsoft’s Globally Distributed, Multi-Model database service.  Transparently scaling across multiple Azure regions, Cosmos DB provides for many API’s including MongoDB, Cassandra, Gremlin and SQL. It offers multiple consistency models and guarantees uptime or 5 9’s.

In this session we’ll take a look at this technology and learn how it might be useful – either now or in the future.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application, DBA and Database Development

Level: Beginner

Session Code:

Date: September 07

Time: 11:00 AM - 12:00 PM

Room: Insight

DAX is easy until it's hard.   The same thing applies to Excel formulas.   The advantage of Excel is you can see exactly which cells are being referenced and you see the immediate answer of your calculation.
DAX formulas are written in isolation with the author having to "picture" the context of where that calculation will be used.
This session compares and contrasts calculations in Excel formulas and DAX formulas to give you a better comprehension on how to tackle DAX.
Tips, tricks and best practice ideas will set you up for more powerful Excel and Power BI reporting.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Big Data

Level: Intermedia

Session Code:

Date: September 07

Time: 9:25 AM - 10:25 AM

Room: Velrada

Interactive reporting has changed the way that organisations share and consume information. Users can slice and dice their data in so many ways without needing to ask developers to change the reports. However, most organisations do still need paginated (fixed format) reports as well. 

In this session, Craig will discuss the various options available for implementing paginated reports in the cloud and/or on-premises using Power BI. We will explore this in depth from all angles so that you can come away understanding these options and implications.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 07

Time: 1:55 PM - 2:55 PM

Room: Velrada

Since its inception, Power BI has gradually folded more and more AI-powered capabilities into the platform so that some very complex and incredibly useful functionality is now easily accessible to a wide range of data-savvy users.

Come and join Lee Moran, organiser of the Perth Modern Excel and Power BI User Group, as he walks you through the many ways you can tap into this great capability and understand how Microsoft’s goal of “democratising AI” can really take the insights surfaced in your Power BI report to the next level.

In this demo-heavy session, Lee will cover everything from the Analytics pane on line charts through to some of the newly released capabilities around a simple mechanism to interface with published, enterprise-scale Azure ML models.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Big Data

Level: Beginner

Session Code:

Date: September 07

Time: 12:50 PM - 1:50 PM

Room: Velrada

In this demo-rich session, learn how to use the unique strength of Microsoft Excel and Power BI to boost your business analytics and insights with Office 365. Learn how to easily collect existing organizational data with Excel and publish to Power BI, create visually rich reports to monitor your business, and securely share it with your colleagues all from within Microsoft Teams. Use the extensive Excel capabilities with Power BI to get valuable business insights and drill down to the last bit of your data.

To finish off we'll go from raw data to a voice generated Power BI mobile visual in under 10 minutes!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Big Data

Level: Beginner

Session Code:

Date: September 07

Time: 3:35 PM - 4:35 PM

Room: Velrada

The idea behind serverless compute is fantastic, less to manage, minimal code, and true elastic scaling. But what does serverless scale actually look like in the world of relational databases? Lets take a deep dive into the risks and rewards of serverless application development on Azure, a have a peek into the world of Azure SQL Serverless.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application, DBA and Database Development

Level: Intermedia

Session Code:

Date: September 07

Time: 3:35 PM - 4:35 PM

Room: PASS

If you've dipped your toe into the waters of Azure SQL DB, you'll know that there's no SQL Agent available. Fortunately there are many options available to get you over this hurdle. One of these is Azure Automation, a scheduling engine which runs PowerShell or Python scripts to perform your tasks. As a bonus, these Runbooks can also be triggered from Azure SQL DB alerts. This session will introduce Azure Automation, from a basic, manually executed Runbook to an alert-driven responsive utility that can save you considerable effort. We'll then take Alert responses a step further and use them to trigger an Azure Logic App workflow - a utility that provides a robust workspace with built-in scalability & retry logic along with a multitude of connectors which can expand the response to your alert. Imagine being able to capture an Alert, perform the remedial action, log the issue & response in your ticketing system and switch on your kettle so you can sit back and let Azure do it all for you.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application, DBA and Database Development

Level: Advanced

Session Code:

Date: September 07

Time: 9:25 AM - 10:25 AM

Room: Insight

There has been lots of focus recently on upgrades and migrations with the end-of-life of SQL Server 2008 and 2008R2.

With so many critical databases running on these older versions, how do you ensure that you achieve a successful and safe transition to your new platform? Fortunately there are some fantastic tools and defined processes that can lead you through each stage. 

There are tools to test different versions and infrastructures, processes to track query regressions and provide a way to remediate them.

This session will walk through the upgrade process from end-to-end and show what tools can help you at each step.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application, DBA and Database Development

Level: Intermedia

Session Code:

Date: September 07

Time: 1:55 PM - 2:55 PM

Room: Curtin

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
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application, DBA and Database Development

Level: Beginner

Session Code:

Date: September 07

Time: 1:55 PM - 2:55 PM

Room: Insight

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