Presentations

I am proud to be a part of the #SQLCommunity and #SQLFamily as well as the PowerShell Community and lucky enough to be selected to speak at SQL and PowerShell Events. You can find links to the presentations, demos and webinars

Speaking

2017
May 3, 2017

PowerShell Conference Europe – Creating and Maintaining Successful Open Source Projects

Looking to get more contributors for your Open Source project?
Once you’ve got them, what’s awesome and what sucks about your baby being popular?

In this session, Community Leader Rob Sewell and PowerShell MVP Chrissy LeMaire talk about their real world experiences with building popular PowerShell repos and the catalysts for their projects becoming owned and beloved by the open source community

Event Page

Slides

 

May 3, 2017

PowerShell Conference Europe – Green is bad Red is Good – Turning your Checklists into Pester Tests

Relevant to any technicians who use checklists. Intro level and idea forming, getting people to look at the way they can use Pester
I was required to prove that I had successfully installed and configured a backup solution across a large estate. I had a number of success criteria that had to be met. Checking all of these by hand (eye) would have been error prone, so I wrote a test to do this for me and an easy for management to read HTML report using PowerShell and Pester.
The session has come from that situation and is about enabling you to provide an easy to read output to quickly and repeatedly show that infrastructure is as expected for a set of checks. There are many use cases for this type of solution; DR testing, installation, first line checks, presentation setups
After this session you will have a basic understanding of how Pester works and the capability to examine your checklists and create your own validation tests and provide some reporting for management. You will pick up ideas of processes and checks that can be automated within your company
I am able to perform the following checks in 15 minutes across hundreds of servers and thousands of databases and I think it is cool and useful and everyone should be able to do so and take the functionality to create their own.
Every Job in Ola Hallengrens Maintenance Solution exists, is enabled, has a schedule, has succeeded, has 2 job steps, has a generate restore script job step, the root backup folder is contactable, for every database the correct folders exist for the full, differential and log backup depending on recovery model in that folder, that each of those backup folders has files in it, that the most recent file in each of those folders is less than the required frequency for those job

Event Page

Code and Slides 

 

 

 

 

 

March 29, 2017

Battle of the Beards – Powershell: A Beards Favourite Shell

You don’t have to be a marquisotte to see the Power in PowerShell. Pogonophiles and pogonophobes alike who work in IT can benefit across all platforms, operating systems and cloud providers by taking advantage of it.
Join this famous, impressively be whiskered PowerShell nut and his fabulous chin curtain in a quick introduction to the magnificence of PowerShell and learn some the basics quickly so you won’t need to stroke your muzzle lashings but will be able to help yourself.

Event Page – Raising money for a great cause

Battle of the Beards started out as a fun user group event, where bristling techies would square off in our very own arena. Our Beardy Battlers would give presentations and winners would be decided based on the quality of their beards and their talks. The crowd went wild (and wanted more)!

Where our first events had a mere 3 contenders, this year we’re upping the ante and there’ll be at least 10 contenders! Whether their beard is permanent or just for the day, our Beardy Battlers will be delivering half-hour techie talks that’ll be useful and engaging for anyone in IT. Every Beardy Battler will make a difference to your life.

If you come along you’ll make a difference. All proceeds will go to the Campaign Against Living Miserably (CALM). Supporting CALM means they can provide vital counselling services and save lives.

In our male dominated industry, we’re likely to be disproportionately affected by suicide. It was the cause of a quarter of all deaths of 20 – 34 year old males in 2014. That’s a sad and uncomfortable fact.

We need to take care of ourselves and each other.

So let’s have some fun for a good cause!

Code

 

 

 

 

 

March 27, 2017

SQL South West – Using the SQL Server Provider in PowerShell

Using the SQL Server Provider in PowerShell

With the new sqlserver module released last year I decided to revisit the SQL Server Provider. Come and take a look at it with me and I will show you what works and what doesn’t and how you can make use of it

Event Page

Code and Slides

 

March 9, 2017

SQL Belfast User Group – Using the PowerShell SQL Provider

Introduction to Powershell SQLServer provider Using the SQL Powershell Server Module (SQLPS)

Event Page

Code and Slides

 

 

March 7, 2017

SQL North East User Group – Green is good, Red is bad – Turning your Checklists into Pester Tests

I was required to prove that I had successfully installed and configured a backup solution across a large estate. I had a number of success criteria that had to be met. Checking all of these by hand (eye) would have been error prone, so I wrote a test to do this for me and an easy for management to read HTML report using PowerShell and Pester.

The session has come from that situation and is about enabling you to provide an easy to read output to quickly and repeatedly show that infrastructure is as expected for a set of checks, also known as Operational Validation using Pester. There are many use cases for this type of solution; DR testing, installation, first line checks, presentation setups

What is Pester?

Pester is a Unit Testing framework for PowerShell which can be used for testing your code but also as shown in this session for validating your infrastructure. This is an excellent post by Adam Bertram to introduce Pester It is included with PowerShell on modern Operating Systems and free to download from the PowerShell Gallery or GitHub if not included

