Nr: 702
SQLSaturday #702 - Malaysia 2018
SessionID: 69727
Cloud Data Warehousing: Azure SQL Data Warehouse
Event Date: 13-01-2018 - Session time: 10:20:00 - Track: Data and BI Platforms
Speaker: Dinesh Priyankara
Title: Cloud Data Warehousing: Azure SQL Data Warehouse
Abstract:
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.
SessionID: 70267
Adaptive Query Processing in SQL Server 2017
Event Date: 13-01-2018 - Session time: 10:20:00 - Track: Data and BI Platforms
Speaker: Nagaraj Venkatesan
Title: Adaptive Query Processing in SQL Server 2017
Abstract:
SessionID: 71965
Database Corruption - Advanced Recovery Techniques
Event Date: 13-01-2018 - Session time: 11:30:00 - Track: Data and BI Platforms
Speaker: Patrick Flynn
Title: Database Corruption - Advanced Recovery Techniques
Abstract:
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!
SessionID: 72104
Empowering Modern BI - the gap between Self-Service and Corporate BI
Event Date: 13-01-2018 - Session time: 11:30:00 - Track: Data and BI Platforms
Speaker: Danaraj Ram Kumar
Title: Empowering Modern BI - the gap between Self-Service and Corporate BI
Abstract:
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.
SessionID: 72273
Azure Data Lake Analytics: Leveraging the Modern Data Warehouse
Event Date: 13-01-2018 - Session time: 11:30:00 - Track: Data and BI Platforms
Speaker: Gogula Aryalingam
Title: Azure Data Lake Analytics: Leveraging the Modern Data Warehouse
Abstract:
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.
SessionID: 69733
Let's make a complex data set simple using Azure Cosmos DB
Event Date: 13-01-2018 - Session time: 13:40:00 - Track: Data and BI Platforms
Speaker: Hansamali Gamage
Title: Let's make a complex data set simple using Azure Cosmos DB
Abstract:
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.
SessionID: 71963
Event Date: 13-01-2018 - Session time: 13:40:00 - Track: Data and BI Platforms
Speaker: Patrick Flynn
Abstract:
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!
SessionID: 71966
Event Date: 13-01-2018 - Session time: 13:40:00 - Track: Data and BI Platforms
Speaker: Hamid J. Fard
Abstract:
SessionID: 70302
SQL Consolidation with Azure SQL Database: an IT Pro DBA's view.
Event Date: 13-01-2018 - Session time: 14:45:00 - Track: Data and BI Platforms
Speaker: Darien Nagle
Title: SQL Consolidation with Azure SQL Database: an IT Pro DBA's view.
Abstract:
SessionID: 71964
Optimizing your management of SQL Server with SSMS and SQLOperationsStudio - The 2018 Edition
Event Date: 13-01-2018 - Session time: 14:45:00 - Track: Data and BI Platforms
Speaker: Patrick Flynn
Title: Optimizing your management of SQL Server with SSMS and SQLOperationsStudio - The 2018 Edition
Abstract:
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
SessionID: 72927
SQL Server Security Features - GDPR Data Security Protection
Event Date: 13-01-2018 - Session time: 14:45:00 - Track: Data and BI Platforms
Speaker: Sina Manavi
Title: SQL Server Security Features - GDPR Data Security Protection
Abstract:
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.
SessionID: 69599
Working with Azure Data, BIG Data Services and Azure SQL for your Applications
Event Date: 13-01-2018 - Session time: 16:20:00 - Track: Data and BI Platforms
Speaker: Adnan Hendricks
Title: Working with Azure Data, BIG Data Services and Azure SQL for your Applications
Abstract:
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
SessionID: 70268
High Availability for Azure SQL Database
Event Date: 13-01-2018 - Session time: 16:20:00 - Track: Data and BI Platforms
Speaker: Nagaraj Venkatesan
Title: High Availability for Azure SQL Database
Abstract:
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.