Most Active Speaker

Rob Sewell

Rob Sewell

Be-Whiskered Automator of Things

Exeter, United Kingdom

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 Data Platform MVP and an Azure MVP,a SQLBits committee member, a PowerShell Conference Europe organiser, and maintainer of many open-source projects. He 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

Awards

Area of Expertise

  • Information & Communications Technology

Topics

  • PowerShell
  • Azure DevOps
  • Azure Arc Data Services
  • Azure Bicep
  • Bicep
  • Infrastructure as Code

Deploy your Azure Data Solutions with Bicep and Azure DevOps or GitHub Actions

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

Looking After Yourself - Dealing with this New World

After the success of last years open session about Mental Health, we are returning with another session lead by Rob designed to enable you to be more capable dealing with the new Modern world

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

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

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

Why every project needs a dev container - an introduction

Dev containers are a VS Code feature that allow us to define the perfect development environment for our project.

This enables a definition of a working development environment for all of your team or your open-source contributors to be quickly and easily provisioned and updated. It will even work in a browser! No more worrying about the right hardware, software installations, dependencies, or updates. You can control it all with dev containers and make it simple and easy.

In this session we'll cover why dev containers can be so useful, show off an example we built to make contributing to dbachecks (an open-source module combining pester & dbatools to test our infrastructure) easy, and how you can easily add a dev container to your own projects.

A SQL environment for test or how we provided a dbatools training day at SQLBits using devcontainers

In March Jess Pomfret and I gave a Training Day for 5 million* attendees about dbatools.

For those that dont know, dbatools is the most popular SQL Server open source PowerShell module and has used blog posts from many of the SQL community as inspiration for over 900 million* commands written by over 4tn* contributors.

As we did not know even right up till the day whether we would be delivering together or separately, in person or remotely, we decided to put our demo into a repository and deliver it from a controlled environment (two containers) using GitHub Actions, Docker Hub and VS Code.

We learned some things along the way and had some fun also and we shall share this all with you.

Whilst this is about dbatools, PowerShell, containers, Pester and some fun. It will also show you how you can create a SQL Server environment which will enable you to repeatedly run demos, allow others to run the same code as you.

* It is highly likely that some numbers may have been exaggerated

Automate your DBA tasks with dbatools and dbachecks

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 take your dbatools and dbachecks skills to the next level or be introduced to dbatools and learn how effective it 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

There will be many practical examples of how dbatools and dbachecks can help to save time in DBA administration duties

- Creating Availability Groups
- Syncing Agent Jobs and Logins between replicas
- Finding SQL Instances on your estate
- Working with Central Management Server
- Disaster Recovery
- Backup Testing
- Simple instance migrations
- Complex instance migrations
- Tracking Activity
- Simplify application upgrades with database snapshots
- Working with other community tools with dbatools
- Encompassing dbatools in DevOps
- Validating your estate
- Using dbatools in the cloud (i.e. working with Azure SQL Database)

And much much more

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. You will improve your knowledge and skills, see how the modern DBA will work and have fun at the same time.

Who Are You?

You are a DBA, senior or junior, looking after 1 or 100,000 instances, a developer who interacts with SQL Server, an accidental DBA or you have DevOps in your job title.
You are interested in improving your PowerShell skills for SQL Server or reducing the time you and your team spend administering SQL Server.
You have spent 1 day or 20 years working with SQL Server.
You know that you work in a field where automation is king and want to understand more of what is available.
You are interested in learning and improving your automation skillset.

What do you need?

All you need is yourself! We would recommend that you bring something to take notes with as well as a minimum.

All scripts and slides will be provided to you. If you wish to follow along with most of the demos you should have access to a machine with PowerShell v 5 or above with a SQL Server 2012 or above instance.

20 Productivity tools we use to make life easier

You are busy, we are busy, everyone is busy. These are the tools that two busy consultants use to improve their productivity.

We want to tell you about the tools that we use; that maximise our time, simplify our life, reduce our key strokes and generally make us appear more amazing. So that you can use them too.

Think PowerShell and SQL is meh? Meet dbatools!

Come and join one of the creators of the most popular SQL Server open source PowerShell module and learn how we have used blog posts from many of the SQL community as inspiration for over 900 million* commands written by over 4tn* contributors.

Let me show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed module dbatools.

I will even demonstrate in containers using Jupyter Notebooks that you can try out for yourself on your own machine.

Afraid of PowerShell?
Worried its too complicated?
Don't want to go through the learning curve?

Let me show you with plenty of demos how easy and straight forward it can be and I will save you time starting Monday

Want to restore an entire servers databases to the latest available point in time of the backups in just one line?
Be useful to know the Last DBCC Check for your entire estate in only one line of code?
Need to test your restores but it's complicated?
and many many more
All this in a fast-paced, fun session
* Some numbers may have been exaggerated

A deeper dive into dev containers for your project

Dev containers are a VS Code feature that allow us to define the perfect development environment for our project.

This enables a definition of a working development environment for all of your team or your open-source contributors to be quickly and easily provisioned and updated. It will even work in a browser! No more worrying about the right hardware, software installations, dependencies or updates. You can control it all with dev containers and make it simple and easy.

In this session we will dive deeper into dev containers and take a look at how we can use multiple containers for our development, multiple configurations for our dev containers, how to customise the entire experience and how to connect to your containers externally.

This sesssion is a natural follow on from our Why every project needs a dev container session but can also live on its lonesome