After this session you will have a basic understanding of how Pester works and the capability to examine your checklists and create your own validation tests and provide some reporting for management.

PowerShell dbatools / SQL Server module

Rob Sewell

SQLServer and PowerShell an exploration.

Event Page

Code

Slides

 

March 6, 2017

Notts Dev Workshop – Introduction to PowerShell

Intro to PowerShell workshop for the first ever Notts Dev Workshop user group.

Notable also for the amazing B and B I stayed in 🙂

Code

 

 

February 10, 2017

Combined Dutch SQL and PowerShell User Group – Utrecht – Powershell ❤ SQL Server Modern Database Administration

On Friday morning, the 10th of February we, PASS NL and the Dutch Powershell User Group (DUPSUG) will host a joint User Group session. 

Expect a full morning filled with Powershell and get to know many of your colleagues in both the SQL Server world and the Powershell world. 

Event Page

Code

Slides

 

 

 

 

 

 

 

January 23, 2017

MS Cloud Summit Paris – Pre Con

We all had to start somewhere, and today is the day you start learning PowerShell.

In the morning, this session will go through the basic concepts of PowerShell, on to creating your first function and then taking this knowledge to create your first scripts to run against Azure.

In the afternoon, we will focus on PowerShell for SQL Server. We will show you how to perform many DBA tasks easily and simply using PowerShell. Need to properly configure tempdb? We’ve got you covered. Not sure if all of the SQL Servers in your estate are set to the proper power plan? A single PowerShell command can help. Want to alter the schedule for an Agent Job on dozens, hundreds or even thousands of servers? We will teach you how easy that is, along with many other solutions as well as showing you how to easily gather information about your estate and display it in SSRS or Power BI

Come and join us for a great day of PowerShell, Azure and SQL full of demos and useful solutions that you will be able to take back to your workplace. We will improve your knowledge and skills, show you how the modern Admin and DBA will work and have fun at the same time.

Event Page

 

 

January 20, 2017

SQL Saturday Vienna – Modern Database Administration using PowerShell and dbatools

In this session, I’ll feature some crazy useful PowerShell commands from the dbatools module. This SQL Server-centric toolset, which has evolved into an open-source community project with over 20 contributors, includes commands like Remove-SqlDatabaseSafely, Set-SqlTempDbConfiguration, Find-SqlDuplicateIndex, Show-SqlWhoIsActive, Test-SqlPowerPlan and Repair-SqlOrphanUser. Join for me for this electric, demo-heavy session to learn how to greatly simplify your life as a DBA.

Code and Slides

 

 

 

 

 

January 19, 2017

SQL Saturday Vienna Pre-Con – SQL Server and PowerShell – Better Together. Building the Modern DBAs Tools

With the new SqlServer module announced by Microsoft with the July SSMS release SQL Server finally got some PowerShell love.

Join PowerShell MVP & DBA Chrissy LeMaire and PowerShell Expert & DBA Rob Sewell to learn how you can take advantage of the new module and some amazing community modules to improve your work/bacon life balance.

We will show you how to perform many DBA tasks easily and simply using PowerShell. Need to properly configure tempdb? We’ve got you covered. Not sure if all of the SQL Servers in your estate are set to the proper power plan? A single PowerShell command can help. Want to alter the schedule for an Agent Job on dozens, hundreds or even thousands of servers? We will teach you how easy that is, along with many other solutions as well as showing you how to easily gather information about your estate and display it in SSRS or PowerBi

Our session is aimed at DBAs, from junior to senior, who want to embrace the latest methods and increase their toolset

Come and join us for a great day of PowerShell and SQL full of demos and useful solutions that you will be able to take back to your workplace. We will improve your knowledge and skills, show you how the modern DBA will work and have fun at the same time.

 

 

 

 

 

2016
December 10, 2016

SQL Saturday Slovenia – Green is Good Red is Bad – Turning Your Checklists into Pester Tests

This session is for DBAs specifically, but will be relevant to any technicians who use checklists

I was required to prove that I had successfully installed and configured a backup solution across a large estate.
I had a number of success criteria that had to be met.
Checking all of these by hand (eye) would have been error prone, so I wrote a test to do this for me and an easy for management to read HTML report using PowerShell and Pester.

The session has come from that situation and is about enabling you to provide an easy to read output to quickly and repeatedly show that infrastructure is as expected for a set of checks, also known as Operational Validation using Pester.
There are many use cases for this type of solution; DR testing, installation, first line checks, presentation setups After this session you will have a basic understanding of how Pester works and the capability to examine your checklists, create own validation tests and provide reports for managers.

Event Page

Code

PPTX

 

December 10, 2016

SQL Saturday Slovenia – How I use PowerShell to automate the installation & upgrade of DBA scripts

