sqlsathistory

Nr: 818

SQLSaturday #818 - Malaysia 2019

Start Time (24h)	Speaker	Track	Title
09:30:00	Ian Choy	Strategy and Architecture	Microsoft Data AI Landscape
10:45:00	Asanka Padmakumara	BI Platform Architecture, Development Administration	ETL2.0: Data Engineering with Azure Databricks
10:45:00	Ben Weissman	Information Delivery	SQL Server Big Data Clusters - A game changer?
10:45:00	Khilitchandra Prajapati	BI Information Delivery	Build Dashboards in Power BI with Real-time* Data
11:45:00	Vinod Kumar M	Application Database Development	Become a SQL Ninja: SQL Server Tools
11:45:00	Jonathan Stewart	Analytics and Visualization	Data Visualization: How to truly tell a great story!
11:45:00	David Alzamendi	BI Platform Architecture, Development Administration	Modern Azure Data Warehouse
13:45:00	Kevin Boles	Other	Common TSQL Mistakes
13:45:00	Patrick Flynn	Application Database Development	GITHB 101 - An introduction to using Github and Git for Source Control and Open Source Projects
13:45:00	Danaraj Ram Kumar	BI Platform Architecture, Development Administration	Orchestrating Data Movement in the Cloud
14:45:00	Hamid J. Fard	Enterprise Database Administration Deployment	Optimum Environment for SQL Server
14:45:00	Ben Weissman	Information Delivery	Let’s Build SSIS Packages with Biml – Live!
14:45:00	Janusz Rokicki	Enterprise Database Administration Deployment	AIOps for Sql Server - Introduction
16:00:00	Jason Aw	Enterprise Database Administration Deployment	SQL Server in "The Cloud": High Availability and Disaster Recovery in Azure, AWS and Google
16:00:00	Jonathan Stewart	BI Platform Architecture, Development Administration	Performance Tuning for the BI Professional
16:00:00	Kevin Boles	Application Database Development	Know What Your Code is Doing to SQL Server!
19:00:00	Chiu Kiang Phua	Enterprise Database Administration Deployment	Placeholder (Testing)

SessionID: 88328

Microsoft Data AI Landscape

Back to calendar

Event Date: 26-01-2019 - Session time: 09:30:00 - Track: Strategy and Architecture

Speaker: Ian Choy

Title: Microsoft Data AI Landscape

Abstract:

SessionID: 86589

ETL2.0: Data Engineering with Azure Databricks

Back to calendar

Event Date: 26-01-2019 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Asanka Padmakumara

Title: ETL2.0: Data Engineering with Azure Databricks

Abstract:

Spark and Azure Databricks have become game changing features in data world and processing large volume of data has never been faster. In this session , I will give a introduction to Azure Databricks, Apache Spark and will walk though step by step on how to use Azure Databricks.Additionally I will showcase how to perform ETL operations using Azure Databricks.

SessionID: 87060

SQL Server Big Data Clusters - A game changer?

Back to calendar

Event Date: 26-01-2019 - Session time: 10:45:00 - Track: Information Delivery

Speaker: Ben Weissman

Title: SQL Server Big Data Clusters - A game changer?

Abstract:

With SQL Server 2019, Microsoft is introducing a new couple of features for data virtualization, data mart scale out and big data analysis. They all together for the SQL Server Big Data Clusters.

Let's take a look at what that means and how you can make use of the extended polybase capabilities, built in spark queries and more!

SessionID: 87073

Build Dashboards in Power BI with Real-time* Data

Back to calendar

Event Date: 26-01-2019 - Session time: 10:45:00 - Track: BI Information Delivery

Speaker: Khilitchandra Prajapati

Title: Build Dashboards in Power BI with Real-time* Data

Abstract:

In this session, we will go through architecture, components demos in order to build Power BI Dashboards with Real-time* data. Of course in fun way :)

SessionID: 86389

Become a SQL Ninja: SQL Server Tools

Back to calendar

Event Date: 26-01-2019 - Session time: 11:45:00 - Track: Application Database Development

Speaker: Vinod Kumar M

Title: Become a SQL Ninja: SQL Server Tools

Abstract:

In this session I will walk through some of the out-of-box SQL Server tools that you will need to know or never knew could be so much fun. A number of commandline utilities exist with SQL Server that we are never exposed to. In this session, I will take a tour of each of these tools and the scenario’s that real world customers used them in innovative ways. From SQL Server Management Studio to every tools will be an hour of Demo extravaganza not to be missed. This is a Zero slide but an hour of demo marathon.

SessionID: 86475

Data Visualization: How to truly tell a great story!

Back to calendar

Event Date: 26-01-2019 - Session time: 11:45:00 - Track: Analytics and Visualization

Speaker: Jonathan Stewart

Title: Data Visualization: How to truly tell a great story!

Abstract:

We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…

SessionID: 87442

Modern Azure Data Warehouse

Back to calendar

Event Date: 26-01-2019 - Session time: 11:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: David Alzamendi

Title: Modern Azure Data Warehouse

Abstract:

What is a Modern Data Warehouse? How is it different from the traditional Data Warehouse architecture? Where to start building the Data Warehouse? Cloud or no Cloud?

This session will answer and expand upon each one of these questions.

From the traditional data warehouse architecture to the modern data warehouse using Azure technologies, you will learn different services that are a good fit for your solutions and how to integrate them.

SessionID: 86647

Common TSQL Mistakes

Back to calendar

Event Date: 26-01-2019 - Session time: 13:45:00 - Track: Other

Speaker: Kevin Boles

