Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type


Sessions Found: 31
SQL Server implements the relational model of data. Up until now. 2017 introduced the graph model, with syntax extensions to support this alternative way of conceptualising data. This session will compare and contrast relational and graph models, with examples implemented in T-SQL.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: June 30

Time: 3:30 PM - 4:30 PM

Room: Room 5

Indexing doesn't have to be hard, but you need to have the right level of understanding to get the most out of it. Knowing what's going on with different types of indexes, and how your index choices affect various components of the SQL engine can cause you to look at indexing in a new way. This demo-heavy session will take you on a journey from the basics of indexing through to advanced concepts that become simple when viewed correctly, using practical examples to explain the theory.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 30

Time: 2:00 PM - 3:00 PM

Room: Microsoft Room

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: June 30

Time: 3:30 PM - 4:30 PM

Room: Room 6

- 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:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 30

Time: 10:10 AM - 11:10 AM

Room: Room 5

While you can do some pretty amazing things with DAX expressions, at the end of the day nothing beats having a correctly structured data model. Having the right data model can make everything else a breeze. Having the wrong data model can make result in slow performance, convoluted expressions or potentially even block you from achieving your desired output all together. In this session we will look at demos of a number of different modelling patterns and how to implement them to solve real world business problems.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 30

Time: 10:10 AM - 11:10 AM

Room: Microsoft Room

Azure Cosmos DB - the first and only globally distributed, multi-model database system. The service is designed to allow customers to elastically and horizontally scale both throughput and storage across any number of geographical regions, it offers guaranteed <10 ms latencies at the 99th percentile, 99.99% high availability and five well defined consistency models to developers. It’s been powering Microsoft’s internet-scale services for years.
In this session, we will present an overview of Azure Cosmos DB - from global distribution to scaling out throughput and storage - enabling you to build highly scalable mission critical applications
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: June 30

Time: 11:25 AM - 12:25 PM

Room: Room 4

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: June 30

Time: 11:25 AM - 12:25 PM

Room: Microsoft Room

If you are hesitating between choosing a Business Intelligence Solution in the cloud or on-premises, this session will provide you with the different options on-premises as well in Azure to take into account regarding your Business Intelligence architecture.

During the past few years we have been experiencing vast changes in the Business Intelligence space, not only related to data analytics, data modelling or applications, but also the importance of infrastructure.

In this presentation, I will explain how to get the best from both worlds.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 30

Time: 2:00 PM - 3:00 PM

Room: Room 5

Data security is one of the hot button topics of our time. When making the decision to move to cloud you are spoilt for choice when it comes to tools and technologies for storing, transforming and moving your data. Beyond the plethora of choices you have there is the fundamental question of how do you secure your data in the cloud. In this session we will look at the various tools and technologies you have available to ensure your data is secured at rest and in transit across a range of IaaS and PaaS Data technologies in Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: June 30

Time: 9:00 AM - 10:00 AM

Room: Wardy IT Room

While Power BI comes with a lot of useful visualisations out of the box, and third-party visuals and R gives you a lot more choice, sometimes you need full control over what is being displayed. This is not for the faint hearted, as you will require Typescript and JavaScript skills and an understanding of the D3 JavaScript libraries, but there is a lot of sample code to smooth the way. 

This session introduces you to writing your own fully interactive custom visualisations in NodeJS, how to troubleshoot and debug, culminating in deployment of the Visual to your Power BI environment, giving you the ability to display exactly what you want in your Power BI reports.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: June 30

Time: 11:25 AM - 12:25 PM

Room: Room 6

It’s almost a daily occurrence to hear about some sort of data breach. 
But what are the consequences of a data breach – for both the victims and companies involved – and what does that mean for you as a data professional.
As governments start to legislate more in an effort to protect the privacy of its citizens the entire concept of data storage become more complex.
Exactly what is legislation like the General Data Protection Regulation (GDPR) and how will it affect around the world.
We’re seen Microsoft give us tools over the years – like Transparent Data Encryption and Dynamic Data masking - to help with this sort of thing – but is there a better answer?
Come along to this session and hear how you and your team can lessen your chances of being the ones responsible for the next data breach.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: June 30

Time: 10:10 AM - 11:10 AM

Room: Room 6

If you are a DBA and want to get started with Data Science, then this session is for you. This demo-packed session will show you few components and technologies needed for a Data Science project in Microsoft Data + AI stack. You will learn the basics of R programming language, Machine Learning and visualisations that businesses need today. In this session you will get a head start about few component in Microsoft Data + AI stack and the possibilities that can be achieved with them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Beginner

Session Code:

Date: June 30

Time: 10:10 AM - 11:10 AM

Room: VMware 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: June 30

Time: 2:00 PM - 3:00 PM

Room: Wardy IT Room

Now that SQL Server loves PowerShell and Microsoft loves open source, it is even easier to automate even your most time-consuming, repetitive, mundane or burdensome tasks.

Using the DbaChecks PowerShell module released at the SQLBits 2018 conference we can:
    Track SQL Server instance configurations
    Promptly provide required information to managmement, change configuration or developers
    Deftly respond to audit change requirements across your entire estate (and impress your auditor with PowerShell;)
    Restore SQL Servers to their correct state prior and post deployment
    Test *everything* from configuration to permissions, SQL service account share access to sysadmins, Agent Jobs to SPNs
 
This session will look at how to install and use this module . With multiple examples we will look at both running the checks and viewing the data in the supplied PowerBI reports.

Pre-requisites
Some basic knowledge of PowerShell and DBA
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 30

Time: 11:25 AM - 12:25 PM

Room: VMware 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:
Data Science

Level: Intermedia

Session Code:

Date: June 30

Time: 9:00 AM - 10:00 AM

Room: Microsoft Room

Join me to learn about SQL Server Auditing and how you might do more than simply log activity on your SQL instances.
Lets take a look at how to set it up, how flexible it can be, and some of the interesting things you can do with the data collected.
From collecting and reviewing events, triggering alerts and examples of analysing and creating visualisations with Cloud Log Aggregation Service SumoLogic.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 30

Time: 9:00 AM - 10:00 AM

Room: Room 5

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:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: June 30

Time: 9:00 AM - 10:00 AM

Room: Room 6

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: June 30

Time: 3:30 PM - 4:30 PM

Room: VMware Room

Organisations capture huge volumes of data and they need actionable information to act on them proactively in real-time to stay competitive. This requires a different thinking from the conventional Data Warehouse Architecture to more Cloud based Data Processing Architecture where high volume batch and real-time processing can be achieved using optimal cost.

In this session you will learn about

1. Overview of Lambda Architecture
2. How Azure Services implement Lambda Architecture
3. Advantages of leveraging Azure for Lambda Architecture
4. Business Scenarios to consider Lambda Architecture
5. End to End Demo
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 30

Time: 3:30 PM - 4:30 PM

Room: Microsoft Room

SQL SERVER, R and Python - The Data Science Triple Treat by Helen Gross
RDS for SQL Server, is it a right choice? by Mohammad Hafizullah

Helen's session abstract is "SQL Server 2017, using Machine Learning Services we can now run both R and Python in the database. This session will demonstrate how this is done and focus on some interesting use cases and examples."

Mohammad's session abstract is "AWS is a great cloud platform, with a great adoption rate. RDS is Relational Database Service provided by AWS. It supports various DB technologies and SQL Server is one of them. RDS comes with some great functionality but also has some issues; so in this session I am going to discuss the factors which can help you to make a decision on whether RDS can be implemented for their next SQL Server instance."
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lightning Talk (15 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: June 30

Time: 3:30 PM - 3:45 PM

Room: Wardy IT Room

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