talk-data.com

Duration: 60 minutes Level: Beginner

Ready to dive into PowerShell but not sure where to start? Join us for an accessible introduction to PowerShell by completing database administration tasks. This session is designed for DBAs and data professionals who want to harness the power of automation but may feel intimidated by scripting.

In the first half of this session, we'll cover PowerShell fundamentals that every DBA should know. You'll learn about cmdlets, the pipeline, objects, and basic syntax through practical examples that relate directly to your daily work.

The second half focuses on dbatools - often called "the gateway drug to PowerShell" - a free, open-source PowerShell module containing almost 700 commands designed specifically for SQL Server management. We'll demonstrate how dbatools can simplify common DBA tasks such as:

• Backups and restores
• Configuration management
• Database migrations
• And more…

By the end of this session, you'll have a foundation in PowerShell basics and practical experience with dbatools commands that you can immediately apply to your environment. Whether you're managing one server or hundreds, you'll discover how PowerShell and dbatools can save you time, reduce errors, and make your life significantly easier.

No prior PowerShell experience required - just bring your curiosity and willingness to learn!

*In Person Only MeetUp, Free To Attend*

Thank you to Accenture for sponsoring and hosting this event.

Join us for a In-Person User Group Meeting (LDPaC), where you can network, learn, ask a question, and meet other likeminded folks. These events are a really great opportunity to socialise in an informal learning setting. This event is a Double MVP Speaker Edition!

Remember to tell your friends and the people you work with; make sure you register as soon as you can. We will need to provide a list of names to Accenture before the event, so to ensure there are no issues with access on the day please make sure you have registered.

17.45 - 18:00 Network 🤝

18.00 - 18:30 Drinks & Pizza 🍕

18:30 - 18:40 Intro🎙️

18:40 - 19:30 Azure Virtual WAN 101 - Jake Walsh (MVP) 🔊

Join me for a technical exploration and overview of Azure Virtual WAN. We will cover what it is, how it can be used, and the key features that make it a great choice for Azure Networking. The session will provide a baseline overview - and share lots of links and resources to help continue your learning around Azure Virtual WAN.

19:30 - 19:40 10-min Break 🥤

19:40 - 20:30 Introduction to SQL Server Automation with dbatools - Jess Pomfret (MVP) 🔊

Unlock the potential of PowerShell as a tool for managing your SQL Server estate. Regardless of your current expertise level, in this 60-minute session, I'll guide you from the basics to becoming comfortable using PowerShell to simplify your SQL Server administration.

Throughout the session, I'll delve into the fundamentals of PowerShell, explore how modules, like dbatools, can extend its capabilities, and dive deep into practical scenarios encountered by database administrators.

This session will include many demos, so you can see just how easy this can be, and you can take those demos back to your environments and get started right away.

PowerShell is not just a scripting language; it's a gateway to efficient automation and management of diverse IT environments, from on-premises SQL Servers to cloud-based resources. Whether you're a complete novice or have dabbled with PowerShell before, this session equips you with the skills needed to harness its power effectively.

Come and join the Leeds Data Community and start learning and networking! All are welcome!

WHEN: Wednesday, October 23rd, 2024, 1900 GMT

DESCRIPTION of TALK

Title: dbatools - Wheel of Fortune Ad voice: Want to play Wheel of Fortune dbatools style?

Come and join us on a demo-driven session where you will be the player and we gift you with some next-level demos using dbatools!

Spin the wheel and let luck be with you!

There are so many things we want to show you with dbatools that we couldn't decide - so now you decide!

Demos could include: - Managing Availability Groups - Migrating databases - Refreshing test environments - Masking sensitive data - Checking we're meeting best practices - Managing Logins\, Users & Permissions - Using Database Snapshots for Application Upgrades - Document your entire SQL environment - Backups and Restores - Copy table data around - Deploy tools including WhoIsActive & Ola maintenance scripts - Patching SQL Servers - Finding objects - and others - who knows where the wheel may take us

This is a place for online attendees. Check out the other one for an in-person meeting in Chilworth.

Link to the Teams Meeting: https://teams.microsoft.com/l/meetup-join/19%3ameeting_ZDk0NWQ4MTYtNjBlZi00OTVhLWE4ZDEtMThhNTU1OTI2NDg4%40thread.v2/0?context=%7b%22Tid%22%3a%22ecbebdab-1287-47b8-8709-694ffe8697d1%22%2c%22Oid%22%3a%22a901008d-8ba1-459d-b8fa-3eccacfccadf%22%7d

