talk-data.com

Hosted by Amdaris, an Insight company - https://amdaris.com and sponsored by Data Masterminds - https://datamasterminds.io/

Data Masterminds will hold a free raffle to win a couple of ebooks - Learn dbatools in a Month of Lunches (manning.com)

Amdaris, an Insight company, is your trusted partner for high velocity extended delivery teams.

Data Masterminds is a leading Microsoft Data Platform consultancy and managed service provider to customers across the globe.

Location: Amdaris, Finzels Reach, Aurora, Bristol BS1 6BX

AGENDA

18.00 – 18:30 Meet & Greet

--------------

18:30 - 19:15 dba tools by Jess Pomfret

Folks - the wait is over! - REPLICATION commands are in dbatools.

One of the most highly requested dbatools features was for commands to manage snapshot, transactional... and even merge replication and now they're here. The wait is over!

In this session, we'll run through the available commands and work through demos including:

- Enabling publication and distribution for our instance - Creating publications - Adding articles to publications - Adding subscriptions - Confirm it's all working - Tearing it all back down again!

If you have been managing replication through the GUI and dreaming of a better way - come and join me for this action-packed session.

--------------

19:15 - 19:45 Pizza and Networking

--------------

19:45 - 20:30 Deploy your Azure Data Solutions with Bicep and Azure DevOps or GitHub Actions by Rob Sewell

Lets migrate to the cloud.

You can go to the portal and click in the blades and manually create all of the resources that you need. Such as Azure SQL Databases, Azure SQL VMs, Azure Arc Enabled Managed Instances, Azure Databricks or Azure Data Factory for example. You will want to ensure that they are all logging to Log Analytics and have monitoring enabled, maybe you need all of them to have Private Endpoints set up.

But you will forget something, you will mistype something, you will need to create multiple environments and they will need to be the same. Manually creating things is time consuming and mistake prone. Humans make mistakes.

Come and join me and I will show you how to deploy your data infrastructure into Azure using Bicep and Azure DevOps. How to ensure that when you deploy your resources, you automatically include Log Analytics or monitoring or add Private Endpoints.

You will learn • What Bicep is • How to compose Bicep with VS Code • How to create a pipeline in Azure DevOps to deploy the code • How to add Logging and Monitoring to your Azure Data Platform • How to create modules so that you can ensure that you deploy all of the resources that you require quickly, easily and repeatedly

You are • Someone interested in Infrastructure as Code for cloud data resources • Interested in learning new things • Want to deploy consistently to Azure • Never heard of Bicep or pipelines

--------------

20:30 - Pub

-------------- Notes

• Bicycle parking: We do not have arrangements with the venue for secure storage. There are public bicycle stands by Spicer and Cole/Premier Inn (to the left of Amdaris). Bicycles are left at your own risk

-------------- About Amdaris - https://amdaris.com/

We are Amdaris, an Insight company, and at our core we specialise in extending teams with highly skilled software experts. With bespoke Software Development, Product Design, Strategy and Consultation, Managed Services and Data Solutions, we seamlessly integrate into your business and culture, bringing passion, care, and technical proficiency directly to you.

About Data Masterminds - https://datamasterminds.io/

Data Masterminds is a leading Microsoft Data Platform consultancy and managed service provider to customers across the globe.

Our expert team offers comprehensive guidance and mentorship throughout the entire data lifecycle, whether your systems are on-premises, in the cloud, or a hybrid environment.

Utilizing our Data Platform Maturity Model, we can optimize your systems and enhance your team’s skills, ensuring your Data Platform delivers superior performance, stability, and relevance to meet your business objectives.

---- Photos We ask that you do NOT take photos at this meetup.

We will invite people to be included in a group photo/s during the event. Speakers will let you know if it's okay to photograph their presentation (excluding other attendees).

You may see organisers taking photos during the talks. These will be of speakers, if they have agreed to this, and will not include faces of attendees.

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/

This practical book provides a comprehensive overview of troubleshooting and performance tuning best practices for Microsoft SQL Server. Database engineers, including database developers and administrators, will learn how to identify performance issues, troubleshoot the system in a holistic fashion, and properly prioritize tuning efforts to attain the best system performance possible. Author Dmitri Korotkevitch, Microsoft Data Platform MVP and Microsoft Certified Master (MCM), explains the interdependencies between SQL Server database components. You'll learn how to quickly diagnose your system and discover the root cause of any issue. Techniques in this book are compatible with all versions of SQL Server and cover both on-premises and cloud-based SQL Server installations. Discover how performance issues present themselves in SQL Server Learn about SQL Server diagnostic tools, methods, and technologies Perform health checks on SQL Server installations Learn the dependencies between SQL Server components Tune SQL Server to improve performance and reduce bottlenecks Detect poorly optimized queries and inefficiencies in query execution plans Find inefficient indexes and common database design issues Use these techniques with Microsoft Azure SQL databases, Azure SQL Managed Instances, and Amazon RDS for SQL Server