sqlsathistory

Nr: 1013

Back to Main list

SQLSaturday #1013 – Malaysia – Virtual 2020

Start Time (24h) Speaker Track Title
10:00:00 Patrick Gallucci Cloud Application Development Deployment Build a Complete Azure Data Platform in 1 Hour
10:00:00 Mohammad Darab Enterprise Database Administration Deployment Big Data Clusters for the Absolute Beginner
10:00:00 Jasmin Azemović Application Database Development Handle Data with Care
11:00:00 Pio Balistoy Enterprise Database Administration Deployment Azure SQL - What to Use When
11:00:00 Rui Romano BI Platform Architecture, Development Administration Power BI Tips, Tricks Hacks from the Trenches
11:00:00 Hamid J. Fard Enterprise Database Administration Deployment Optimum Environment for SQL Server
12:00:00 Amit R S Bansal Enterprise Database Administration Deployment Real-World Query Tuning Examples
12:00:00 André Melancia Advanced Analysis Techniques Machine Learning is full of stars: An Azure Story
12:00:00 Tiago Balabuch Cloud Application Development Deployment Azure SQL Database Hyperscale: Bigger, Bigger and Bigger!

SessionID: 107210

Build a Complete Azure Data Platform in 1 Hour

Back to calendar

Event Date: 17-10-2020 - Session time: 10:00:00 - Track: Cloud Application Development Deployment

Speaker: Patrick Gallucci

Title: Build a Complete Azure Data Platform in 1 Hour

Abstract:

Migrating Data and Analytic workloads to Azure gives organizations the ability to innovate faster with the Azure Data Platform. To unlock the potential, it typically takes months to architect, engineer, and deploy a Modern Data and Analytics Platform in Azure. Even with a prescriptive approach for cloud adoption, many organizations are not equipped to take on the full scope of responsibility required to leverage the all-up capabilities they have acquired as a result of the project.

Patrick Gallucci will share a service delivery approach that helps organizations move large and small data platforms to Azure. He will show you how to leverage proven cloud adoption methodologies, tools, resources, and best practices to enable your organization to simplify and accelerate their move to the cloud.

SessionID: 107606

Big Data Clusters for the Absolute Beginner

Back to calendar

Event Date: 17-10-2020 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Mohammad Darab

Title: Big Data Clusters for the Absolute Beginner

Abstract:

Are you a DBA or data professional working with out-dated technology or feel your skills are quickly becoming irrelevant? Stay ahead in today's ever changing tech space and take your career to the next level.

Join Mohammad Darab this session to explore the cutting-edge technology that SQL Server 2019 has to offer: Big Data Clusters.

Topics include: -Big Data Cluster architecture and its components such as: Containers, Kubernetes and the newly enhanced Polybase -Unique advantage of SQL Server Big Data Clusters -Data Virtualization, Scale-out Data Marts, and Data Hub concepts

SessionID: 107831

Handle Data with Care

Back to calendar

Event Date: 17-10-2020 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Jasmin Azemović

Title: Handle Data with Care

Abstract:

https://informationisbeautiful.net/visualizations/worlds-biggest-data-breaches-hacks/ Data Breaches figures are generally measured in the tens and hundreds of millions of records. However, the other side of the medal from the Hall of Fame is that it is unprotected data from databases that have reached the "deep web". What happens next, hypothetically, can have very serious consequences. Is everything just so black? Learn about it on this session.

SessionID: 107213

Azure SQL - What to Use When

Back to calendar

Event Date: 17-10-2020 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Pio Balistoy

Title: Azure SQL - What to Use When

Abstract:

With the advent of cloud we now have multiple deployment options for SQL Server. Be it a Full instance on premise or in the cloud, to a managed instance or a Platform as a service in the form of Azure SQL Database - each deployment options have their own use case. In this session, we will explore SQL Server's deployment options to help you decide which path is applicable to which scenarios.

SessionID: 107594

Power BI Tips, Tricks Hacks from the Trenches

Back to calendar

Event Date: 17-10-2020 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Rui Romano

Title: Power BI Tips, Tricks Hacks from the Trenches

Abstract:

Power BI is an amazing BI platform out of the box, but there' is a lot of things that you can do with Power BI that probably you dont even imagine!

This session is a collection of my top tips, tricks hacks gathered over the years from simple tips to advanced hacks to boost your productivity.

SessionID: 107661

Optimum Environment for SQL Server

Back to calendar

Event Date: 17-10-2020 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Hamid J. Fard

Title: Optimum Environment for SQL Server

Abstract:

Databases are essential in the business world, we all have databases that are critical to the

organization. When it comes to storing and querying on data, SQL Server is the top choice for many businesses and data professionals. It’s used for a range of projects--from Enterprise Resource Planning (ERP) to mini Human Resources (HR) solution systems. In this session, you will learn step by step how to prepare an optimum environment for SQL Server. We will review best practices for SQL Server configuration, PowerShell basics, advanced hardware resource planning, performance tuning techniques, high availability and disaster recovery designs, and the importance of documentation.

SessionID: 107704

Real-World Query Tuning Examples

Back to calendar

Event Date: 17-10-2020 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Amit R S Bansal

Title: Real-World Query Tuning Examples

Abstract:

Query Tuning is easier said than done. Here is an opportunity to learn some real-world query tuning examples. In this 100% demo, deep-dive session you will learn to identify query performance issues using execution plans, re-write queries to improve execution time, use new T-SQL constructs for better performance, re-define indexes deal with statistics to improve query performance. You will also learn many advanced concepts and true to the session title, you are going to see bad query vs good query, all real-world. This session will be an eye-opener for you and you will learn things that Google cannot find for you. Assured. (The content demonstrated will only be relevant to SQL Server 2012 and onward including 2019)

SessionID: 107752

Machine Learning is full of stars: An Azure Story

Back to calendar

Event Date: 17-10-2020 - Session time: 12:00:00 - Track: Advanced Analysis Techniques

Speaker: André Melancia

Title: Machine Learning is full of stars: An Azure Story

Abstract:

Want to get started with Machine Learning and have no idea what technologies to use?

Don't hybernate your career. Learn about some of technologies available, focusing on Microsoft's offering, such as Azure Machine Learning (Service) workspace, Spark using Azure Databricks and HDInsight, Azure Synapse Analytics, and many more. Disclaimer: All these worlds are yours except Cognitive Service, that's for a different session.

SessionID: 107862

Azure SQL Database Hyperscale: Bigger, Bigger and Bigger!

Back to calendar

Event Date: 17-10-2020 - Session time: 12:00:00 - Track: Cloud Application Development Deployment

Speaker: Tiago Balabuch

Title: Azure SQL Database Hyperscale: Bigger, Bigger and Bigger!

Abstract:

Microsoft is building the biggest cloud database. Hyperscale is a new cloud-native solution purpose-built to address common cloud scalability limits with either compute, storage, memory or combinations of all three.

Come to this session and learn about how we do it with Azure SQL Database Hyperscale.