talk-data.com

Duration: 60 minutes Level: Beginner

Pester is the Testing framework for PowerShell code. Think tSQLt for PowerShell. In this beginner friendly follow-along, you will learn how to write Pester tests from scratch.

We will start from existing code that has no tests. And we will end with code that is fully covered with tests, (and built in CI/CD pipeline if we have time.)

You will see the basic shapes of functions, and understand how to write tests for them. You will examine how to write unit and integration tests. And you will ensure that your code coverage does not drop under 75%.

This practical lesson will arm you with knowledge that is easy to translate to real-life, and that will help you ship better and more reliable code.

All of the code will be made available and you will also be able to follow along

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

DOUBLE MEETING!!!!!

Rob Sewell - Commits - What's the point? Tips for data professionals Committing code is an integral part of the development lifecycle. However, not all commits or commit messages are created equal. As more data professionals are required or expected to use source control within a continuous integration or deployment solution, a lack of good information is reducing the efficacy and usefulness of commit messages. In this session we will explore the source control system git, what makes a commit and what a commit message is for. We will also learn what makes a good, and a bad, commit message and how to automatically link commit messages to User Stories and release notes.

Traci Sewell

When the firehose causes the burnout How Do we create a firebreak?

Burnout is complex, and as it is unique to every person, it can be difficult to define and identify. Let me help you with that. Over the past few years burnout has become commonly mentioned in conversations about work life balance, about work from home, about hybrid working, about returning to the office. As is often the case when a newer issue becomes a commonly used buzzword, it's true definition and potential causes have become watered down. Even the description of the recognized symptoms, prevention and treatments has become diluted. The realities of dealing with burnout, both in the workplace and in our personal lives, have been lost in the smoke. In this session we will be reminded of what burnout actually looks like, how it is correctly defined, and how we can avoid some of the triggers. I will share my professional experiences with a variety of different symptoms and issues and introduce you to some of the approaches that I encourage people to use. You will leave this session having added tools to your toolbox that are relatively straightforward, hopefully memorable, and generic enough that they will apply to the majority of us.

Im April kehrt nach langer Abwesenheit Rob Sewell zu uns zurück - und bringt gleich seine Gattin mit für einen gemeinsamen Kurzvortrag auf DEUTSCH:

• Rob & Traci Sewell: Meine Frau, Fabric und ich Rollenwechsel – Übersetzung von Themen zur psychischen Gesundheit
• Rob Sewell: What makes a good commit? Good practices for data professionals

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.

Agenda 18:00 - 18:15 - Welcome 18:15 - 19:00 - Old Name - New CLI - why you should take a look at sqlcmd - Rob Sewell Introduced with SQL Server 2005 and replacing osql, sqlcmd has been a part of SQL Server professionals toolbox for a long time now. Many people only know it from the sqlcmd mode switch in SSMS, while others use it within automation as a lightweight easily available query runner. I have long recommended that DBAs are familiar with using it as it may be the only option to query an instance in severe emergencies. Times they are a changing. There is a new sqlcmd available and it has some awesome new capabilities. Let me introduce you to the new sqlcmd in a fun filled demo session and show you the new things it can do and why they will be of benefit to all Data Professionals We will cover deploying a database into a container from a backup with one command. Querying it, Opening it in Azure Data Studio, all from the command line and much more.

Rob Sewell Be-Whiskered Automator of Things Rob was a SQL Server DBA with a passion for PowerShell, Azure, Automation, and SQL (PaaS geddit?). Now he just helps people make things. He is a Cloud and Data Center MVP and a Data Platform MVP, SQLBits committee member, PSConf EU organiser, and co-leader of Data South West UK User Group. H has spoken at and volunteered at many Data and PowerShell events all over the world. He is a proud supporter of the Data and PowerShell communities. He relishes sharing and learning and can be found doing both via Twitter and his blog. He spends most of his time looking at a screen and loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, he is often out riding his bike as his eyes are not good enough to play cricket any more. He has a fabulous beard

17:30 - Pizza and networking

19:30 - 20:45 - Realtime streaming data with Microsoft Fabric - James Dales Realtime streaming data is now possible within Microsoft’s new SaaS environment, Microsoft Fabric, without any Azure resources required. In this session we’ll stream data from aircraft transponder data and other sensors directly into Microsoft Fabric via EventStream into KQL DB and OneLake, and analyse the results, both live and historic in Power BI. The session will be back to back demos as we build the whole solution from scratch – what could go wrong!?

