sqlsathistory

Nr: 893

Back to Main list

SQLSaturday #893 - Singapore 2019

Start Time (24h)	Speaker	Track	Title
09:50:00	Joseph D'Antoni	Application Database Development	Automagic Tuning - SQL Server 2019 and Beyond
09:50:00	Dinesh Priyankara	Advanced Analysis Techniques	Data Science with SQL Server Machine Learning Service: Predictive Experiment
09:50:00	Gogula Aryalingam	BI Platform Architecture, Development Administration	Azure Data Factory: Ingesting and Integrating Data for a Modern Data Warehouse
09:50:00	Aroh Shukla	BI Information Delivery	3 reasons to get excited about Power BI Dataflow.
10:55:00	Karen Lopez	Application Database Development	The Tricky Part of Doing Tricky Things in your Database
10:55:00	Eng Soon Cheah	Cloud Application Development Deployment	Securing your data with Azure SQL DB
10:55:00	Nisal Mihiranga	BI Platform Architecture, Development Administration	Scalable Data Models using Aggregations in Power BI
10:55:00	Janusz Rokicki	Advanced Analysis Techniques	Anomaly Detection in Predictive Maintenance for Sql Server
12:55:00	Jason Aw	Enterprise Database Administration Deployment	High Availability and Disaster Recovery for SQL Server in Azure IaaS
12:55:00	Monica Rathbun	Enterprise Database Administration Deployment	Performance Tuning, Getting the Biggest Bang for Your Buck
12:55:00	Sandy Winarko	BI Platform Architecture, Development Administration	PaaSport to Paradise: Lifting Shifting with Azure SQL DB/Managed Instance + Azure Data Factory
12:55:00	Patrick Flynn	Application Database Development	Get Comfortable with Query tuning and Execution Plans
14:00:00	Ben Weissman	Advanced Analysis Techniques	SQL Server Big Data Clusters - A game changer?
14:00:00	Mohamed Mawla	Cloud Application Development Deployment	From Zero to Hero: Start Machine Learning using Azure ML studio
14:00:00	Manohar Punna	Strategy and Architecture	Bridging the gap between SSRS and Power BI
14:00:00	Denny Cherry	Application Database Development	SQL Server Database Administration for the non-DBA
15:15:00	Shehab El-Najjar	Application Database Development	T-SQL Performance Guidelines for the optimal DB stress powers
15:15:00	Senthamil V	Cloud Application Development Deployment	SharePoint as a Data Platform for Microsoft Power Platform
15:15:00	Anupama Natarajan	Analytics and Visualization	Enterprise Big Data Analytics using Azure Data Lake Storage Gen2
15:15:00	Pio Balistoy	Enterprise Database Administration Deployment	The Right way of Modernizing Your SQL Server
16:15:00	Asanka Padmakumara	BI Platform Architecture, Development Administration	ETL2.0: Data Engineering with Azure Databricks
16:15:00	Joanna Wolthuis	Application Database Development	Be a dynamic SQL dynamo!
16:15:00	Mohammad Asif Waquar	Cloud Application Development Deployment	Manage data to the ledger using Azure Blockchain as Service

SessionID: 94992

Automagic Tuning - SQL Server 2019 and Beyond

Back to calendar

Event Date: 31-08-2019 - Session time: 09:50:00 - Track: Application Database Development

Speaker: Joseph D'Antoni

Title: Automagic Tuning - SQL Server 2019 and Beyond

Abstract:

Identifying and fixing problematic query plans got a lot easier in SQL Server 2016, with the introduction of the Query Store. SQL Server 2019 takes that power a few steps further. Have you ever:

• Had a query suddenly slow down at 2 AM when you were on call? • Seen a query that received a giant memory grant that brought the rest of the work on your server to a screeching halt? • Had the optimizer choose the wrong type of join and send your query off to never finish?

Don’t worry, you will still have your job, but the features introduced in SQL Server 2017 will make narrow your focus to the absolute worst queries in your environment. You will also get a sneak preview of what’s coming into future releases of SQL Server in terms of performance.

SessionID: 95407

Data Science with SQL Server Machine Learning Service: Predictive Experiment

Back to calendar

Event Date: 31-08-2019 - Session time: 09:50:00 - Track: Advanced Analysis Techniques

Speaker: Dinesh Priyankara

Title: Data Science with SQL Server Machine Learning Service: Predictive Experiment

Abstract:

Making data available for data science was considered as very expensive and it was rare to see data scientist works directly with a database for creating experiments. Main reason could be, widely-used languages for data science were not available within DBMSs and DBMSs were not rich enough for experiments.

