22-25 April 2026 
SQLBits 2022
Applying a Security Mindset to Lockdown Azure SQL Database
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.
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.
feedback link: https://sqlb.it/?7075
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.
feedback link: https://sqlb.it/?7075
Speakers
Surbhi Pokharna's previous sessions
Snowflake concepts & architecture
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.
Applying a Security Mindset to Lockdown Azure SQL Database
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.
Different dimensions of monitoring and tuning performance for Azure SQL
Azure SQL performance capabilities, how to configure and maintain your Azure SQL for higher performance. We will explore various monitoring tools and pick few scenarios for deeper troubleshooting. In this demo centric session, we will tune our database and find an optimal ground to manage cost. We will generate Power BI powered database score card for trend analysis.