sqlsathistory

Nr: 639

Back to Main list

SQLSaturday #639 - Sri Lanka 2017

Start Time (24h)	Speaker	Track	Title
09:30:00	Hansamali Gamage	Cloud Mobile	Let's make a complex dataset simple using Azure Cosmos DB
09:30:00	Reza Rad	Business Intelligence Data Analytics	10 Amazing Things About Power BI You Don't Know
09:30:00	Rushabh Mehta	Database Development Administration	Columnstore Indexes with SQL Server 2016
10:45:00	Patrick Flynn	Database Development Administration	Database Corruption - Advanced Recovery Techniques
10:45:00	Dinesh Priyankara	Business Intelligence Data Analytics	Cloud Data Warehousing: Azure SQL Data Warehouse
10:45:00	Leila Etaati	Business Intelligence Data Analytics	On-premises Machine Learning: SQL Server 2016 with R
12:00:00	Dharmendra Keshari	Database Development Administration	SQL Server 2016 Query Store
12:00:00	Vijayakumar Thurupathan	Business Intelligence Data Analytics	Build data driven IoT analytics with Azure
12:00:00	Dinesh Asanka	Business Intelligence Data Analytics	Using Neural Network for Prediction with Microsoft Technologies
14:00:00	Satya Jayanty	Cloud Mobile	Big Data with Azure: Where to begin? Concepts and Best Practices
14:00:00	Pinal Dave	Database Development Administration	Kick Start! SQL Server 2014/2016 Performance Tips and Tricks
14:00:00	Haritha Thilakarathne	Business Intelligence Data Analytics	A Journey of a Data Point through Cortana Intelligence Suite
15:15:00	Reza Rad	Business Intelligence Data Analytics	Data Preparation is the Keystone; Power Query is Building Block
15:15:00	Shamil Sadique	Database Development Administration	A JSON's Journey through SQL Server
15:15:00	Rushabh Mehta	Cloud Mobile	Getting started with SQL Server in Azure
16:30:00	Dinesh Priyankara	General Other	The Great Data Panel Discussion

SessionID: 65565

Let's make a complex dataset simple using Azure Cosmos DB

Back to calendar

Event Date: 12-08-2017 - Session time: 09:30:00 - Track: Cloud Mobile

Speaker: Hansamali Gamage

Title: Let's make a complex dataset 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: 67330

10 Amazing Things About Power BI You Don't Know

Back to calendar

Event Date: 12-08-2017 - Session time: 09:30:00 - Track: Business Intelligence Data Analytics

Speaker: Reza Rad

Title: 10 Amazing Things About Power BI You Don't Know

Abstract:

Have you used Power BI for a real-time dashboard? Have you looped through source files in your Power Query and applied custom functions on them? Have you changed your data model to help Power QA to respond intelligently? Have you heard of structured columns in Power Query? Have you used Calculated Tables in DAX? Have you used Power BI Embedded? Have you done many other amazing things with Power BI?

In this session you can expect many live demos and to be impressed by the extraordinary things you can do with Power BI. You will learn tips and tricks to empower your Power BI solution. Tips and tricks that you learn in this session helps you to make your Power BI solution more scale-able, robust, and with high performance.

SessionID: 67696

Columnstore Indexes with SQL Server 2016

Back to calendar

Event Date: 12-08-2017 - Session time: 09:30:00 - Track: Database Development Administration

Speaker: Rushabh Mehta

Title: Columnstore Indexes with SQL Server 2016

Abstract:

The columnstore index is the standard for storing and querying large data warehousing fact tables. It uses column-based data storage and query processing to achieve up to 10x query performance gains in your data warehouse over traditional row-oriented storage, and up to 10x data compression over the uncompressed data size. Beginning with SQL Server 2016, columnstore indexes enable operational analytics, the ability to run performant real-time analytics on a transactional workload.

In this session, you will learn all about columnstore indexes and how to start taking advantage of this technology to achieve true real-time analytics.

SessionID: 63534

Database Corruption - Advanced Recovery Techniques

Back to calendar

Event Date: 12-08-2017 - Session time: 10:45:00 - Track: Database Development Administration

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: 67198

Cloud Data Warehousing: Azure SQL Data Warehouse

Back to calendar

Event Date: 12-08-2017 - Session time: 10:45:00 - Track: Business Intelligence Data Analytics

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: 67337

On-premises Machine Learning: SQL Server 2016 with R

Back to calendar

Event Date: 12-08-2017 - Session time: 10:45:00 - Track: Business Intelligence Data Analytics

Speaker: Leila Etaati

Title: On-premises Machine Learning: SQL Server 2016 with R

Abstract:

The R server 2016 provides many functionalities for database developers. It helps us to get more insight out of data by applying descriptive, predictive, and prescriptive analysis on data which located in SQL server 2016. In this session, first I will provide some descriptions on the descriptive, predictive, and prescriptive analysis. Then I will discuss what algorithm we can use to reach these three analysis using R. Finally, I will show a couple of demos on each of these type of analysis and will present how to write them in SQL Server 2016. the process of writing R code in SQL Server 2016 will be presented and the best practice for doing that also explained.

SessionID: 62411

SQL Server 2016 Query Store

Back to calendar

Event Date: 12-08-2017 - Session time: 12:00:00 - Track: Database Development Administration

Speaker: Dharmendra Keshari

Title: SQL Server 2016 Query Store

Abstract:

The Query Store feature is a game changer for how SQL Server professionals troubleshoot query performance. It provides the ability to natively capture baseline data within SQL Server. Using the performance metrics the Query Store records, we can decide which Execution Plan SQL Server should use when executing a specific query.