Good news is, SQL Server Machine Learning Service is now equipped for data science. Let’s have a look on it and see how we can work on training experiments and predictive experiments. Let me show you; • What is Data Science and its processes? • What is SQL Server Machine Learning Service? • Configuring SQL Server for data science • Make a training experiment and predictive experiment using Python within SQL Server • Consumed a trained model using TSQL

Join with me and see how useful this with both operational and business intelligence areas.

SessionID: 95923

Azure Data Factory: Ingesting and Integrating Data for a Modern Data Warehouse

Back to calendar

Event Date: 31-08-2019 - Session time: 09:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Gogula Aryalingam

Title: Azure Data Factory: Ingesting and Integrating Data for a Modern Data Warehouse

Abstract:

When you build a business intelligence system for the current times, such as a modern data warehouse, the mantra for getting data onboard is ELT, and not ETL. Building an ELT solution is not as simple as switching two letter; it is a paradigm shift in thinking. In this session, I will brief you on the concept of a modern data warehouse, then move to why its data integration needs are different, how a solution for such a need is designed, and finally how you would build it using Azure Data Factory, and related technologies.

SessionID: 96131

3 reasons to get excited about Power BI Dataflow.

Back to calendar

Event Date: 31-08-2019 - Session time: 09:50:00 - Track: BI Information Delivery

Speaker: Aroh Shukla

Title: 3 reasons to get excited about Power BI Dataflow.

Abstract:

Power BI Dataflow is a new feature in Power BI and gives you self-service data prep in Power BI. Dataflows give extensibility to other services Azure, Dynamics, Azure Databricks, Azure ML etc. and uses common data model that PowerApps leverages.

SessionID: 92837

The Tricky Part of Doing Tricky Things in your Database

Back to calendar

Event Date: 31-08-2019 - Session time: 10:55:00 - Track: Application Database Development

Speaker: Karen Lopez

Title: The Tricky Part of Doing Tricky Things in your Database

Abstract:

We've mastered the basics of basic database design patterns, but what happens when you or a teammate wants to use THIS ONE WEIRD TRICK to improve on your database design? Have you just discovered a brilliant new trick that no one else has ever thought of? Or will your new design cost you more, take on more risk and cause all kinds of pain for both IT and your business users?

We'll demo tricks that we've seen in our database design reviews and show you how they work and talk about the trade-offs for using them. You' learn about: Building a database engine inside your database, Implementing Hierarchies, Dealing with data structures that don't do as well in RDBMSs, Generating code out of the database, Optimizing the developer versus the data or the app, Using design patterns that don't reflect modern architectures and tools, …and a lot more.

SessionID: 93644

Securing your data with Azure SQL DB

Back to calendar

Event Date: 31-08-2019 - Session time: 10:55:00 - Track: Cloud Application Development Deployment

Speaker: Eng Soon Cheah

Title: Securing your data with Azure SQL DB

Abstract:

In this session, you will learn about the layers of data protection, important security features, potential scenarios in which these features can be applied to limit exposure to security threats and best practices for securing business applications and data.

SessionID: 93835

Scalable Data Models using Aggregations in Power BI

Back to calendar

Event Date: 31-08-2019 - Session time: 10:55:00 - Track: BI Platform Architecture, Development Administration

Speaker: Nisal Mihiranga

Title: Scalable Data Models using Aggregations in Power BI

Abstract:

The Aggregations is one of the biggest feature introduced in Power BI in terms of scalability. In this session, will introduce the aggregation feature first. Then move to discuss use cases where you can implement aggs and finally demonstrate how to implement aggregations in your data models.

SessionID: 94776

Anomaly Detection in Predictive Maintenance for Sql Server

Back to calendar

Event Date: 31-08-2019 - Session time: 10:55:00 - Track: Advanced Analysis Techniques

Speaker: Janusz Rokicki

Title: Anomaly Detection in Predictive Maintenance for Sql Server

Abstract:

The amount of data we collect, store and process is rapidly growing and goes hand in hand with growing amount of work related to managing it. Automation is a key if we want to stay in control and AIOps represents its next major level with potential to revolutionise IT operations. This session explains what predictive maintenance is, provides common use cases and gives practical examples that help to avoid costly Sql Server disruptions and eliminate firefighting. Presented real-world examples address limitations of Query Store and automate the identification and resolution of common performance issues.

SessionID: 92856

High Availability and Disaster Recovery for SQL Server in Azure IaaS

Back to calendar

Event Date: 31-08-2019 - Session time: 12:55:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Aw

Title: High Availability and Disaster Recovery for SQL Server in Azure IaaS

Abstract:

The CEO just tasked you with moving all the SQL Server instances to Azure, or maybe you are deploying a brand new application and want to leverage Azure IaaS to host SQL Server. Beyond security and performance, your most pressing concern might be ensuring SQL Server running in Azure is highly available.

