sqlsathistory

Nr: 750

SQLSaturday #750 - Sri Lanka 2018

Start Time (24h)	Speaker	Track	Title
09:30:00	Dharmendra Keshari	Database Development Administration	Trend Analysis of SQL Server Logs using Powershell!
09:30:00	Dinesh Asanka	Business Intelligence Analytics	Text Analytics Solutions with Azure Machine Learning
10:50:00	Patrick Flynn	Database Development Administration	GITHUB 101 - An introduction to using Github and Git for Source Control and Open Source Projects
10:50:00	Asanka Padmakumara	Business Intelligence Analytics	Moving your on-prem data warehouse to cloud. What are your options?
12:00:00	Hamish Watson	Database Development Administration	DevOPs and the Data Professional
12:00:00	Anupama Natarajan	Business Intelligence Analytics	Creating and Exploring Power BI Report and Dashboard in one hour
14:00:00	Patrick Flynn	Database Development Administration	Graph Databases with Azure Cosmos DB
14:00:00	Nisal Mihiranga	Business Intelligence Analytics	Real-time Data Analytics using Microsoft Azure Stream Analytics and Power BI
15:10:00	Anupama Natarajan	Business Intelligence Analytics	Modern Data Warehouse using Lambda Architecture and Azure
15:10:00	Indika Dalugama	Database Development Administration	Azure SQL Database Services: What You Need to Know
16:30:00	Anupama Natarajan	Business Intelligence Analytics	Chalk Talk: Business Intelligence Analytics
16:30:00	Hamish Watson	Database Development Administration	Chalk Talk: Database Development Administration

SessionID: 84392

Trend Analysis of SQL Server Logs using Powershell!

Back to calendar

Event Date: 04-08-2018 - Session time: 09:30:00 - Track: Database Development Administration

Speaker: Dharmendra Keshari

Title: Trend Analysis of SQL Server Logs using Powershell!

Abstract:

DBAs regularly need to keep an eye on the error logs of all their SQL Servers.When server numbers get large, it becomes very difficult to manage them. If you don't maintaining the error logs, SQL Server will recycle the log and you are going to loose the valuable information. In this session, you will learn how to automatically parse the errors from multiple SQL error logs using PowerShell, store the data in a central location database, and create reports to visualize the information using PowerBI or Splunk.

SessionID: 84622

Text Analytics Solutions with Azure Machine Learning

Back to calendar

Event Date: 04-08-2018 - Session time: 09:30:00 - Track: Business Intelligence Analytics

Speaker: Dinesh Asanka

Title: Text Analytics Solutions with Azure Machine Learning

Abstract:

This session will focus on the Text Classification. There are broad applications of text classification: categorizing newspaper articles and news wire contents into topics, organizing web pages into hierarchical categories, filtering spam email, sentiment analysis, predicting user intent from search queries, routing support tickets, and analyzing customer feedback. The goal of text classification is to assign some piece of text to one or more predefined classes or categories.

SessionID: 80529

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

Back to calendar

Event Date: 04-08-2018 - Session time: 10:50:00 - Track: Database Development Administration

Speaker: Patrick Flynn

Title: GITHUB 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: 82099

Moving your on-prem data warehouse to cloud. What are your options?

Back to calendar

Event Date: 04-08-2018 - Session time: 10:50:00 - Track: Business Intelligence Analytics

Speaker: Asanka Padmakumara

Title: Moving your on-prem data warehouse to cloud. What are your options?

Abstract:

With the limitation and challenges faced during on-prem data warehousing projects, it can be observed that people have started to move their data warehouse to cloud. In this session, I will be covering why we need to move our DWs to cloud and what are the factors I should consider when doing so. Additionally this session will cover what are the possible option to move your DW in to cloud and what are the pros and cons in each approach. By participating to this session , you will gain good understanding about all possible options before making a decision.

SessionID: 83040

DevOPs and the Data Professional

Back to calendar

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

Speaker: Hamish Watson

Title: DevOPs and the Data Professional

Abstract:

You may have heard the word "DevOps" and wondered whether it is just another buzzword and/or what it can do for you.

In this session I will demystify the concepts of DevOps and we will look at how both BI, DEV and DBA Professionals can benefit from it.

Continuous Integration is the practice in which software developers frequently integrate their work with that of other members of the development team.It also involves automating tests around the integrated work

Continuous Delivery is the next step after Continuous Integration in the deployment pipeline and is the process of automating the deployment of software to test, staging, and production environments.