Every DBA will have a collection of scripts that they want to have on all of their instances. Maintenance scripts, Troubleshooting scripts, post-installation scripts – with a dozen instances these may be easy to manage manually. But when your number of instances increases, you still want that consistency and when you need to deploy an upgrade to the scripts, you want to test it prior to releasing to production In this session I will show how I tackle this for hundreds or thousands of instances using my DBA database and PowerShell

Event Page 

Code

pptx

 

December 7, 2016

Southampton SQL User Group – Turn Your Checklist into a Pester Test

This session is for DBAs specifically, but will be relevant to any technicians who use checklists
I was required to prove that I had successfully installed and configured a backup solution across a large estate. I had a number of success criteria that had to be met. Checking all of these by hand (eye) would have been error prone, so I wrote a test to do this for me and an easy for management to read HTML report using PowerShell and Pester.

The session has come from that situation and is about enabling you to provide an easy to read output to quickly and repeatedly show that infrastructure is as expected for a set of checks, also known as Operational Validation using Pester.
There are many use cases for this type of solution; DR testing, installation, first line checks, presentation setups
After this session you will have a basic understanding of how Pester works and the capability to examine your checklists, create own validation tests and provide reports for managers.

Event Page

Code

PPTX

November 1, 2016

Birmingham SQL User Group – PowerShell Loves SQL Server – Community Modules for All

Prior to June 28th 2016 there were 46 official PowerShell Cmdlets.
Then the sqlserver module was released and more come with every release of SSMS every month
Lets take a tour through the new sqlserver module and see the new cmdlets in action
We will also look at the SQL Server Community Collaborative – an organisation on Github providing superb resources for DBAs.
Join me for a demo heavy fun filled tour of PowerShell and SQL Server.

Event Page

Code

October 22, 2016

PowerShell Conference Asia – Singapore – Using my DBA Database to automate the install and upgrade scripts

Code

 

 

October 22, 2016

PowerShell Conference Asia – Singapore – PowerShell, SQL and PowerBi-Reducing your Context Switching

“Could you just tell me……….?”

This may cost 10 seconds of time or it may take several hours but it will definitely stop the current task and impact its completion

A SQL DBA will be required to provide a myriad of information in many different ways to many different types of people, answering questions from technical teams, technology teams, other parts of the business as well as directors and external parties.

In this session you will learn the why, what and how of automating the gathering, storing and displaying of information enabling self-service and reducing the interruptive calls on your time whilst ensuring that the data is correct and trustworthy. I will also show you how you can use this to enable consistency across your estate. This session will be of benefit to the “Accidental DBAs” as well as DBAs looking after large estates

The majority of the session will concentrate on the way I use PowerShell to gather the information and store it. I will also show you how to enable self-service with natural language query using PowerBi.

You will leave the session with all of the tools you need to return to work and convince your boss this is a worthwhile use of your time and to implement this solution to provide a modern way of providing accurate information about your estate

Code

October 21, 2016

PowerShell Conference Asia – Singapore – Powershell Profile Prepares Perfect Production Purlieu

A Purlieu is a place, an environment, a haunt
The 6 P’s are usually Proper Prior Preparation Prevents Poor Performance.
The Powershell profile is a powerful tool that can provide a perfect Powershell scripting environment.
It runs on start up preparing your editor for the purposes and processes that you intend to produce If you use Powershell you should be making use of your profile and in this beginners session I will show you how you can start making your Powershell environment work even better for you

Code

 

October 4, 2016

SQL Relay Cardiff – Impromptu Session – This is not the session you are expecting

 

October 4, 2016

SQL Relay – Cardiff – PowerShell Loves SQLServer – New module and community modules

Prior to June 28th 2016 there were 46 official PowerShell Cmdlets.

Then the sqlserver module was released and more come with every release of SSMS every month
Lets take a tour through the new sqlserver module and see the new cmdlets in action
We will also look at the SQL Server Community Collaborative – an organisation on Github providing superb resources for DBAs.
Join me for a demo heavy fun filled tour of PowerShell and SQL Server.

Code

 

 

September 28, 2016

SQL Relay – Guerrilla Talks -New PowerShell Commands for SQL Server

September 19, 2016

SQL South West User Group – New PowerShell Commands For SQL Server

September 1, 2016

Dutch PowerShell User Group – PowerShell SQL and Power Bi

Could you just tell me…?
This may cost 10 seconds of time or it may take several hours but it will definitely stop the current task and impact its completion
A SQL DBA will be required to provide a myriad of information in many different ways to many different types of people, answering questions from technical teams, technology teams, other parts of the business as well as directors and external parties.
In this session you will learn the why, what and how of automating the gathering, storing and displaying of information enabling self-service and reducing the interruptive calls on your time whilst ensuring that the data is correct and trustworthy.

 

 

 

 

August 22, 2016

PowerShell Monday Munich – PowerShell SQL and Power Bi

Could you just tell me…?
This may cost 10 seconds of time or it may take several hours but it will definitely stop the current task and impact its completion
A SQL DBA will be required to provide a myriad of information in many different ways to many different types of people, answering questions from technical teams, technology teams, other parts of the business as well as directors and external parties.
In this session you will learn the why, what and how of automating the gathering, storing and displaying of information enabling self-service and reducing the interruptive calls on your time whilst ensuring that the data is correct and trustworthy.