Using PowerShell with Excel

You are often required to put data into Excel for sharing with business users. This is frequently a manual process involving copying and pasting and manipulating in Excel.

Come and lose the CTRL + C CTRL + V by learning how the ImportExcel module can help to automate this for you, including creating charts and conditionally formatting cells.

Notebooks, PowerShell and Excel Automation

Everyone loves Excel. A common request that I hear is can you put that into Excel for me, please. I love automation and so have combined two of my favourite tools PowerShell and Notebooks. Using Jupyter Notebooks to accomplish regular tasks and run-books has become common over the past year.

A particular use-case that my clients have found very useful is to quickly create Excel sheets of information using Notebooks, PowerShell, and the ImportExcel module.

Let me share my experience with you and show you how to create your own Notebooks for your users and the tactics I have learned to enable users to self-service and create their own Excel Workbooks.

psconf.eu 2024 Sessionize Event Upcoming

June 2024 Antwerpen, Belgium

SQLBits 2024 - General Sessions Sessionize Event

March 2024 Farnborough, United Kingdom

SQLBits 2024 - Full day training sessions Sessionize Event

March 2024 Farnborough, United Kingdom

DataTune 2024 Sessionize Event

March 2024 Nashville, Tennessee, United States

Data Community Austria Day 2024 Sessionize Event

January 2024 Vienna, Austria

New Stars of Data Speaker Improvement Library Sessionize Event

December 2023

Intersection of Technology Fall 2023 Sessionize Event

December 2023 Orlando, Florida, United States

#DataWeekender 6.5 Sessionize Event

November 2023

Data Relay 2023 Sessionize Event

October 2023

SQL Friday Season 7 (September - December 2023) User group Sessionize Event

September 2023

Data Moshpit 2023 Sessionize Event

September 2023 Berlin, Germany

DATA:Scotland 2023 Sessionize Event

September 2023 Edinburgh, United Kingdom

Data Saturday Oslo 2023 Sessionize Event

September 2023 Oslo, Norway

psconf.eu 2023 Sessionize Event

June 2023 Prague, Czechia

Data Céilí 2023 Sessionize Event

June 2023 Dublin, Ireland

SQLBits 2023 - General Sessions Sessionize Event

March 2023 Newport, United Kingdom

SQLBits 2023 - Full day training sessions Sessionize Event

March 2023 Newport, United Kingdom

PSDayUK 2023 Sessionize Event

March 2023 London, United Kingdom

South Coast Summit 2022 Sessionize Event

October 2022 Southampton, United Kingdom

Data Relay 2022 Sessionize Event

October 2022

PSConfEU MiniCon Sessionize Event

September 2022

DATA:Scotland 2022 Sessionize Event

September 2022 Glasgow, United Kingdom

psconf.eu 2022 Sessionize Event

June 2022 Vienna, Austria

DataGrillen 2022 Sessionize Event

June 2022 Lingen, Germany

Global Azure Lüdinghausen 2022 Sessionize Event

May 2022

SQLBits 2022 Sessionize Event

March 2022 London, United Kingdom

SQL Ireland Meetup - 2022 Sessionize Event

January 2022 Dublin, Ireland

Data Saturday Portugal 2021 Sessionize Event

December 2021

SQL Ireland – Annual Christmas Event 2021 Sessionize Event

December 2021

Data Saturday Slovenia 2021 Sessionize Event

December 2021

PASS Data Community Summit 2021 Sessionize Event

November 2021

New Stars of Data #3 Sessionize Event

October 2021

Azure Bootcamp South Africa 2021 Sessionize Event

September 2021

PowerShell, DevOps and Cloud Conference Sessionize Event

September 2021

Data Saturday Oslo - Virtual Sessionize Event

September 2021

Data ANZ Sessionize Event

June 2021

DataMinutes #1 Sessionize Event

June 2021

Power Saturday 2021 Sessionize Event

June 2021

Data Saturday Southwest US Sessionize Event

May 2021

#DataWeekender v3.1 Sessionize Event

May 2021

Global Azure Lüdinghausen 2021 Sessionize Event

April 2021

New Stars of Data 2021 Sessionize Event

March 2021

Virtual Scottish Summit 2021 Sessionize Event

February 2021

#DataWeekender #TheSQL Sessionize Event

October 2020

Data Ceili Dublin 2020 Sessionize Event

July 2020 Dublin, Ireland

Power Saturday 2020 Sessionize Event

June 2020 Paris, France

psconf.eu 2020 Sessionize Event

June 2020 Hannover, Germany

Data Community Weekender Europe Sessionize Event

May 2020

dataMinds Connect 2019 Sessionize Event

October 2019 Mechelen, Belgium

Data Saturday Holland Sessionize Event

October 2019 Utrecht, The Netherlands

DATA:Scotland 2019 Sessionize Event

September 2019 Glasgow, United Kingdom

DataGrillen 2019 Sessionize Event

June 2019 Lingen, Germany

Techorama Belgium 2019 Sessionize Event

May 2019 Antwerpen, Belgium

Data in Devon 2019 Sessionize Event

April 2019 Exeter, United Kingdom

SQLGLA 2018 Sessionize Event

September 2018 Glasgow, United Kingdom

SQLGrillen 2018 Sessionize Event

June 2018 Lingen, Germany

Battle of the Beards Sessionize Event

March 2017

Rob Sewell

Be-Whiskered Automator of Things

Exeter, United Kingdom