Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 26
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 01

Time: 3:20 PM - 4:20 PM

Room: Auditorium 3

In this session you will learn about the various migration paths and tools available to migrate your databases to Azure.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: September 01

Time: 10:00 AM - 11:00 AM

Room: Auditorium 3

In this session we will take a look at what all the fuss is about as well as 

Architecture of AMI(Azure managed Instance)
Cost of AMI vs on-prem
Different options to migrate to AMI
Benefits of AMI
Differences Between AMI and SQL Server on=prem
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: September 01

Time: 10:00 AM - 11:00 AM

Room: Conference Room 4

Discussion around Data Warehouse Schema Design and evolution.The flexibility of ROLAP and In-Memory data models to support all Schema design categorizations and optimizes the performance of the data model.

Different types Schema Design: In terms of tables accessed, Joins, data modification, data loading/Maintenance, data redundancy, design and size.

•         Normalized
•         Moderately de-normalized
•         Completely de-normalized
•         Star Schema
•         Data vault
•         NoSQL

And lastly discuss around the common schema design roadblocks that people face like Hierarchy, SCD etc…
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 01

Time: 3:20 PM - 4:20 PM

Room: Auditorium 2

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:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 01

Time: 1:00 PM - 2:00 PM

Room: Auditorium 2

Microsoft has released amazing Machine Learning, Advanced Analytics and AI capabilities. as a Power BI user, how can we use these capabilities in our analytics and dashboards. This will cover in the box capabilities as well as enhancing Power BI with other Microsoft ML capabilities.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: September 01

Time: 1:00 PM - 2:00 PM

Room: Room 6

Lets face it. Excel is still the largest used BI tool in the world. From traditional end user all the way up to organisational BI, data is still sucked into Excel and shared across the business. Now we know that at a data level, data is encrypted at REST and in transit but what happens once the data is surfaced in traditional applications like Excel? How do we ensure that the output (The excel file) is secured, protected and retained? Enter Azure Information Protection.

In this session we unpack:
·         What is Azure IP
·         How to find content that needs protection
·         How to use Azure IP to protect your content
·         How to build out you Information protection strategy

In the mobile first, work from anywhere world we live it, managing access control is only half the journey to ensuring that your content is protected from misuse and inadvertent dissemination.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: September 01

Time: 2:10 PM - 3:10 PM

Room: Conference Room 4

Implementing Power BI for the enterprise is not as easy as it may look. Most enterprises seem to follow a somewhat ad-hoc approach. 

In this session I will look at what is required to plan a successful Power BI Premium implementation for the Enterprise. 

The following topics may be included: 
- Versions Overview
- Decision Points
- Data Sources
- Data Storage Options
- Data Refresh
- Dataset development vs Report authoring
- Security, Compliance and Auditing
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: September 01

Time: 1:00 PM - 2:00 PM

Room: Auditorium 3

So you've built a flashy new Data Warehouse and deployed it to production. 

Great now what?

Nobody wants to be involved with a project that is constantly failing and difficult to support.
This session will take a look at some design considerations and tips to ensure that your mart runs with minimal intervention and is easy to support.

The tools discussed and used in the examples will be SSIS and SQL server but many of the points discussed are valid for all tools.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 01

Time: 2:10 PM - 3:10 PM

Room: Auditorium 3

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 01

Time: 11:10 AM - 12:10 PM

Room: Auditorium 2

Within the Microsoft reporting ecosystem, Power BI and Excel easily support the implementation of heatmaps yet the same cannot be said of SQL Server Reporting Services (SSRS). In this session, we take a look at the Top 3 options for implementing heatmaps in SSRS, namely,  using the SWITCH Expression, using Custom VB.NET Code, as well as using External Assembly File.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: September 01

Time: 3:20 PM - 4:20 PM

Room: Conference Room 3

Learn how to leverage Python and SQL Server 2017 In-Database Analytics with GPU acceleration to use NeuralNet algorithms for Deep Learning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: September 01

Time: 3:20 PM - 4:20 PM

Room: Auditorium 1

Are you underpaid? Would you like to know what a market related salary is for your skill set? What are the most in demand IT Developer profiles in the market today? Is your CV going to stand out from the guy sitting next to you? Come along to my presentation and we will have a look at what a market related salary for you is; are you keeping your skills relevant for today’s needs and are you representing yourself well enough to stand out.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 01

Time: 10:00 AM - 11:00 AM

Room: Auditorium 1

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 01

Time: 2:10 PM - 3:10 PM

Room: Auditorium 2

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 01

Time: 3:20 PM - 4:20 PM

Room: Conference Room 4

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:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 01

Time: 11:10 AM - 12:10 PM

Room: Conference Room 4

SQL Server Machine Learning Services (ML Services) was introduced in SQL Server 2016. At that time SQL Server ML Services only supported the R language. When SQL Server 2017 was released Python was added to the mix. In this session, we get an overview of what SQL Server ML services can do and what it can be used for. The session is code heavy.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: September 01

Time: 2:10 PM - 3:10 PM

Room: Auditorium 1

Do you ever worry that your reports look they were born in the 90s, or designed by a grade 1? Do you feel overwhelmed when tasked with creating attractive reports which tell the customer a story?

Thankfully, a few simple design concepts can have big impacts on your reports. There are easy-to-learn techniques and patterns to create a pleasing look and feel to our reports, and some well defined principles to decide which visual is most appropriate in your situation.

Join me in this session to learn:

- How to choose the right visual to complement the data message.
- Best practices for visual formatting to tell a complete story.
- Colour theory - designing a colour palette, and ensuring accessibility.
- Layout techniques for clean and simple reports.
- Real estate management, or how to fit everything on a report without it looking cluttered and losing effectiveness.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: September 01

Time: 11:10 AM - 12:10 PM

Room: Auditorium 3

In an outdated "resource hogged" solution the data archiving strategy of using stored procedures for DML with no caching, validation, exception handling and working automation was preventing thousands of the organisations client internet usage data from being correctly reported, due to lost records causing data integrity issues. This was a huge concern for the organisation as it affected the service ratings and client retention. In this presentation we relive the empirical process by going through the solution demonstrating the SSIS Incremental Data Loads method, discussing the creation and purpose of read and write tables, implementing indexes whilst keeping fill-factor, rebuilds and reorganization in mind, as well as provisioning staging tables for troubleshooting and verification purposes. Lastly we end off with the mirrored architecture's scheduled SQL agent jobs automation and notifications.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 01

Time: 11:10 AM - 12:10 PM

Room: Room 6

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 01

Time: 10:00 AM - 11:00 AM

Room: Auditorium 2

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