Event Page

 

 

 

 

 

August 18, 2016

PASS PowerShell Virtual Group – PowerShell, SQL and Power BI – Reducing your Context Switching

Could you just tell me…?
This may cost 10 seconds of time or it may take several hours but it will definitely stop the current task and impact its completion
A SQL DBA will be required to provide a myriad of information in many different ways to many different types of people, answering questions from technical teams, technology teams, other parts of the business as well as directors and external parties.
In this session you will learn the why, what and how of automating the gathering, storing and displaying of information enabling self-service and reducing the interruptive calls on your time whilst ensuring that the data is correct and trustworthy.

Event Page – https://powershell.pass.org/Sessions.aspx

August 3, 2016

SQL Southampton User Group – New PowerShell Commands For SQL Server

July 23, 2016

SQL Saturday Manchester – Powershell Profile Prepares Perfect Production Purlieu

A Purlieu is a place, an environment, a haunt The 6 P’s are usually Proper Prior Preparation Prevents Poor Performance. The Powershell profile is a powerful tool that can provide a perfect Powershell scripting environment. It runs on start up preparing your editor for the purposes and processes that you intend to produce If you use Powershell you should be making use of your profile and in this beginners session I will show you how you can start making your Powershell environment work even better for you

Event Page https://www.sqlsaturday.com/543

Code https://github.com/SQLDBAWithABeard/Presentations/tree/master/2017/PowerShell%20Profile%20Provides%20Perfecct%20Production%20Purlieu

 

 

 

 

July 6, 2016

PASS PowerShell Virtual Chapter – The State of PowerShell, SQL Server, and SQLPS

The end-of-June release of SSMS 2016 is bringing more needed PowerShell enhancements to the new SqlServer PowerShell module. We will discuss the 25 new cmdlets that made the cut and show you some practical ways to use them! There are also 3 great update to existing functionality that we will walk through.

June 18, 2016

SQL Saturday Dublin – Making PowerShell useful for your team

Come on a journey from The bloke that wrote some scripts to a professional solution for a whole IT team.

A session for Powershell beginners and those wishing to improve how their team use PowerShell
Each organization requires specific tasks that can be accomplished using PowerShell.
I will show you how you can achieve this by demonstrating An easy way to learn the syntax
How to explore objects with Powershell and turn your one off scripts into shareable functions
How to ensure that your team can easily and quickly make use of and contribute to PowerShell solutions

A fast-paced session with ideas and discussion points for you to take back to work

Event Page – SQL Saturday Dublin

Code – https://github.com/SQLDBAWithABeard/Presentations/tree/master/2016/Making%20PowerShell%20useful%20for%20your%20team%20-%20Dublin

 

 

 

April 27, 2016

SQL Relay Guerilla Talks – Four things you should know to effectively learn PowerShell

Guerrilla Talks – 27th April 2016

Four things you should know to effectively learn PowerShell

This short demo will be of use to new comers to PowerShell explaining 4 things to remember and a process to follow to make it easier to learn some PowerShell.

Feel free to ask questions @SQLDBAWithBeard

You can find the code at https://github.com/SQLDBAWithABeard/Presentations/tree/master/2016/FourThingsToLearnPowerShell

April 22, 2016

PSConfEU – Making Powershell Useful For Your Team

Come on a journey from The bloke that wrote some scripts to a professional solution for a whole IT team.

A session for Powershell beginners and those wishing to improve how their team use PowerShell
Each organization requires specific tasks that can be accomplished using PowerShell.
I will show you how you can achieve this by demonstrating
An easy way to learn the syntax
How to explore objects with Powershell and turn your one off scripts into shareable functions
How to ensure that your team can easily and quickly make use of and contribute to PowerShell solutions
A fast-paced session with ideas and discussion points for you to take back to work

Event Page – PSConfEU

Code – Making PowerSHell Useful For Your Team

 

 

 

April 21, 2016

PSConfEU – Power Bi, PowerShell and DBA Double Session Rob Sewell Part1

“Could you just tell me……….?”

This may cost 10 seconds of time or it may take several hours but it will definitely stop the current task and impact its completion

A SQL DBA will be required to provide a myriad of information in many different ways to many different types of people, answering questions from technical teams, technology teams, other parts of the business as well as directors and external parties.

In this session you will learn the why, what and how of automating the gathering, storing and displaying of information enabling self-service and reducing the interruptive calls on your time whilst ensuring that the data is correct and trustworthy. I will also show you how you can use this to enable consistency across your estate. This session will be of benefit to the “Accidental DBAs” as well as DBAs looking after large estates

The majority of the session will concentrate on the way I use PowerShell to gather the information and store it. I will also show you how to enable self-service with natural language query using PowerBi.

