Build Schedule

Advanced Filters:
  • Track

    clear all

  • Speaker


  • Level


  • Session Type

Sessions Found: 13
Adaptive Query Processing is one of the most important enhancements to be released in SQL Server 2017. Adaptive Query Processing adds intelligence to the optimizer and improves query plan choices significantly. Following session will provide an overview on Adaptive query processing and explain the scenarios at which Adaptive Query Processing automatically provides performance gain with no change to the code.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data and BI Platforms

Level: Intermedia

Session Code:

Date: January 13

Time: 10:20 AM - 11:20 AM

Room: Auditorium 2

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:
Data and BI Platforms

Level: Intermedia

Session Code:

Date: January 13

Time: 11:30 AM - 12:30 PM

Room: Auditorium 1

The heart of almost all Business Intelligence solutions; Relational Data Warehouse, has been servicing us for decades making the implementation is complete and success. It was always an On-Premises database, but now it is available as a Database-as-a-Service with Microsoft Azure, called Azure SQL Data Warehouse. It is a MPP cloud-based, scale-out relational database that supports workloads from few hundred gigabytes to petabytes of data and it addresses all modern requirements in data warehousing. Let’s talk about traditional On-Premises data warehouse little bit and then discuss about Azure SQL Data Warehouse and implementation of it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data and BI Platforms

Level: Intermedia

Session Code:

Date: January 13

Time: 10:20 AM - 11:20 AM

Room: Auditorium 1

Being able to monitor, diagnose and recover from Database Corruption is  a critical skill for any SQL Server DBA. 
In this session we will walk through the techniques required to detect and repair various forms of Corruption 
Using a number of example corrupted database we will explore how to determine and fix corruption while avoiding some of the common mistakes.
Warning: Hex Editors and DBCC Page dumps will be involved!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data and BI Platforms

Level: Advanced

Session Code:

Date: January 13

Time: 11:30 AM - 12:30 PM

Room: Auditorium 2

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:
Data and BI Platforms

Level: Beginner

Session Code:

Date: January 13

Time: 1:40 PM - 2:40 PM

Room: Auditorium 1

BI is evolving fast and this track walks you through on how corporate BI and self-service BI closes the gap. Empower analytics with SQL Server Analysis Services Tabular and watch how business can rapidly derive insights from corporate models while integrating self-service BI with corporate models.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data and BI Platforms

Level: Intermedia

Session Code:

Date: January 13

Time: 11:30 AM - 12:30 PM

Room: Room 1

Configuring high availability on Azure SQL Database comes with a few options. The following session provides an overview on concepts of Geo Replication, Elastic Pools and Azure Failover Groups and how they can be used in providing high availability for Azure SQL Database. Session would involve few demos on configuring high availability and would provide the audience a clear understanding on developing resilient applications on Azure SQL Database.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data and BI Platforms

Level: Intermedia

Session Code:

Date: January 13

Time: 4:20 PM - 5:20 PM

Room: Auditorium 1

Azure Cosmos DB is an evolution of Azure Document DB. 
It's the industry first globally distributed database service, allow you to scale storage and throughput across many geographical regions with promising low latency.
Cosmos DB supports for multi model database, different types of database engines like key-value, document, graph and multi API support like SQL, Azure Table Storage, Gremlin, MongoDB.
Let's see in action with a demo, how you can transfer your complex data into a simpler format with Document API and scale it in different regions with specific storage and throughput.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Data and BI Platforms

Level: Beginner

Session Code:

Date: January 13

Time: 1:40 PM - 2:40 PM

Room: Auditorium 2

In this session we will look at how to optimise your use of the GUI tools provided for SQL Server

We will cover 
(a) How to efficiently use the latest version of SQL Server Management Studio
(b) What is available with the New Kid in Town - SQL Server Operations Studio
(c) An introduction to some of the Third Party extensions available

Attendees will come away with an appreciation of how to maximise the use of these tools and also some useful extensions for these tools
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data and BI Platforms

Level: Beginner

Session Code:

Date: January 13

Time: 2:45 PM - 3:45 PM

Room: Auditorium 1

Azure SQL Database has come a long way, and for MS SQL, it's ahead of its other public Cloud competitors by miles. This session will look at the practical benefits of using a fully managed SQL Server database as a platform for traditional DBA-managed SQL consolidation. We'll take a look at the benefits in terms of technology and cost models, as well as a direct comparison with SQL Server on-premise and comparisons with other public Cloud providers. We'll also take a look at the most significant features that have been added in the last year that'll make you change your mind about adopting this as your next Database.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data and BI Platforms

Level: Intermedia

Session Code:

Date: January 13

Time: 2:45 PM - 3:45 PM

Room: Auditorium 2

Sometimes DBAs find that SQL Server Availability Group performs very slow REDO operation on Replica server. During this session, you will realize what is going in Availability Group internal process.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data and BI Platforms

Level: Intermedia

Session Code:

Date: January 13

Time: 1:40 PM - 2:40 PM

Room: Room 1

This talk will introduce the latest security controls and features introduced by Microsoft. The OWASP Top 10 Application Security Risks – 2017 will be introduce to address common SQL Server  misconfiguration sin and application security vulnerabilities to help SQL Server experts to obtain a better understanding on SQL Server Hardening and Best Practices. And Finally, We will brief GDPR and Data Security and share how SQL Server can ease the process with minimum application change.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data and BI Platforms

Level: Intermedia

Session Code:

Date: January 13

Time: 2:45 PM - 3:45 PM

Room: Room 1

A Guide to Working with Data Services and Azure SQL for your Applications Although Microsoft Azure and the concept of Cloud Computing has been around for a while it is still a mystery to many.This talk takes a look at Azure Data storage – what it is, the types of storage options available and their advantages and disadvantages. 
 We’ll take a look at the different options available for your SQL applications to see how to create and manage SQL databases in the Cloud. By the end of this talk you will be ready to get straight into Azure and start taking advantage of what it has to offer
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data and BI Platforms

Level: Intermedia

Session Code:

Date: January 13

Time: 4:20 PM - 5:20 PM

Room: Auditorium 2

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