sqlsathistory

Nr: 902

Back to Main list

SQLSaturday #902 - Nepal 2019

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

SessionID: 100137

Ways of securing your data - SQL Server Security Features (On-Prem and Azure)

Back to calendar

Event Date: 30-11-2019 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Dinesh Priyankara

Title: Ways of securing your data - SQL Server Security Features (On-Prem and Azure)

Abstract:

Regardless of the platform, securing data is a must and it cannot be easily ignored. There are many techniques for securing data and databases and, SQL Server and Azure SQL database offer a good collection of features that can be used for protecting the database. Let's have a look on these with demos, for understanding them and picking the best for the situation.

SessionID: 95535

Battle Tested Monitoring for Always On Availability Groups

Back to calendar

Event Date: 30-11-2019 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Hemantgiri Goswami

Title: Battle Tested Monitoring for Always On Availability Groups

Abstract:

You are the go-to guy for your company. You are not only coding but also administering

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

SessionID: 94563

Time to Solve your VLDB problems - Managed Instance Hyperscale Edition

Back to calendar

Event Date: 30-11-2019 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Patrick Flynn

Title: Time to Solve your VLDB problems - Managed Instance Hyperscale Edition

Abstract:

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.

SessionID: 95978

Bigdata: Into the multi-cloud-verse

Back to calendar

Event Date: 30-11-2019 - Session time: 13:30:00 - Track: Advanced Analysis Techniques

Speaker: Sandeep Arora

Title: Bigdata: Into the multi-cloud-verse

Abstract:

Data analytics returns more value and uncover profound business insights but as the data grows how do you find a scalable, flexible, cost-effective, and even secure platform for this exponentially growing data?

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.

SessionID: 99104

Microsoft Power BI, Python to visualize and predict connected car.

Back to calendar

Event Date: 30-11-2019 - Session time: 14:30:00 - Track: Analytics and Visualization

Speaker: Anil Maharjan

Title: Microsoft Power BI, Python to visualize and predict connected car.

Abstract:

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.

SessionID: 100161

What's New: Modernizing on SQL Server 2019

Back to calendar

Event Date: 30-11-2019 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Shree Khanal

Title: What's New: Modernizing on SQL Server 2019

Abstract:

SQL Server has been one of the leading industry database products for many years. SQL Server 2019 includes capabilities that maximize the engine to its full potential providing you a modern data platform. In this session, learn about new enhancements in SQL Server 2019 to maximize performance, security, and availability.