While on-prem high availability and disaster recovery options for SQL Server are well defined, moving those instances to Azure immediately presents some questions and challenges. Can I simply lift and shift my SQL Server Failover Cluster Instance to the cloud? Do I need to upgrade to SQL Server Enterprise Edition and us Always On Availability Groups? What about shared storage and failover clustering? What about disaster recovery, what are my options there? Load Balancers, Fault Domains, Availability Zones, Azure Site Recovery and Region Pairs, what are these things and why do they matter to me?

HA and DR professional Jason Aw with 20 years of experience explains all this and more in

SessionID: 93528

Performance Tuning, Getting the Biggest Bang for Your Buck

Back to calendar

Event Date: 31-08-2019 - Session time: 12:55:00 - Track: Enterprise Database Administration Deployment

Speaker: Monica Rathbun

Title: Performance Tuning, Getting the Biggest Bang for Your Buck

Abstract:

Everyone wants to know if there are magic buttons you can push to make SQL Server run faster, better and more efficiently. In this session we will go over some of my go-to performance tricks that you can implement to get the biggest improvement with the least amount of change. When it comes to performance tuning, every second counts. We will cover memory optimization, isolation levels, trace flags, statistics, configuration changes and more. I’ll go over real life scenarios we come across as consultants and the changes we made to fix them.

SessionID: 93653

PaaSport to Paradise: Lifting Shifting with Azure SQL DB/Managed Instance + Azure Data Factory

Back to calendar

Event Date: 31-08-2019 - Session time: 12:55:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sandy Winarko

Title: PaaSport to Paradise: Lifting Shifting with Azure SQL DB/Managed Instance + Azure Data Factory

Abstract:

This session focuses on the all PaaS solution of Azure SQL DB/Managed Instance (MI) + SSIS in Azure Data Factory (ADF) to lift shift, modernize, and extend ETL workflows. You will first learn to provision Azure-SSIS Integration Runtime (IR) – dedicated ADF servers for running SSIS – with SSIS catalog (SSISDB) hosted by Azure SQL DB/MI and extend it with custom components. You will also learn to configure SSIS IR to access data on premises using Windows authentication and Virtual Network injection. You can then use the familiar SSDT/SSMS tools to manage your SSIS packages in the cloud just like you do on premises. You will next learn to modernize your ETL workflows by invoking SSIS package executions as first-class activities in ADF pipelines, allowing you to chain them with other activities, automatically (de)provision SSIS IR just in time, store secrets in Azure Key Vault, and splice advanced transformations, such as Power Query Source, Data Quality Tasks, etc.

SessionID: 94734

Get Comfortable with Query tuning and Execution Plans

Back to calendar

Event Date: 31-08-2019 - Session time: 12:55:00 - Track: Application Database Development

Speaker: Patrick Flynn

Title: Get Comfortable with Query tuning and Execution Plans

Abstract:

Even as many of the traditional DBA activities become automated or managed by Cloud providers, the ability to tune and optimize database query performance remains a desirable and marketable skill.

Central to ability to tune queries is an ability to use information provided from Execution plans, DMVs, Query Store and Extended Events.

In this demo based session we will look into:

• What information is available
• How it can be used.
• Techniques to improve performance.

Attendees will leave with an understanding of possibilities of turning queries and a roadmap for further learning.

This session will assume a basic knowledge of T-SQL and execution plans.

SessionID: 92095

SQL Server Big Data Clusters - A game changer?

Back to calendar

Event Date: 31-08-2019 - Session time: 14:00:00 - Track: Advanced Analysis Techniques

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 form 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: 92200

From Zero to Hero: Start Machine Learning using Azure ML studio

Back to calendar

Event Date: 31-08-2019 - Session time: 14:00:00 - Track: Cloud Application Development Deployment

Speaker: Mohamed Mawla

Title: From Zero to Hero: Start Machine Learning using Azure ML studio

Abstract:

The session aim is to get people excited and curious more about ML without digging in coding or deep concepts.

We will explore ML Azure offering, Some ML concepts, ML Studio, create an experiment from Scratch and show how ML can target common business challenges like demand projection or price targeting

Lots of hands-on

SessionID: 93350

Bridging the gap between SSRS and Power BI

Back to calendar

Event Date: 31-08-2019 - Session time: 14:00:00 - Track: Strategy and Architecture

Speaker: Manohar Punna

Title: Bridging the gap between SSRS and Power BI

Abstract:

Traditionally, SSRS is used for paginated reports which gives flexibility like drill through reports, subscriptions and print formatting. With Power BI the reports are now more interactive and dynamic. There are still few gaps between these two platforms which are built to purpose. This gap is getting smaller as features are ported between these two platforms. In this session I will be going through various features which are bridging these gaps and point out the differences. These are significant and can affect your decision in choosing the right platform which will fit your needs.