During this session we will take a thorough look at the Query Store, its architecture, the build-in reporting, DMVs and the performance impact of enabling the Query Store. No matter if you are a DBA or developer, the Query Store has information that can help you

SessionID: 63792

Build data driven IoT analytics with Azure

Back to calendar

Event Date: 12-08-2017 - Session time: 12:00:00 - Track: Business Intelligence Data Analytics

Speaker: Vijayakumar Thurupathan

Title: Build data driven IoT analytics with Azure

Abstract:

Internet of Things (IoT) is one of the emerging technology which transforms many different industries. IoT often produce large amount of data which is analysed in different levels. Data Analytics and Business Intelligence take a different landscape in IoT. We use different tools and techniques with the power of Cloud to solve the challenges and provide solutions. This session will provide you the information you required to get started with the IoT data analytics with the real case driven scenario.

SessionID: 67297

Using Neural Network for Prediction with Microsoft Technologies

Back to calendar

Event Date: 12-08-2017 - Session time: 12:00:00 - Track: Business Intelligence Data Analytics

Speaker: Dinesh Asanka

Title: Using Neural Network for Prediction with Microsoft Technologies

Abstract:

Neural Network is common thus complex technique in Data Analytics. Azure Machine Learning and SQL Server Data Mining has the option of using Neural Network for different purposes.

SessionID: 62951

Big Data with Azure: Where to begin? Concepts and Best Practices

Back to calendar

Event Date: 12-08-2017 - Session time: 14:00:00 - Track: Cloud Mobile

Speaker: Satya Jayanty

Title: Big Data with Azure: Where to begin? Concepts and Best Practices

Abstract:

In order to ascertain the abilities of cloud computing platform, let us overview what is available offered on Microsoft Azure.

Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.

SessionID: 62994

Kick Start! SQL Server 2014/2016 Performance Tips and Tricks

Back to calendar

Event Date: 12-08-2017 - Session time: 14:00:00 - Track: Database Development Administration

Speaker: Pinal Dave

Title: Kick Start! SQL Server 2014/2016 Performance Tips and Tricks

Abstract:

Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2014/2016 has introduced many new features. In this session we will be learning quite a few of the new features of SQL Server 2014/2016.

Here is the glimpse of the features we will cover in this session. • live plans for long-running queries • transaction durability and its impact on queries • new cardinality estimate for optimal performance • In-memory OLTP optimization of superior query performance • columnstore indexes and performance tuning • Query Store • Temporal Tables.

This 75 minutes will be the most productive time for any DBA and Developer who wants to quickly jumpstart with SQL Server 2014 and its new features.

SessionID: 67570

A Journey of a Data Point through Cortana Intelligence Suite

Back to calendar

Event Date: 12-08-2017 - Session time: 14:00:00 - Track: Business Intelligence Data Analytics

Speaker: Haritha Thilakarathne

Title: A Journey of a Data Point through Cortana Intelligence Suite

Abstract:

Cortana Analytics is a suite of fully managed Business Intelligence (BI), Big Data, and Advanced Analytics service offerings from Microsoft in the Azure Cloud. A raw data point comes from a user input or from an IoT sensor gets the real value through these services. Session discusses about the features and the abilities of Cortana Intelligence Suite.

SessionID: 67334

Data Preparation is the Keystone; Power Query is Building Block

Back to calendar

Event Date: 12-08-2017 - Session time: 15:15:00 - Track: Business Intelligence Data Analytics

Speaker: Reza Rad

Title: Data Preparation is the Keystone; Power Query is Building Block

Abstract:

Prepare to be amazed with what you can achieve using Power Query in this demo-heavy session. Power Query is the data extraction, transformation, and mash up tool. It can be accessed through Excel or from Power BI Desktop. There are numerous data transformation features that can be used to solve real-world data preparation challenges.

We will use customer case studies to go through scenarios of preparing data for modelling, and visualization. You will learn how to use features of Power Query such as generators, custom functions, and lots of built-in functions to solve those scenarios. You will also learn some data preparation techniques through Excel itself.

SessionID: 67440

A JSON's Journey through SQL Server

Back to calendar

Event Date: 12-08-2017 - Session time: 15:15:00 - Track: Database Development Administration

Speaker: Shamil Sadique

Title: A JSON's Journey through SQL Server

Abstract:

This session talks about the newly introduced built-in JSON support of SQL Server. Session will compare the JSON support offered with that of the XML support, comparing and contrasting them on different aspects. Also will walkthrough the new functions introduced with regards to JSON support, performance aspects and real world scenarios on how to get the best out of this feature.

SessionID: 67695

Getting started with SQL Server in Azure

Back to calendar

Event Date: 12-08-2017 - Session time: 15:15:00 - Track: Cloud Mobile

Speaker: Rushabh Mehta

Title: Getting started with SQL Server in Azure

Abstract:

Azure offers a range of data management technologies and options with the promise of no maintenance overhead. In this session, we will learn about the 2 flavors of SQL Server data platform available in Azure and deep dive into how you can start taking advantage of Azure SQL DB to complement your on-premise data management solutions and how you can build a strategy for moving to the cloud.

SessionID: 67714

The Great Data Panel Discussion

Back to calendar

Event Date: 12-08-2017 - Session time: 16:30:00 - Track: General Other

Speaker: Dinesh Priyankara

Title: The Great Data Panel Discussion

Abstract:

A panel discussion on SQL Server, Business Intelligence and Analytics topics featuring all the speakers of SQLSaturday Sri Lanka. Ask them the questions that you want! The ultimate finale to a day of learning awesomeness! The best way to summarize what you learnt throughout the day!

This site is open source. Improve this page.