sqlsathistory

Nr: 784

Back to Main list

SQLSaturday #784 - Singapore 2018

Start Time (24h)	Speaker	Track	Title
10:00:00	Jason Aw	Track 3	SQL Server on Linux High Availability Features and Considerations
10:00:00	Amit R S Bansal	Track 1	SQL Server Developer Tricks
10:00:00	Senthamil V	Track 2	Fundamentals of Block chain Development
11:00:00	Kevin Boles	Track 2	Tune Like a Guru - The Big Three!
11:00:00	David Alzamendi	Track 1	Business Intelligence Solutions in Azure
11:00:00	Karen Lopez	Track 3	A Database Designer's Favorite Features: Security,Privacy More
13:00:00	Manohar Punna	Track 2	Real-Time Analytics with Power BI
13:00:00	Denny Cherry	Track 3	How to Maintain the Same Level of utilities in Cloud Deployments
13:00:00	Dinesh Priyankara	Track 1	Accelerating and modernizing data integration with Azure Data Factory
14:00:00	Patrick Flynn	Track 3	Graph Databases with Azure Cosmos DB
14:00:00	Asanka Padmakumara	Track 1	Want to move your data to Cloud ? what are your options?
14:00:00	Sarbjit Singh	Track 2	Don’t be naive, Learn machine learning algorithms
15:30:00	Sanjiv Venkatram	Track 2	MS BI + AI experiences: Using PBI, Azure AML across industries
15:30:00	Dharmendra Keshari	Track 3	Trend Analysis of SQL Server Logs using Powershell!

SessionID: 82342

SQL Server on Linux High Availability Features and Considerations

Back to calendar

Event Date: 18-08-2018 - Session time: 10:00:00 - Track: Track 3

Speaker: Jason Aw

Title: SQL Server on Linux High Availability Features and Considerations

Abstract:

With SQL Server on Linux, Microsoft brings SQL Server’s core relational database engine to the growing enterprise Linux ecosystem. High Availability and Disaster Recovery (HADR) are aspects of SQL Server that are critically important and in this session we discuss the features, limitations and options for High Availability and how SANless clustering can ensure proper functionality, availability and reliability for SQL Server on Linux, on-premise and in the Azure cloud.

SessionID: 84241

SQL Server Developer Tricks

Back to calendar

Event Date: 18-08-2018 - Session time: 10:00:00 - Track: Track 1

Speaker: Amit R S Bansal

Title: SQL Server Developer Tricks

Abstract:

Session will cover a few cool SQL Server tricks for Developers

SessionID: 85284

Fundamentals of Block chain Development

Back to calendar

Event Date: 18-08-2018 - Session time: 10:00:00 - Track: Track 2

Speaker: Senthamil V

Title: Fundamentals of Block chain Development

Abstract:

In this session you will learn about technical details of blockchain. Basics of data hashing and keys. I will also discuss how to do development on ethereum platform.

SessionID: 82414

Tune Like a Guru - The Big Three!

Back to calendar

Event Date: 18-08-2018 - Session time: 11:00:00 - Track: Track 2

Speaker: Kevin Boles

Title: Tune Like a Guru - The Big Three!

Abstract:

EVERY client I engage with is taught to RUN 3 SCRIPTS IMMEDIATELY, WITHOUT THOUGHT AND WITHOUT DELAY as soon as a performance problem is noted. I am exceptionally good at performance tuning and forensics, but I (nor anyone else out there) cannot get at the root cause of a problem without information about the occurrence. These scripts will give you said information (which is very often transient in nature)! I could be putting myself out of work teaching stuff like this! :-D

SessionID: 82492

Business Intelligence Solutions in Azure

Back to calendar

Event Date: 18-08-2018 - Session time: 11:00:00 - Track: Track 1

Speaker: David Alzamendi

Title: Business Intelligence Solutions in Azure

Abstract:

When the number of services is more than 600 in Azure, many questions arise surrounding the different services that can be included in a Business Intelligence Architecture. This session will cover traditional as well as modern Business Intelligence solutions taking advantage of technologies such as Azure HDInsight, Azure Data Lakes or Azure Event Hubs.

I will go over the characteristics of the main services that can be implemented in a Business Intelligence solution in the cloud. The demo will include 5 of these services.

SessionID: 84433

A Database Designer's Favorite Features: Security,Privacy More

Back to calendar

Event Date: 18-08-2018 - Session time: 11:00:00 - Track: Track 3

Speaker: Karen Lopez

Title: A Database Designer's Favorite Features: Security,Privacy More

Abstract:

The launch of SQL Server 2016 means there will be a lot of blog posts and webinars of people talking about all the great administration features that come with this new release. In this session, Karen will be discussing the newer SQL Server features from a database designers point of view, including: - Dynamic Data Masking - Always Encrypted - Row Level Security - Deprecated Features - Data Type Seleciton We'll look at the new features, why you should consider them, where they work, where they don't, who needs to be involved in using them, and what changes, if any, need to be made to applications or tools that you use with SQL Server.