Due to their complexity database changes are an area that may not be typically automated or utilise DevOps.

Through the use of a comprehensive live demo to running databases hosted in Azure the audience will learn the benefits and how to implement DevOps processes in their database and BI deployment pipeline.

SessionID: 84484

Creating and Exploring Power BI Report and Dashboard in one hour

Back to calendar

Event Date: 04-08-2018 - Session time: 12:00:00 - Track: Business Intelligence Analytics

Speaker: Anupama Natarajan

Title: Creating and Exploring Power BI Report and Dashboard in one hour

Abstract:

In this session we will create a Power BI Report using Power BI Desktop, Azure SQL Database and incorporate Q and A, Custom Visualisations, Themes and explore the latest features that have been released in a past 6 months. It will be demo filled session and even if you know Power BI you will definitely learn something new from the session.

SessionID: 82269

Graph Databases with Azure Cosmos DB

Back to calendar

Event Date: 04-08-2018 - Session time: 14:00:00 - Track: Database Development Administration

Speaker: Patrick Flynn

Title: Graph Databases with Azure Cosmos DB

Abstract:

Graph Database technology is one of the fastest growing fields of database design and evelopment.

In SQL Server 2017 a new option to process Graph Data within the database engine was added. This was based around the Cypher Query language from Neo4J

At the same time a Graph Data API was added to Azure Cosmos DB (Microsoft's Globally Distributed Mult-Model cloud databse) This was built around the Apache TinkerPop graph traversal language, Gremlin

In this Session we will briefly look at use cases for Graph Database and then investigate how these have been implemented in Azure Cosmos DB.

This session is aimed at any developer/architect/DBA that is looking to understand Graph Database and how they have been implemented inside Microsoft's new Cloud based NoSQL database.

SessionID: 83357

Real-time Data Analytics using Microsoft Azure Stream Analytics and Power BI

Back to calendar

Event Date: 04-08-2018 - Session time: 14:00:00 - Track: Business Intelligence Analytics

Speaker: Nisal Mihiranga

Title: Real-time Data Analytics using Microsoft Azure Stream Analytics and Power BI

Abstract:

Stream Analytics is all about fast moving real-time data analytics where you can analyze the data near real-time in order to make actions before it is too late to do so. Ex: You may need to identify fraudulent credit card transaction in real time before making the payment. Similar to that, there are numerous real-world scenarios which we can apply Stream Analytics in order to solve problems more effectively and efficiently. Let's see how to perform Stream Analytics using Microsoft technologies like Azure Stream Analytics and Power BI

SessionID: 84438

Modern Data Warehouse using Lambda Architecture and Azure

Back to calendar

Event Date: 04-08-2018 - Session time: 15:10:00 - Track: Business Intelligence Analytics

Speaker: Anupama Natarajan

Title: Modern Data Warehouse using Lambda Architecture and Azure

Abstract:

Organisations capture huge volumes of data and they need actionable information to act on them proactively in real-time to stay competitive. This requires a different thinking from the conventional Data Warehouse Architecture to more Cloud based Data Processing Architecture where high volume batch and real-time processing can be achieved using optimal cost.

In this session you will learn about

Overview of Lambda Architecture
How Azure Services implement Lambda Architecture
Advantages of leveraging Azure for Lambda Architecture
Business Scenarios to consider Lambda Architecture

SessionID: 84851

Azure SQL Database Services: What You Need to Know

Back to calendar

Event Date: 04-08-2018 - Session time: 15:10:00 - Track: Database Development Administration

Speaker: Indika Dalugama

Title: Azure SQL Database Services: What You Need to Know

Abstract:

TBD

SessionID: 85060

Chalk Talk: Business Intelligence Analytics

Back to calendar

Event Date: 04-08-2018 - Session time: 16:30:00 - Track: Business Intelligence Analytics

Speaker: Anupama Natarajan

Title: Chalk Talk: Business Intelligence Analytics

Abstract:

A chalk talk session where you can discuss architecture, design and other aspects of business intelligence analytics solutions.

SessionID: 85061

Chalk Talk: Database Development Administration

Back to calendar

Event Date: 04-08-2018 - Session time: 16:30:00 - Track: Database Development Administration

Speaker: Hamish Watson

Title: Chalk Talk: Database Development Administration

Abstract:

A chalk talk session where you can discuss architecture, design and other aspects of database solutions and database administration.

This site is open source. Improve this page.