You will leave the session with all of the tools you need to return to work and convince your boss this is a worthwhile use of your time and to implement this solution to provide a modern way of providing accurate information about your estate

Event Page – PSConfEU

Code – Power Bi, PowerShell and DBA Double Session Rob Sewell Part1

 

 

April 1, 2016

PSConfEU – Power Bi, PowerShell and DBA Double Session Rob Sewell Part2

“Could you just tell me……….?”

This may cost 10 seconds of time or it may take several hours but it will definitely stop the current task and impact its completion

A SQL DBA will be required to provide a myriad of information in many different ways to many different types of people, answering questions from technical teams, technology teams, other parts of the business as well as directors and external parties.

In this session you will learn the why, what and how of automating the gathering, storing and displaying of information enabling self-service and reducing the interruptive calls on your time whilst ensuring that the data is correct and trustworthy. I will also show you how you can use this to enable consistency across your estate. This session will be of benefit to the “Accidental DBAs” as well as DBAs looking after large estates

The majority of the session will concentrate on the way I use PowerShell to gather the information and store it. I will also show you how to enable self-service with natural language query using PowerBi.

You will leave the session with all of the tools you need to return to work and convince your boss this is a worthwhile use of your time and to implement this solution to provide a modern way of providing accurate information about your estate

Event Page – PSConfEU

Code – Power Bi, PowerShell and DBA Double Session Rob Sewell Part1

March 30, 2016

Cardiff SQL User Group – Return Of The Beards – PowerShell, SQL and PowerBI – Reducing your Context Switching

“Could you just tell me……….?”

This may cost 10 seconds of time or it may take several hours but it will definitely stop the current task and impact its completion

A SQL DBA will be required to provide a myriad of information in many different ways to many different types of people, answering questions from technical teams, technology teams, other parts of the business as well as directors and external parties.

In this session you will learn the why, what and how of automating the gathering, storing and displaying of information enabling self-service and reducing the interruptive calls on your time whilst ensuring that the data is correct and trustworthy. I will also show you how you can use this to enable consistency across your estate. This session will be of benefit to the “Accidental DBAs” as well as DBAs looking after large estates

The majority of the session will concentrate on the way I use PowerShell to gather the information and store it. I will also show you how to enable self-service with natural language query using PowerBi.

You will leave the session with all of the tools you need to return to work and convince your boss this is a worthwhile use of your time and to implement this solution to provide a modern way of providing accurate information about your estate

Event Page – Cardiff SQL User Group

Code – https://github.com/SQLDBAWithABeard/DBA-Database

 

March 12, 2016

SQL Saturday Exeter – Using Power Bi with my DBA Database

Every good DBA should have a DBA database. A place to store information about all of their instances and databases. They should automatically gather information into that database. They are also often required to query that information to answer questions from other technical teams, Project Managers, Client Account managers, Compliance Teams, Auditors, Directors In this session I will talk about the way that I automate the gathering of this information and also how I use Power BI to be able to allow people to self serve answers to their own questions and remove some load from the DBA team. I am no BI expert so this session is aimed at DBAs who want to be able to show information using the latest tools rather than BI professionals

Event Page SQL Saturday Exeter

Code – https://github.com/SQLDBAWithABeard/DBA-Database

February 3, 2016

SQL Southampton User Group – PowerShell, SQL and PowerBI – Reducing your Context Switching

PowerShell, SQL and PowerBI – Reducing your Context Switching

“Could you just tell me……….?”

This may cost 10 seconds of time or it may take several hours but it will definitely stop the current task and impact its completion

A SQL DBA will be required to provide a myriad of information in many different ways to many different types of people, answering questions from technical teams, technology teams, other parts of the business as well as directors and external parties.

In this session you will learn the why, what and how of automating the gathering, storing and displaying of information enabling self-service and reducing the interruptive calls on your time whilst ensuring that the data is correct and trustworthy. I will also show you how you can use this to enable consistency across your estate. This session will be of benefit to the “Accidental DBAs” as well as DBAs looking after large estates

The majority of the session will concentrate on the way I use PowerShell to gather the information and store it. I will also show you how to enable self-service with natural language query using PowerBi.

You will leave the session with all of the tools you need to return to work and convince your boss this is a worthwhile use of your time and to implement this solution to provide a modern way of providing accurate information about your estate

Code – https://github.com/SQLDBAWithABeard/DBA-Database

January 25, 2016

SQL South West – PowerShell, SQL and PowerBi-Reducing your Context Switching

PowerShell, SQL and PowerBI – Reducing your Context Switching

“Could you just tell me……….?”

This may cost 10 seconds of time or it may take several hours but it will definitely stop the current task and impact its completion

A SQL DBA will be required to provide a myriad of information in many different ways to many different types of people, answering questions from technical teams, technology teams, other parts of the business as well as directors and external parties.

In this session you will learn the why, what and how of automating the gathering, storing and displaying of information enabling self-service and reducing the interruptive calls on your time whilst ensuring that the data is correct and trustworthy. I will also show you how you can use this to enable consistency across your estate. This session will be of benefit to the “Accidental DBAs” as well as DBAs looking after large estates