SessionID: 82347

Real-Time Analytics with Power BI

Back to calendar

Event Date: 18-08-2018 - Session time: 13:00:00 - Track: Track 2

Speaker: Manohar Punna

Title: Real-Time Analytics with Power BI

Abstract:

Power BI helps you build appealing visualizations of your data. With ever growing footprint of data it is equally important to get real-time insights into your data. It can be as simple as monitoring a single metric or viewing real-time sales performance across multiple locations. Power BI real-time streaming enables you to stream data and update dashboards in real-time. Any time sensitive data can be a source of streaming data set like IoT sensor devices, social media sources, service usage metrics etc.

In this session

1. I will dive deep into real-time analytics with Power BI.
2. How to build streaming tiles in Power BI Dashboards.
3. Demo using Power BI REST APIs.
4. Demo using Azure Event Hub and Azure Stream Analytics.

SessionID: 82454

How to Maintain the Same Level of utilities in Cloud Deployments

Back to calendar

Event Date: 18-08-2018 - Session time: 13:00:00 - Track: Track 3

Speaker: Denny Cherry

Title: How to Maintain the Same Level of utilities in Cloud Deployments

Abstract:

In this session we will review the differences between deploying Microsoft SQL Server 2016 in Microsoft Azure and on-premises from a Security, Reliability and Scalability perspective.

We'll review the common mistakes which people make when deploying SQL Server Virtual Machines to Azure which can lead to security problems including data breaches.

We'll review the common performance problems which people encounter, and how to resolve them.

We'll review the common scalability misunderstandings of Azure and SQL Server Virtual Machines.

Join us for this fun session and learn how to improve the security, reliability and scalability of your Azure deployments of SQL Server 2016.

SessionID: 83792

Accelerating and modernizing data integration with Azure Data Factory

Back to calendar

Event Date: 18-08-2018 - Session time: 13:00:00 - Track: Track 1

Speaker: Dinesh Priyankara

Title: Accelerating and modernizing data integration with Azure Data Factory

Abstract:

Integration Services (aka SSIS) has been serving us for years for building enterprise data integration solutions, not only for data warehousing but for all types of data integrations between heterogenous data sources. SSIS is not retiring but it is high time to check out its new neighbor; Azure Data Factory, fully managed ETL service in the cloud. Let me show you how we can use Azure Data Factory for implementing modern data integrations for on-premise and cloud sources with various type of transformations available including Azure services such as Azure Data Lake Analytics, HDInsight and Machine Learning.

SessionID: 82944

Graph Databases with Azure Cosmos DB

Back to calendar

Event Date: 18-08-2018 - Session time: 14:00:00 - Track: Track 3

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

Want to move your data to Cloud ? what are your options?

Back to calendar

Event Date: 18-08-2018 - Session time: 14:00:00 - Track: Track 1

Speaker: Asanka Padmakumara

Title: Want to move your data to Cloud ? what are your options?

Abstract:

Due to certain limitations of On-Prem Solutions, people have started to move their data to Cloud. Since Azure provide unlimited storage and processing power, most organizations have started to use Azure data related technologies in their Big Data and Analytical Solutions. However, Azure offers different options when it comes to Big Data,Data Analytic and Data Storage. In this session , I will cover what are the best suited options when it come to your data requirements and comparison between Azure Data related technologies.

SessionID: 84243

Don’t be naive, Learn machine learning algorithms

Back to calendar

Event Date: 18-08-2018 - Session time: 14:00:00 - Track: Track 2

Speaker: Sarbjit Singh

Title: Don’t be naive, Learn machine learning algorithms

Abstract:

Following session will provide an overview on Machine Learning

SessionID: 84432

MS BI + AI experiences: Using PBI, Azure AML across industries

Back to calendar

Event Date: 18-08-2018 - Session time: 15:30:00 - Track: Track 2

Speaker: Sanjiv Venkatram

Title: MS BI + AI experiences: Using PBI, Azure AML across industries

Abstract:

Use case in presentation is from discrete manufacturing (part 2)/ higher education industries, with following summary:

1. The relative ease with which Power BI and SQL Azure can be used and integrated to design and simulate performance of machine elements

2. Power BI and SQL Azure can be used to replace “design handbooks” which typically are paper based or static on a SharePoint – now these can be made “live” by leverage Power BI and SQL Azure

3. Output from physical tests of designs can be analyzed using ML to validate relationships and can be used to predict actual performance

SessionID: 85285

Trend Analysis of SQL Server Logs using Powershell!

Back to calendar

Event Date: 18-08-2018 - Session time: 15:30:00 - Track: Track 3

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.

This site is open source. Improve this page.