SQLSaturday #784 - Singapore 2018

Event Date: 08/18/2018 00:00:00

Event Location:

  • Microsoft Singapore Operations Pte Ltd
  • #22-01 One Marina Boulevard
  • Singapore, Singapore, Singapore

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


This is a list of sessions from the event, based on the schedule in the XML files.

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.


  • Manohar Punna

Track and Room: Track 2 - L21-MPR02

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.


  • Patrick Flynn

Track and Room: Track 3 - L22-CF15

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.


  • Karen Lopez

Track and Room: Track 3 - L22-CF15

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.


  • Dinesh Priyankara

Track and Room: Track 1 - L21-MPR01

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.


  • David Alzamendi

Track and Room: Track 1 - L21-MPR01

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

Abstract: Following session will provide an overview on Machine Learning


  • Sarbjit Singh

Track and Room: Track 2 - L21-MPR02

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.


  • Asanka Padmakumara

Track and Room: Track 1 - L21-MPR01

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.


  • Denny Cherry

Track and Room: Track 3 - L22-CF15

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.


  • Jason Aw

Track and Room: Track 3 - L22-CF15

Title: SQL Server Developer Tricks

Abstract: Session will cover a few cool SQL Server tricks for Developers


  • Amit R S Bansal

Track and Room: Track 1 - L21-MPR01

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


  • Sanjiv Venkatram

Track and Room: Track 2 - L21-MPR02

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


  • Kevin Boles

Track and Room: Track 2 - L21-MPR02

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.


  • Dharmendra Keshari

Track and Room: Track 3 - L22-CF15

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.


  • Senthamil V

Track and Room: Track 2 - L21-MPR02


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Sarbjit Singh

Twitter: - https://twitter.com/sarbjitgill

LinkedIn: Sarbjit Singh

Contact: https://mvp.microsoft.com/en-us/PublicProfile/4040012?fullName=Sarbjit%20%20Singh

Sarbjit brings 24 years of IT experience spanning assessments, consulting, implementation and training for a wide range of Microsoft technologies from mid 1990s to 2017. Sarbjit has cross-functional experience serving customer environments across a wide range of industries. Financial, Public Sector, Telecommunication, Media, Energy, Transport and Healthcare sectors.

Sarbjit have had experience leading and working with culturally diverse international teams across US, Europe, Asia Pacific and ANZ regions delivering business transformation outcomes for client organizations. Sarbjit now runs experience4live.com as a life coach and is a FIA licensed race car driver, underwater photography and videography and travels.

Denny Cherry

Twitter: - mrdenny

LinkedIn: Denny Cherry

Contact: https://www.dcac.com

Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.

Amit R S Bansal

Twitter: - A_Bansal

LinkedIn: Amit R S Bansal

Amit R. S. Bansal is a SQL Server Specialist at SQLMaestros. He leads the SQL Server practice with a focused team providing consulting, training, and content development services to more than 160+ SQL customers globally. He frequently speaks at international conferences on SQL Server performance tuning, which is his core expertise. Amit is also honored with Microsoft Regional Director status, MVP award, and Microsoft Certified Master of SQL Server credential. Amit has been working with SQL Server since 1999 and has been part of countless mission-critical SQL deployments. Performance Tuning in SQL Server is his core area of expertise. To learn more about Amit, visit http://sqlmaestros.com/amit-bansal.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Karen Lopez

Twitter: - @datachick

LinkedIn: Karen Lopez

Contact: http://datamodel.com

Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.

Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”

Dharmendra Keshari

LinkedIn: Dharmendra Keshari

Contact: http://dharmendrakeshari.com/

Dharmendra Keshari has strong and in-depth experience in Database Management. Currently, working as Senior Database Administrator at Micron Technology in Singapore and handling one of the most critical databases which are being used by Singapore Public Hospitals, national specialty centres and polyclinics. Dharmendra is an avid, regular mentor on social media, helping several enthusiast in solving their problems related to Database management. he is co-leader and regular speaker at Singapore SQL Server Pass Chapter (User Group). He has done certification for “Microsoft SQL Server#174; 2008, Implementation” and “Maintenance amp; Administering Microsoft SQL Server 2012 Database”.

