|Start Time (24h)||Speaker||Track||Title|
|09:00:00||Dinesh Priyankara||Application Database Development||Ways of securing your data - SQL Server Security Features (On-Prem and Azure)|
|10:00:00||Hemantgiri Goswami||Enterprise Database Administration Deployment||Battle Tested Monitoring for Always On Availability Groups|
|11:10:00||Patrick Flynn||Enterprise Database Administration Deployment||Time to Solve your VLDB problems - Managed Instance Hyperscale Edition|
|13:30:00||Sandeep Arora||Advanced Analysis Techniques||Bigdata: Into the multi-cloud-verse|
|14:30:00||Anil Maharjan||Analytics and Visualization||Microsoft Power BI, Python to visualize and predict connected car.|
|15:45:00||Shree Khanal||Enterprise Database Administration Deployment||What's New: Modernizing on SQL Server 2019|
Event Date: 30-11-2019 - Session time: 09:00:00 - Track: Application Database Development
Event Date: 30-11-2019 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment
SQL Server in your organization. You've also implemented one of the coolest High Availability feature – Always On Availability Group. However, you are not sure if you are monitoring everything that you should and you don't have a commercial tool to help. Lately, there were some issues reported where you have seen AG is lagging behind, and it has eaten up your time and effort analyzing what went wrong I can help you here!! I can share some of the monitoring scripts that I have written, and I can show you some monitoring tips that can help you. I would also like to help you with some of the metrics/counters that you would like to capture for analysis to make sure your Always On Availability Group is healthy. These are the things that you would love to try and implement in your environment. By the way, have you ever think of getting this monitoring via a Power BI tool? If not, ready to see the repo
Event Date: 30-11-2019 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
Included in the Managed Instance Service Tiers is the new Hyperscale Storage layer. Built from the ground up to take advantage of Cloud scalability this option offers an entirely new architecture than can resolve the issue with Very Large Databases (VLDB)
In this session we will explore
What exactly are Azure Managed Instances What the new Hyperscale storage layer is. How it resolves VLDB issues and allows SQL Server to scale to 100TB+
Attendees will come away with an understanding of what Azure Managed Instance HyperScale offers and where it makes sense to consider it.
Event Date: 30-11-2019 - Session time: 13:30:00 - Track: Advanced Analysis Techniques
Cloud Computing offers access to data storage, processing, and analytics to handle the data volume but how do you decide which platform one to choose? Following up on the last year's The Battle of DBAAS – RDS vs Cloud SQL vs SQL Azure, this time around, we will explore the big data solutions provided by the leading cloud platforms, AWS, GCP and Microsoft Azure, and compare key features such as the types of the services on the offer, Data Storage Options, Data Processing Options, Infrastructure Design Challenges, Performance Indicators, Pricing and Data Security on the cloud.
Event Date: 30-11-2019 - Session time: 14:30:00 - Track: Analytics and Visualization
From this session one can learn how can we make some simple and quick visualization using Power BI desktop taking IOT Sensors data and publish into PowerBI Service and find out the different possible scenarios in a smarter city with connected cars. Also, this session mainly helps to tell the story of connected car. Overall, by using Power BI and Python and Azure ML how one can use analytics and prediction. So, this session will surely help one to learn regarding Power BI, Python and Azure ML and its capabilities.
Event Date: 30-11-2019 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment