Jess Pomfret
Jess Pomfret is a Data Platform Engineer and a Microsoft MVP. She started working with SQL Server in 2011, and enjoys the problem-solving aspects of performance tuning and automating processes with PowerShell.
She also enjoys contributing to dbatools and dbachecks, two open source PowerShell modules that aid DBAs with automating the management of SQL Server instances. She has also contributed to the SqlServerDsc module, adding several new resources to use when configuring your SQL Servers.
She grew up in the South West of England and outside of her DBA life enjoys Crossfit, cycling and watching proper football.
Jess Pomfret's Training Days
The DBA in a hybrid environmentSQLBits 2024
Ideal for database administrators, developers, and database reliability engineers, this training day will explore all the skills you need to enable you to manage SQL Server estates spanning on-premises and cloud environments.
Getting your SQL estate in order at scale and keeping it that way with ease.SQLBits 2023
Still on-prem and need to automate your administration and validation of your SQL instances? We will share with you how we solve the challenges of automating estates at scale and all of the tips and tricks we have gained from working with large estates at scale with excellent performance and automation. You will leave with a strong understanding of the tools that you have available to automate and validate your SQL estate and the confidence to implement it in your environment.
Automate your DBA tasks with dbatools and dbachecksSQLBits 2022
Let us show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed modules dbatools and dbachecks. Join Jess Pomfret and Rob Sewell, two of the dbatools in a Month of Lunches authors and learn how effective dbatools and dbachecks can make you. We will show you the skills, scripts and tricks that we have learned with dbatools and dbachecks and tell you how they have rocketed our careers
Jess Pomfret's Sessions
Managing replication with dbatoolsSQLBits 2024
One of the most highly requested dbatools features was for commands to manage replication and now they're here.
In this session, we'll run through the available commands and how they can be used to build up and tear down replication.
Anyone can be an alphabet soup allySQLBits 2024
Folks that belong to the queer community are often referred to as LGBTQ+, Jess and Linda represent a small portion of the letters within this alphabet soup and they will guide you through some common situations where you can be a good ally.
There is no one right answer, but there are ways for you to prepare for certain situations so you know what your best move might be to provide support and allyship.
This session will provide tips for people who are new to being an ally and for existing allies who want to add skills to their toolbelt.
Managing replication with dbatoolsSQLBits 2024
One of the most highly requested dbatools features was for commands to manage replication and now they're here.
In this session, we'll run through the available commands and how they can be used to build up and tear down replication.
Anyone can be an alphabet soup allySQLBits 2024
Folks that belong to the queer community are often referred to as LGBTQ+, Jess and Linda represent a small portion of the letters within this alphabet soup and they will guide you through some common situations where you can be a good ally.
There is no one right answer, but there are ways for you to prepare for certain situations so you know what your best move might be to provide support and allyship.
This session will provide tips for people who are new to being an ally and for existing allies who want to add skills to their toolbelt.
I'm here, I'm queer ( Why Representation Matters)SQLBits 2023
In this 20 minute session we’ll talk about why it matters that ‘I’m here and I’m Queer’. Representation, both at conferences and in the media, is so important not just for us now, but also for the future generations.
If you want to know why all this DEI stuff matters, why we need to keep striving to diversify the attendees and speakers at our conferences and events, then this session is for you.
SQL Server 2022 migrations with dbatoolsSQLBits 2023
Using dbatools we'll migrate our databases to a shiny new SQL Server 2022 instance.
Keynote by The CommunitySQLBits 2023
Ben and Rob have found some wonderful folk to actually do the important parts of the community keynote. on the theme of
How to be a nonpassive member of the data community
Introduction to PowerShellSQLBits 2022
Everything you need to get started with PowerShell.
Migrate databases easily with dbatoolsSQLBits 2022
Quickly and easily migrate databases and associated logins using dbatools.
Life Hacks: dbatools editionSQLBits 2020
dbatools is an open source PowerShell module. This session will walk through several life hacks that you can take back to work and quickly implement to make your life easier and impress your friends.
Install & Configure SQL Server with PowerShell DSCSQLBits 2020
Using PowerShell Desired State Configuration (DSC) we'll install and configure a SQL Server instance in under 5 mins.