SQLSaturday #784 - Singapore 2018
SQL Server on Linux High Availability Features and Considerations
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
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.
SQL Server Developer Tricks
Event Date: 18-08-2018 - Session time: 10:00:00 - Track: Track 1
Speaker: Amit R S Bansal
Title: SQL Server Developer Tricks
Session will cover a few cool SQL Server tricks for Developers
Fundamentals of Block chain Development
Event Date: 18-08-2018 - Session time: 10:00:00 - Track: Track 2
Speaker: Senthamil V
Title: Fundamentals of Block chain Development
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.
Tune Like a Guru - The Big Three!
Event Date: 18-08-2018 - Session time: 11:00:00 - Track: Track 2
Speaker: Kevin Boles
Title: Tune Like a Guru - The Big Three!
Business Intelligence Solutions in Azure
Event Date: 18-08-2018 - Session time: 11:00:00 - Track: Track 1
Speaker: David Alzamendi
Title: Business Intelligence Solutions in Azure
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.
A Database Designer's Favorite Features: Security,Privacy More
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
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.
Real-Time Analytics with Power BI
Event Date: 18-08-2018 - Session time: 13:00:00 - Track: Track 2
Speaker: Manohar Punna
Title: Real-Time Analytics with Power BI
In this session
- I will dive deep into real-time analytics with Power BI.
- How to build streaming tiles in Power BI Dashboards.
- Demo using Power BI REST APIs.
- Demo using Azure Event Hub and Azure Stream Analytics.
How to Maintain the Same Level of utilities in Cloud Deployments
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
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.
Accelerating and modernizing data integration with Azure Data Factory
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
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.
Graph Databases with Azure Cosmos DB
Event Date: 18-08-2018 - Session time: 14:00:00 - Track: Track 3
Speaker: Patrick Flynn
Title: Graph Databases with Azure Cosmos DB
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.
Want to move your data to Cloud ? what are your options?
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?
Don’t be naive, Learn machine learning algorithms
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
Following session will provide an overview on Machine Learning
MS BI + AI experiences: Using PBI, Azure AML across industries
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
Use case in presentation is from discrete manufacturing (part 2)/ higher education industries, with following summary:
The relative ease with which Power BI and SQL Azure can be used and integrated to design and simulate performance of machine elements
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
Output from physical tests of designs can be analyzed using ML to validate relationships and can be used to predict actual performance
Trend Analysis of SQL Server Logs using Powershell!
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!
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.