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

Techorama – Continuous Delivery to the PowerShell Gallery with Azure DevOps
Come and join Cloud and DataCenter MVP Rob Sewell and learn how to publish your PowerShell module to the PowerShell Gallery continuously for free using AzureDevOps enabling you to easily share your code with all of the community or colleagues
We will have plenty of demos and scripts and discuss
From Scripts to Modules and why
Using VS Code
Using Plaster to create the customised framework for your modules
How to use Script Analyser to help you to code better
Why you should use Test Driven Development and how to do that for your PowerShell modules with Pester
The importance of Get-Help and why you need write good help
The PowerShell Gallery and how to create your own private PowerShell Gallery
Signing your code
How to continuously deliver changes to your PowerShell Module in the gallery using GitHub and AzureDevOps
We will have a lot of fun along the way and you will return to work with a lot of ideas, samples and better habits
Register – https://techorama.be
Techorama – Workshop – Professional and Proficient PowerShell
IT Pros are seeing the benefit of using PowerShell to automate away the mundane. A modern technology professional needs to be able to interact with multiple services and learning PowerShell increases your ability to do that and your usefulness to your company.
At the end of this fun filled day with Rob, a former SQL Server DBA turned professional automator, you will be much more confident in being able to approach any task with PowerShell and you will leave with all of the code and demos.
We will cover:
How to learn how to interact with any technology using PowerShell
Understanding the syntax
The importance of Get-Help and how PowerShell enables you to help yourself
Why to write your own Modules and how to make them available to all of your team
A quick automated method to creating your module framework
Unit testing and debugging your code
How to continuously deliver changes to your PowerShell modules using GitHub and Azure DevOps
We will have a lot of fun along the way and you will return to work with a lot of ideas, samples and better habits to become a PowerShell ninja and save yourself and your organisation time and effort. Prerequisites: Know how to open PowerShell!! It is better if you have typed in a command. Those brand new to PowerShell might find the learning curve steep but everyone will find benefit.
Register Here – https://techorama.be/workshops/professional-and-proficient-powershell/
Data In Devon – How Can You Do CI/CD with SQL Databases using AKS and ACR and Azure DevOps?
Continuous Delivery using the Azure Managed Kubernetes Services (which is called Azure Container Service and known as AKS !) and Azure Container Registry (ACR) using Visual Studio Team Services (VSTS)
It sounds like we are just using cool tech acronyms but come on a journey with Eelco Drost and Rob Sewell and we will show you how simple and easy it is to enable your team to be able to Spin up new SQL databases for developers to use (and when they break it they can do it again.. and again… and again)
Automatically provision testing environments run tests and enable control of progression of changes.
Complete deployment to production automatically in a controlled and useful fashion.
We will teach you the lessons we have learnt enabling data teams to be able to make changes more effectively and proficiently and show you how you can too.
How Can You Do CI/CD with SQL Databases using AKS and ACR and VSTS?
Data In Devon – Workshop – Getting up to speed with PowerShell
PowerShell is cross-platform, it works exactly the same on Windows, on Linux and Mac. It is awesome for automation and amazing for administration.
Come and join Cloud and Data Center MVP Rob Sewell and spend a day getting yourself up to speed with PowerShell.
We will cover
- the basics about PowerShell, PowerShell security
- how to open it, how to install it.
- 4 vital commands to enable you to be able to help yourself
- The PowerShell Gallery and how to find, install and use additional modules
- Reading the language
- Working with output
- We will even delve into scripting with PowerShell and how to validate your environment
There will also be the opportunity to learn about any areas of PowerShell, Automation, CI/CD that you have questions about.
What do I need to know / bring with me
Attendees wanting to follow along should bring a laptop.
Register https://sqlsouthwest.co.uk/training-day-schedule/#Powershell
SQL Bits – Validate Your SQL Server Estate with Ease Using dbachecks
As a SQL DBA you want to know that your SQL Server Estate is compliant with the rules that you have set up. Now there is a simple method using PowerShell and you can get the results in PowerBi or embedded into your CI/CD solution
Details such as:
How long since your last backup?
How long since your last DBCC Check?
Are your Agent Operators Correct?
Is AutoClose, AutoShrink, Auto Update Stats set up correctly?
Is DAC Allowed?
Are your file growth settings correct, what about the number of VLFs?
Is your latency, TCP Port, PS remoting as you expect?
Is Page Verify, Data Purity, Compression correctly set up?
And many more checks (even your own) can be achieved using the dbachecks PowerShell module brought to you by the SQL Collaborative team.
and all configurable so that you can validate YOUR settings
Join one of the founders of the module, Rob Sewell MVP. and he will show you how easy it is to use this module and release time for more important things whilst keeping the confidence that your estate is as you would expect it.
https://sqlbits.com/Sessions/Event18/Validate_Your_SQL_Server_Estate_with_Ease_Using_dbachecks
SQLBits – Workshop – Professional and Proficient PowerShell: From Writing Scripts
DBAs are seeing the benefit of using PowerShell to automate away the mundane. A modern data professional needs to be able to interact with multiple technologies and learning PowerShell increases your ability to do that and your usefulness to your company.
At the end of this fun filled day with Rob, a former SQL Server DBA turned professional automator, you will be much more confident in being able to approach any task with PowerShell
and you will leave with all of the code and demos. You can even follow along if you bring a laptop with an instance of SQL Server installed.
We will cover
• How to learn how to interact with any technology using PowerShell
• Understanding the syntax
• The importance of Get-Help and how PowerShell enables you to help yourself
• Why to write your own Modules and how to make them available to all of your team
• A quick automated method to creating your module framework
• Unit testing and debugging your code
• How to continuously deliver changes to your PowerShell modules using GitHub and Azure DevOps
• Tips and tricks for script writing with the popular open-source community dbatools module
• How to validate your SQL Server estate with PowerShell
• Advanced SQL Server Agent and PowerShell management
We will have a lot of fun along the way and you will return to work with a lot of ideas, samples and better habits to become a PowerShell ninja and save yourself and your organisation time and effort.
Prerequisites: Know how to open PowerShell!! It is better if you have typed in a command. Those brand new to PowerShell might find the learning curve steep but everyone will find benefit. Bring your laptop with SQL Server and WideWorldImporters and you can follow along.
Pre-requisites
Very basic experience with PowerShell
Laptop Required: Optional
https://sqlbits.com/Sessions/Event18/Professional_and_Proficient_PowerShell_From_Writing_Scripts
Manchester Data Platform User Group – #DataDrinks A community-run social for data folk and #SQLBits attendees.
Hosted by Manchester and Leeds’ Data Platform User Groups (https://www.meetup.com/leeds_data_platform/), this is an informal get together where you’ll meet fellow data professionals, have a drink, have a laugh, and learn something new. They’ll be a casual Q&A session compered by Rob Sewell where anybody can ask or answer data platform related questions.
This event is free, and light bites/snacks and some drinks will be provided by our sponsors Aireforge (https://www.aireforge.com/), who will be around on the night.
Hosted at Rainbar, in private function room close to the SQLbits venue
Birmingham Data Platform User Group – dbachecks – The PowerShell Module to validate your SQL Estate
As a SQL DBA you want to know that your SQL Server Estate is compliant with the rules that you have set up. Now there is a simple method to set this up using PowerShell and you can get the results in PowerBi or a report emailed to you on a schedule. Details such as How long since your last backup? How long since your last DBCC Check? Are your Agent Operators Correct? Is AutoClose, AutoShrink, Auto Update Stats set up correctly? Is DAC Allowed? Are your file growth settings correct, what about the number of VLFs? Is your latency, TCP Port, PS remoting as you expect? Is Page Verify, Data Purity, Compression correctly set up? and many more checks (even your own) can be achieved using the dbachecks PowerShell module brought to you by the dbatools team. Join one of the founders of the module, Rob Sewell MVP. and he will show you how easy it is to use this module and release time for more important things whilst keeping the confidence that your estate is as you would expect it
Full house tonight for @pkamasani and @sqldbawithbeard talking #PowerBI and #PowerShell pic.twitter.com/Jk0oEfTHxm
— Microsoft Data Platform Group Birmingham (@MSDataGroupBrum) August 9, 2018
Next up the ever awesome @sqldbawithbeard on #PowerShell in #SQLServer pic.twitter.com/DmuvvYEwaC
— Microsoft Data Platform Group Birmingham (@MSDataGroupBrum) August 9, 2018
If using #PowerShell use VSCode not the IDE #TopTipsFromTheBeard @sqldbawithbeard pic.twitter.com/YT0t7vPHsY
— Microsoft Data Platform Group Birmingham (@MSDataGroupBrum) August 9, 2018
SQL Saturday Manchester – Precon – PowerShell and SQL Server with Rob Sewell
Since Microsoft announced the SQL Server PowerShell module with the July release of SSMS more and more people have been using PowerShell to help them to administer their SQL Servers.
The SQL Server Collaborative organisation have created the free, open source PowerShell module dbatools lead by Chrissy LeMaire and with over 80 contributors to extend PowerShell support for SQL Server even further
Join Cloud and Data Center MVP and dbatools evangelist Rob Sewell to learn how to you can make use of both of these modules to simplify and automate your DBA needs.
You will be shown how you can accomplish many routine DBA tasks easily and simply with one line of PowerShell code
Come and join me 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
The folk in my pre-con at #sqlsatmanc didn't know why you should test your backups so it's @GFritchey to the rescue. Thank you Grant pic.twitter.com/DZ2T9A4Ut9
— Rob Sewell (@sqldbawithbeard) July 13, 2018
Im at #Powershell and #sqlserver by @sqldbawithbeard #sqlsatmanc pic.twitter.com/GOO6dTk11W
— Lewis McKee (@shotbylewism) July 13, 2018
#PowerShell & #SQLServer #sqlsatmanc training day with @sqldbawithbeard pic.twitter.com/3MJ29SnYNG
— flyingcod (@flyingcod) July 13, 2018
Great to be here at the Powershell pre-con with @sqldbawithbeard @SQLSatMcr
— Tom (@tomevans_data) July 13, 2018
Great to be here at the Powershell pre-con with @sqldbawithbeard @SQLSatMcr
— Tom (@tomevans_data) July 13, 2018
After watching loads of his stuff I got to meet the man himself. He’s like a database Jedi Master😂😂. Great course. Thanks Rob 👍🏾 #sqldbawithbeard #sqlsatmanc https://t.co/r6zXamHXbX pic.twitter.com/uTPp1BH0xf
— Conrad Gauntlett (@connyg69) July 14, 2018
SQL Saturday Manchester – dbachecks – The PowerShell Module to validate your SQL Estate
As a SQL DBA you want to know that your SQL Server Estate is compliant with the rules that you have set up. Now there is a simple method to set this up using PowerShell and you can get the results in PowerBi or a report emailed to you on a schedule. Details such as How long since your last backup? How long since your last DBCC Check? Are your Agent Operators Correct? Is AutoClose, AutoShrink, Auto Update Stats set up correctly? Is DAC Allowed? Are your file growth settings correct, what about the number of VLFs? Is your latency, TCP Port, PS remoting as you expect? Is Page Verify, Data Purity, Compression correctly set up? and many more checks (even your own) can be achieved using the dbachecks PowerShell module brought to you by the dbatools team. Join one of the founders of the module, Rob Sewell MVP. and he will show you how easy it is to use this module and release time for more important things whilst keeping the confidence that your estate is as you would expect it
My First Sql Saturday as a helper and who do I get to 'help'? @sqldbawithbeard talking about @dbachecks #sqlsatmanc pic.twitter.com/1A2chgAfcR
— Michał Poręba (@michalinwales) July 14, 2018
Great presentation on @dbachecks from @sqldbawithbeard at @SQLSatMcr 😎 pic.twitter.com/zTYbRZ5bbj
— Mark Allison (@dataguzzle) July 14, 2018
Manchester Data Platform User Group – Administrating SQL Server with PowerShell dbatools
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. 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 its complicated? and many many more All this in a fast paced, fun session
So @tsqltidy says "oh show a real migration with dbatools instead of the video" so I created a container and copied everything except the databases onto it in a couple of minutes to 🧙♂️
dbatools is dead mint
as they say in Manchester#sqlsatmanc— Rob Sewell (@sqldbawithbeard) July 12, 2018
@sqldbawithbeard Presenting at the SQL Manchester Usergroup @ManSSUG #Powershell #DBAtools #SQLfamily. Start of 3 days of SQL/Data content at SQL Saturday Manchester @SQLSatMcr pic.twitter.com/BjXGubt30w
— Mcr Data Platform User Group (@McrDataPlatform) July 12, 2018
Time to head over to the pre #sqlsatmanc user group. All my @PSPester tests have passed so looking forward to talking dbatools pic.twitter.com/1uhGJU7DCG
— Rob Sewell (@sqldbawithbeard) July 12, 2018
Leeds Data Platform User Group – dbachecks – The PowerShell Module to validate your SQL Estate
As a SQL DBA you want to know that your SQL Server Estate is compliant with the rules that you have set up. Now there is a simple method to set this up using PowerShell and you can get the results in PowerBi or a report emailed to you on a schedule. Details such as
How long since your last backup?
How long since your last DBCC Check?
Are your Agent Operators Correct?
Is AutoClose, AutoShrink, Auto Update Stats set up correctly?
Is DAC Allowed?
Are your file growth settings correct, what about the number of VLFs?
Is your latency, TCP Port, PS remoting as you expect?
Is Page Verify, Data Purity, Compression correctly set up?
and many more checks (even your own) can be achieved using the dbachecks PowerShell module brought to you by the dbatools team.
Join one of the founders of the module, Rob Sewell MVP. and he will show you how easy it is to use this module and release time for more important things whilst keeping the confidence that your estate is as you would expect it.
So I come to #sqlleeds user group and get met with @jodouglass wearing the shirt she won at #sqlbits @cl pic.twitter.com/0RCOV35GUa
— Rob Sewell (@sqldbawithbeard) July 10, 2018
Watching @sqldbawithbeard talk about talk about @dbachecks at @LeedsSql pic.twitter.com/Zfolm1HRlY
— Phil Grayson (@databoffin) July 10, 2018
Sentry One Webinar – Panel Discussion: Tips and Tricks to Growing Your SQL Server Estate from SMB to Enterprise Scale
Growing pains are a common and unpleasant part of many life experiences, from our youth as we grew up, to the difficulties companies experience when growing from a Small- or Medium-sized Business (SMB) to a major Enterprise, to IT teams that grow from having no specialized database skillset to supporting and grooming thousands of databases concurrently.
It’s a learning process, one littered with many pitfalls and potholes. So what do those top-tier DBAs do to ensure reliable and fast performance despite managing hundreds or even thousands of SQL Servers?
View this panel discussion to learn those secrets! This collection of tips, tricks, tools, and techniques will help you achieve consistently better performance, support a rapidly growing infrastructure, perform fast and accurate troubleshooting, and deliver more effective customer service.
Thank you again for this. This was amazing and learned some really good speaking tips during the entire event. Would love to do it again!
— Jason Squires (@js_0505) June 28, 2018
SQL Grillen – dbachecks – The PowerShell Module to validate your SQL Estate
As a SQL DBA you want to know that your SQL Server Estate is compliant with the rules that you have set up. Now there is a simple method to set this up using PowerShell and you can get the results in PowerBi or a report emailed to you on a schedule. Details such as
How long since your last backup?
How long since your last DBCC Check?
Are your Agent Operators Correct?
Is AutoClose, AutoShrink, Auto Update Stats set up correctly?
Is DAC Allowed?
Are your file growth settings correct, what about the number of VLFs?
Is your latency, TCP Port, PS remoting as you expect?
Is Page Verify, Data Purity, Compression correctly set up?
and many more checks (even your own) can be achieved using the dbachecks PowerShell module brought to you by the dbatools team.
Join one of the founders of the module, Rob Sewell MVP. and he will show you how easy it is to use this module and release time for more important things whilst keeping the confidence that your estate is as you would expect it.
We had such fun presenting about #DbaChecks At #sqlgrillen
Thank you for coming along. pic.twitter.com/uRA8ZdYQFd— Rob Sewell (@sqldbawithbeard) June 22, 2018
@SQLGrillen managent information about #dbachecks with @sqldbawithbeard, @cl and @ClaudioESSilva pic.twitter.com/mizdKJz8xt
— Andre van den Berg (@aavdberg) June 22, 2018
#SqlGrillen has @cl @sqldbawithbeard @ClaudioESSilva talk about @dbachecks .
Even if you know #DbaChecks, you should come over here for the fun they bring!#PowerShell pic.twitter.com/5auwA0fLEv— Jan Mulkens (@JanMulkens) June 22, 2018
Have @dbachecks export the data of it's checks to your own monitoring system like #Nagios for example. As long as the system can read JSON/XML/CSV, it can read these checks@sqldbawithbeard @ClaudioESSilva #DbaChecks #SqlGrillen pic.twitter.com/PAUcs5D9vE
— Jan Mulkens (@JanMulkens) June 22, 2018
SQL Saturday Cork – Administrating SQL Server with PowerShell dbatools
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. 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 its complicated? and many many more All this in a fast paced, fun session
SQL Day – dbachecks – The PowerShell Module to validate your SQL Estate
As a SQL DBA you want to know that your SQL Server Estate is compliant with the rules that you have set up. Now there is a simple method to set this up using PowerShell and you can get the results in PowerBi or a report emailed to you on a schedule. Details such as
How long since your last backup?
How long since your last DBCC Check?
Are your Agent Operators Correct?
Is AutoClose, AutoShrink, Auto Update Stats set up correctly?
Is DAC Allowed?
Are your file growth settings correct, what about the number of VLFs?
Is your latency, TCP Port, PS remoting as you expect?
Is Page Verify, Data Purity, Compression correctly set up?
and many more checks (even your own) can be achieved using the dbachecks PowerShell module brought to you by the dbatools team.
Join one of the founders of the module, Rob Sewell MVP. and he will show you how easy it is to use this module and release time for more important things whilst keeping the confidence that your estate is as you would expect it.
Next @sqldbawithbeard is going to talk about dbachecks. Great effort for translating some of slides to polish @SadowskiMichal @b_ratajczyk pic.twitter.com/fEOjG9zvIk
— J Rokicki (@DataSic) May 16, 2018
Amazin tools, amazing person. Good job @sqldbawithbeard at #sqlday.
Photo by @cathrinew .— Mikey Bronowski (@MikeyBronowski) May 16, 2018
SQL Saturday Finland – Administrating SQL Server with PowerShell dbatools
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. 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 its complicated? and many many more All this in a fast paced, fun session
Packed room for @sqldbawithbeard's session on administrating #SQLServer with #powershell and #dbatools. Slides in Finnish! 😀 #SQLSatFinland pic.twitter.com/FdGYGXX6y1
— Cathrine Wilhelmsen (@cathrinew) May 12, 2018
Did you know @sqldbawithbeard customizes his slides for the locals at #SqlSatFinland?
That's at least as awesome as the @psdbatools he's talking about! pic.twitter.com/22c1MluyCz— Jan Mulkens (@JanMulkens) May 12, 2018
Say whaaaaat? I know what i'll be doing on monday!
Creating extended events will not get easier! @psdbatools even has a ton of default ones from Microsoft and the community integrated!
Thanks @sqldbawithbeard for showing us at #SqlSatFinland pic.twitter.com/u8aYZBvmC4— Jan Mulkens (@JanMulkens) May 12, 2018
It was very cool recommending https://t.co/7Cfp6cMoqx to an attendee in my Always On talk and then getting to meet @sqldbawithbeard immediately afterwards as his session followed mine!
— Matt Gordon (@sqlatspeed) May 12, 2018
PowerShell Conference Europe – Continuous Delivery for your Module to the PowerShell Gallery
An intro session to show how to deploy a PowerShell module with CD In this fast paced demo heavy session we will – Use Plaster – Use GitHub – Use Pester – Use VSTS to Build, Test & Release All using a module that uses the Microsoft Cognitive Services Faces API to analyse Beards!
Nottingham PowerShell User Group
Now finalised, it’s a beard double header. Rob Sewell will be presenting 2 of his great sessions.
These 2 add up to a great introduction into using modern Continuous Integration and Continuous Deployment (or Devops if you prefer) in the PowerShell world.
Session 1:
Introuction to Pester:
Start from nothing and use Test Driven Development to write a PowerShell function that uses the Microsoft Cognitive Services API to analyse pictures. I will take you on a journey from nothing to a complete function, making sure that all of the code works as expected, is written according to PowerShell best practices and has a complete help system. You will leave this session with a good understanding of what Pester can do and a methodology to develop your own PowerShell function
Session 2:
Continuous Delivery for your Module – Put your PowerShell modules in the gallery with just a commit.
An introduction session to show you how YOU can deploy your PowerShell module to a PowerShell Gallery (public or private) automatically
In this fast paced demo heavy session we will
– Use Plaster to create our module framework
– Use GitHub for Version Control
– Use Pester to develop our module with TDD
– Use VSTS to Build, Test (with Pester) and Release our changes to the PowerShell Gallery
Within 45 minutes you will have the tools that you require to continuously deliver changes safely to your published PowerShell module for the consumption of others
Cosy #powershell knowledge transfer from @sqldbawithbeard
If you wanted to learn about pester you should have been here pic.twitter.com/93gDBGyXt5— Nottingham PowerShell User Group (@NottsPSUG) April 12, 2018
Did we just do an update to @dbachecks in the pub at @NottsPSUG
Yes we did 😎
1.1.121 is out with a speed improvement to the broker service check
Also HUGE props to @KoprowskiT
For the sharing to pc screen— Rob Sewell (@sqldbawithbeard) April 12, 2018
When projector at the venue doesn’t work but both bearded MVPs use #Windows10 they can simply share screens from @sqldbawithbeard to other machine at #Nottingham #PowerShell User Group Meetup conducted by @napalmgram #MVPsSolvingProblems #MVPBuzz pic.twitter.com/enZgznYMCz
— Tobias Koprowski (@KoprowskiT) April 12, 2018
This is the door to get into the Nottingham PowerShell User Group location 😎 pic.twitter.com/gxqYJ8EyRg
— Rob Sewell (@sqldbawithbeard) April 12, 2018
24 Hours Of PASS – Writing PowerShell with VS Code
We should be using VS Code to write our PowerShell code. In this presentation I will show you how to set up VS Code, which extensions I use, and some of the features that make writing PowerShell easy using VS Code.
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
LPT from @cl and @sqldbawithbeard : #dontbeadick pic.twitter.com/0FS5R2WK6u
— Lennart (@Baiteman) 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
Most inspiring session of the day! Thanks @sqldbawithbeard #psconfeu #pester pic.twitter.com/AzYuGlndX5
— Tom-Inge Larsen (@ti83) May 3, 2017
"According to my watch, I'm 26 minutes into a dynamic workout" – @sqldbawithbeard live on stage at #PSConfEU pic.twitter.com/kNoNI5Ts5C
— Mathias Jessen (@IISResetMe) May 3, 2017
The @sqldbawithbeard in action #PSConfEU – have you done your tests today ??
— Flemming Rohde (@FlemmingRohde) May 3, 2017
Let's go with Pester #PSConfEU @PSConfEU @sqldbawithbeard #mythbusters pic.twitter.com/zRZgIDDGI6
— M.S. (@eich0rn) May 3, 2017
The magnificent @sqldbawithbeard competes against the “comprehensive slide” award. #PSConfEu pic.twitter.com/avVvsO8tPy
— 🏳️🌈 Thorsten Butz (@thorstenbutz) May 3, 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!
.@way0utwest Distinct lack of beards so far pic.twitter.com/HcRKJAje82
— Rob Sewell (@sqldbawithbeard) March 29, 2017
It's not too late to see @sqldbawithbeard & Co this morning at @battlingbeards
Register at https://t.co/dYFslUVAza pic.twitter.com/hQ2cL0giU8— Steph Locke (@TheStephLocke) March 29, 2017
Battle of the Beards – Its tech conference for a good cause pic.twitter.com/pULj9dIvMJ
— Rob Sewell (@sqldbawithbeard) March 29, 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
SQL Belfast User Group – Using the PowerShell SQL Provider
Introduction to Powershell SQLServer provider Using the SQL Powershell Server Module (SQLPS)
@sqldbawithbeard presenting to SQL Belfast pic.twitter.com/xRoKdjDuzs
— Mary Fealty (@Br0adtree) March 9, 2017
great session, to have you here would be awesome! Thanks loads
— Mary Fealty (@Br0adtree) March 9, 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.
So @sqlne had a double dose of @gfritchey tonight. Here they are watching the backup rant pic.twitter.com/sUhqbhb9Sd
— Rob Sewell (@sqldbawithbeard) March 7, 2017
@SQLNE @sqldbawithbeard thanks for a great night of @sqlpowershell and intro to @psdbatools
— Malcolm Smith (@mhSQL) March 7, 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 🙂
We just stared our #PowerShell workshop! @sqldbawithbeard @rebelrecruit @AccelerateNttm @SHAConsultingUK pic.twitter.com/NpO5DVc5Wh
— Notts Dev Workshop (@nottsdev) March 6, 2017
We just started #powershell with @sqldbawithbeard at @nottsdev first meeting pic.twitter.com/CMHB8w48Av
— Tobias Koprowski (@KoprowskiT) March 6, 2017
A great turn out for our very first gathering! @nottsdev @sqldbawithbeard @rebelrecruit @AccelerateNttm @SHAConsultingUK pic.twitter.com/fUVJHzdwt8
— Mica Bell (@MicaSophieBell) March 6, 2017
Ace 1st @nottsdev tonight @PowerShell_Team, @code & @PSPester with @sqldbawithbeard. Congrats @MicaSophieBell, @GosiaBorzecka & @rebeljulija pic.twitter.com/GqgJRCU1rV
— Peter Gallagher (@PJGCreations) March 7, 2017
. @cl I asked who knows about @psdbatools –> 100% of @nottsdev attendees 😀👏💥 cc @KoprowskiT @nottsdev pic.twitter.com/ea4FM4UgSZ
— Rob Sewell (@sqldbawithbeard) March 6, 2017
9 pm. Time go home. Thank you @sqldbawithbeard for the great workshop about #PowerShell! pic.twitter.com/yWQSL6LQXb
— Notts Dev Workshop (@nottsdev) March 6, 2017
Tonight I sleep like a king!! pic.twitter.com/gEylJdptKk
— Rob Sewell (@sqldbawithbeard) March 6, 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.
Great morning crowd, great venue & A/V at @ilionx as @sqldbawithbeard presents about the SqlServer module for @DuPSUG and @sqlpass Nederland pic.twitter.com/zRj3nOPyNr
— Chrissy LeMaire 🏴☠️ (@cl) February 10, 2017
enthousiastic way of presenting helps learning a lot! So much new info, thanks!
— Nicky van Vroenhoven (@NickyvV) February 10, 2017
Great sessions with @cl, @sqldbawithbeard and @SQLStad on #dbatools & #powershell <3 #SQLServer via @sqlpassnl pic.twitter.com/B5iUKLhjDZ
— Roni Vered Adar (@RoniVeredAdar) February 10, 2017
Next #PowerShell session by @cl & @sqldbawithbeard #pass morning @ilionx pic.twitter.com/ofpKxnQJ1U
— Joost van Rossum (@ssisjoost) February 10, 2017
PowerShell in Utrecht pic.twitter.com/e62JBITk2W
— Rob Sewell (@sqldbawithbeard) February 10, 2017
Dbatools Admin and migrations with @cl in Utrecht pic.twitter.com/KeTrWEKehE
— Rob Sewell (@sqldbawithbeard) February 10, 2017
"I know you're at the airport,could you just login & change a few hundred SQL Agent Jobs for us?" Of course, PowerShell & done in 2 mins 🙂
— Rob Sewell (@sqldbawithbeard) February 9, 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.
Preconference #powershell at @MSCloudSummit is about to start! Can't wait to learn from @cl, @sqldbawithbeard and @jaapbrasser !
— Arnaud Lacroix (@MartyMcFlaye) January 23, 2017
Presenting in a room with a view today with @sqldbawithbeard and @cl @MSCloudSummit pic.twitter.com/BDBfjLSag7
— Jaap Brasser (@Jaap_Brasser) January 23, 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.
Standing room only for @cl and I talking PowerShell and SQL at #sqlsatvienna Loving seeing interest in PowerShell from the SQL folk pic.twitter.com/bj1egIEnn8
— Rob Sewell (@sqldbawithbeard) January 20, 2017
Another cool tool #dbareports via @sqldbawithbeard #sqlsatvienna pic.twitter.com/edjLzpwRr0
— Jaroslav Reken (@jaroreken) January 20, 2017
Awwww! The #PowerShell and @psdbatools community loves @cl 🙂 @sqldbawithbeard is a sneaky, awesome man 😀 #SQLSatVienna #SQLPass #SQLFamily pic.twitter.com/it15DFx1Eo
— Cathrine Wilhelmsen (@cathrinew) January 20, 2017
I ❤ presenting with @sqldbawithbeard! I also love that #sqlsatvienna delivered – standing room only for #SQLServer #PowerShell 🇦🇹 pic.twitter.com/gZdxpjZIHM
— Chrissy LeMaire 🏴☠️ (@cl) January 20, 2017
Awesome speach about #PowerShell from @sqldbawithbeard #sqlsatvienna pic.twitter.com/A2KbLgSyHU
— Radek Tůma (@RadekTuma) January 20, 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.
Learned a lot new things at the workshop by @cl and @sqldbawithbeard Thanks! #sqlsatvienna pic.twitter.com/whrtIgNiBB
— Bartosz Ratajczyk (@b_ratajczyk) January 19, 2017
Verify your backup now! Awesome #powershell precon on #SQLSatVienna with @sqldbawithbeard and @cl pic.twitter.com/ntlCTAZ1gj
— Bernhard Engleder (@bengleder) January 19, 2017
Can Powershell be funny? Of course, especially with @cl and @sqldbawithbeard at #sqlsatvienna precon #sqlpass pic.twitter.com/gXKSfBSP25
— Друг Дражић (@MilosSQL) January 19, 2017
#SQLSatVienna #Powershell precon started.. @cl and @sqldbawithbeard in full action.. pic.twitter.com/J2SKowrj57
— SQLSaturday Vienna (@sqlsatvienna) January 19, 2017
Powershell workshop with @cl and @sqldbawithbeard starting in a moment #SqlSatVienna pic.twitter.com/ZkwxLEZRFF
— Bartosz Ratajczyk (@b_ratajczyk) January 19, 2017
The calm before the #sqlsatvienna pre-con @cl pic.twitter.com/sUZWbPmb1J
— Rob Sewell (@sqldbawithbeard) January 19, 2017
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.
Pester tests and checklists with @sqldbawithbeard #sqlsatSlovenia pic.twitter.com/hw7kSffBIr
— Gianluca Sartori (@spaghettidba) December 10, 2016
Pester is bloody amazing! #sqlsatSlovenia // @sqldbawithbeard
— William Durkin (@sql_williamd) December 10, 2016
Great presentation and trully inspirational. Thanks @sqldbawithbeard for this #sqlsatSlovenia session
— Marko Radakovic (@MarkoSQL) 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
Another great session comming up with @sqldbawithbeard at #sqlsatSlovenia pic.twitter.com/LGKurNt1ty
— Dejan Dragman (@ddragman) December 10, 2016
@sqldbawithbeard at #sqlsatSlovenia talked about how to automate installation of scripts within your environment. Really useful one! 😊 pic.twitter.com/j7STSFetH6
— Miroslav Dimitrov (@miro_dd) December 10, 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.
Thank you for@sqldbawithbeard for Powershell presentation @SQLSoton last night 🙂
— Emad (@gobiman) December 8, 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.
Next up at @SQLMidlands Mr. @sqldbawithbeard why #PowerShell loves #SQLServer pic.twitter.com/AeiPiqG9Hx
— Paul Andrew (@mrpaulandrew) November 10, 2016
I really enjoyed learning about encryption and powershell
— Parvinder Nijjar (@parvindernijjar) November 10, 2016
PowerShell Conference Asia – Singapore – Using my DBA Database to automate the install and upgrade scripts
@sqldbawithbeard showing us how to effectively test SQL with PowerShell and Pester. @PSConfAsia #PSConfAsia pic.twitter.com/l4ri0WT0dC
— Jason Yoder (@JasonYoder_MCT) October 22, 2016
#PSConfAsia use a checklist to drive your #pester tests @sqldbawithbeard pic.twitter.com/KEKdMZcRII
— thom schumacher (@driberif) October 22, 2016
#PSConfAsia questions or beard facts?? @sqldbawithbeard pic.twitter.com/HIWicqS7dS
— thom schumacher (@driberif) 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
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
@PSConfAsia #PSConfAsia PowerShell Profiles Explained @sqldbawithbeard pic.twitter.com/5asGuB2LsO
— AnnavarapuJaganmohan (@jagan_anna) October 21, 2016
SQL Relay Cardiff – Impromptu Session – This is not the session you are expecting
This is not the session you are expecting at #SQLRelay Me and @splappy pic.twitter.com/ETXsSNTfi8
— Rob Sewell (@sqldbawithbeard) October 4, 2016
Stop!
Collaborate
and Listen
or how to stop be crap at things
with @splappy #SQLRelay pic.twitter.com/lBRQXBq2jl— Rob Sewell (@sqldbawithbeard) 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.
@sqldbawithbeard great presentation and major new features for #SQL #Powershell @SQLRelay #Cardiff. can't wait to implement!
— Shahjan Mohammed (@sh4h) October 4, 2016
Full house at #SQLRelay pic.twitter.com/k7JbUOQSFL
— Rob Sewell (@sqldbawithbeard) October 4, 2016
Floor space only in @sqldbawithbeard session on "PowerShell community tools" at @SQLRelay_uk
Great to see so much #PowerShell love here!
— Ryan Yates (MVP) (@ryanyates1990) October 4, 2016
— Ryan Yates (MVP) (@ryanyates1990) October 4, 2016
SQL South West User Group – New PowerShell Commands For SQL Server
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.
Yes its really him, @sqldbawithbeard #DuPSUG pic.twitter.com/q2AA4s77L3
— Richard Diphoorn (@rdtechie) September 1, 2016
Next up: @sqldbawithbeard about reporting on SQL servers… Guest appearance by @EJHeeres as the security manager #DuPSUG #PowerShell
— Robert Prüst (@r_prust) September 1, 2016
@sqldbawithbeard Is explaining how to reduce DBA's context switching #DuPSUG #PowerShell pic.twitter.com/mXmMiyVd2d
— Ryan Ververs-Bijkerk (@Logitblog) September 1, 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.
#PowerShell script #deployment for the busy #dba with @sqldbawithbeard or should we say dba with a bear? #PSmonday pic.twitter.com/zyTfJB7gGm
— Sebastian Klenk (@seklenk) August 22, 2016
Now @sqldbawithbeard on @dbareports at #PSMonday pic.twitter.com/Bm0EiIZiGw
— Christian Lehrer (@chri_tea) August 22, 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
SQL Southampton User Group – New PowerShell Commands For SQL Server
@sqldbawithbeard sharing all the new and lovely #PowerShell cmd S for #SQLServer at #sqlsoton pic.twitter.com/otbX8p73gb
— Nick Fry (@SQLBadPanda) August 3, 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
Never use Write-Host, never ever! @sqldbawithbeard @ryanyates1990 #SQLSatmcr #SQLSat pic.twitter.com/D7iw69FuJD
— Jon Taylor (@jtredbase) July 23, 2016
And we have @sqldbawithbeard talking us through #PowerShell profiles at @SQLSatMcr pic.twitter.com/NG9bNxncp7
— Ryan (not yet a Dr) | Love will conquer over hate (@ryanyates1990) July 23, 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.
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
Right now at #sqlsatDublin : @sqldbawithbeard on Making #PowerShell useful for your team, full room pic.twitter.com/Dteq2YphHq
— Jens Vestergaard (@vestergaardj) June 18, 2016
@sqldbawithbeard on making PoSH useful for your team #SQLSatDublin pic.twitter.com/RtcrTkQxcS
— Andrew Pruski 🏴 (@dbafromthecold) June 18, 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
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
gread session from @sqldbawithbeard @PSConfEU. I would definitly use this in Production
— Constantin Hager (@chagerCOC) April 21, 2016
Great relaxed session with @sqldbawithbeard, need this after 2 days of beer and hardcore #PowerShell #PSConfEU pic.twitter.com/QdQbqTC6jO
— Bjørn Olav V. Aure (@Equerm) April 21, 2016
Most animated speaker of #PSConfEU Day 2: @sqldbawithbeard. May also be Duck Dynasty family's smarter British cousin.
— Amanda Debler (@texmandie) April 21, 2016
Lovely break from bleeding edge topics, @sqldbawithbeard recounts the ubiquitous nightmare of being a #PowerShell first mover #PSConfEU
— Mathias Jessen (@IISResetMe) 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
Sitting in @sqldbawithbeard's PS, PowerBI, & Context Switching talk #PSConfEU pic.twitter.com/wAEATDhu2D
— Steven Taylor (@Torch02) April 21, 2016
Nice and interactive dashboard presenting your inventory data using #PowerBI demoed by @sqldbawithbeard #PSConfEU pic.twitter.com/aU0H5F1ns5
— Simon Wåhlin (@SimonWahlin) April 21, 2016
Natural language query in #PowerBI can even answer correct with a typo in your query! #PSConfEU @sqldbawithbeard pic.twitter.com/6391qbhXO1
— Simon Wåhlin (@SimonWahlin) April 21, 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
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
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
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
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
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.
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
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.
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
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
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
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
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
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.
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.
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.
Azure automated backup with @fade2blackuk #SQLSouthWest #sqlserver pic.twitter.com/SoSykdLfFF
— Simon Stride (@sqlStride) August 17, 2015
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
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.
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.
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
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.
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
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.
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
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.
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
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.
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.
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.
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.
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.
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.
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.
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
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
May 5th
May 6th
Modern Database Administration using PowerShell and dbatools
Video
Test your Powershell code with AppVeyor for ITPros
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
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
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 27th – Four things you should know to effectively learn PowerShell
April 21st
Power Bi, PowerShell and DBA Double Session Rob Sewell Part1
Power Bi, PowerShell and DBA Double Session Rob Sewell Part2
Code – https://github.com/SQLDBAWithABeard/DBA-Database
Making Powershell Useful For Your Team
March 30th – Return of the Beards PowerShell, SQL and PowerBi-Reducing your Context Switching
Code – https://github.com/SQLDBAWithABeard/DBA-Database
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
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
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
August 17th – Continuous Learning 2.0
– Azure SQL VM Automated Backup and Azure Automated Patching
July 31 – Making Powershell useful for your team
April 25th – Making Powershell useful for your team
March 31st – Battle of the Beards – Making Powershell useful for your team
PASS Virtual Chapter PowerShell
March 19th – Making Powershell useful for your team – Webinar Recording
2014
SQL NorthEast
Tue September 16th – PowerShell Box of tricks
May 15th – PowerShell Box of tricks
SQL Saturday Exeter
March 22 – PowerShell Box of tricks
2013
October 1st – PowerShell Box of tricks
May 17th –