Agenda

17:50: Welcome and Intros

🎦Introduction to SQL Server Automation with dbatools 🗣️Jess Pomfret & 🗣️Rob Sewell

🍕pizza/networking

🎦Introduction to Performance Tuning on Azure Databricks 🗣️Niall Langley

*** A massive thanks to our sponsor Spectrum IT. Without them, we could not host this event for free. Spectrum IT kindly provided funding for the room, pizza and a £20 Amazon Voucher for in-person attendees. ***

This is a place for an in-person meeting in Chilworth. Check out the other one for an online meeting.

https://www.meetup.com/southampton-data-platform-and-cloud-group/events/303649794

!!!!! ATTENTION Since September, we've been having meetups at Spectrum IT's office - Gamma House, Enterprise Rd, Chilworth, Southampton SO16 7NS https://maps.app.goo.gl/66tL8HfgFnoiQEh66

Agenda

17:50: Welcome and Intros

🎦Introduction to SQL Server Automation with dbatools 🗣️Jess Pomfret & 🗣️Rob Sewell

🍕pizza/networking

🎦Introduction to Performance Tuning on Azure Databricks 🗣️Niall Langley

*** A massive thanks to our sponsor Spectrum IT. Without them, we could not host this event for free. Spectrum IT kindly provided funding for the room, pizza and a £20 Amazon Voucher for in-person attendees. ***

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.

The October Ohio North Database Training user group meeting will be held a week early due to scheduling. So, we'll be hosting the meetup on Tuesday, September 26, 2023. This will be a HYBRID event and our featured speaker, Jess Pomfret, will join us in person.

Our in-person meeting location is in the Artemis offices at:

6161 Oak Tree Blvd, Ste 300

Independence, OH 44131

5:00 PM EST: Online and in-person meeting begins with a social hour. This is an unstructured hour where you can join us to catch up and meet other group members before the session starts. There will be pizza brought in for in-person attendees.

6:00 PM EST: Updates and announcements, followed by the main presentation (please review the abstract below for more details).

7:15 PM EST: Optionally after the main presentation, the in-person crowd may go out for snacks and drinks at a local establishment.

We hope to see you there!

*Please note, that we will be using Microsoft Teams for the online portion of this meeting. You may want to join a few minutes early to ensure you do not have any issues. If you are attending in person, there are large TVs at the office and you do not need to bring a laptop or use Teams.

Session Abstract:

Managing replication with dbatools

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

One of the most highly requested dbatools features is for commands to manage replication and now they're here.

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.

Welcome to Southampton Data Platform and Cloud Group.

This is the meetup for the IN-PERSON event.

!!!! LOCATION CHANGE - DIFFERENT BUILDING !!!!! This month the meetup will be hosted at the Spectrum IT office:

Gamma House, Enterprise Road Southampton Science Park, Chilworth, SO16 7NS https://goo.gl/maps/BD9xqqBWPMgsrPze9

Registration will be open on Monday, two days before the event.

Agenda

18:00: Welcome and Intros

18:00: Jess Pomfret - Managing replication with dbatools

pizza/networking break

19:15: Mikey Bronowski - tba

20:00: Raffle and finish

Session details:

1. Jess Pomfret - Managing replication with dbatools

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

One of the most highly requested dbatools features is for commands to manage replication and now they're here.

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.

2. Mikey Bronowski - tba

***

A massive thanks to our sponsor Spectrum IT. Without them, we would not be able to host this event for free. Spectrum IT kindly provide funding for the room, pizza and a £20 Amazon Voucher for in-person attendees. Jess Pomfret provides the book about dbatools as a raffle prize.

***

DataSaturday Oslo is coming back on September 2nd! And with the free main event we also offer full day classes on select topics at a very low price! Please note that this is a paid event and you must register with the Eventbrite site to attend! Hybrid DBA pre-con registration