James Dales James Dales is the Global Capability Lead for Microsoft Fabric and Power BI at Avanade and is a Microsoft FastTrack Recognised Solution Architect. As a Microsoft Data Platform MVP he is the co-leader of the London Power BI user group. In 2019 he became the first member of the Power BI Contributors Program, working alongside the Microsoft engineering team to build new functionality into the Power BI product itself. He has a keen interest in spatial analytics and is the author of the Icon Map custom visual.

Hosted by Amdaris, an Insight company - https://amdaris.com and sponsored by Cloud Formations - https://www.cloudformations.org

Amdaris is your trusted partner for high velocity extended delivery teams.

Cloud Formations provides No Nonsense Consulting on Data Strategy, Design, Delivery, and Training.

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

AGENDA

18.00 – 18:30 Meet & Greet

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

18:30 - 19:15 From Theory to Practice - Building a Data Mesh Architecture in Azure by Paul Andrew

The principals of a data mesh architecture have been around for a while now, but we still don’t have a clear way to deliver such a platform in Azure. Are the concepts so abstract that it’s hard to translate the principals into real world requirements and maybe even harder to think about what technology you might need to deploy within your Azure tenant.

In this session, we’ll explore options for building scalable data products in Azure, following Data Mesh architecture principals. Turning the theory into practice. What data storage technology should be used? Does it matter? What endpoints should be exposed for the products across the overall mesh? And what resource(s) should sit at the centre of the Data Mesh? Answers to all these questions are more as we turn the theory of a Data Mesh architecture into practice. Including, how to dissect the planes of the Data Mesh using Azure concepts.

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

19:15 - 19:45 Pizza and Networking

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

19:45 - 20:30 Migrating to Azure - Panel QnA with **Paul Andrew, Rob Sewell **and Dan Addy

Bring your questions and challenges about migrating to Azure Data Platform for an open question-and-answer session with an exceptionally skilled and experienced panel! This is a rare opportunity. Talk and connect with other data professionals considering or implementing migration projects.

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

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 Cloud Formations - https://www.cloudformations.org/

We partner for the journey to achieve a common goal, from siloed data solutions to scalable, value driven data platforms. Ensuring foundations that support the strategic direction of the business. Our loyalty is to your success through innovation and excellence, informed by decades of experience in the industry.

---- 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.

_________________

MeetUp Agenda

18:00 - Arrive. Networking 18:30 - Guest Speaker Talk 19:30 - Pizza. Networking 20:30 - Event Close

_________________

Old Name - New CLI - Why you should take a look at sqlcmd

Introduced with SQL Server 2005 and replacing osql, sqlcmd has been a part of SQL Server professionals toolbox for a long time now.

Many people only know it from the sqlcmd mode switch in SSMS, while others use it within automation as a lightweight easily available query runner. I have long recommended that DBAs are familiar with using it as it may be the only option to query an instance in severe emergencies. Times they are a changing.

There is a new sqlcmd available and it has some awesome new capabilities.

Let me introduce you to the new sqlcmd in a fun filled demo session and show you the new things it can do and why they will be of benefit to all Data Professionals _________________

Speaker Details

Rob was a SQL Server DBA with a passion for PowerShell, Azure, Automation, and SQL (PaaS geddit?). Now he just helps people make things. He is a Cloud and Data Center MVP and a Data Platform MVP, SQLBits committee member, PSConf EU organiser, and co-leader of Data South West UK User Group. H has spoken at and volunteered at many Data and PowerShell events all over the world. He is a proud supporter of the Data and PowerShell communities.

He relishes sharing and learning and can be found doing both via Twitter and his blog. He spends most of his time looking at a screen and loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, he is often out riding his bike as his eyes are not good enough to play cricket any more.

He has a fabulous beard.

LinkedIn: https://www.linkedin.com/in/robsewellsqldba Twitter: https://twitter.com/sqldbawithbeard

_________________

Venue Website

https://www.castlerockbrewery.co.uk/pubs/vat-and-fiddle

_________________

Sponsors

Cloud Formations https://www.cloudformations.org

_________________

Microsoft Community Code of Conduct

https://answers.microsoft.com/en-us/page/codeofconduct

_________________

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.

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