SessionID: 93541

SQL Server Database Administration for the non-DBA

Back to calendar

Event Date: 31-08-2019 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Denny Cherry

Title: SQL Server Database Administration for the non-DBA

Abstract:

Are you a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it? I've got some of the answers here in this session for you. During this session we will cover a variety of topics including backup and restore, recovery models, database maintenance, compression, data corruption, database compatibility levels and indexing.

While this session won't teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to better know what to look for.

SessionID: 92251

T-SQL Performance Guidelines for the optimal DB stress powers

Back to calendar

Event Date: 31-08-2019 - Session time: 15:15:00 - Track: Application Database Development

Speaker: Shehab El-Najjar

Title: T-SQL Performance Guidelines for the optimal DB stress powers

Abstract:

To reach your desired business functionalities, it can be easy using some common T-SQL practices like MTVF , scalar functions , Temp tables, Union…etc and they might perform pretty well on development server coz neither adequate stress of users nor adequate volume of data exist there but actually they seem totally strange once going to live where they become performing badly ending up eventually with and sharp skew of performance and standstill cases sometimes , this is due to the lack of stress powers of T-SQL codes which should be considered largely for critical mission DBs in particular more therefore I am going to talk to you about How to capture expensive queries using different techniques ..?and How to optimize them in the shortest time using scientific ways ..? (10 different T-SQL Practices will be explained within this session)

SessionID: 94587

SharePoint as a Data Platform for Microsoft Power Platform

Back to calendar

Event Date: 31-08-2019 - Session time: 15:15:00 - Track: Cloud Application Development Deployment

Speaker: Senthamil V

Title: SharePoint as a Data Platform for Microsoft Power Platform

Abstract:

Use SharePoint Online site and custom List as a data source for number of applications. SharePoint Custom list can behave like a data table with Relationship to enforce data integrity. Use Custom list as a development platform for custom apps. Microsoft Power platform can be used to integrate with custom list to fetch and act on data. Microsoft Flow can be a business process engine.

SessionID: 94595

Enterprise Big Data Analytics using Azure Data Lake Storage Gen2

Back to calendar

Event Date: 31-08-2019 - Session time: 15:15:00 - Track: Analytics and Visualization

Speaker: Anupama Natarajan

Title: Enterprise Big Data Analytics using Azure Data Lake Storage Gen2

Abstract:

Azure Data Lake Storage Gen2 is a highly scalable and cost-effective data lake solution for big data analytics. Data Lake Storage Gen2 makes Azure Storage the foundation for building enterprise data lakes on Azure. Data Lake Storage Gen2 allows you to easily manage massive amounts of data.

In this session you will learn • How to ingest structured and unstructured data into Azure Data Lake Storage Gen2? • How to access Azure Data Lake Storage Gen2 data with Azure Data Bricks using Spark? • How to secure data in Azure Data Lake Storage Gen2? At the end of the session you will learn how to implement end to end Analytics for a modern Data Warehouse using Azure Data Lake Storage Gen2.

SessionID: 96414

The Right way of Modernizing Your SQL Server

Back to calendar

Event Date: 31-08-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Pio Balistoy

Title: The Right way of Modernizing Your SQL Server

Abstract:

Any SQL Server from 2008 R2 and older are no longer supported. Compatibility and Support has changed. In this session we will discuss compatibility, support and the right way of modernizing your Database Application and the necessary tasks for planning, migrating and optimizing your Database be it on premise or into the cloud.

SessionID: 92092

ETL2.0: Data Engineering with Azure Databricks

Back to calendar

Event Date: 31-08-2019 - Session time: 16:15: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: 93938

Be a dynamic SQL dynamo!

Back to calendar

Event Date: 31-08-2019 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Joanna Wolthuis

Title: Be a dynamic SQL dynamo!

Abstract:

This session will cover the basics of dynamic SQL; how, why and when you may wish to use it with demos of use cases and scenarios where it can really save the day (trying to perform a search with a variable number of optional search terms, anyone?). We will also cover the performance and security impacts touching on the effect on query plans, index usage and security (SQL injection!) along with some best practices.

SessionID: 95579

Manage data to the ledger using Azure Blockchain as Service

Back to calendar

Event Date: 31-08-2019 - Session time: 16:15:00 - Track: Cloud Application Development Deployment

Speaker: Mohammad Asif Waquar

Title: Manage data to the ledger using Azure Blockchain as Service

Abstract:

Block chain is very fast growing technology.It is going to transform industry , lot of RD and initiatives going on in this area. In this session, We are going to cover patterns and server-less tools for sending data to the ledger network with Azure Blockchain Service and understand data flow in Blockchain Consortium Network.

This site is open source. Improve this page.