talk-data.com

A demo-centric session exploring defense-in-depth security strategies to safeguard Azure SQL Database. Learn practical techniques across multiple layers of protection, including Network Security, RBAC, Row-Level Security, Auditing, Advanced Threat Protection, and Encryption (TDE and Always Encrypted).

Defend the Core: Multi-Layered Security for Azure SQL in Action - Deepthi Goguri

Description

Are you considering migrating your databases to the cloud but concerned about ensuring complete data security? Whether your data is hosted on-premises or in the cloud, implementing strong, multilayered security is essential to protect the data tier of your applications.

In this demo-centric session, you'll explore how defense-in-depth security strategies can safeguard your Azure SQL Database. Through practical demonstrations, you'll learn how to apply proven techniques across multiple layers of protection.

Key Topics Covered:

Network Security – Learn best practices for securing your network and managing access controls. Azure Role-Based Access Control (RBAC) – Effectively assign and manage user permissions and roles. Row-Level Security – Enforce fine-grained access control to protect sensitive data within your database. Auditing – Monitor database activities to support compliance and accountability. Advanced Threat Protection – Detect, respond to, and mitigate potential security threats in real-time. Encryption Layers – Understand and implement encryption methods such as Transparent Data Encryption (TDE) and Always Encrypted. By the end of this session, you'll walk away with actionable insights and hands-on knowledge to make confident, informed decisions about securing your Azure SQL databases.

Please join us on 22nd August, 2024 to listen to the topic: Latest and greatest features in SQL Server 2022

What \~ Toronto Data Professionals Community (Virtual) When \~ Thursday, 22nd August, 2024

Agenda:

• 6:00 PM Networking and Introduction
• 6:15 PM Topic: Latest and greatest features in SQL Server 2022 with Deepthi Goguri
• 7:30 PM End

Where: Online via Microsoft team

Session Details: This session explores the exciting features of SQL Server 2022, showcasing how it empowers organizations to unlock new levels of performance, security, and scalability while simplifying data workflows. This session covers performance improvements in SQL Server 2022 like Intelligent Query Processing and adaptive query processing techniques to optimize query performance and enhance overall database efficiency. By attending this session, participants will gain a comprehensive understanding of the transformative capabilities of SQL Server 2022. They will learn how these advancements enable organizations to optimize performance, enhance security, ensure scalability, and streamline data management and analysis workflows. Armed with this knowledge, attendees can leverage SQL Server 2022.

Speaker Bio: Deepthi is a SQL Server Database Administrator with several years of experience in Administering SQL Servers. She is a Microsoft Data Platform MVP, Microsoft certified trainer and Microsoft certified professional with an Associate and Expert level Certification on Data Management and Analytics. Deepthi blogs for http://DBANuggets.com. Deepthi is an Co-Organizer for Microsoft Data and AI South Florida user group and Data Platform Diversity, Equity, and Inclusion Virtual Group. She is a Volunteer for Data platform Women in Technology user group. She is a Friend of Redgate. Along with this, Deepthi loves arts and crafts. You can contact her on Twitter @dbanuggets

Please note that this event is also live-streamed on YouTube: https://youtube.com/c/transmokopter/streams

--

In today's data-driven world, organizations face the challenge of effectively managing and extracting insights from vast amounts of data while ensuring compliance with regulations and maintaining data security. Azure Purview, Microsoft's cutting-edge data governance and discovery platform, emerges as a transformative solution to address these challenges.

This session will provide an overview of Azure Purview and its key capabilities, focusing on how it enables organizations to unleash the power of their data assets. By the end of this session, attendees will learn how to establish a comprehensive data catalog that provides a single source of truth for all data assets, enhancing data understanding and governance practices.

Performance features in SQL Server 2022

Description