The majority of the session will concentrate on the way I use PowerShell to gather the information and store it. I will also show you how to enable self-service with natural language query using PowerBi.

You will leave the session with all of the tools you need to return to work and convince your boss this is a worthwhile use of your time and to implement this solution to provide a modern way of providing accurate information about your estate

Code – https://github.com/SQLDBAWithABeard/DBA-Database

2015
December 5, 2015

SQL Saturday Southampton – Making Powershell useful for your team

You have heard about PowerShell and may be spent a little bit of
time exploring some of the ways in which it will benefit you at work.

You want to be able to perform tasks more specific to your
organisation and need to share them with your team.

Event Page

Slides and Demos 

I will show you how you can achieve this by demonstrating

– An easy way to learn the syntax

– How to explore SQL Server with Powershell

– How to turn your one off scripts into shareable functions

– How to ensure that your team can easily and quickly make use of and contribute to PowerShell solutions

– Where else to go for help

October 15, 2015

SQL Relay – Birmingham – Making Powershell useful for your team

You have heard about PowerShell and may be spent a little bit of
time exploring some of the ways in which it will benefit you at work.

You want to be able to perform tasks more specific to your
organisation and need to share them with your team.

Event Page

Slides and Demos 

I will show you how you can achieve this by demonstrating

– An easy way to learn the syntax

– How to explore SQL Server with Powershell

– How to turn your one off scripts into shareable functions

– How to ensure that your team can easily and quickly make use of and contribute to PowerShell solutions

– Where else to go for help

October 14, 2015

SQL Relay – Cardiff – Using Power Bi with my DBA Database

Every good DBA should have a DBA database.

A place to store information about all of their instances and databases. They should automatically gather information into that database. They are also often required to query that information to answer questions from other technical teams, Project Managers, Client Account managers, Compliance Teams, Auditors, Directors

Slides and Demos 

In this session I will talk about the way that I automate the gathering of this information and also how I use Power BI to be able to allow people to self serve answers to their own questions and remove some load from the DBA team. I am no BI expert so this session is aimed at DBAs who want to be able to show information using the latest tools rather than BI professionals

October 13, 2015

SQL Relay – Bristol – Using Power Bi with my DBA Database

Every good DBA should have a DBA database.

A place to store information about all of their instances and databases. They should automatically gather information into that database. They are also often required to query that information to answer questions from other technical teams, Project Managers, Client Account managers, Compliance Teams, Auditors, Directors

Slides and Demos 

In this session I will talk about the way that I automate the gathering of this information and also how I use Power BI to be able to allow people to self serve answers to their own questions and remove some load from the DBA team. I am no BI expert so this session is aimed at DBAs who want to be able to show information using the latest tools rather than BI professionals

October 12, 2015

SQL Relay – London – Continuous Learning

A look at the importance of continuing to learn every day, how and where
you can achieve this and suggestions that you can bring into the workplace.

Online Sway 

October 7, 2015

PASS Virtual Chapter Professional Development – Continuous Learning

A look at the importance of continuing to learn every day, how and where
you can achieve this and suggestions that you can bring into the workplace.

Online Sway 

August 17, 2015

SQL South West – Azure SQL VM Automated Backup and Azure Automated Patching

If you are building SQL VMs in Azure you can use Azure SQL VM Automated
Backup and Azure Automated Patching to reduce the amount of configurations
you need to do to ensure that your user databases are regularly backed up and
your servers are kept up to date with the latest updates.

Event Page

Slides and Demos

In this session you will learn how easy it is to set these up, the restrictions that

are in place and most importantly how you can restore from those backups
using both the GUI and PowerShell

 

August 17, 2015

SQL South West – Continuous Learning

A look at the importance of continuing to learn every day, how and where
you can achieve this and suggestions that you can bring into the workplace.

Online Sway 

July 31, 2015

SQL Relay Online – Making Powershell useful for your team

You have heard about PowerShell and may be spent a little bit of
time exploring some of the ways in which it will benefit you at work.

You want to be able to perform tasks more specific to your
organisation and need to share them with your team.

Event Page

Slides and Demos 

Video

I will show you how you can achieve this by demonstrating

– An easy way to learn the syntax

– How to explore SQL Server with Powershell

– How to turn your one off scripts into shareable functions

– How to ensure that your team can easily and quickly make use of and contribute to PowerShell solutions

– Where else to go for help

April 25, 2015

SQL Saturday Exeter – Making PowerShell useful for your team

You have heard about PowerShell and may be spent a little bit of
time exploring some of the ways in which it will benefit you at work.

You want to be able to perform tasks more specific to your
organisation and need to share them with your team.

Event Page

Slides and Demos 

I will show you how you can achieve this by demonstrating

– An easy way to learn the syntax

– How to explore SQL Server with Powershell

– How to turn your one off scripts into shareable functions