The role of a DBA is evolving in today's hybrid computing landscape, where applications are deployed on both on-premises and cloud platforms. This training day is specifically designed for DBAs who are required to work in a hybrid environment, where some applications use Platform as a Service databases while others are supported on-premises or on Azure VMs. We will provide you with a hands-on experience in using automation tooling including PowerShell and community-developed modules such as dbatools, dbachecks, and ImportExcel, to automate many everyday tasks in your estate, whether it is totally on-prem, hybrid, or 100% cloud. You will learn from Jess Pomfret and Rob Sewell, two of the dbatools in a Month of Lunches authors, how to take your Data Platform skills to the next level. We will also cover the basic concept of infrastructure as code. You will learn how to manage your infrastructure through code, allowing you to automate the provisioning, configuration, and management of your SQL Server instances and PaaS services. You will also see how this approach can improve the reliability and consistency of your environment, reduce errors, and increase the efficiency of your operations. Finally, we will touch on how you can use GitHub Actions or Azure Functions to automate your workflows and integrate with other tools in your environment. You will learn how to create workflows that trigger when specific events occur, such as a new pull request or a database schema change and automate the execution of scripts or the deployment of changes to your SQL Server instances. This approach will help you streamline your operations, reduce manual intervention, and improve the overall quality of your work. Overall, this training day will provide you with a comprehensive set of skills to manage your hybrid SQL Server estate. There are many tools for you to add to your toolbox and we’ll show you how to get the most out of your available time and effort by utilising PowerShell, a collection of community-written modules with some CI\CD tools mixed in. Whether you are a senior or junior DBA, a developer who interacts with SQL Server, an accidental DBA, or someone with DevOps in your job title, this training is for you. You will improve your PowerShell skills for SQL Server and reduce the time you and your team spend administering SQL Server. You do not need any specific equipment or tools for this training, but we recommend bringing something to take notes with. All scripts and slides will be provided to you, and you will have the opportunity to follow along with most of the demos on a machine that can run Docker or with PowerShell v5 or above and a SQL Server 2012 or above instance.

Join us for a wonderful day of PowerShell and SQL, full of demos and useful solutions that you will be able to take back to your workplace.

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

One of the most highly requested dbatools features is for commands to manage replication and now they're here.

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.

If you work with SQL Server, dbatools is a lifesaver. This book will show you how to use this free and open source PowerShell module to automate just about every SQL server task you can imagine—all in just one month! In Learn dbatools in a Month of Lunches you will learn how to: Perform instance-to-instance and customized migrations Automate security audits, tempdb configuration, alerting, and reporting Schedule and monitor PowerShell tasks in SQL Server Agent Bulk-import any type of data into SQL Server Install dbatools in secure environments Written by a group of expert authors including dbatools creator Chrissy LeMaire, Learn dbatools in a Month of Lunches teaches you techniques that will make you more effective—and efficient—than you ever thought possible. In twenty-eight lunchbreak lessons, you’ll learn the most important use cases of dbatools and the favorite functions of its core developers. Stabilize and standardize your SQL server environment, and simplify your tasks by building automation, alerting, and reporting with this powerful tool. About the Technology For SQL Server DBAs, automation is the key to efficiency. Using the open-source dbatools PowerShell module, you can easily execute tasks on thousands of database servers at once—all from the command line. dbatools gives you over 500 pre-built commands, with countless new options for managing SQL Server at scale. There’s nothing else like it. About the Book Learn dbatools in a Month of Lunches teaches you how to automate SQL Server using the dbatools PowerShell module. Each 30-minute lesson introduces a new automation that will make your daily duties easier. Following the expert advice of dbatools creator Chrissy LeMaire and other top community contributors, you’ll learn to script everything from backups to disaster recovery. What's Inside Performing instance-to-instance and customized migrations Automating security audits, best practices, and standardized configurations Administering SQL Server Agent including running PowerShell scripts effectively Bulk-importing many types of data into SQL Server Executing advanced tasks and increasing efficiency for everyday administration About the Reader For DBAs, accidental DBAs, and systems engineers who manage SQL Server. About the Authors Chrissy LeMaire is a GitHub Star and the creator of dbatools. Rob Sewell is a data engineer and a passionate automator. Jess Pomfret and Cláudio Silva are data platform architects. All are Microsoft MVPs. Quotes All SQL Server professionals should learn dbatools. With its combination of knowledge transfer, anecdotes, and hands-on labs, this book is the perfect way. - From the Foreword by Anna Hoffman, Databases Product Management, Microsoft Excellent guide for dbatools with lots of practical tips! Required reading for anyone interested in dbatools. - Ruben Vandeginste, PeopleWare A must-have for any SQL server developer. - Raushan Kumar Jha, Microsoft If you want to automate all vital aspects of SQL Server, wait no more! Learn dbatools in a month, with guidance from the best minds in the business. - Ranjit Sahai, RAM Consulting