Title: Common TSQL Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over 100 times now and it is always very highly rated!

SessionID: 87204

GITHB 101 - An introduction to using Github and Git for Source Control and Open Source Projects

Back to calendar

Event Date: 26-01-2019 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Patrick Flynn

Title: GITHB 101 - An introduction to using Github and Git for Source Control and Open Source Projects

Abstract:

In the last few years the requirement to understand and use distributed Source control systems has become an increasing part of a Data Professionals life.

With the move into Open Source and community involvement even Microsoft has embraced the use of GitHub!

In this session we will investigate the setup and use of GitHub and Git for source control. Using the highly popular DBATools open source project we will also investigate getting involved in an Open Source project and the process of Pull and Push requests!

Based around personal experience of learning not to hate Source control, this session assume no experience with Git or Github

SessionID: 87722

Orchestrating Data Movement in the Cloud

Back to calendar

Event Date: 26-01-2019 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Danaraj Ram Kumar

Title: Orchestrating Data Movement in the Cloud

Abstract:

Data sourcing has changed a lot in the past. This session walks through on orchestrating data movement by an ELT approach by sourcing data from a centralized data lake store to Azure SQL DW and performing data transformation using Azure Data Factory.

SessionID: 86277

Optimum Environment for SQL Server

Back to calendar

Event Date: 26-01-2019 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Hamid J. Fard

Title: Optimum Environment for SQL Server

Abstract:

During this session, you will learn about what is neccessary to know

and learn about SQL Server to have the best performing database environment in terms of managability, performance, security, HADR and etc. SQL Server is not just only a data storage, and due to very complex and complicated interanl engines, requires to be maintained and administrated in proper manner. This session will give you enough knowledge about what you are not aware about SQL Server.

SessionID: 86595

Let’s Build SSIS Packages with Biml – Live!

Back to calendar

Event Date: 26-01-2019 - Session time: 14:45:00 - Track: Information Delivery

Speaker: Ben Weissman

Title: Let’s Build SSIS Packages with Biml – Live!

Abstract:

Have you heard about the Business Intelligence Markup Language (Biml)? Maybe you’ve even seen a session about it before but you still have doubts about how easily you can make something useful out of it. In this session, we’ll use Biml to build and populate a staging area including the corresponding SSIS packages. But there won’t be any pre-compiled demos - everything is happening live! Starting with a blank staging database, we will end up building a complete solution over the course of this session to prove that you can start from scratch and still quickly be successful.

Let’s see, how that goes… 

PS: Even if you have not heard about Biml but are still tired of manually building SSIS packages, this is the right session for you!

SessionID: 87951

AIOps for Sql Server - Introduction

Back to calendar

Event Date: 26-01-2019 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Janusz Rokicki

Title: AIOps for Sql Server - Introduction

Abstract:

For years we have been bombarded with AI-enabled/smart/intelligent features, tools and platforms. But what does it actually mean for Sql Server developers and DBAs in practical terms? Is it just marketing hype or contrary - distinct trend that has already started and impacts how and what we do, our workplaces and future careers? This session defines what AIOPs is, provides framework to measure AI, goes through the list and evaluates 'the latest and greatest' tools and features available in Sql Server both on-premises and in the cloud and finally shows practical use cases of the best of them that we have to adopt to stay relevant on increasingly competitive market. Let's find out if maintenance free, self-healing, auto-tuning databases that are able to detect and automatically mitigate security risks are ready for real-world workloads! Areas covered:

Conditional Access VS Thread Detection
Query Store and Automatic Tuning
Intelligent Query Processing

SessionID: 86320

SQL Server in "The Cloud": High Availability and Disaster Recovery in Azure, AWS and Google

Back to calendar

Event Date: 26-01-2019 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Aw

Title: SQL Server in "The Cloud": High Availability and Disaster Recovery in Azure, AWS and Google

Abstract:

If you are considering moving your SQL Server instances to "The Cloud" you will need to have a plan in place for both high availability and disaster recovery. In this session we will examine the three top public cloud providers and what they have to offer in terms of both high availability and disaster recovery. We will discuss where the providers are the same and where the differ. Some real life customer configurations will be presented. With content from Cloud and Datacenter Management MVP Dave Bermingham, Jason Aw will lead this session and encourages you to bring your questions specific to your environment.

SessionID: 86478

Performance Tuning for the BI Professional

Back to calendar

Event Date: 26-01-2019 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jonathan Stewart

Title: Performance Tuning for the BI Professional

Abstract:

Being a BI Professional, you need all the performance tuning the DB folks get and more. In this hour, we will go over important performance tuning tips that you can use to help make your deliverables faster and more effective. We will touch on the MSBI tools of SSIS, SSAS, SSRS and PowerBI.

SessionID: 86648

Know What Your Code is Doing to SQL Server!

Back to calendar

Event Date: 26-01-2019 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Kevin Boles

Title: Know What Your Code is Doing to SQL Server!

Abstract:

ORMs - oh how I LOVE them! As a consultant, when I see them in play at a client I go KACHIIINNNNGGGG!! :-D Seriously though, they can provide some substantial benefits for coding throughput. But if you don't Read The Fine Manual and do some things right and avoid some major gotchas you will fall prey to one of my favorite Guruisms: "Anything that allows developers to slap code together more quickly is inversely proportional to the performance, concurrency and scalability you will get from that code"! Although this talk is based on Entity Framework, all ORMs suffer from the same flaws.

SessionID: 87941

Placeholder (Testing)

Back to calendar

Event Date: 26-01-2019 - Session time: 19:00:00 - Track: Enterprise Database Administration Deployment