This session explores the exciting features of SQL Server 2022, showcasing how it empowers organizations to unlock new levels of performance, security, and scalability while simplifying data workflows. This session covers performance improvements in SQL Server 2022 like Intelligent Query Processing and adaptive query processing techniques to optimize query performance and enhance overall database efficiency. By attending this session, participants will gain a comprehensive understanding of the transformative capabilities of SQL Server 2022. They will learn how these advancements enable organizations to optimize performance, enhance security, ensure scalability, and streamline data management and analysis workflows. Armed with this knowledge, attendees can leverage SQL Server 2022.

The final meetup of 2023 will be a set of lightning talks from speakers all over the world.

You can visit the schedule here:

Be aware, the times are in UTC! Timezones are very hard, ask me how I keep learning that...

thankful-field-057fcc110.4.azurestaticapps.net/Index.html

The event kicks off at 16:00 UTC, 17:00 GMT+1, order of speakers:

Deepthi Goguri Sarath Sasidharan Koen Verbeeck Roy Menger Javier Villegas Jon Vöge Hugo Kornelis John Miner

WHEN: Wednesday, November 8, 2023, 1700 GMT

DESCRIPTION of TALK

Title: Get the best of the Query Store

Query optimization is an important part of a Database Administrator job. Query store feature is used to identify and fix the query performance issues. In this Demo-centric presentation, we will take a deep dive into mastering the Query Store feature and its latest enhancements in SQL Server 2022 and in Azure SQL database. This session will cover the advantages of Query Store, Automatic plan correction in SQL Server and in Azure SQL database, Query hints with real time scenarios and examples. Attendees will leave this presentation with a solid understanding of Query Store and how to use it to optimize query performance in both SQL Server 2022 and Azure. They will also learn best practices for using Query Store to identify and troubleshoot performance issues, and how to leverage this feature for maximum Query performance.

In this session, Learn about what is Azure Arc Enabled SQL Server. How your SQL Server can connect to Azure Arc and how beneficial to have a central location to view your Servers. If you are using SQL Server 2022, after you register your server to Azure Arc, you can enable the Azure AD for the SQL Server. This session will show you a step by step process of how you can enable Azure AD to on-prem SQL Server but also show you how you can connect to Azure AD from the SQL Server on Virtual VM. By the end of this session, audience will have the knowledge to follow the steps, enable the Azure Arc in their environemnts and leverage this feature to fullest.

Presentation Title: All about performance in Azure SQL Databases

Description: Once you deploy your database in Azure, you need to make sure you are always increasing the tiers and paying more for the performance of your database. Just like you tune your databases on-prem, you need to focus on optimizing your database for performance. But how do we achieve this in Azure? Let's dedicate this session to mainly focus on the ways that you can optimize and tune your Azure data solutions so you can save money being on Azure and get fast response times for your queries.

Bio: Deepthi Goguri SQL Database Administrator

Deepthi is a SQL Server Database Administrator with several years of experience in Administering SQL Servers. She is a Microsoft Data Platform MVP, Microsoft certified trainer and Microsoft certified professional with an Associate and Expert level Certification on Data Management and Analytics. Deepthi blogs for DBANuggets.com. Deepthi is an Co-Organizer for Microsoft Data and AI South Florida user group and Data Platform Diversity, Equity, and Inclusion Virtual Group. She is a Volunteer for Data platform Women in Technology user group. She is a Friend of Redgate. Along with this, Deepthi loves arts and crafts. You can contact her on Twitter @dbanuggets.

Join Our LinkedIn Groups: • https://www.linkedin.com/groups/12485934/ • https://www.linkedin.com/groups/12531517/

Follow Our LinkedIn Pages: • https://www.linkedin.com/company/clouddatadriven/ • https://www.linkedin.com/company/futuredatadriven • https://www.linkedin.com/company/data-driven-community

Follow Us: • https://twitter.com/CloudDataDriven • https://www.eventbrite.com/u/507632298011

Join Our Meetup Group: • https://www.meetup.com/cloud-data-driven/