Dinesh Priyankara

Twitter: - http://twitter.com/dinesh_priya

LinkedIn: Dinesh Priyankara

Contact: http://dinesql.blogspot.com/

Dinesh is an experienced professional and database enthusiast with skills in database management systems and business intelligence. Possessing over 18 years of experience on data related technologies, he does training, consulting, and is a top contributor to the local SQL Server community. In recognition of his contributions and expertise he has demonstrated, he was awarded the Microsoft Most Valuable Professional (MVP) award for SQL Server for 13 consecutive years since 2006. He is a Subject Matter Expert on SQL Server exams and has contributed for SQL Server 2012, 2016, 2017 and Azure Data Engineering exam development and Job Task Analysis (JTA). Dinesh is the Founder/Principal Architect of dinesQL (Pvt) Ltd (http://dinesql.com). In his

David Alzamendi

Twitter: - techtalkcorner

LinkedIn: David Alzamendi

Contact: https://www.techtalkcorner.com

Delivering Business Intelligence and Data Analytics Solutions with On-Premises and Cloud technologies since 2011, David Alzamendi is a Microsoft Certified Solutions Expert and event speaker who solves problems with best practice procedures and the latest technology.

David is passionate about the positive impact data can have on our lives, businesses, economy and the environment. He prides himself on using his creativity and optimism to solve what others thought impossible.

Asanka Padmakumara

Twitter: - asanka_e

LinkedIn: Asanka Padmakumara

Contact: https://asankap.wordpress.com/

Asanka is an experienced data engineer who is currently performing the role of Business Intelligence Consultant in Qrious. He has worked close to 10 years in BI and data analytics field and has implemented BI solutions for different industries. As a technology enthusiastic, he enjoys conducting technical presentations both locally and internationally. He is a MCSE in Data Management and Analytics as well as a Microsoft certified Azure Data Engineer. He is passionate about Data Analytics, Business Intelligence and AI related technologies.

Sanjiv Venkatram

LinkedIn: Sanjiv Venkatram

Background in financial planning and analysis, sales analytics, program management and engineering. Over 20 years of experience in IT Cloud Services/Software, IT Professional Services and Automotive Electronics Hardware. Worked across North America (17 years) and now APAC (3.5 years).

MBA from the University of Michigan (2003) and Master of Science in Mechanical Engineering from the University of Rhode Island (1997). Hold 7 published US patents.

Senthamil V

Twitter: - @altfo

Contact: https://msisgreat.net

Microsoft MVP on Windows Development. SharePoint is my profession and Windows Dev is my Passion

Jason Aw

LinkedIn: Jason Aw

Contact: http://www.sios-apac.com/

A passionate IT leader with over 20 years of experience in in technology, infrastructure, cloud environments particularly with high availability and disaster recovery solutions for different architectures including SQL database applications.

Patrick Flynn

Twitter: - sqllensman

Contact: http://sqllensman.com/blog/

Patrick Flynn is a Senior Database Administrator with 10 years experience in large 24 x 7 enterprise environments. He is a certified master for SQL Server and a regular attendee of the PASS Summit.

Has presented at SQLSaturday events in Sydney, Melbourne, Brisbane and Auckland, Edmonton and Calgary, Oslo and Cambridge

Manohar Punna

Twitter: - ManuSQLGeek

LinkedIn: Manohar Punna

Contact: http://www.sqlservergeeks.com/author/manoharpunna/

Manohar Punna is an Data Platform Geek and Vice President of DataPlatformGeeks by passion and a Data Platform Consultant by profession. He is a speaker at various conferences like PASS Summit, SQLBits, DPS. He has authored over 150 blogs and has written a One DMV a Day series which is a longest one day series on any topic on SQL Server till date. Manohar is a product of this community and strongly believes in giving back to the community. So, ask him anything you would like to know and he is happy to learn it with you.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page