Surbhi Pokharna
Charles River Development, Director, Cloud Data Platform Services
Boston, Massachusetts, United States
Actions
Surbhi is a data professional with over two decades of architectural/administration experience in the financial domain. Architecting the operationalization aspect in a client-facing role, delivering relational and advanced analytics solutions for large scale Operational and Data Warehouse implementations with focus on learning and innovation remained a constant part of her data journey. Currently she is leading enterprise scale cloud data migrations in SQL Server/Snowflake/Azure SQL/Managed Instance and involved with designing next generation Data Analytics solutions using Snowflake. Surbhi is board member of the New England SQL Server User Group, member of PASS, speaker in PAAS Summit/Snowflake User Group/Azure Data User Groups/Data Saturdays/SQLBits.
Links
Awards
Area of Expertise
Topics
Snowflake concepts and architecture for data professionals
Cloud databases bring a new set of performance and cost benefits. In this session, we’ll learn Snowflake architecture and basic concepts, what makes Snowflake ideal for large-scale data warehousing. We’ll begin with the concepts of PaaS and how that applies to databases in particular. We’ll see how Snowflake’s design allows for high performance at low cost. We will also talk about what makes Snowflake unique compared to other cloud databases. Each step of the way we will have demos to show you how to implement Snowflake in Azure cloud. By the end of this session, you’ll be able to compare Snowflake to other tools like SQL Server and have a good idea about concepts and architecture of the Snowflake ecosystem.
Principles of architecting a cloud data migration
Is your company planning to move your on-prem, hosted application to cloud? Have you been asked to assess your on-prem data workload and design the new castle in the cloud?
Designing the new castle is important aspect but also this is more important to live happily in that castle ones you migrate to cloud. That’s where the art of architecting the operationalization aspect come into play.
In this demo centric session, we will understand the fundamental building blocks of migrating on-prem SQL server workload to cloud via lift and shift or to Azure SQL/Managed Instance. We will build our hierarchy of needs checklist, a secured data migration plan and perform a sample migration to IaaS and PaaS Azure SQL databases keeping Data Security, Size, Performance, and Cost aspects in mind. By the end of this session, you will have good idea on how to execute a secured and scalable cloud data migration solution.
Monitoring and tuning performance for SQL Server 2022 and Azure SQL databases
You moved to the Azure SQL or Managed Instance or SQL Server 2022 Database, so your job is done - right? No, you still need to monitor and performance tune your database.
It can be overwhelming having to learn a whole new set of tools and new performance constraints. In the cloud improving performance can directly lower your costs, making it important to manage and optimize.
In this demo centric session, we will show you how to monitor and troubleshoot Azure SQL/Managed Instance/SQL Server 2022 database performance issues. We will assess new performance features in these relational engines from the lenses of performance troubleshooting. And we will also see how to juggle between cost and performance to find the optimal ground with low cost and high performance of your database with scalability.
After this session you would be empowered with knowledge and tools to monitor and tune your Azure SQL, Managed Instance and SQL Server 2022 database.
Different dimensions of monitoring and tuning performance for Azure SQL
You moved to the Azure SQL Database, so your job is done - right? No, you still need to monitor and performance tune your database.
It can be overwhelming having to learn a whole new set of tools and new performance constraints. In the cloud, improving performance can directly lower your costs, making it important to manage and optimize.
In this demo centric session, we will show you how to monitor and troubleshoot Azure SQL/Managed Instance database performance issues. We will see the differences between on-prem SQL Server Vs Azure SQL/Managed Instance cloud database performance troubleshooting. And we will also see how to juggle between cost and performance to find the optimal ground with low cost and high performance of your Azure SQL database with scalability. We will generate Power BI powered database scorecards for trend analysis.
After this session you would be empowered with knowledge and tools to monitor and tune your Azure SQL database.
Building Secured and Scalable IoT solution with Azure SQL database
The IoT is here to give the power of things over to human just in a SMART way.
There are endless daily life examples: “Helmet Sensor ‘Calls Your Loved Ones’ in a Bike Crash”, “A location sensor aka ‘real-world search bar’ to easily find misplaced items, like keys and TV remotes” etc.etc
Building such IoT solutions include several components like device communication, management, event processing, data ingestion and analysis. Azure SQL is one of the most secure and scalable database which can handle stream processing workloads effectively from our connected IoT device.
In this demo centric session, we will build an IoT solution using components like edge devices, IoT Hub, Azure Functions and Azure SQL database to store and analyze telemetry data.
We will review and configure key security aspects on Azure SQL database, then create disk-based or in-memory optimized tables for low latency and high throughput, to be queried and analyzed by Azure Stream Analytics. We will simulate heavy events ingestion workload and monitor performance.
After this session you would be empowered with knowledge and tools to build and manage Secured and Scalable IoT solutions using Azure SQL database.
Architect your cloud data workload to perform, scale and save $
You are planning cloud migration and wondering what should be the T-shirt size of your SQL Server in IaaS or Azure SQL/MI in PaaS. You are concerned if your workload be able to scale without making a hole in your company’s pocket!
Well, understanding the workload of your data intensive application and performance capabilities of Azure SQL is the first and very important stage. Based on the workload you need to pick T-shirt size or SKU/Service tier.
Picking right T-shirt size save cost, result into better performance, enough room to scale and less performance issues for your DBAs.
In this demo centric session, I will show you how to calculate your on-prem or cloud data workloads and pick a correct T-shirt size using various methods and tools like DMA, Query Store, DMVs.
Applying Security Mindset on Azure Synapse Analytics
Security is a large portion when planning building data strategy.
Securing multifaceted Azure Synapse Analytics is frustrating because how do you know when you are done? Azure Synapse Analytics scope is wide-range combining dedicated SQL pools, server less SQL pools, Spark pools. Meeting bare minimum of an auditor’s checklist is likely to leave gaps. The best option is to develop a security mindset and aim for building a multi-layered defense system approach.
In this talk, we will start with explaining Azure Synapse essentials, followed by demos for how to implement each layer of defense. This way, if one layer is breached, you aren’t left defenseless. We will review data life cycle from the lenses of security to protect data at rest, in transit, and data in use. Lastly, we will assess tools to intensify your security posture.
Applying a Security Mindset to Lockdown Azure SQL Database
Securing your database in the cloud is not an act but a mindset.
Securing a database is frustrating because how do you know when you are done? Meeting bare minimum of an auditor’s checklist is likely to leave gaps. The best option is to develop a security mindset and aim for building a multi-layered defense system approach.
In this talk, I will show you demos for how to implement each layer of defense. This way, if one layer is breached, you aren’t left defenseless. We will start at the outer layer with network access. Next, we will cover the authentication and authorization using Azure RBAC. Finally, we will protect the innermost layer with Data At Rest and Data In Transit encryption. Once these protections are in place, we’ll see how to monitor Azure SQL security ecosystem for intrusions with Advanced threat protection and more.
By the end of this talk, you will have a plan in play to implement multi-layer defense as well as monitoring for Azure SQL.
SQL Saturday Boston 2022 Sessionize Event
Future Data Driven Summit 2022 Sessionize Event
PASS Data Community Summit 2021 Sessionize Event
New Stars of Data #3 Sessionize Event
Surbhi Pokharna
Charles River Development, Director, Cloud Data Platform Services
Boston, Massachusetts, United States
Links
Actions
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top