– How to ensure that your team can easily and quickly make use of and contribute to PowerShell solutions

– Where else to go for help

 

March 31, 2015

Battle of the Beards – Making PowerShell useful for your team

You have heard about PowerShell and may be spent a little bit of
time exploring some of the ways in which it will benefit you at work.

You want to be able to perform tasks more specific to your
organisation and need to share them with your team.

Event Page

Slides and Demos 

I will show you how you can achieve this by demonstrating

– An easy way to learn the syntax

– How to explore SQL Server with Powershell

– How to turn your one off scripts into shareable functions

– How to ensure that your team can easily and quickly make use of and contribute to PowerShell solutions

– Where else to go for help

March 19, 2015

PASS PowerShell Virtual Chapter – Making PowerShell useful for your team

You have heard about PowerShell and may be spent a little bit of
time exploring some of the ways in which it will benefit you at work.
You want to be able to perform tasks more specific to your
organisation and need to share them with your team.

Event Page

Video Link

Slides and Demos 

I will show you how you can achieve this by demonstrating

  • An easy way to learn the syntax
  • How to explore SQL Server with Powershell
  • How to turn your one off scripts into shareable functions
  • How to ensure that your team can easily and quickly make
    use of and contribute to PowerShell solutions
  • Where else to go for help
2014
September 16, 2014

SQL NorthEast User Group – Making Powershell Useful

SQL DBAs should be using Powershell. It will significantly aid them to make life easier.

Knowing where to start and how to easily use Powershell in a Team setting can seem complicated at first.

Code and Slides 

Event Page

By the end of the talk you will:

  • Have learnt some good tricks to help you to start learning Powershell
  • Gained some ideas of tasks you can use Powershell to assist you with
  • Identified further resources
  • Enabled your entire team to easily use the results of your learning.

 

 

May 15, 2014

SQL South West – PowerShell Box Of Tricks

The life of a SQL Server DBA is a busy one. A fount of all knowledge,
the SQL Server DBA is often interrupted with small questions and
routine tasks.

Code and Slides

Event Page

This session will show you some functions that you can use to save
time spent on this and hopefully inspire SQL DBAs to explore
PowerShell further by showing how easy it is to explore SQL Server
properties with it.

March 22, 2014

SQL Saturday Exeter – PowerShell Box of Tricks

 

The life of a SQL Server DBA is a busy one. A fount of all knowledge,
the SQL Server DBA is often interrupted with small questions and
routine tasks.

Event Page

Slides and Demos

This session will show you some functions that you can use to save
time spent on this and hopefully inspire SQL DBAs to explore
PowerShell further by showing how easy it is to explore SQL Server
properties with it.
2013
October 1, 2013

Cardiff SQL User Group – PowerShell Box of Tricks 

The life of a SQL Server DBA is a busy one. A fount of all knowledge,
the SQL Server DBA is often interrupted with small questions and
routine tasks.

Code and Slides
Event Page

This session will show you some functions that you can
use to save time spent on this and hopefully inspire SQL DBAs to
explore PowerShell further by showing how easy it is to explore SQL
Server properties with it.

May 16, 2013

SQL South West

Rob’s First ever talk – Some PowerShell!

 

 

2017

December 9th SQL Saturday Slovenia

November 10th SQL Glasgow

October 31st SQL PASS Summit (proctor)

October 28th PSConf Asia

October 27th PSConf Asia

October 26th PSConf Asia Pre-Con

October 24th Devops Singapore

October 13th SQL relay Bristol

October 12th SQL Relay Birmingham

October 11th SQL Relay Leeds

October 10th SQL Relay Nottingham

October 9th SQL Relay Reading

October 2nd DataMinds Connect 2017

September 30th SQL Saturday Holland

September 25th SQL South West

September 22nd PSDay.UK

September 21st Southampton Dev User Group

September 18th South Coast PowerShell User Group

September 16 PowerShell Saturday Stuttgart

August 24th Wellington SQL User Group New Zealand

July 24th SQL South West

Administrating SQL Server with PowerShell dbatools

July 15th SQL Saturday Manchester

Administrating SQL Server with PowerShell dbatools

Teaching the IT Pro how to Dev – PowerShell, Source Control & Unit Testing

June 9th – GroupBy

Green is Good – Red is Bad – Turning Your Checklists into Pester Tests

Video

June 2nd SQL Grillen – Lingen

Green is good, Red is bad – Turning your Checklists into Pester Tests

May 23rd Techorama – Antwerp

PowerShell SQL Server: Modern Database Administration with dbatools and dbareports

May 20th TUGAIT – Lisbon

Introduction to Pester – TDD for PowerShell

dbatools open source project – SQL Server and PowerShell together

PowerShell Conference Europe – Hannover

May 4th

Creating and Maintaining Successful Open Source Projects

Video

Green is bad Red is Good – Turning your Checklists into Pester Tests

Video

May 5th

Using the SQL Server Provider

Video

May 6th

Modern Database Administration using PowerShell and dbatools

Video

Test your Powershell code with AppVeyor for ITPros

Video

March 29th Battle of the Beards

Powershell: A Beards Favourite Shell

March 27th SQL South West User Group

Using the PowerShell SQL Provider

March 9th SQL Belfast User Group

Using the PowerShell SQL Provider

March 7th SQL North East User Group

Green is good, Red is bad: Turning Checklists into Pester Tests

PowerShell dbatools / SQL Server module

March 6th – Notts Dev Workshop Introduction to PowerShell

Code

February 15th –  PowerShell ❤ SQL Server: Modern Database Administration with dbatools and dbareports

Combined Dutch SQL and PowerShell User Group – Utrecht

February 10th – Powershell ❤ SQL Server Modern Database Administration

MS Cloud Summit Paris – Pre Con

January 23rd – A full day of PowerShell from basics to Azure and SQL Server

SQL Saturday Vienna

January 20th – Modern Database Administration using PowerShell and dbatools

January 19th –  SQL Saturday Pre-Con SQL Server and PowerShell – Better Together. Building the Modern DBAs Tools

2016

SQL Saturday Slovenia

December 10th – Green is good, Red is bad: Turning Checklists into Pester Tests
How I use PowerShell to automate the installation & upgrade of DBA scripts

Southampton SQL User Group

December 7th – Turn Your Checklist into a Pester Test

Birmingham SQL User Group

November 10th – PowerShell Loves SQL Server – Community Modules for All

PowerShell Conference Asia – Singapore

October 22nd – PowerShell, SQL and PowerBi-Reducing your Context Switching

October 22nd – Using my DBA Database to automate the install and upgrade scripts

October 21st – Powershell Profile Prepares Perfect Production Purlieu

SQL Relay Cardiff

October 4th – PowerShell Loves SQLServer – New module and community modules

SQL Relay – Guerrilla Talks

September 28th – New PowerShell Commands for SQL Server

SQL South West User Group

September 19th – New PowerShell Commands For SQL Server

Dutch PowerShell User Group

September 1st – PowerShell SQL and Power Bi

PowerShell Monday Munich

August 22nd PowerShell SQL and Power Bi

PASS PowerShell Virtual Chapter

August 18th PowerShell, SQL and Power BI – Reducing your Context Switching

Video

SQL Southampton User Group

August 3rd New PowerShell Commands For SQL Server

SQL Saturday Manchester

July 23rd – Powershell Profile Prepares Perfect Production Purlieu

PASS PowerShell Virtual Chapter – Co Presenter

July 6th –  The State of PowerShell, SQL Server, and SQLPS Video

SQL Saturday Dublin

June 18th – Making Powershell Useful for your Team

SQL Relay – Guerrilla Talks

April 27thFour things you should know to effectively learn PowerShell

Video

Powershell Conference Europe

April 21st

Power Bi, PowerShell and DBA Double Session Rob Sewell Part1

Video

Power Bi, PowerShell and DBA Double Session Rob Sewell Part2

Video

Code – https://github.com/SQLDBAWithABeard/DBA-Database

Making Powershell Useful For Your Team

Video 

Cardiff SQL User Group

March 30th – Return of the Beards PowerShell, SQL and PowerBi-Reducing your Context Switching

Code – https://github.com/SQLDBAWithABeard/DBA-Database

SQL Saturday Exeter

March 12th Using Power Bi with my DBA Database

Code – https://github.com/SQLDBAWithABeard/DBA-Database

SQL Southampton

February 3rd PowerShell, SQL and PowerBi-Reducing your Context Switching

Code – https://github.com/SQLDBAWithABeard/DBA-Database

SQL South West

January 25th – PowerShell, SQL and PowerBi-Reducing your Context Switching

Code – https://github.com/SQLDBAWithABeard/DBA-Database

2015

SQL Saturday Southampton 2015 December 5th

Using Power Bi with my DBA Database

SQL Relay

Birmingham October 15th – Making Powershell useful for your team

Cardiff October 14th – Using Power Bi with my DBA Database

Bristol October 13th – Using Power Bi with my DBA Database

London October 12th – Continuous Learning 2.0

PASS Virtual Chapter Professional Development

October 7th – Continuous Learning 2.0

SQL South West

August 17th – Continuous Learning 2.0
Azure SQL VM Automated Backup and Azure Automated Patching

SQL Relay

July 31 – Making Powershell useful for your team

SQL Saturday Exeter

April 25th Making Powershell useful for your team

Cardiff SQL User Group

March 31st – Battle of the BeardsMaking Powershell useful for your team

PASS Virtual Chapter PowerShell

March 19th  – Making Powershell useful for your teamWebinar Recording

2014

SQL NorthEast

Tue September 16th – PowerShell Box of tricks

SQL South West

May 15th –   PowerShell Box of tricks

SQL Saturday Exeter

March 22 –   PowerShell Box of tricks

2013

Cardiff SQL User Group

October 1st –   PowerShell Box of tricks

SQL South West

May 17th –